datavortexTrader category
Updated 2025-01-17
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
swapper AS trader,
SUM(COALESCE(amount_in_usd, 0)) AS total_traded_volume
FROM
aptos.defi.ez_dex_swaps
WHERE
symbol_in = 'DONK'
AND amount_in_usd IS NOT NULL
GROUP BY
swapper
),
categorized_traders AS (
SELECT
trader,
total_traded_volume,
CASE
WHEN total_traded_volume >= 100000 THEN 'Whale'
WHEN total_traded_volume BETWEEN 50000 AND 99999 THEN 'Crab'
WHEN total_traded_volume BETWEEN 10000 AND 49999 THEN 'Dolphin'
WHEN total_traded_volume BETWEEN 1000 AND 9999 THEN 'Shark'
WHEN total_traded_volume BETWEEN 100 AND 999 THEN 'Small Fish'
ELSE 'Plankton'
END AS category
FROM
trader_volumes
)
SELECT
category,
COUNT(trader) AS num_traders,
SUM(total_traded_volume) AS total_volume
FROM
categorized_traders
GROUP BY
category
ORDER BY
QueryRunArchived: QueryRun has been archived