count(*) as Total_sales,

SUM(TOTAL_PRICE) AS sales_volume,

AVG(TOTAL_PRICE) AS average_sale_price,

SUM(TOTAL_PRICE_USD) AS sales_volume_usd,

AVG(TOTAL_PRICE_USD) AS average_sale_price_usd,

count(distinct buyer_address) as buyers,

count(distinct seller_address) as sellers,

FROM aptos.nft.ez_nft_sales

where project_name= 'Pixel Pirates'