ErsvanAverage of ALGO in these wallets created in May
    Updated 2022-06-16
    WITH
    AD (ADDRESS,CREATED_AT, BALANCE) AS (
    SELECT ADDRESS, CREATED_AT, BALANCE FROM flipside_prod_db.algorand.account
    )

    SELECT
    AVG(BALANCE) AS WALLET_AVG
    FROM
    AD
    JOIN flipside_prod_db.algorand.block ON AD.CREATED_AT = BLOCK_ID
    WHERE
    BLOCK_TIMESTAMP BETWEEN '2022-05-01' AND '2022-05-31'
    AND BALANCE > 1

    Run a query to Download Data