-- WHERE block_timestamp >= '2022-05-1'
-- AND block_timestamp <= '2021-05-31'
SELECT count(address) as total_new_wallets ,
date_trunc('day',b.block_timestamp) as DAY
FROM algorand.account a LEFT JOIN algorand.block b
ON a.created_at = b.block_id
WHERE block_timestamp >= '2022-05-1'
AND block_timestamp <= '2022-05-31'
GROUP BY DAY