TRADER_CATEGORY | NUMBER_OF_TRADERS | VOLUME_RANGE | |
|---|---|---|---|
1 | Whale | 592 | Volume > $100,000 |
2 | dolphins | 3327 | Volume between $10,000 and $100,000 |
3 | Crab | 16794 | Volume between $1,000 and $10,000 |
4 | Plankton | 895330 | Volume between $1 and $1,000 |
5 | Micro Plankton | 72369 | Volume < $1 |
datavortexTraders Categories
Updated 2024-12-13
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
s.trader,
SUM(s.amount_in_usd) AS total_volume
FROM
near.defi.ez_dex_swaps s
WHERE
s.block_timestamp >= '2024-01-01'
AND s.block_timestamp <= '2024-12-31'
GROUP BY
s.trader
),
categorized_traders AS (
SELECT
trader,
total_volume,
CASE
WHEN total_volume > 100000 THEN 'Whale'
WHEN total_volume > 10000
AND total_volume <= 999999 THEN 'dolphins'
WHEN total_volume > 1000
AND total_volume <= 9999 THEN 'Crab'
WHEN total_volume > 1
AND total_volume <= 999 THEN 'Plankton'
ELSE 'Micro Plankton'
END AS trader_category
FROM
trader_volumes
)
SELECT
trader_category,
COUNT(DISTINCT trader) AS number_of_traders,
CASE
WHEN trader_category = 'Whale' THEN 'Volume > $100,000'
WHEN trader_category = 'dolphins' THEN 'Volume between $10,000 and $100,000'
WHEN trader_category = 'Crab' THEN 'Volume between $1,000 and $10,000'
Last run: 4 days ago
5
232B
583s