brainstorm on Core Pools / LST liquidity dashboard

[mendesfabio]

Context

We've talked in Barcelona about a Core Pools dashboard and recently Marketing guys reached out regarding a LST Liquidity dashboard. I'm still not sure about how to approach it because:

• There's a lot of overlap between the dashboards and metrics would be very similar;
• I wonder if wouldn't be better to highlight Core Pools and LST liquidity in other dashboards;
  • For instance, Balancer Overview could have charts/counter for % of liquidity and volume coming from LSTs.

[mendesfabio]

Regardless of the outcome here I believe it would be cool to have the Core Pools concept on Dune. We could add the dune-upload to a repository (managed by Maxis?) with a CSV list of pools designated as Core. Also, needs to find a way to classify/identify the liquid staking tokens - maybe that would be a tokens.lst table on Dune.

[mendesfabio]

TIL Maxis have a Core Pools list on GitHub: https://github.com/BalancerMaxis/multisig-ops/blob/main/config/core_pools.json

could add the dune-upload action to their repository. would be cool to have this historically as well

[viniabussafi]

LSTs

• We could add a token type (stable, LST etc) breakdown in the Balancer Volume - Token Breakdown dashboard
• Balancer Exchange could showcase most traded token pairs

Core Pools

• Pools overview could have a table for core pools, with link to pool analysis

[viniabussafi]

Currently working on 2 forms of defining LSTs:

• LST tokens
• LST Pools

Working on this dashboard. Trying to have it done by friday, as coordinated with the marketing team

[viniabussafi]

Core Pools dataset uploaded to dune via Fábio's script

[viniabussafi]

LSTs dashboard is done It is more introductory for now, to fit the timeframe of the marketing team also. My idea is to have a more complex one once we have a complete bpt.prices spell, which will allow us to have a core pools dashboard with metrics such as ROI on bribes

[viniabussafi]

Updated to include missing token-pairs due to limitations on dune side + pools with LSTs paired with wstETH. Will try to have volume metrics in eth, as well as usd

[viniabussafi]

Created a big workaround to properly calculate the TVL in Missing LSTs

[viniabussafi]

Will be complete once we have BPT prices for all pools

[viniabussafi]

Dashboard has been completed for a while and we're reaching completeness when it comes to pricing, so I'll close this issue