SUBSTRING(TOKENID, CHARINDEX('#', TOKENID) + 1) AS TOKEN_ID,

SUM(TOTAL_PRICE) AS VOLUME_apt,

COUNT(DISTINCT tx_hash) AS TX,

COUNT(DISTINCT Seller_address) AS Sellers,

COUNT(DISTINCT buyer_address) AS Buyers

FROM aptos.nft.ez_nft_sales

WHERE project_name IN ('{{project_name}}')

AND block_timestamp::date >= '{{Start_Date}}'

AND block_timestamp::date <= '{{End_Date}}'

AND project_name IS NOT NULL

AND EVENT_TYPE = 'sale'

AND TOKEN_ID IS NOT NULL

GROUP BY 1

ORDER BY VOLUME_apt DESC;