[SPIKE] Review, identify & validate required data sources for the Analytics site

[RyRy79261]

Description

This spike's objective is to review the data requirements of the spec doc in order to see if existing Dune data is sufficient for the proposed api end points.

The dune dashboards can be found here

Additionally, a review of existing data sources needs to be assessed & pruned for relevance from the existing reserve site.

This folder contains a majority of data sources used presently in the reserve site.

The output of this spike is to establish if there are any missing dependencies for the proposed metrics on the new analytics site, to establish retrieval queries, as well as validate said data for being accurate, for example, some stables, if you were to look at the total supply, would not actually be accurate to the amount in circulation if the burning & minting is handled differently, like in the case of a bridged asset.

It is uncertain if there is an existing document that would allow inference of potential inaccurate data from the Dune dashboard.

Data sources to verify, this spike will be considered successfully completed if the endpoint, the request, and the return type for each data source is detailed in the Spec document on notion

• Reserve
  • Validate we have required data sources
  • Prune unneeded data sources
• Product usage
  • Outstanding supply - Validate potential inaccuracies with each token
  • Trading volume
  • Velocity
  • Transaction count
  • Active addresses
  • Transactions per address
• Mento Token usage
  • Issued/redeemed $ per period, where a period is defined as 1 Day, 1 Week, 1 Month, Year to Date, All time
  • Issued/redeemed transaction count
  • Issued/redeemed by unique address
  • Issued $ broken down by collateral used
  • Redeemed $ broken down by collateral used.
• Protocol config
  • This is to fulfil the data type of TradingPairCard, this may need queries to determine metrics monitored by the breaker box, these are the required properties:
  • Title: pair symbol (e.g. axlUSDC/cUSD)
  • token1 address
  • token2 address
  • Formula: ConstantSum/Prod
  • Spread (value in % basis points)
  • Price update (value in minutes)
  • Minimum reports ( X out of Y)
  • Daily trading volume max / used so far visualised as a progress bar
  • 5min trading volume max / used so far
  • Max allowed mcap: (Unlimited or a number)