PLATFORM | TRADER_RANK | TRADERS | |
---|---|---|---|
1 | animeswap | E - Master Trader | 711 |
2 | animeswap | D - Ultra-Active Trader | 594 |
3 | animeswap | C - Active Trader | 10925 |
4 | animeswap | B - Avid Trader | 43471 |
5 | animeswap | A - One Time Trader | 78945 |
6 | auxexchange | E - Master Trader | 686 |
7 | auxexchange | D - Ultra-Active Trader | 435 |
8 | auxexchange | C - Active Trader | 7784 |
9 | auxexchange | B - Avid Trader | 45977 |
10 | auxexchange | A - One Time Trader | 99607 |
11 | batswap | E - Master Trader | 102 |
12 | batswap | D - Ultra-Active Trader | 117 |
13 | batswap | C - Active Trader | 923 |
14 | batswap | B - Avid Trader | 7963 |
15 | batswap | A - One Time Trader | 18952 |
16 | cellana | E - Master Trader | 9289 |
17 | cellana | D - Ultra-Active Trader | 3948 |
18 | cellana | C - Active Trader | 32959 |
19 | cellana | B - Avid Trader | 110165 |
20 | cellana | A - One Time Trader | 455045 |
mr_dTraders rank on aptos dex protocols
Updated 2025-05-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
With wallet_txs AS (
SELECT
platform
, swapper
, Count(tx_hash) AS txs
, CASE WHEN txs <= 2 THEN 'A - One Time Trader'
WHEN txs > 1 AND txs <= 10 THEN 'B - Avid Trader'
WHEN txs > 10 AND txs <= 50 THEN 'C - Active Trader'
WHEN txs > 50 AND txs <= 100 THEN 'D - Ultra-Active Trader'
WHEN txs > 100 THEN 'E - Master Trader' END AS Trader_Rank
FROM aptos.defi.ez_dex_swaps
GROUP BY 1, 2
)
SELECT
platform
, trader_rank
, COUNT(DISTINCT swapper) AS traders
FROM wallet_txs
GROUP BY Platform, Trader_rank
ORDER BY Platform, Trader_rank desc
Last run: about 1 month ago
60
2KB
44s