flipside

    Daily transactions(failed/succeeded) in each second
    ML6Daily transactions(failed/succeeded) in each second
    Updated 2022-08-08
    select count(distinct TX_HASH)/(24*60*60) as t_seconds,to_date(BLOCK_TIMESTAMP) ,STATUS
    from optimism.core.fact_transactions
    where to_date(BLOCK_TIMESTAMP) > '2022-06-30' and to_date(BLOCK_TIMESTAMP) <= '2022-07-31'
    group by 2,3
    Run a query to Download Data