Query editor
WITH eth_activity AS (SELECTDATE_TRUNC ('day', block_time) AS day,'ethereum' AS blockchain,COUNT (*) AS daily_txn,COUNT (DISTINCT ("from")) AS active_walletFROM ethereum.transactionsWHERE block_time >= CAST('2021-01-01' AS TIMESTAMP)GROUP BY 1),arb_activity AS (SELECTDATE_TRUNC ('day', block_time) AS day,'arbitrum' AS blockchain,COUNT (*) AS daily_txn,COUNT (DISTINCT ("from")) AS active_walletFROM arbitrum.transactionsWHERE block_time >= CAST('2021-01-01' AS TIMESTAMP)GROUP BY 1),op_activity AS (SELECTDATE_TRUNC ('day', block_time) AS day,'optimism' AS blockchain,COUNT (*) AS daily_txn,COUNT (DISTINCT ("from")) AS active_walletFROM optimism.transactionsWHERE block_time >= CAST('2021-01-01' AS TIMESTAMP)GROUP BY 1),base_activity AS (SELECTDATE_TRUNC ('day', block_time) AS day,'base' AS blockchain,COUNT (*) AS daily_txn,COUNT (DISTINCT ("from")) AS active_walletFROM base.transactionsWHERE block_time >= CAST('2021-01-01' AS TIMESTAMP)GROUP BY 1),blast_activity AS (SELECTDATE_TRUNC ('day', block_time) AS day,'blast' AS blockchain,COUNT (*) AS daily_txn,COUNT (DISTINCT ("from")) AS active_walletFROM blast.transactionsWHERE block_time >= CAST('2021-01-01' AS TIMESTAMP)GROUP BY 1),bnb_activity AS (SELECTDATE_TRUNC ('day', block_time) AS day,'bnb' AS blockchain,COUNT (*) AS daily_txn,COUNT (DISTINCT ("from")) AS active_walletFROM bnb.transactionsWHERE block_time >= CAST('2021-01-01' AS TIMESTAMP)GROUP BY 1),