MONTH | ACTIVE_USERS | NEW_USERS | RECURRING_USERS | CUM_TOTAL_USERS_MILLIONS | |
|---|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 408001 | 212597 | 195404 | 2.162321 |
2 | 2024-12-01 00:00:00.000 | 464830 | 269100 | 195730 | 1.949724 |
3 | 2024-11-01 00:00:00.000 | 555344 | 367862 | 187482 | 1.680624 |
4 | 2024-10-01 00:00:00.000 | 242155 | 91492 | 150663 | 1.312762 |
5 | 2024-09-01 00:00:00.000 | 381926 | 236941 | 144985 | 1.22127 |
6 | 2024-08-01 00:00:00.000 | 220381 | 86245 | 134136 | 0.984329 |
7 | 2024-07-01 00:00:00.000 | 211749 | 79111 | 132638 | 0.898084 |
8 | 2024-06-01 00:00:00.000 | 216302 | 83844 | 132458 | 0.818973 |
9 | 2024-05-01 00:00:00.000 | 223879 | 88647 | 135232 | 0.735129 |
10 | 2024-04-01 00:00:00.000 | 226093 | 88882 | 137211 | 0.646482 |
11 | 2024-03-01 00:00:00.000 | 273062 | 132224 | 140838 | 0.5576 |
12 | 2024-02-01 00:00:00.000 | 271804 | 145784 | 126020 | 0.425376 |
13 | 2024-01-01 00:00:00.000 | 279592 | 279592 | 0 | 0.279592 |
permarymonthly stellar users
Updated 2025-02-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 monthly_users as (
select
date_trunc('month', block_timestamp) as month,
account,
min(date_trunc('month', block_timestamp)) over (partition by account) as first_active_month
from stellar.core.fact_transactions
where account is not null
),
user_metrics as (
select
month,
count(distinct account) as active_users,
count(distinct case when month = first_active_month then account end) as new_users,
count(distinct case when month > first_active_month then account end) as recurring_users
from monthly_users
group by month
),
cumulative_metrics as (
select
month,
active_users,
new_users,
recurring_users,
sum(new_users) over (order by month) as cum_total_users
from user_metrics
)
select
month,
active_users,
new_users,
recurring_users,
cum_total_users::float/1e6 as cum_total_users_millions
from cumulative_metrics
where month >= (select min(date_trunc('month', block_timestamp)) from stellar.core.fact_transactions)
and month < date_trunc('month', current_timestamp())
order by month desc;
Last run: about 2 months ago
13
741B
280s