boomer774. curve swap vol
Updated 2022-01-10
9
1
2
3
4
5
6
›
⌄
select date_trunc('week', block_timestamp) as dt, to_address_name as pools, sum(amount_usd) as Swap_Volume, count(distinct from_address) as Active_Users
from ethereum.udm_events
where to_label_type = 'dex' and to_label = 'curve fi' and block_timestamp between '2021-01-01' and '2021-12-31' and symbol is not null and to_address_name not like '%deposit%'
and to_address_name not in ('curve.fi: donate', 'CRV Token curve token', 'curve.fi: deployer 2', 'curve.fi: sbtc adapter 3', 'voting escrow', 'curve.fi: ren adapter 2', 'curve.fi: ren adapter', 'curve.fi: deployer',
'DAO Fee Distributor', 'curve.fi: ren adapter 3')
group by 1,2
Run a query to Download Data