Query editor
SELECTdate_trunc('month', block_date) AS month,COUNT(*) AS total_transactions,COUNT(*) / DAY(LAST_DAY_OF_MONTH(date_trunc('month', block_date))) AS avg_daily_transactionsFROM arbitrum.transactionsWHERE block_date >= DATE '2023-03-01'AND block_date < DATE '2026-03-01'GROUP BY 1ORDER BY 1