TYPE | USERS | TRANSACTIONS | VOLUME_AVAX | VOLUME_USD | AVG_VOLUME_USD | |
|---|---|---|---|---|---|---|
1 | SELL | 9254 | 511608 | 1936891300.53967 | 356539175.75 | 555.814956171 |
2 | BUY | 21313 | 450117 | 425277140281.033 | 395994724.34 | 708.998355209 |
SniperShare of Users
Updated 2025-05-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
case when TOKEN_in = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') then 'SELL'
when TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') then 'BUY' end as type,
count(DISTINCT ORIGIN_FROM_ADDRESS) as users,
count(DISTINCT TX_HASH) as transactions,
sum(AMOUNT_IN) as volume_avax,
sum(AMOUNT_IN_USD) as volume_usd,
avg(AMOUNT_IN_USD) as avg_volume_usd
from avalanche.defi.ez_dex_swaps
where AMOUNT_IN_USD is NOT NULL
and TOKEN_in = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7') OR
TOKEN_out = lower('0xFFFF003a6BAD9b743d658048742935fFFE2b6ED7')
group by 1
Last run: 3 months ago
2
131B
6s