DATE_TRUNC('YEAR', BLOCK_TIMESTAMP) AS year,

COUNT(*) AS total_transactions

FROM

bitcoin.core.fact_transactions

WHERE

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

GROUP BY

DATE_TRUNC('year', BLOCK_TIMESTAMP)

ORDER BY

year;