DEX | USD_TRADING_VOLUME | AVERAGE_USD_TRADING_VOLUME | SWAPS | TRADERS_COUNT | |
|---|---|---|---|---|---|
1 | Pharaoh | 10136616.69 | 419.527220015 | 23210 | 3197 |
2 | Uniswap | 227.97 | 18.9975 | 12 | 10 |
3 | Trader Joe | 103956085.54 | 742.416196795 | 122173 | 17767 |
4 | Pangolin | 246.78 | 0.3115909091 | 792 | 131 |
Ali3NBy DEX BLUB Trading Stats in DEX Avalanche
Updated 21 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 (hour,block_timestamp) as day,
'0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd' as token_address,
'BLUB ' as symbol,
'18' as decimals,
median (amount_in_usd/amount_out) as USDPrice
from avalanche.defi.ez_dex_swaps
where (symbol_in = 'WAVAX' or symbol_in ilike 'USDC')
and (symbol_out = 'BLUB' or token_out = '0x0f669808d88b2b0b3d23214dcd2a1cc6a8b1b5cd')
and block_timestamp >= '2025-03-04'
group by 1,2,3,4
union all
select hour 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 21 hours agoAuto-refreshes every 12 hours
4
179B
94s