DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",

COUNT(DISTINCT TX_HASH) AS "Number of Transactions"

FROM

base.core.fact_transactions

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

ORDER BY

"Date";