DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS date_group,

COUNT(*) AS count

bitcoin.core.fact_transactions

GROUP BY

date_group

ORDER BY

date_group;