arctic-night-foxaccount that have NFT
Updated 2022-07-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
WITH NFT_holders as (
SELECT
ADDRESS,
SUM(AMOUNT) as sum_amount
FROM
flipside_prod_db.algorand.account_asset
WHERE ASSET_ID IN (
SELECT
DISTINCT ASSET_ID
FROM
flipside_prod_db.algorand.asset_transfer_transaction
WHERE
SENDER = 'CCNFTNFTSXVYGCGP5EU7AMUTQLUZI6TXRS4XMW2LP4XARZH3LB6RZPUOQM'
AND ASSET_RECEIVER = 'MS7TKJ3MXE6CQ5IZW2ZQC2KT3NWJFQPRSDAFTZPGYPFCZZ43PL7UPBTZXE')
GROUP BY ADDRESS
HAVING sum_amount > 1)
SELECT
COUNT (ADDRESS) as NFT_HOLDER
FROM
NFT_holders
Run a query to Download Data