block_timestamp::date as date,

status,

count(distinct tx_hash) as number_of_txs,

sum(number_of_txs) over(partition by status order by date) as total_txs

from optimism.core.fact_transactions

where date >= '2022-07-01'

and date <= '2022-07-31'

group by 1,2