chrisfdpast_24h_active_users
    Updated 2023-10-19
    -- forked from DEX_past_24h_volume copy @ https://flipsidecrypto.xyz/edit/queries/d7f0aa86-e4c7-4fbe-85e5-9fb57227c746

    --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
    count(distinct origin_from_address) as users
    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