SniperUnique Traders
    Updated 2024-11-02
    select
    count(DISTINCT ORIGIN_FROM_ADDRESS) as users,
    count(DISTINCT TX_HASH) as transactions,
    sum(AMOUNT_IN_USD) as volume_usd,
    avg(AMOUNT_IN_USD) as avg_volume_usd
    from ethereum.defi.ez_dex_swaps
    where TOKEN_in = '0x72e4f9f808c49a2a61de9c5896298920dc4eeea9'
    or TOKEN_out = '0x72e4f9f808c49a2a61de9c5896298920dc4eeea9'
    AND AMOUNT_IN_USD is NOT NULL


    QueryRunArchived: QueryRun has been archived