mariyaEthereum - daily volume of USDC
    Updated 2022-04-18
    with USDC_vol_ethereum as (
    select sum(amount_usd) as USDC_amount ,to_date(block_timestamp) as swapdate from ethereum.dex_swaps where
    swapdate >= '2022-01-01' and POOL_NAME like '%USDC%'
    group by swapdate)
    , USDC_num_ethereum as (select count(*) as USDC_count,to_date(block_timestamp) as swapdate from ethereum.dex_swaps where
    swapdate >= '2022-01-01' and POOL_NAME like '%USDC%'
    group by swapdate)
    ,USDC_avg_ethereum as (select (sum(amount_usd)/count(*)) as USDC_avg, sum(amount_usd),count(*) from ethereum.dex_swaps where
    to_date(block_timestamp) >= '2022-01-01' and POOL_NAME like '%USDC%' and amount_usd is not null
    )


    select * from USDC_vol_ethereum
    Run a query to Download Data