COUNT(*) AS total_transactions

FROM

bitcoin.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= '2024-09-01' AND BLOCK_TIMESTAMP < '2024-10-01';