FatemeTheLadyPerformance-TPS
    Updated 2023-02-18
    select
    block_timestamp::date as date,'Arbitrum' as type, count( tx_hash )/ 86400 as tps
    from arbitrum.core.fact_transactions
    where date between '2023-01-01' and '2023-02-10'
    group by 1
    union
    select
    block_timestamp::date as date,'Optimism' as type, count( tx_hash )/ 86400 as tps
    from optimism.core.fact_transactions
    where date between '2023-01-01' and '2023-02-10'
    group by 1
    order by 1 asc
    Run a query to Download Data