search

josephd8 / index-coop-analytics

analytics for INDEX Cooperative
MIT License
2 stars 1 forks source link

USD Prices for $INDEX & $DPI in Dune #26

Open josephd8 opened 3 years ago

josephd8 commented 3 years ago

Option #1: DPI and INDEX on Coinpaprika Option #2: You can actually build a decentralized pricefeed yourself (by actually observing the trades) from Uniswap/sushiswap/balancer to get an accurate DEX pricefeed. https://duneanalytics.com/embeds/18253/36950/ESPuHbvRGcPtGE4VVXL4s5GYz0MmgyqiLh6NLMAp

josephd8 commented 3 years ago

example query: https://explore.duneanalytics.com/queries/18511/source

josephd8 commented 3 years ago

write a CTE that provides date, amount, usd price for both $DPI and $INDEX