SELECT

a.address,

a.balance,

b.block_timestamp as creation_date

FROM flipside_prod_db.algorand.account as a JOIN flipside_prod_db.algorand.block as b

ON a.created_at = b.block_id

WHERE

a.account_closed = FALSE AND

a.closed_at is NULL AND

creation_date BETWEEN '2022-05-01' AND '2022-06-01'

SELECT a.asset_name, COUNT(DISTINCT address) AS holding_addresses, sum(amount/pow(10, b.decimals)) as total_amount

FROM flipside_prod_db.algorand.account_asset AS a JOIN flipside_prod_db.algorand.asset as b

ON a.asset_id = b.asset_id

WHERE a.amount > 0

AND a.asset_closed = FALSE

AND a.asset_last_removed IS NULL

AND a.address IN (SELECT address FROM new_wallets)

GROUP BY a.asset_name

ORDER BY holding_addresses DESC

LIMIT 10