block_timestamp :: DATE as date,

COUNT(tx_hash) as n_tx

FROM ethereum.core.fact_transactions

WHERE block_timestamp :: DATE BETWEEN '2024-01-01' AND '2024-01-31'

GROUP BY date

ORDER BY date;