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