BLOCK_TIMESTAMP::date as date ,

count (DISTINCT tx_hash )/(24*60*60) TPS

from optimism.core.fact_transactions

where STATUS = 'SUCCESS'

and BLOCK_TIMESTAMP::date >= CURRENT_DATE-30

group by 1