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