0-MIDTop 20 ARB Buyers In Terms Of Buy Swaps
    Updated 2024-01-16

    select
    ORIGIN_FROM_ADDRESS as buyer
    ,count(distinct TX_HASH) as buy_swaps
    ,count(distinct BLOCK_TIMESTAMP::date) as active_days
    from arbitrum.defi.ez_dex_swaps
    where BLOCK_TIMESTAMP::date>='2023-10-01'
    and PLATFORM='uniswap-v3'
    and SYMBOL_OUT='ARB'
    group by 1
    order by 2 desc
    limit 20





    QueryRunArchived: QueryRun has been archived