WITH
AD (ADDRESS,CREATED_AT, BALANCE) AS (
SELECT ADDRESS, CREATED_AT, BALANCE FROM flipside_prod_db.algorand.account
)
SELECT
AD.ADDRESS,
BALANCE
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
ORDER BY 2 DESC