search

balancer / dune-spellbook

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

Track bribe returns on ARB #124

Closed viniabussafi closed 3 months ago

viniabussafi commented 3 months ago

Message from BD

gm! Could I get your help with something please? As I think you know, our arbitrum grant is used to boost emissions for yield bearing pools on arbi.

Partners with ARB grants have been bribing using their ARB which, we believe, has resulted in much greater than 1 bribe efficiency.

It'd would be AWESOME if we could track the bribe efficiency for pools on Arbitrum. There was some initial push back from arbitrum foundation on whether partners should be using their grant to bribe. We convinced them that $1 would earn more than $1, so it's accretive. They agreed but we'd like to use data now to tell that story.

Additionally, we have partners ask us the bribe efficiency with the grant program, and it's kind of hard to figure out tbh. Your help would be greatly valued.

viniabussafi commented 3 months ago

BAL emissions to gauge: https://dune.com/queries/3981181 ARB incentives to gauge: https://dune.com/queries/3981256 Combining both for gauges incentivised on STIP: https://dune.com/queries/3981342

viniabussafi commented 3 months ago

HiddenHand voting markets (AURA and BALANCER): https://dune.com/queries/3976357?category=decoded_project&namespace=hiddenhand&blockchain=arbitrum&contract=BribeVault&blockchains=arbitrum

viniabussafi commented 3 months ago

HiddenHand voting markets x BAL and ARB sent to gauges incentivised on STIP: https://dune.com/queries/3981420

viniabussafi commented 3 months ago

HiddenHand proposal x Gauge matching: https://dune.com/queries/3971574

viniabussafi commented 3 months ago

AURA emissions to balancer gauges: https://dune.com/queries/3981894?category=decoded_project&namespace=aura_finance&blockchain=arbitrum&contract=BoosterLite&blockchains=arbitrum&id=aura_finance_arbitrum.BoosterLite_evt_PoolAdded

viniabussafi commented 3 months ago

Monthly HiddenHand ARB bribes x BAL+AURA+ARB gauge emissions: https://dune.com/queries/3981822

viniabussafi commented 3 months ago

So, structuring everything: BAL emissions to gauge: https://dune.com/queries/3981181 --considers 7 day lag between voting round end and emissions to L2 gauge Direct ARB incentives to gauge: https://dune.com/queries/3981256 --at the moment of injection of incentives AURA emissions to gauge: https://dune.com/queries/3981894 --at the moment of stashing of AURA to gauge

Combining all emissions and incentives: https://dune.com/queries/3981342

HiddenHand bribes: https://dune.com/queries/3976357 --considers only ARB incentives sent to Aura and Balancer at the moment bribes are deposited matching proposals and gauges: https://dune.com/queries/3971574

Aggregating monthly information for all gauges: https://dune.com/queries/3981420 --decided to aggregate monthly in order to minimize mismatching of dates Aggregating the monthly ratio of bribes vs. emissions and incentives: https://dune.com/queries/3981822 --only considering gauges that received both bribes and incentives

viniabussafi commented 3 months ago

Just had a very good chat with trit and this is what we came to: The ARB emissions we're considering right now are only from our quota of $ARB, which are done through an injector used specifically for the STIP I added a new column to the overview and the detailed queries in which we only consider BAL and ARB emissions, as AURA can be a bit trickier to accrue, considering their BAL fees He agreed that aggregating the data monthly can help with date mismatches, but it's important we keep mindful of this limitation