select
date_trunc('day',BLOCK_TIMESTAMP) as dt,
count(distinct TX_FROM) as active_user,
sum(active_user) over (order by dt asc) as cum_active
from osmosis.core.fact_transactions
where tx_id is not NULL
and TX_STATUS='SUCCEEDED'
and BLOCK_TIMESTAMP>='2022-01-01'
group by 1