with user_list as (
select
from_address as users,
min(block_timestamp) as min_date,
count( tx_hash) as txs
from ethereum_core.fact_transactions
-- where min_date >= '2022-01-01'
group by 1
)
, ts as (
select
min_date::date as date,
count(users) as number_users
from user_list
-- where date >= '2021-01-01' and date < '2022-01-01'
group by 1
order by 1
)
select
date,
sum(number_users) over (order by date) as Cumulative,
number_users
from ts
group by 1,3
order by 3 desc
limit 20