DATE_TRUNC('day', BLOCK_TIMESTAMP) AS day,

COUNt(*) AS daily_transaction

FROM

bitcoin.core.fact_transactions

WHERE

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

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

day;