#Days of Activity | Users Count | |
|---|---|---|
1 | 2-7 Days | 2832399 |
2 | 1 Day | 2162740 |
3 | 8-30 Days | 1700466 |
4 | >30 Days | 1203868 |
Eman-RazDistribution of Users By # of Days of Activity
Updated 2025-03-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with tab1 as (select from_address as user, count(distinct block_timestamp::date), case
when count(distinct block_timestamp::date)=1 then '1 Day'
when count(distinct block_timestamp::date)>1 and count(distinct block_timestamp::date)<=7 then '2-7 Days'
when count(distinct block_timestamp::date)>7 and count(distinct block_timestamp::date)<=30 then '8-30 Days'
when count(distinct block_timestamp::date)>30 then '>30 Days'
end as "#Days of Activity"
from ronin.core.fact_transactions
where tx_succeeded='TRUE'
group by 1)
select "#Days of Activity", count(distinct user) as "Users Count"
from tab1
group by 1
order by 2 desc
Last run: about 1 month ago
4
83B
14s