-- platform_name,

count(DISTINCT buyer_address) as buyer_count,

count(DISTINCT seller_address) as seller_count,

count(DISTINCT tx_hash) as tx_count,

count(distinct project_name) as collection_count,

sum(price_usd) as total_vol,

avg(price_usd) as avg_tx_vol,

sum(TOTAL_FEES_USD) as "Platform Fee + Creator Fee",

avg(TOTAL_FEES_USD) as "AVG Platform Fee + Creator Fee",

sum(PLATFORM_FEE_USD) as total_platform_fee,

avg(PLATFORM_FEE_USD) as avg_platform_fee,

sum(CREATOR_FEE_USD) as total_creator_fee,

avg(CREATOR_FEE_USD) as avg_creator_fee,

sum(TX_FEE_USD) as total_tx_fee,

avg(TX_FEE_USD) as avg_tx_fee,

from

base.nft.ez_nft_sales

where

block_timestamp::date between '2024-10-01' and '2024-10-31'