SELECT SUM(PRICE) AS total_sale_USD,
flow.BUYER
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.BUYER
ORDER BY total_sale_USD DESC
LIMIT 10