Query editor
with eth as (-- ethereumselect'ethereum' as blockchain,date_trunc('month', block_time) as month,count(*) as num_txsfrom ethereum.transactionswhere block_time > date('2023-01-01') AND date_trunc('month', block_time) >= date('2023-01-01')and block_time < current_dategroup by 1, 2-- polygonUNION ALLselect'polygon' as blockchain,date_trunc('month', block_time) as month,count(*) as num_txsfrom polygon.transactionswhere block_time > date('2023-01-01') AND date_trunc('month', block_time) >= date('2023-01-01')and block_time < current_dategroup by 1, 2-- gnosisunion allselect'gnosis' as blockchain,date_trunc('month', block_time) as month, count(*) as num_txsfrom gnosis.transactionswhere block_time > date('2023-01-01') AND date_trunc('month', block_time) >= date('2023-01-01')and block_time < current_dategroup by 1, 2-- optimismunion allselect'optimism' as blockchain,date_trunc('month', block_time) as month, count(*) as num_txsfrom optimism.transactionswhere block_time > date('2023-01-01') AND date_trunc('month', block_time) >= date('2023-01-01')and block_time < current_dategroup by 1, 2-- arbitrumunion allselect'arbitrum' as blockchain,date_trunc('month', block_time) as month, count(*) as num_txsfrom arbitrum.transactionswhere block_time > date('2023-01-01') AND date_trunc('month', block_time) >= date('2023-01-01')and block_time < current_dategroup by 1, 2-- baseunion allselect'base' as blockchain,date_trunc('month', block_time) as month, count(*) as num_txsfrom base.transactionswhere block_time > date('2023-01-01') AND date_trunc('month', block_time) >= date('2023-01-01')and block_time < current_date