SELECT date_trunc('day', block_timestamp) as date,

SUM(fee) as total_algo_fee

FROM flipside_prod_db.algorand.transactions

WHERE block_timestamp >= '2022-01-01'

GROUP BY date)

SELECT date, total_algo_fee, SUM(total_algo_fee) OVER (ORDER BY date ASC) as fee_sum

FROM tx

ORDER BY DATE DESC