with Op_air as ( -- forked from 0f8a5ac5-0d03-4f46-8383-b3a5f3935518 select date_trunc('hour', block_timestamp) as hours, count(distinct tx_hash) as hourly_claim_tx_count_Op --sum(raw_amount/1e18) as OP_amount_claimed, --sum(OP_amount_claimed) over (order by day) as cum_OP_amount_claimed, --sum(claimer_count) over (order by day) as cum_claimer_count, --214748364.80 as total_OP_airdrop_amount, --248699 as eligible_OP_claimers from optimism.core.fact_token_transfers where from_address ilike '0xFeDFAF1A10335448b7FA0268F56D2B44DBD357de' and contract_address = '0x4200000000000000000000000000000000000042' and origin_function_signature ilike '0x2e7ba6ef' and hours <= '2022-06-01 14:00:00' group by 1 ), RB_air as ( select date_trunc('hour', block_timestamp) as hour, count(distinct tx_hash) as hourly_claim_tx_count_Arb from arbitrum.core.fact_transactions where origin_function_signature = '0x4e71d92d' and to_address = '0x67a24ce4321ab3af51c2d0a4801c3e111d88c9d9' and status = 'SUCCESS' and hour <= '2023-03-24 13:00:00' group by 1 ), air as ( select RB_air.*, OP_air.* from RB_air join OP_air on DATEDIFF(hour, OP_air.hours, RB_air.hour) = 7103 ), parameter3 as ( with parameter as ( select RB.*, OP.* from ( select date_trunc('hour', block_timestamp) as hours, count(distinct tx_hash) as OP_hourly_tx_count, sum(tx_fee) as OP_hourly_fee, (count(distinct tx_hash)/count(distinct block_number)) as OP_hourly_avg_tx_per_block, avg(tx_fee) as OP_hourly_avg_fee_per_tx, avg(gas_price) as OP_hourly_avg_gas_price_per_tx from optimism.core.fact_transactions where hours <= '2022-06-01 14:00:00' and hours >= '2022-05-31 14:00:00' and status = 'SUCCESS' group by 1 ) OP join ( select date_trunc('hour', block_timestamp) as hour, count(distinct tx_hash) as Arbitrum_hourly_tx_count, sum(tx_fee) as Arbitrum_hourly_fee, (count(distinct tx_hash)/count(distinct block_number)) as Arbitrum_hourly_avg_tx_per_block, avg(tx_fee) as Arbitrum_hourly_avg_fee_per_tx, avg(gas_price_paid) as Arbitrum_hourly_avg_gas_price_per_tx from arbitrum.core.fact_transactions where hour <= '2023-03-24 13:00:00' and hour >= '2023-03-23 13:00:00' and status = 'SUCCESS' group by 1 ) RB on DATEDIFF(hour, OP.hours, RB.hour) = 7103 --OP.hour = RB.hour ), parameter2 as ( select U.*, I.* from ( select count(distinct case when status = 'SUCCESS' then tx_hash end) as total_succeded_txs_OP, sum(case when status = 'SUCCESS' then tx_fee end) as total_paid_fee_OP, count(distinct case when status <> 'SUCCESS' then tx_hash end) as total_failed_txs_OP, avg(tx_fee) as average_fee_per_tx_OP, (count(distinct case when status = 'SUCCESS' then tx_hash end)/count(distinct case when status <> 'SUCCESS' then tx_hash end)) as Ratio_of_succeded_to_failed_tx_OP from optimism.core.fact_transactions where date_trunc('hour', block_timestamp) <= '2022-06-01 14:00:00' and date_trunc('hour', block_timestamp) >= '2022-05-31 14:00:00' ) U join ( select count(distinct case when status = 'SUCCESS' then tx_hash end) as total_succeded_txs_RB, sum(case when status = 'SUCCESS' then tx_fee end) as total_paid_fee_RB, count(distinct case when status <> 'SUCCESS' then tx_hash end) as total_failed_txs_RB, avg(case when status = 'SUCCESS' then tx_fee end) as average_fee_per_tx_RB, (count(distinct case when status = 'SUCCESS' then tx_hash end)/count(distinct case when status <> 'SUCCESS' then tx_hash end)) as Ratio_of_succeded_to_failed_tx_RB from arbitrum.core.fact_transactions where date_trunc('hour', block_timestamp) <= '2023-03-24 13:00:00' and date_trunc('hour', block_timestamp) >= '2023-03-23 13:00:00' ) I ) select parameter.*, parameter2.* from parameter join parameter2 ) select air.*, parameter3.* from air join parameter3 on parameter3.hour = air.hour

Arbitrum VS Optimism, which one was beter?