SUM(price_usd) as volume,

avg(price_usd) as avg_volume,

COUNT(distinct buyer_address) as buyers,

COUNT(distinct seller_address) as sellers,

COUNT(tokenid) as nft_sold,

COUNT(DISTINCT nft_address) AS Unique_nft_sold,

COUNT(distinct tx_hash) as transaction,

SUM(total_fees_usd) AS Total_fees,

SUM(platform_fee_usd) AS Platform_fees,

SUM(creator_fee_usd) AS Creator_fee,

AVG(creator_fee_usd) AS Avg_creator_fee,

AVG(platform_fee_usd) AS Avg_platform_fee_usd,

AVG(total_fees_usd) AS Avg_total_fees_usd

FROM arbitrum.nft.ez_nft_sales

WHERE PLATFORM_NAME = 'opensea'