TRADING_PAIR | TX_COUNT | TRADERS_COUNT | TOTAL_TRADING_VOLUME | TOTAL_USD_TRADING_VOLUME | AVERAGE_TRADING_VOLUME | AVERAGE_USD_TRADING_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | USDC => XSGD | 54210 | 2202 | 169645261.129032 | 125499912.03 | 2984.873073441 | 2208.183693388 |
2 | XSGD => USDC | 52676 | 2339 | 170539132.404278 | 126094772.55 | 3169.342162171 | 2343.376991767 |
3 | XSGD => WAVAX | 51869 | 1942 | 117011040.511483 | 86404106.75 | 1979.045082647 | 1461.380241015 |
4 | WAVAX => XSGD | 49434 | 2108 | 122245688.801121 | 90894232.94 | 2158.10201785 | 1604.629410186 |
5 | USDt => XSGD | 72 | 19 | 166.792554 | 124.05 | 1.87407364 | 1.393820225 |
6 | avUSD => XSGD | 27 | 10 | 74.269809 | 55.5 | 2.750733667 | 2.055555556 |
7 | XSGD => USDt | 25 | 18 | 196.990262 | 145.05 | 7.87961048 | 5.802 |
8 | XSGD => avUSD | 11 | 5 | 60.714788 | 45.33 | 5.519526182 | 4.120909091 |
Ali3NXSGD Swap Pairs' Stats in Avalanche DEXs
Updated 2025-03-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
select symbol_in || ' => ' || symbol_out as Trading_Pair,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Traders_Count,
sum (case when token_in = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e' then amount_in
when token_out = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e' then amount_out end) as Total_Trading_Volume,
sum (coalesce(amount_in_usd,amount_out_usd)) as Total_USD_Trading_Volume,
avg (case when token_in = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e' then amount_in
when token_out = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e' then amount_out end) as Average_Trading_Volume,
avg (coalesce(amount_in_usd,amount_out_usd)) as Average_USD_Trading_Volume,
from avalanche.defi.ez_dex_swaps
where token_in in ('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')
or token_out = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e'
group by 1
order by 2 desc
Last run: about 1 month ago
8
600B
19s