,date_trunc('week',BLOCK_TIMESTAMP) as date

,sum(creator_fee_usd) as "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 = ('x2y2')

group by 1,2

having sum(CREATOR_FEE_USD) > 0

order by 2 asc