Updated 2023-01-23
    SELECT SUM(flow.PRICE) AS top_sale_USD,
    flow.BUYER AS buyer,
    flow.BLOCK_TIMESTAMP,
    flow.NFT_COLLECTION,
    CONCAT('https://ongaia.com/dimension-x/nft/',flow.NFT_ID) NFT_Sold
    FROM

    flow.core.ez_nft_sales flow
    WHERE NFT_COLLECTION ='A.e3ad6030cbaff1c2.DimensionX'
    AND flow.TX_SUCCEEDED = TRUE

    GROUP BY flow.BUYER,
    flow.BLOCK_TIMESTAMP,
    flow.NFT_COLLECTION,
    flow.NFT_ID
    ORDER BY top_sale_USD DESC
    LIMIT 10

    Run a query to Download Data