AmiRTop token pair by vol
    Updated 2024-09-25
    select symbol_in || '➡' || symbol_out as "Token Pair",
    sum(amount_in_usd) as "swap_vol",
    count(DISTINCT tx_hash) as "swap_count",
    count(DISTINCT origin_from_address) as "swappers"
    from arbitrum.defi.ez_dex_swaps
    where BLOCK_TIMESTAMP>=current_date-60 and platform='camelot-v3'
    and symbol_in is not null and symbol_out is not null and amount_in_usd is not null
    group by 1
    order by 2 DESC limit 8


    QueryRunArchived: QueryRun has been archived