date_trunc('day', block_timestamp),

count_if(status like 'SUCCESS')/ 86400 as Succesful_TPS

from optimism.core.fact_transactions

where block_timestamp > '2022-07-01'

group by 1