USER_COUNT | ACTIVITY_TIER | |
|---|---|---|
1 | 123038 | 🟢 One-Time |
2 | 31947 | 🔁 Light User |
3 | 4494 | 🔂 Moderate |
4 | 605 | 🔥 Heavy User |
5 | 141 | 🚀 Grinder |
6 | 233 | 👑 Ultra Active |
sagharkariUser Distribution by Swap Frequency
Updated 2025-04-06
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
›
⌄
WITH user_activity AS (
SELECT
swapper,
COUNT(DISTINCT tx_id) AS swap_count
FROM solana.marinade.ez_swaps
WHERE succeeded = TRUE
AND block_timestamp >= DATE '2025-01-01'
AND (
swap_from_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So' OR
swap_to_mint = 'mSoLzYCxHdYgdzU16g5QSh3i5K3z3KZK7ytfqcJm7So'
)
GROUP BY swapper
)
SELECT
COUNT(*) AS user_count,
CASE
WHEN swap_count = 1 THEN '🟢 One-Time'
WHEN swap_count BETWEEN 2 AND 5 THEN '🔁 Light User'
WHEN swap_count BETWEEN 6 AND 20 THEN '🔂 Moderate'
WHEN swap_count BETWEEN 21 AND 50 THEN '🔥 Heavy User'
WHEN swap_count BETWEEN 51 AND 100 THEN '🚀 Grinder'
ELSE '👑 Ultra Active'
END AS activity_tier
FROM user_activity
GROUP BY activity_tier
ORDER BY MIN(swap_count);
Last run: 21 days ago
6
146B
2s