select block_timestamp::date as date,
sum(tx_fee) as collected_fees,
sum(collected_fees) over (order by date) as cumulative_collected_fees
from
optimism.core.fact_transactions
where month(block_timestamp) = 6 and year(block_timestamp) = 2022
group by 1