WITH accounts AS (

SELECT * FROM flipside_prod_db.algorand.account

), blocks AS (

SELECT * FROM flipside_prod_db.algorand.block

), assets AS(

SELECT ADDRESS, ASSET_NAME, AMOUNT FROM flipside_prod_db.algorand.account_asset

WHERE AMOUNT > 0

), main AS (

SELECT

accounts.ADDRESS AS address,

blocks.BLOCK_TIMESTAMP AS created_at,

accounts.BALANCE AS balance,

accounts.ACCOUNT_DATA AS metadata

FROM accounts, blocks

WHERE blocks.BLOCK_ID = accounts.CREATED_AT

AND accounts.ACCOUNT_CLOSED = FALSE

ORDER BY created_at DESC

), may_wallets_one_algo AS (

SELECT address, balance FROM main

WHERE created_at > '2022-05-01' AND created_at < '2022-06-01'

AND balance > 1

SELECT assets.ASSET_NAME AS asset, SUM(assets.AMOUNT) AS amount

FROM assets, may_wallets_one_algo

WHERE may_wallets_one_algo.ADDRESS = assets.ADDRESS

GROUP BY asset