nsightsvol traded dex
    Updated 2024-09-21

    select
    DATE_TRUNC('day', block_timestamp) as date,
    SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS daily_volume_traded,
    count(TX_HASH) as total_tx,
    count(distinct ORIGIN_FROM_ADDRESS) as users,
    from ethereum.defi.ez_dex_swaps
    where (TOKEN_IN = '0x455e53cbb86018ac2b8092fdcd39d8444affc3f6' or TOKEN_OUT = '0x455e53cbb86018ac2b8092fdcd39d8444affc3f6')
    and BLOCK_TIMESTAMP >= '2023-01-01'
    group by date
    order by date desc;

    QueryRunArchived: QueryRun has been archived