With number_of_tx as (select
date_trunc('week', block_timestamp) AS week,
COUNT(fee) AS txs --for measuring the number of rows
from solana.transactions
where week >= '2022-01-01'
group by week
order by week ASC)
SELECT
week,
txs,
SUM (txs) over (ORDER BY week ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS Cum_number_of_txs
FROM number_of_tx