SELECT b.block_timestamp::date as date, a.address AS address

FROM algorand.account a

JOIN algorand.block b

ON b.block_id=a.created_at

WHERE block_timestamp::date >= '2022-05-01'

AND account_closed = false

)

SELECT date, COUNT(DISTINCT address) AS number_of_new_wallets

FROM new_wallet

GROUP BY date

ORDER BY date