CATEGORY | NUMBER_OF_TRADERS | |
|---|---|---|
1 | Big Fish (10k-50k) | 7755 |
2 | Dolphins (50k-100k) | 1573 |
3 | Goldfish (100-500) | 78260 |
4 | Minnows (10-100) | 324170 |
5 | Plankton (<10) | 648483 |
6 | Salmon (1k-5k) | 26620 |
7 | Trout (500-1k) | 20458 |
8 | Tuna (5k-10k) | 6204 |
9 | Whales (100k+) | 2219 |
datavortextraders categories
Updated 2025-04-30
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 user_volumes AS (
SELECT
trader,
SUM(amount_in_usd) AS total_volume
FROM
near.defi.ez_dex_swaps
WHERE
platform = 'v2.ref-finance.near'
AND amount_in_usd IS NOT NULL
GROUP BY
trader
)
SELECT
category,
COUNT(DISTINCT trader) AS number_of_traders
FROM (
SELECT
'Whales (100k+)' AS category, trader
FROM user_volumes
WHERE total_volume >= 100000
UNION ALL
SELECT
'Dolphins (50k-100k)' AS category, trader
FROM user_volumes
WHERE total_volume BETWEEN 50000 AND 99999
UNION ALL
SELECT
'Big Fish (10k-50k)' AS category, trader
FROM user_volumes
WHERE total_volume BETWEEN 10000 AND 49999
UNION ALL
SELECT
'Tuna (5k-10k)' AS category, trader
FROM user_volumes
WHERE total_volume BETWEEN 5000 AND 9999
UNION ALL
Last run: 20 days ago
9
238B
192s