date(block_timestamp) as dates,

count(distinct(tx_id)) as n_transactions,

sum(n_transactions) over (order by dates) as cum_trans

from flow.core.fact_transactions

where dates >= '2022-04-01'

and chain_id = 'flow'

group by dates

order by dates desc