ErsvanALGO balance per wallet with nft hold
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
AA.ADDRESS,
COUNT(*) NFTS,
AC.BALANCE
FROM flipside_prod_db.algorand.account_asset AS AA
JOIN flipside_prod_db.algorand.account AS AC ON AC.ADDRESS = AA.ADDRESS
JOIN flipside_prod_db.algorand.block AS BL ON BL.BLOCK_ID = AC.CREATED_AT
WHERE AA.ASSET_ID IN (
select ASSET_ID from algorand.asset where asset_name like 'Warrior Croc%' and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
)
AND AMOUNT !=0
GROUP BY 1, 3
ORDER BY 2 DESC
Run a query to Download Data