select date_trunc('month',BLOCK_TIMESTAMP) as date

,Platform_name as "Platform name"

,sum(creator_fee_usd) as "Creator fee($)"

,sum("Creator fee($)") over(order by date asc) as "Cumulative Creator fee($)"

,avg(creator_fee_usd) as "Avg Creator fee($)"

,median(creator_fee_usd) as "Median Creator fee($)"

,(sum(creator_fee_usd) / sum(price_usd))*100 as "%Creator fee percent"

,sum(price_usd) as "volume"

,avg(price_usd) as "Avg price"

,count(distinct buyer_address) as "number of buyers "

from ethereum.core.ez_nft_sales

-- where Platform_name not in('x2y2')

group by 1,2

having sum(CREATOR_FEE_USD) > 0

order by 1 asc