fb3ce38c-7bfe-475c-bca8-3f1e44ae80a6Copy of DimensionX_Sales
    Updated 2022-09-10


    SELECT SUM(PRICE) AS total_sale_USD,
    flow.BLOCK_TIMESTAMP,
    flow.NFT_ID,
    flow.BUYER,
    CONCAT('https://ongaia.com/dimension-x/nft/',flow.NFT_ID) AS direct_url
    FROM

    flow.core.ez_nft_sales flow
    WHERE NFT_COLLECTION ='A.e3ad6030cbaff1c2.DimensionX'
    AND flow.TX_SUCCEEDED = TRUE
    AND flow.BLOCK_TIMESTAMP > '2022-09-07T00:00+00:00'
    GROUP BY flow.NFT_ID,
    flow.BLOCK_TIMESTAMP,
    flow.BUYER,
    direct_url

    ORDER BY flow.BLOCK_TIMESTAMP DESC

    Run a query to Download Data