DATE_TRUNC(day, block_timestamp) as date,

count(*) as tx_count,

sum(tx_count) over (order by date asc) as cumu_tx

from optimism.core.fact_transactions

where status = 'SUCCESS' and block_timestamp::date < CURRENT_DAte and block_timestamp::date >= '2022-07-01'

group by date