TRANSACTION_GROUP | USER_COUNT | |
|---|---|---|
1 | 🟢 1 Transaction | 500861 |
2 | 🔵 2-5 Transactions | 223161 |
3 | 🟡 6-10 Transactions | 18298 |
4 | 🟠 11-25 Transactions | 6767 |
5 | 🔴 >50 Transactions | 1783 |
6 | 🟣 26-50 Transactions | 1367 |
Afonso_Diazusers
Updated 2025-01-31
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
›
⌄
WITH user_transactions AS (
SELECT
swapper,
COUNT(DISTINCT tx_id) AS transaction_count
FROM
solana.defi.ez_dex_swaps
WHERE
Swap_from_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'
OR swap_to_mint = '2zMMhcVQEXDtdE6vsFS7S7D5oUodfJHE8vd1gnBouauv'
GROUP BY
swapper
)
SELECT
CASE
WHEN transaction_count = 1 THEN '🟢 1 Transaction'
WHEN transaction_count BETWEEN 2 AND 5 THEN '🔵 2-5 Transactions'
WHEN transaction_count BETWEEN 6 AND 10 THEN '🟡 6-10 Transactions'
WHEN transaction_count BETWEEN 11 AND 25 THEN '🟠 11-25 Transactions'
WHEN transaction_count BETWEEN 26 AND 50 THEN '🟣 26-50 Transactions'
ELSE '🔴 >50 Transactions'
END AS Transaction_Group,
COUNT(*) AS User_Count
FROM
user_transactions
GROUP BY
Transaction_Group
ORDER BY
User_Count DESC;
Last run: 27 days ago
6
194B
67s