princefarzam What is the average ALGO holding of these new wallets?
    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
    ),
    Group_1 AS ( --hold more than Algo
    SELECT
    date_trunc('day',block_timestamp)::DATE AS DAY,
    AVG(BALANCE) AS Average_Algo_balance
    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'
    AND BALANCE >=1
    GROUP BY 1
    ORDER BY 1 ASC),
    Group_0 AS ( --hold less than Algo
    SELECT
    date_trunc('day',block_timestamp)::DATE AS DAY,
    AVG(BALANCE) AS Average_Algo_balance
    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 1 ASC)

    SELECT
    Run a query to Download Data