Closed jacek0x closed 1 year ago
@hedgehog-jacek can you open this PR to Dune repo? Remember from now to branch off balancer-labs:main and create a feature branch under balancer-labs fork instead of yours. I guess this will help us avoid lots of diffs. Thanks so much!
@hedgehog-jacek can you open this PR to Dune repo? Remember from now to branch off balancer-labs:main and create a feature branch under balancer-labs fork instead of yours. I guess this will help us avoid lots of diffs. Thanks so much!
Thanks @mendesfabio, I created the following PR to the Dune repo: https://github.com/duneanalytics/spellbook/pull/2184
Brief comments on the purpose of your changes:
balancer.view_pools_tokens_weights
abstraction to a v2 spellbook.For Dune Engine V2
I've checked that:
General checks:
lowercase_snake_cased
Pricing checks:
coin_id
represents the ID of the coin on coinpaprika.comall the coins are active on coinpaprika.com (please remove inactive ones)Join logic:
Incremental logic:
I used is_incremental & not is_incremental jinja block filters on both base tables and decoded tableswhere block_time >= date_trunc("day", now() - interval '1 week')if joining to base table (i.e. ethereum transactions or traces), I applied join condition where block_time >= date_trunc("day", now() - interval '1 week')if joining to prices view, I applied join condition where minute >= date_trunc("day", now() - interval '1 week')