Query editor
witheth as (SELECTdate_trunc('day', block_time) AS time, COUNT(*) AS daily_txFROM ethereum.transactionswhere block_time > now() - interval '6 months'and not ( -- remove arbitrum and optimism batch tx`to` = lower('0x4c6f947Ae67F572afa4ae0730947DE7C874F95Ef') -- Arbitrum: Sequencer InboxOR `to` = lower('0x51de512aa5dfb02143a91c6f772261623ae64564') -- Arbitrum: Validator1OR `to` = lower('0x1c479675ad559DC151F6Ec7ed3FbF8ceE79582B6') -- Arbitrum: Sequencer Inbox NITROOR `to` = lower('0x72Ce9c846789fdB6fC1f34aC4AD25Dd9ef7031ef') -- Arbitrum: Gateway RouterOR `to` = lower('0x4BF681894abEc828B212C906082B444Ceb2f6cf6') -- Optimism: OVM Canonical Transaction Chain OLDOR `to` = lower('0x5E4e65926BA27467555EB562121fac00D24E9dD2') -- Optimism: OVM Canonical Transaction Chain NEWOR `to` = lower('0xBe5dAb4A2e9cd0F27300dB4aB94BeE3A233AEB19') -- Optimism: OVM State Commitment Chain NewOR `to` = lower('0xc4448b71118c9071Bcb9734A0EAc55D18A153949') -- Arbitrum Nova: Delayed InboxOR `to` = lower('0xD4B80C3D7240325D18E645B49e6535A3Bf95cc58') -- Arbitrum Nova: Outbox)GROUP BY time), op as (SELECTdate_trunc('day', block_time) AS time, COUNT(*) AS daily_txFROM optimism.transactionswhere block_time > now() - interval '6 months'and `to` != lower('0x420000000000000000000000000000000000000f')GROUP BY time), arb as (SELECTdate_trunc('day', block_time) AS time, COUNT(*) AS daily_txFROM arbitrum.transactionswhere block_time > now() - interval '6 months'and `to` != lower('0x00000000000000000000000000000000000a4b05')GROUP BY time)select eth.time, eth.daily_tx as eth_daily_tx, op.daily_tx as op_daily_tx, arb.daily_tx as arb_daily_txfrom ethleft join op on eth.time=op.timeleft join arb on eth.time=arb.time