Updated 2023-05-22
    SELECT SUM(PRICE) AS total_sale_USD,
    COUNT(TX_ID) AS total_volume
    FROM

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