select
date_trunc('day', enterance_date) as date,
case when date < '2023-01-01' then 'Before 2023'
else '2023'
END as "Time",
count(user) as "Number of New Users",
sum("Number of New Users") over (order by date) as "Cumulative Number of New Users (Past 2 Month)"
from (
select
tx_sender as user,
min(block_timestamp) as enterance_date
from terra.core.fact_transactions
group by 1
)
where enterance_date > current_date - interval '60 days'
group by 1
order by 1