Query editor
with arbitrum as (SELECTdate_trunc('week',block_time) as date_time,"from" as user,hash as total_transactionsFROM arbitrum.transactionsWHERE success = trueand block_time >= current_date - interval '365' day),optimism as (SELECTdate_trunc('week',block_time) as date_time,"from" as user,hash as total_transactionsFROM optimism.transactionsWHERE success = trueand DATE(block_time) >= current_date - interval '365' day),base as (SELECTdate_trunc('week',block_time) as date_time,"from" as user,hash as total_transactionsFROM base.transactionsWHERE success = trueand DATE(block_time) >= current_date - interval '365' day),ethereum as (SELECTdate_trunc('week',block_time) as date,COUNT(DISTINCT("from")) as active_users,COUNT(DISTINCT(hash)) as total_transactions,SUM(COUNT(DISTINCT(hash))) OVER (ORDER BY date_trunc('week',block_time)) as cumulative_transactionsFROM ethereum.transactionsWHERE success = trueand DATE(block_time) >= current_date - interval '365' dayGROUP BY date_trunc('week',block_time)ORDER BY date_trunc('week',block_time) DESC),combined_l2 as (SELECTdate_time as date,COUNT(DISTINCT(user)) as active_users,COUNT(DISTINCT(total_transactions)) as total_transactions,SUM(COUNT(DISTINCT(total_transactions))) OVER (ORDER BY date_time) as cumulative_transactionsFROM (SELECT *FROM arbitrumUNION ALLSELECT *FROM optimismUNION ALLSELECT *FROM base) f