sinahosseinzadehUntitled Query
    Updated 2022-08-08
    select
    block_timestamp::date as date,
    case
    when date < '2022-07-01' then 'Before July'
    when date >= '2022-07-01' and date <= '2022-07-31' then 'July'
    when date > '2022-07-31' then 'After July'
    end as period,
    count(distinct tx_hash) / (24 * 60 * 60) as tps,
    count(distinct tx_hash) / (24 * 60) as tx_per_min
    from optimism.core.fact_transactions
    group by 1
    Run a query to Download Data