TRADING_TYPE | TX_COUNT | TRADERS_COUNT | TRADING_VOLUME | AVERAGE_TRADING_VOLUME | |
|---|---|---|---|---|---|
1 | Swap To Qi | 530087 | 41926 | 22705565517.0696 | 38272.924442262 |
2 | Swap From Qi | 641303 | 47743 | 22973147959.2473 | 32426.377310077 |
Ali3NOverall Qi Swaps Stats on Avalanche
Updated 2025-03-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from Overall Qi Swaps Stats on Avalanche @ https://flipsidecrypto.xyz/edit/queries/f97442f7-8103-47da-bc8b-a151083afa28
select case when token_in = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then 'Swap From Qi'
when token_out = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then 'Swap To Qi' end as Trading_Type,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Traders_Count,
sum (case when token_in = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_in
when token_out = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_out end) as Trading_Volume,
avg (case when token_in = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_in
when token_out = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_out end) as Average_Trading_Volume
from avalanche.defi.ez_dex_swaps
where token_in in ('0x8729438eb15e2c8b576fcc6aecda6a148776c0f5')
or token_out = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5'
group by 1
Last run: about 1 month ago
2
125B
13s