-- forked from DimensionX_Sales @ https://flipsidecrypto.xyz/edit/queries/d4e172d5-61ac-4224-9f77-ec2ea832c406
SELECT SUM(PRICE) AS total_sale_USD,
COUNT(TX_ID) AS total_volume
FROM
flow.core.ez_nft_sales flow
WHERE NFT_COLLECTION ='A.ca63ce22f0d6bdba.Cryptoys'
AND flow.TX_SUCCEEDED = TRUE