Drsimontop 10 holders
Updated 2023-03-15
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT 'https://flowscan.org/account/' ||s.buyer AS holder_address, COUNT(DISTINCT s.nft_id) AS nfts_held
FROM flow.core.ez_nft_sales s
JOIN flow.core.dim_contract_labels c ON s.NFT_COLLECTION = c.EVENT_CONTRACT
WHERE s.MARKETPLACE LIKE 'Gigantik Primary Market' --dr simon
AND s.price IS NOT NULL
AND s.tx_succeeded = 'true'
GROUP BY 1
ORDER BY nfts_held DESC
LIMIT 10
Run a query to Download Data