Query editor
SELECT date_trunc('day',block_time) as day,blockchain,count(*) as txnsFROM evms.transactionsWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '365' dayand blockchain in ('base','arbitrum','optimism','zksync','blast','scroll','linea','mantle','zora','mode','zkevm')GROUP BY 1,2union allSELECT date_trunc('day',block_time) as day,'starknet' as blockchain,count(*) as txnsfrom starknet.transactionsWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '365' daygroup by 1,2union allSELECT date_trunc('day',block_time) as day,'world chain' as blockchain,count(*) as txnsfrom worldchain.transactionsWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '365' daygroup by 1,2union allSELECT date_trunc('day',block_time) as day,'unichain' as blockchain,count(*) as txnsfrom unichain.transactionsWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '365' daygroup by 1,2union allSELECT date_trunc('day',block_time) as day,'abstract' as blockchain,count(*) as txnsfrom abstract.transactionsWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '365' daygroup by 1,2union allSELECT date_trunc('day',block_time) as day,'ink' as blockchain,count(*) as txnsfrom ink.transactionsWHEREblock_time >= CURRENT_TIMESTAMP - INTERVAL '365' daygroup by 1,2union all