Map vlAURA holders

[viniabussafi]

map vlaura vs. vebal rounds

[viniabussafi]

ref: https://etherscan.io/address/0x3fa73f1e5d8a792c80f426fc8f84fbf7ce9bbcac https://vscode.blockscan.com/ethereum/0x3fa73f1e5d8a792c80f426fc8f84fbf7ce9bbcac https://dune.com/queries/3999509

[viniabussafi]

vlAURA rounds: https://dune.com/queries/4001808. same results as dune.asnogordo.result_aura_lock_period veBAL rounds: https://dune.com/queries/4001811

[viniabussafi]

Update: this query works for latest data, but this one still needs to be fixed for historical data regarding unlockable vlaura

[viniabussafi]

will work with current balances, as we want a pie chart of vlaura distribution, but after thar will go back to the challenge of rebuilding the data historically

[viniabussafi]

getting close 🙏

[viniabussafi]

Balances by address for debugging: https://dune.com/queries/4008271

[viniabussafi]

Results match with this function for current balances: https://etherscan.io/address/0x3fa73f1e5d8a792c80f426fc8f84fbf7ce9bbcac#readContract#F24

[viniabussafi]

Current veBAL Balances (vlAURA holders breakdown): https://dune.com/queries/4008624/6748633?category=asset-tracking

[viniabussafi]

Update: working on vlaura balances by round here: https://dune.com/queries/4005633 last step is properly calculating vebal balances and voting power

[mendesfabio]

this is the 1st user I tried to play with 0x01a0f8f364c2fec07cfcdebd2980da3f950d0410 and I noticed that:

• Gaps between vlAURA rounds need to be filled;
• Dune returns 4197.7687402245365 for vlAURA 115 while Etherscan returns 0.

[viniabussafi]

historical vlAURA balances by voting round and provider

[viniabussafi]

historical vlAURA balances by voting round and address

[viniabussafi]

vlAURA balances by voting round and delegate

[viniabussafi]

Joining everything in vlaura_balances_round. The idea is to materialize this query once credits refresh and then be able to get data by

• address
• provider
• delegate

[viniabussafi]

Current vlAURA Distribution per provider Current vlAURA Distribution per delegate Current veBAL balances (vlAURA delegates breakdown)

[viniabussafi]

Ok, seems we've definitely progressed. Organizing the multiple links I sent here: Main query, to be materialized once credits refresh, containing vlAURA and veBAL balances for each holder, including 'provider' for labelling and 'delegate': vlaura_balances_round

Current vlAURA distributions: Current vlAURA Distribution per provider Current vlAURA Distribution per delegate Current vlAURA Distribution per address

Current veBAL balances Current veBAL balances (vlAURA delegates breakdown) Current veBAL balances (vlAURA providers breakdown) Current veBAL balances (vlAURA addresses breakdown)

[viniabussafi]

Historical veBAL balances (vlAURA providers breakdown)

[viniabussafi]

historical vlAURA balances by voting round and address historical vlAURA balances by voting round and provider historical vlAURA balances by voting round and delegate

[viniabussafi]

Added to veBAL dashboard

[viniabussafi]

done, added to dashboard and sent to team