WITH Time as(
SELECT
block_timestamp,
block_id
FROM algorand.block
WHERE block_timestamp >= '2022-05-01' --since May
AND block_timestamp < '2022-06-01' --since May
),
Addresses as(
SELECT
ADDRESS,
CREATED_AT
FROM algorand.account
)
SELECT
date_trunc('day', T.block_timestamp)::DATE AS day,
COUNT(DISTINCT A.ADDRESS) AS New_wallets
FROM Addresses A INNER JOIN Time T ON A.CREATED_AT=T.block_id
WHERE day::date >= '2022-05-01' -- may
AND day::date < '2022-06-01'
GROUP BY day
ORDER BY day ASC