sinahosseinzadehUntitled Query
    Updated 2022-08-08
    with tps as (select date_trunc('second',BLOCK_TIMESTAMP) sec,count(*) tx_count
    from optimism.core.fact_transactions
    where BLOCK_TIMESTAMP::date>='2022-07-01'
    group by 1)
    select sec::date date,avg(tx_count) avg_tps
    from tps
    group by 1
    Run a query to Download Data