chrisfdpast_24h_transactions
    Updated 2023-10-20
    -- forked from past_24h_active_users @ https://flipsidecrypto.xyz/edit/queries/c67b4521-b472-457e-a4a2-e6bbe032e1c1

    -- 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 tx_hash) as transactions
    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