TYPE | USERS | TRANSACTIONS | VOLUME_AVAX | VOLUME_USD | AVG_VOLUME_USD | |
|---|---|---|---|---|---|---|
1 | BUY | 2600 | 31455 | 54382938004.9989 | 2261616.52 | 80.301680159 |
2 | SELL | 1935 | 12163 | 2235005947.97251 | 1803697.1 | 147.072496738 |
SniperShare of Users
Updated 2025-02-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select
case when TOKEN_in = '0x18e3605b13f10016901eac609b9e188cf7c18973' then 'SELL'
when TOKEN_out = '0x18e3605b13f10016901eac609b9e188cf7c18973' 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 = '0x18e3605b13f10016901eac609b9e188cf7c18973' OR
TOKEN_out = '0x18e3605b13f10016901eac609b9e188cf7c18973'
group by 1
Last run: 2 months agoAuto-refreshes every 12 hours
2
122B
5s