DEX | TRADING_PAIR | TX_COUNT | TRADERS_COUNT | TOTAL_TRADING_VOLUME | TOTAL_USD_TRADING_VOLUME | AVERAGE_TRADING_VOLUME | AVERAGE_USD_TRADING_VOLUME | |
|---|---|---|---|---|---|---|---|---|
1 | Trader Joe | WAVAX => PLSR | 400 | 90 | 1281651.06127566 | 25025.52 | 751.701502214 | 14.67772434 |
2 | Pharaoh | WAVAX => PLSR | 345 | 114 | 4285484.59955775 | 124937.4 | 12421.694491472 | 362.137391304 |
3 | Pharaoh | PLSR => WAVAX | 490 | 221 | 5119568.50268393 | 153463.59 | 10448.098985069 | 313.191 |
4 | Dexalot | USDC => PLSR | 18 | 8 | 102910.509471956 | 2218.970607236 | 5717.25052622 | 123.276144846 |
5 | Dexalot | PLSR => USDC | 24 | 10 | 502857.824270956 | 8302.293001932 | 20952.409344623 | 345.92887508 |
6 | Trader Joe | PLSR => WAVAX | 439 | 139 | 1364892.9022262 | 29272.95 | 748.296547273 | 16.048766447 |
Ali3NBy DEX & Pair PLSR Swap Pairs' Stats in Avalanche DEXs
Updated 2025-04-04
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
29
30
31
32
33
34
35
36
›
⌄
with pricet as (
select date_trunc (day,block_timestamp) as day,
'0x7a842193d291840fc38b45f991c5b8cc908f8a7c' as token_address,
'PLSR' as symbol,
'18' as decimals,
avg (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 = 'PLSR' or token_out = '0x7a842193d291840fc38b45f991c5b8cc908f8a7c')
and block_timestamp >= '2025-02-05'
group by 1,2,3,4 having USDPrice < 10
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),
maindextable as (
select block_timestamp,
tx_hash,
origin_from_address,
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,
Token_In,
symbol_in,
Amount_In,
Amount_In_USD,
Token_Out,
symbol_out,
Last run: 12 days agoAuto-refreshes every 24 hours
6
547B
41s