Query editor
--- Ethereum, Optimism, Arbitrum, Base, Scroll, zkSyncoptimism.transactionswitheth_tx as (SELECT date_trunc('day', block_time) as period,count(*) as transfersFROM ethereum.transactionsgroup by 1),opt_tx as (SELECT date_trunc('day', block_time) as period,count(*) as transfersFROM optimism.transactionsgroup by 1),arb_tx as (SELECT date_trunc('day', block_time) as period,count(*) as transfersFROM arbitrum.transactionsgroup by 1),base_tx as (SELECT date_trunc('day', block_time) as period,count(*) as transfersFROM base.transactionsgroup by 1),scroll_tx as (SELECT date_trunc('day', block_time) as period,count(*) as transfersFROM scroll.transactionsgroup by 1),zk_tx as (SELECT date_trunc('day', block_time) as period,count(*) as transfersFROM zksync.transactionsgroup by 1),merge as(select *, 'ETHEREUM' as network from eth_txunion allselect *, 'OPTIMISM' as network from opt_txunion allselect *, 'ARBITRUM' as network from arb_txunion allselect *, 'BASE' as network from base_txunion allselect *, 'SCROLL' as network from scroll_txunion allselect *, 'ZKSYNC' as network from zk_tx)select * from mergewhere period >= date_trunc('day', current_date - interval '365' day)and period < date_trunc('day', current_date)order byDATE(period) desc