Query editor
WITH bridge_summary AS (SELECTif(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f', 'One', 'Nova') AS target_chain_name,count(distinct `from`) AS user_count,count(1) AS tx_count,sum(value / power(10,18)) AS total_deposit_ethFROMethereum.transactionsWHERE(`to` = '0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f' -- Arbitrum One Official Bridgeor `to` = '0xc4448b71118c9071bcb9734a0eac55d18a153949' -- Arbitrum Nova Official Bridge)AND block_time >= '2021-05-29' -- frst dayAND success = trueGROUP BYtarget_chain_name),one_bridge_summary AS (SELECTuser_count,tx_count,total_deposit_ethFROMbridge_summaryWHEREtarget_chain_name = 'One'),nova_bridge_summary AS (SELECTuser_count,tx_count,total_deposit_ethFROMbridge_summaryWHEREtarget_chain_name = 'Nova')SELECTa.user_count AS one_user_count,a.tx_count AS one_tx_count,a.total_deposit_eth AS one_total_deposit_eth,b.user_count AS nova_user_count,b.tx_count AS nova_tx_count,b.total_deposit_eth as nova_total_deposit_ethFROMone_bridge_summary aLEFT JOIN nova_bridge_summary b ON true