DEX | USD_TRADING_VOLUME | AVERAGE_USD_TRADING_VOLUME | SWAPS | TRADERS_COUNT | |
|---|---|---|---|---|---|
1 | Pharaoh | 257560577.42 | 1597.393774544 | 110563 | 2873 |
2 | Pangolin | 269.1 | 2.360526316 | 97 | 35 |
3 | Balancer | 2422129 | 5455.245495495 | 444 | 27 |
4 | Trader Joe | 168910418.68 | 2607.849601359 | 44964 | 2323 |
Ali3NBy DEX XSGD Trading Stats in DEX Avalanche copy
Updated 2025-03-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select case when platform ilike '%trader-joe%' then 'Trader Joe'
when platform ilike '%uniswap%' then 'Uniswap'
when platform ilike '%pharaoh%' then 'Pharaoh' else initcap(platform) end as dex,
sum(coalesce(amount_in_usd,amount_out_usd,0)) as USD_Trading_Volume,
avg(coalesce(amount_in_usd,amount_out_usd,0)) as Average_USD_Trading_Volume,
count (distinct tx_hash) as Swaps,
count (distinct origin_from_address) as Traders_Count
from avalanche.defi.ez_dex_swaps
where token_in in ('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')
or token_out = '0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e'
group by 1
Last run: about 1 month ago
4
187B
11s