princefarzamWhat % of total wallets with more than 1 ALGO is this?
    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,
    BALANCE
    FROM algorand.account
    )
    SELECT
    CASE
    WHEN BALANCE >=1 THEN 'WALLETS WITH MORE THAN ONE ALGO'
    ELSE 'WALLETS WITH LESS THAN ONE ALGO'
    END AS BALANCE,
    COUNT(DISTINCT A.ADDRESS) AS New_wallets
    FROM Addresses A INNER JOIN Time T ON A.CREATED_AT=T.block_id
    WHERE T.block_timestamp::DATE >= '2022-05-01' -- may
    AND T.block_timestamp::DATE < '2022-06-01'
    GROUP BY 1
    --ORDER BY ASC
    Run a query to Download Data