with daily_fees as(
SELECT
date_trunc('day', block_timestamp) AS day,
SUM(fee)/POW(10,9) AS total_fees_per_day
FROM
solana.transactions
WHERE
day >= '2022-01-01'
GROUP BY day
ORDER BY day ASC
)
SELECT
day,
SUM(total_fees_per_day) over(ORDER BY day ASC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) as CUM_DAYLY_FEES
FROM daily_fees