gokcinswap volumes usdc
Updated 2023-03-18Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT date_trunc('day', block_timestamp) as date,
sum(CASE WHEN symbol_in = 'USDC' then -1*amount_in END) sell_usdc,-sell_usdc as sell_volume,'Volume',
sum(CASE WHEN symbol_out = 'USDC' then amount_out END) buy_usdc,
buy_usdc+sell_usdc as net_usdc,count(distinct TX_HASH) as swaps,sum(net_usdc) over (order by date) as cum_net
FROM ethereum.core.ez_dex_swaps
where block_timestamp >= '2023-03-01' and (symbol_in = 'USDC' or symbol_out = 'USDC')
group by 1
order by 1
Run a query to Download Data