chrisfddex__monthly_volume
    Updated 2023-10-19
    --Platform considered in the DEX volume computation

    WITH dex_list(dex) as (
    select * from (
    values
    ('uniswap-v2'),
    ('uniswap-v3'),
    ('curve'),
    ('maverick'),
    ('sushiswap'),
    ('dodo-v1'),
    ('dodo-v2'),
    ('pancakeswap-v2'),
    ('pancakeswap-v3')
    -- ('balancer')
    ))


    select
    --date_trunc('month',BLOCK_TIMESTAMP) as time,
    PLATFORM as dex,
    --AMOUNT_IN,
    --SYMBOL_IN,
    SUM(AMOUNT_IN_USD) as volume
    from ethereum.defi.ez_dex_swaps
    where exists (select 1 from dex_list where dex_list.dex = ethereum.defi.ez_dex_swaps.platform)
    and BLOCK_TIMESTAMP > dateadd('month', -1, current_timestamp(9)::timestamp_ntz)
    and AMOUNT_IN_USD > 0
    group by 1
    order by 2 desc
    limit 9





    Run a query to Download Data