ppclMaker steCRV users
Updated 2023-06-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
⌄
⌄
/*select user, cdp, sum(amount) as amount
from (
*/
select depositor as address, c.vault_number as cdp --, amount_deposited as amount
from ethereum.maker.ez_deposits d
left join ethereum.maker.ez_vault_creation c on d.vault = c.vault
where symbol = 'steCRV-gauge'
order by 2
/*union
select withdrawer, c.vault_number as cdp, (-1)*amount_withdrawn
from ethereum.maker.ez_withdrawals w
left join ethereum.maker.ez_vault_creation c on w.vault = c.vault
where symbol = 'steCRV-gauge'
) group by 1,2
*/
Run a query to Download Data