date_trunc('month', block_timestamp) AS month,

COUNT(tx_hash) AS transactions

FROM base.core.fact_transactions

WHERE block_timestamp::DATE >= '2023-03-01'

AND block_timestamp::DATE < current_date

GROUP BY month