Query editor
with temp as (select evt_block_time, case providerwhen '\xf147b8125d2ef93fb6965db97d6746952a133934' then 'yearn'when '\x989aeb4d175e16225e39e87d0d97a3360524ad80' then 'convex'when '\x52f541764e6e90eebc5c21ff570de0e2d63766b6' then 'stakedao'else 'other'end as provider, value / 1e18 vecrvfrom curvefi."voting_escrow_evt_Deposit"unionselect evt_block_time, case providerwhen '\xf147b8125d2ef93fb6965db97d6746952a133934' then 'yearn'when '\x989aeb4d175e16225e39e87d0d97a3360524ad80' then 'convex'when '\x52f541764e6e90eebc5c21ff570de0e2d63766b6' then 'stakedao'else 'other'end as provider, -(value / 1e18) vecrvfrom curvefi."voting_escrow_evt_Withdraw")selectdate(evt_block_time),provider,sum(vecrv) over (partition by provider order by evt_block_time) as abs,sum(vecrv) over (partition by provider order by evt_block_time) / sum(vecrv) over (order by evt_block_time) * 100 as pctfrom temp