COUNT(*) as "Transaction count" ,

COUNT(DISTINCT BUYER_ADDRESS) AS "Buyer's Count",

COUNT(DISTINCT SELLER_ADDRESS) AS "Seller's Count" ,

COUNT(DISTINCT NFT_ADDRESS) AS "NFT Count" ,

SUM(TOTAL_PRICE_USD) AS "Sales Volume" ,

SUM(PLATFORM_FEE_USD) AS "Platform Fees Generated" ,

SUM (CREATOR_FEE_USD) AS "Creator's Fees Generated"

FROM aptos.nft.ez_nft_sales

WHERE PLATFORM_EXCHANGE_VERSION LIKE '%tradeport%'

AND DATE(BLOCK_TIMESTAMP)>='2024-01-01'