DATE_TRUNC('DAY', block_timestamp) AS "Day",

COUNT(tx_hash) AS "Total Transactions"

FROM ink.core.fact_transactions

GROUP BY "Day"

ORDER BY "Day";