date(block_timestamp) as dates,

count(distinct(tx_id)) as n_transactions,

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

FROM solana.core.fact_transactions

where dates >= '2022-01-01'

group by dates

order by dates desc