select
block_timestamp ::date as day,
count(distinct tx_hash) as txns_count,
count(distinct from_address) as users_count,
sum(txns_count) over (order by day) as cumulative_txns_count,
sum(users_count) over (order by day) as cumulative_users_count
from optimism.core.fact_transactions
where block_timestamp >= '2022-06-01'
group by day
order by day