count(*) , DATE_TRUNC('day',block_timestamp) AS day_timestamp

FROM solana.events

WHERE day_timestamp >= ('2022-01-01 00:00:00.000 -0000') AND day_timestamp < ('2022-02-01 00:00:00.000 -0000') AND event_type = 'createAccount'

GROUP BY day_timestamp

ORDER BY day_timestamp ASC