Summary
Create a Dune Analytics dashboard to display key metrics and data visualization for Raft. The dashboard will provide valuable insights into the protocol's performance, user engagement, token metrics, and collateralization ratios.
Requirements
The Dune Analytics dashboard for Raft Protocol will include the following key metrics and features:
R Metrics
- R Price: Display the current price of the R and provide a historical price chart.
- Links to Protocol: Include relevant links to Raft, such as the official website, documentation, and smart contract addresses.
R Token Metrics
- R Circulating Supply: Display the current circulating supply of R tokens, highlighting the overall token distribution over time, in the same chart.
- Number of R Holders over Time: Visualize the number of R token holders over time, demonstrating the growth and distribution of the token.
- Number of R Holders and average wallet balance: Current number of R token holders over time and the median wallet balance of R.
- Total Collateralization Ratio: Show the current collateralization ratio of Raft, which represents the total value of collateral locked divided by the total value of R minted.
- Total Collateralization Ratio over time: Track the changes in the collateralization ratio over time, providing insights into the protocol's stability and risk management.
- R Utilization: Display an area chart that tracks the value of R across the various liquidity pools incl Balancer and Uniswap.
- TVL in R/USDC, R/wstETH, and R/DAI Pools: Present the TVL specific to each trading pair, allowing users to analyze the liquidity and usage of different pools.
- R Volume in All Pools (as above): Visualize the trading volume of R tokens in all supported pools, providing insights into the liquidity and trading activity within the protocol.
- Redemption fees accrued to the protocol over time (with weekly frequency)
Protocol Metrics
- Total Value Locked (TVL): Show the TVL of Raft in both $stETH and USD terms, providing an overview of the capital efficiency and adoption of the protocol. TVL = Total $stETH deposited
- $stETH Staking Rewards: Display the current APR for staking $ETH on Lido.