AndyCoolHolders Of At least 1 NFT
Updated 2022-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with holders AS (
select aa.address, sum(amount) as amount
from flipside_prod_db.algorand.account_asset aa
inner join flipside_prod_db.algorand.account a on a.address = aa.address
where asset_id IN (
select distinct asset_id as assetID from flipside_prod_db.algorand.asset_configuration_transaction
where try_base64_decode_string(tx_message:txn:note::string) like '%arc69%'
or try_base64_decode_string(tx_message:txn:note::string) like '%#arc3%'
)
and account_closed = 'false'
group by aa.address
),
aaa as (
SELECT amount, count(amount) as number
FROM holders
where amount > 0
GROUP BY 1)
select sum(number) from aaa
Run a query to Download Data