Drsimontop 10 buyers by collections
    Updated 2023-03-15
    SELECT s.NFT_COLLECTION,
    s.buyer AS BUYERS, COUNT(DISTINCT s.tx_id) AS nft_sales
    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'
    AND s.price IS NOT NULL
    AND s.tx_succeeded = 'true'
    GROUP BY 1,2
    ORDER BY nft_sales DESC
    LIMIT 10
    Run a query to Download Data