BLOCK_TIMESTAMP::DATE AS Day,

COUNT(DISTINCT(TX_ID)) AS Transactions

FROM cosmos.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= {{start_date}}

GROUP BY Day

ORDER BY Day;