AmiRTop token pair by swappers
Updated 2024-10-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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 blast.defi.ez_dex_swaps
where BLOCK_TIMESTAMP>=current_date-60 and platform='thruster-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 4 DESC limit 5
QueryRunArchived: QueryRun has been archived