Query editor
-- select-- date_trunc('month', day) as month,-- chain,-- sum(transactions) as transactions-- from dune.arbitrum.arbitrum_chains_activity_comprehensive-- group by 1,2-- order by 1 desc,2select date_trunc('month', day) as month,chain,sum(transactions) as transactionsfrom (selectday,chain,transactionsfrom dune.arbitrum.arbitrum_chains_activity_comprehensiveunion allselectblock_date as day,blockchain as chain,count(*) as transactionsfrom gas.feeswhere blockchain in ('nova', 'arbitrum')and tx_to != 0x00000000000000000000000000000000000A4B05and block_month >= date '2024-04-01'group by 1,2)group by 1,2order by 1 desc