date_trunc('day',block_timestamp) as date,

SUM(tx_fee) AS daily_fee,

SUM(daily_fee) OVER (ORDER BY block_timestamp::date) AS cum_fee

FROM gnosis.core.fact_transactions

WHERE date >= '2022-01-01'

GROUP BY 1

ORDER BY 1