gokcinswap volumes usdc
    Updated 2023-03-18
    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