Date | Total Users | New Users | Active Users | |
|---|---|---|---|---|
1 | 2024-10-01 00:00:00.000 | 3840409 | 3840409 | 0 |
2 | 2024-11-01 00:00:00.000 | 3779818 | 2151763 | 1628055 |
3 | 2024-12-01 00:00:00.000 | 2741871 | 809159 | 1932712 |
4 | 2025-01-01 00:00:00.000 | 1769242 | 460129 | 1309113 |
5 | 2025-02-01 00:00:00.000 | 1663008 | 381441 | 1281567 |
6 | 2025-03-01 00:00:00.000 | 1097577 | 230860 | 866717 |
Eman-RazRonin Users Over Time
Updated 2025-03-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with table1 as (select date_trunc('{{Time_Frame}}',block_timestamp) as "Date", count(distinct from_address) as "Total Users"
from ronin.core.fact_transactions
where tx_succeeded='TRUE'
group by 1),
table2 as (with tab1 as (select from_address as user, min(block_timestamp::date) as first_date
from ronin.core.fact_transactions
where tx_succeeded='TRUE'
group by 1)
select date_trunc('{{Time_Frame}}',first_date) as "Date", count(distinct user) as "New Users"
from tab1
group by 1)
select table1."Date", "Total Users", "New Users", "Total Users"-"New Users" as "Active Users"
from table1 left join table2 on table1."Date"=table2."Date"
order by 1
Last run: about 1 month ago
6
302B
8s