trader category | total traders | total trades | |
|---|---|---|---|
1 | Titan (≥100M) | 7 | 1001986 |
2 | Giant (10M-100M) | 38 | 160900792 |
3 | Hero (1M-10M) | 233 | 150528628 |
4 | Champion (500K-1M) | 294 | 59126748 |
5 | Veteran (100K-500K) | 3202 | 137775793 |
6 | rookie (10K-100K) | 21557 | 236509996 |
7 | Novice (<10K) | 1227234 | 107489366 |
datavortexTraders categories
Updated 2025-04-22
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 trader_volumes AS (
SELECT
trader_address,
SUM(volume_usd) AS "total trader volume (USD)",
COUNT(tx_hash) AS "total trades"
FROM
ton.defi.fact_dex_trades
WHERE
project = 'dedust'
AND volume_usd IS NOT NULL
GROUP BY
trader_address
),
trader_pools AS (
SELECT
trader_address,
pool_address
FROM
ton.defi.fact_dex_trades
WHERE
project = 'dedust'
AND volume_usd IS NOT NULL
GROUP BY
trader_address,
pool_address
),
latest_metadata AS (
SELECT
*
FROM
(
SELECT
*,
ROW_NUMBER() OVER (
PARTITION BY address
ORDER BY
Last run: 28 days ago
7
246B
4s