AmiRTop token pair by vol
Updated 2024-09-25
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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