date_trunc('month', block_timestamp) AS month,

COUNT(unit_id) AS "new units"

FROM crosschain.olas.ez_unit_registrations

WHERE

block_timestamp >= TO_TIMESTAMP('{{start_date}}')

AND block_timestamp < TO_TIMESTAMP('{{end_date}}')

GROUP BY month

ORDER BY month;