princefarzamHow many new wallets were created in May?
    Updated 2022-06-16
    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
    Run a query to Download Data