search

balancer / dune-spellbook

SQL views for Dune Analytics
Other
7 stars 11 forks source link

Get liquidity data for beets on fantom #60

Closed viniabussafi closed 8 months ago

viniabussafi commented 9 months ago

To get complete data on our Built on Balancer dashboard, it would be important to get the complete TVL for Beets (OP + Fantom). For that, we need to create the liquidity spell and some other upstream spells (pools tokens weights and pool labels)

viniabussafi commented 9 months ago

PR created

viniabussafi commented 9 months ago

It follows the logic of the balancer liquidity spells, since Beethoven X was built on balancer, with a few simplifications (removal of dex.prices, which was causing outliers and since there's no bpt.prices spell for fantom, it also removes the protocol_liquidity_usd and pool_liquidity_usd logic). We could add the bpt prices spell to the beets namespace for fantom once we deal with https://github.com/balancer/dune-spellbook/issues/59, but for now, the data for the main pools is correct

viniabussafi commented 8 months ago

PR merged