CATEGORY | USER_COUNT | |
|---|---|---|
1 | 📂 2-3 days | 1158 |
2 | 📈 6-7 days | 1015 |
3 | 🗄️ 4-5 days | 914 |
4 | 🔑 8-10 days | 779 |
5 | 📥 1 day | 589 |
6 | 🚀 11-14 days | 425 |
Afonso_DiazGrouping Users By Their wallets Age
Updated 2025-04-11
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 main as (
select
from_address as user,
block_timestamp::date as transaction_date
from
mezo.testnet.fact_transactions
where
tx_succeeded
),
first_transaction as (
select
user,
min(transaction_date) as first_tx_date
from
main
group by
user
),
wallet_age as (
select
user,
first_tx_date,
datediff(day, first_tx_date, current_date) as age_in_days
from
first_transaction
)
select
case
WHEN age_in_days = 1 THEN '📥 1 day'
WHEN age_in_days BETWEEN 2 AND 3 THEN '📂 2-3 days'
WHEN age_in_days BETWEEN 4 AND 5 THEN '🗄️ 4-5 days'
WHEN age_in_days BETWEEN 6 AND 7 THEN '📈 6-7 days'
WHEN age_in_days BETWEEN 8 AND 10 THEN '🔑 8-10 days'
WHEN age_in_days BETWEEN 11 AND 14 THEN '🚀 11-14 days'
WHEN age_in_days BETWEEN 15 AND 30 THEN '💼 15-30 days'
Last run: 14 days ago
6
138B
1s