with success as ( select date(BLOCK_TIMESTAMP) as date, count(DISTINCT(tx_hash)) as success from optimism.core.fact_transactions where BLOCK_TIMESTAMP::date >= '2022-07-01' and BLOCK_TIMESTAMP::date <= '2022-08-01' and STATUS = 'SUCCESS' group by 1) , failed as ( select date(BLOCK_TIMESTAMP) as p_date , count(DISTINCT(tx_hash)) as failed from optimism.core.fact_transactions where BLOCK_TIMESTAMP::Date >= '2022-07-01' and BLOCK_TIMESTAMP::date < '2022-08-01' and STATUS = 'FAIL' group by 1) , total_tx as ( select date(BLOCK_TIMESTAMP) as d_date , count(DISTINCT(tx_hash)) as total_tx from optimism.core.fact_transactions where BLOCK_TIMESTAMP::Date >= '2022-07-01' and BLOCK_TIMESTAMP::date < '2022-08-01' group by 1) , final_op as ( select avg(total_tx) as average_tx , sum(total_tx) as total , total/2628000 as TPS, total/43200 as TPM, total/720 as TPH from total_tx where d_date >= '2022-07-01' and d_date < '2022-08-01') , eth_success as ( select date(BLOCK_TIMESTAMP) as date, count(DISTINCT(tx_hash)) as success from ethereum.core.fact_transactions where BLOCK_TIMESTAMP::date >= '2022-07-01' and BLOCK_TIMESTAMP::date <= '2022-08-01' and STATUS = 'SUCCESS' group by 1) , eth_failed as ( select date(BLOCK_TIMESTAMP) as p_date , count(DISTINCT(tx_hash)) as failed from ethereum.core.fact_transactions where BLOCK_TIMESTAMP::Date >= '2022-07-01' and BLOCK_TIMESTAMP::date < '2022-08-01' and STATUS = 'FAIL' group by 1) , eth_total_tx as ( select date(BLOCK_TIMESTAMP) as d_date , count(DISTINCT(tx_hash)) as total_tx from ethereum.core.fact_transactions where BLOCK_TIMESTAMP::Date >= '2022-07-01' and BLOCK_TIMESTAMP::date < '2022-08-01' group by 1) , final_eth as ( select avg(total_tx) as average_tx , sum(total_tx) as total , total/2628000 as TPS, total/43200 as TPM, total/720 as TPH from eth_total_tx where d_date >= '2022-07-01' and d_date < '2022-08-01') , arb_success as ( select date(BLOCK_TIMESTAMP) as date, count(DISTINCT(tx_hash)) as success from arbitrum.core.fact_transactions where BLOCK_TIMESTAMP::date >= '2022-07-01' and BLOCK_TIMESTAMP::date <= '2022-08-01' and STATUS = 'SUCCESS' group by 1) , arb_failed as ( select date(BLOCK_TIMESTAMP) as p_date , count(DISTINCT(tx_hash)) as failed from arbitrum.core.fact_transactions where BLOCK_TIMESTAMP::Date >= '2022-07-01' and BLOCK_TIMESTAMP::date < '2022-08-01' and STATUS = 'FAIL' group by 1) , arb_total_tx as ( select date(BLOCK_TIMESTAMP) as d_date , count(DISTINCT(tx_hash)) as total_tx from arbitrum.core.fact_transactions where BLOCK_TIMESTAMP::Date >= '2022-07-01' and BLOCK_TIMESTAMP::date < '2022-08-01' group by 1) , final_arb as ( select avg(total_tx) as average_tx , sum(total_tx) as total , total/2628000 as TPS, total/43200 as TPM, total/720 as TPH from arb_total_tx where d_date >= '2022-07-01' and d_date < '2022-08-01') select 'Ethereum' as type, * from final_eth UNION select 'Arbitrum' as type, * from final_arb UNION select 'Optimism' as type,* from final_op

Optimistic Bears