chrisfdDEX_past_24h_volume
    Updated 2023-10-19
    -- forked from dex__monthly_volume @ https://flipsidecrypto.xyz/edit/queries/69a5a6a0-20bf-4e29-a712-33de76ee984f

    --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
    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('hour', -24, current_timestamp(9)::timestamp_ntz)
    and AMOUNT_IN_USD > 0








    Run a query to Download Data