TRADING_TYPE | TX_COUNT | TRADERS_COUNT | TRADING_VOLUME | USD_TRADING_VOLUME | AVERAGE_TRADING_VOLUME | AVERAGE_USD_TRADING_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | Swap To XSGD (BUY) | 103013 | 3492 | 291891190.992516 | 216394324.52 | 2569.555186736 | 1904.963462476 |
2 | Swap From XSGD (SELL) | 104041 | 3478 | 287550430.620811 | 212499069.68 | 2545.369838194 | 1881.022126936 |
Ali3NOverall XSGD Swaps Stats on Avalanche
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
25
26
27
28
›
⌄
select case when token_in = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e' then 'Swap From XSGD (SELL)'
when token_out = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e' then 'Swap To XSGD (BUY)' end as Trading_Type,
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 Trading_Volume,
sum(coalesce(amount_in_usd,amount_out_usd)) as 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
Last run: about 1 month ago
2
194B
14s