DATE_TRUNC('month', BLOCK_TIMESTAMP) AS month,

COUNT(*) AS total_transactions

FROM

bitcoin.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= '2024-01-01' AND BLOCK_TIMESTAMP < '2025-01-01';

GROUP BY

month

ORDER BY

month;