count(DISTINCT tx_from_address) , DATE_TRUNC('day',block_timestamp) AS day_timestamp

FROM solana.transactions

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

GROUP BY day_timestamp

ORDER BY day_timestamp ASC