txns as (

select

*

from flow.core.fact_transactions

select

block_timestamp::date as date,

TX_SUCCEEDED as type,

count(distinct proposer) as n_users,

count(distinct tx_id) as tx_frequncy,

sum(n_users) over (order by date asc rows between unbounded preceding and current row) as cum_n_users,

sum(tx_frequncy) over (order by date asc rows between unbounded preceding and current row) as cum_tx_frequncy

from txns

where block_timestamp between '2022-05-01' and '2022-05-30'

group by date, type