DEX | USD_TRADING_VOLUME | AVERAGE_USD_TRADING_VOLUME | SWAPS | TRADERS_COUNT | |
|---|---|---|---|---|---|
1 | Pharaoh | 213242.996315 | 89.824345541 | 2296 | 260 |
2 | Dexalot | 28618.301299254 | 98.007881162 | 285 | 39 |
3 | Trader Joe | 11607006.7 | 195.703969043 | 38245 | 795 |
4 | Uniswap | 1180963.150102 | 287.269070811 | 4109 | 269 |
Ali3NBy DEX GUNZ Trading Stats in DEX Avalanche
Updated 6 hours ago
999
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
29
30
31
32
33
34
35
36
›
⌄
with pricet as (
select date_trunc (day,block_timestamp) as day,
'0x26debd39d5ed069770406fca10a0e4f8d2c743eb' as token_address,
'GUN' as symbol,
'18' as decimals,
median (amount_in_usd/amount_out) as USDPrice
from avalanche.defi.ez_dex_swaps
where symbol_in in ('WAVAX','USDC')
and (token_out = '0x26debd39d5ed069770406fca10a0e4f8d2c743eb')
and block_timestamp >= '2025-04-01'
group by 1,2,3,4 having usdprice > 0
union all
select hour::date as day,
token_address,
'USDC' as symbol,
decimals,
avg (price) as usdprice
from avalanche.price.ez_prices_hourly
where token_address ilike '0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E'
group by 1,2,3,4),
SimpleSwap as (
SELECT
block_timestamp,
tx_hash,
decoded_log:maker as maker,
decoded_log:makerAsset as makerAsset,
decoded_log:makerAmountReceived as makerAmountReceived,
decoded_log:taker as taker,
decoded_log:takerAsset as takerAsset,
decoded_log:takerAmountReceived as takerAmountReceived,
decoded_log
FROM
avalanche.core.ez_decoded_event_logs
Last run: about 6 hours agoAuto-refreshes every 24 hours
4
197B
475s