select date(block_timestamp) as day, sum(fee) as daily_fee,
sum(daily_fee) over (order by day asc) as cum_daily_fee,
count (distinct tx_id) as count_transaction
from flipside_prod_db.algorand.transactions
where day >= '2022-01-01' and day <= '2022-07-02' and fee is not null
group by 1