chrisfdpast_24h DEX_volume
    Updated 2023-12-11
    -- forked from DEX_volume @ https://flipsidecrypto.xyz/edit/queries/00663fa1-ee50-4afb-8b57-f3686e0342f9

    -- Query DEX Volume
    WITH dex_slugs(dex) as (
    select * from
    values
    ('uniswap v3'),
    ('uniswap v1'),
    ('uniswap v2'),
    ('curve'),
    ('maverick protocol'),
    ('sushiswap'),
    ('dodo'),
    ('pancakeswap amm'),
    ('balancer v2'),
    ('balancer v1')
    )

    --Only five protocols available as per
    select *
    --DISTINCT(chain)
    --DISTINCT(protocol)
    from external.defillama.fact_dex_volume
    where exists (select 1 from dex_slugs where dex_slugs.dex = external.defillama.fact_dex_volume.protocol)
    and date > dateadd('day', -2, current_date())
    and chain = 'ethereum'
    order by 1 asc
    LIMIT 9








    Run a query to Download Data