Drsimontop 10 holders
    Updated 2023-03-15
    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