balancer / dune-spellbook

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

add child gauges v2 to labels #43

Closed mendesfabio closed 10 months ago

mendesfabio commented 11 months ago

From Troy:

WIP:

https://dune.com/queries/3094729

  1. I got all root gauges that had received a vote and then joined a table of all the decoded root gauge contracts we have on Dune;
  2. Created mapping queries for each type of L2 gauge and joined them on the aforementioned table.

* IIRC these queries are just for the v2 gauges, as I do not recall getting the streamers.

Notes:

viniabussafi commented 11 months ago

Query ran for Arbitrum. To do: create spell for avalanche, base and gnosis and run PR.

viniabussafi commented 11 months ago

PR created and tested. Waiting for review.

viniabussafi commented 10 months ago

Just for context, the logic is: output_0 balancer_ethereum.CappedArbitrumRootGaugeFactory_call_create recipient --> output_0 balancer_arbitrum.ChildChainGaugeFactory_call_create pool --> address labels.balancer_v2_pools_arbitrum

viniabussafi commented 10 months ago

PR approved. Will close the issue once it's merged and tested

viniabussafi commented 10 months ago

Child gauges added. The only missing labels are for pools with no labels, which we will have to investigate.

image