TRANSACTION_GROUP | TOTAL_USERS | TOTAL_TRANSACTIONS | |
---|---|---|---|
1 | >500K | 1 | 2855994 |
2 | 100K-500K | 1 | 116610 |
3 | <100 | 9985 | 36342 |
4 | 1K-5K | 11 | 31051 |
5 | 5K-10K | 3 | 23535 |
6 | 10K-50K | 1 | 11648 |
7 | 100-500 | 45 | 11185 |
8 | 500-1K | 9 | 5975 |
par_rnSwell 04
Updated 2025-02-01
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
›
⌄
WITH user_transaction_groups AS (
SELECT
FROM_ADDRESS AS user_address,
COUNT(DISTINCT TX_HASH) AS total_transactions,
CASE
WHEN COUNT(DISTINCT TX_HASH) < 100 THEN '<100'
WHEN COUNT(DISTINCT TX_HASH) BETWEEN 100 AND 500 THEN '100-500'
WHEN COUNT(DISTINCT TX_HASH) BETWEEN 500 AND 1000 THEN '500-1K'
WHEN COUNT(DISTINCT TX_HASH) BETWEEN 1000 AND 5000 THEN '1K-5K'
WHEN COUNT(DISTINCT TX_HASH) BETWEEN 5000 AND 10000 THEN '5K-10K'
WHEN COUNT(DISTINCT TX_HASH) BETWEEN 10000 AND 50000 THEN '10K-50K'
WHEN COUNT(DISTINCT TX_HASH) BETWEEN 50000 AND 100000 THEN '50K-100K'
WHEN COUNT(DISTINCT TX_HASH) BETWEEN 100000 AND 500000 THEN '100K-500K'
ELSE '>500K'
END AS transaction_group
FROM swell.core.fact_transactions
GROUP BY FROM_ADDRESS
)
SELECT
transaction_group,
COUNT(user_address) AS total_users,
SUM(total_transactions) AS total_transactions
FROM user_transaction_groups
GROUP BY transaction_group
ORDER BY total_transactions DESC
Last run: 24 days ago
8
161B
1s