block_timestamp::date as day,

platform_name as market_place,

count(distinct(tx_hash)) as sales_count,

sum(price_usd) as volume_usd,

avg(price_usd) as volume_avg,

median(price_usd) as volume_median,

count(distinct(buyer_address)) as purchasers_count,

(sales_count / purchasers_count) as tx_per_purchaser,

(volume_usd / purchasers_count) as volume_per_purchaser,

count(distinct(seller_address)) as sellers_count,

(sales_count / sellers_count) as tx_per_seller,

(volume_usd / sellers_count) as volume_per_seller,

count(distinct(project_name)) as projects_count,

sum(sales_count) over (partition by platform_name order by day asc) as sales_count_cum,

sum(sellers_count) over (partition by platform_name order by day asc) as sellers_count_cum,

sum(purchasers_count) over (partition by platform_name order by day asc) as purchasers_count_cum,

sum(volume_usd) over (partition by platform_name order by day asc) as volume_usd_cum

from ethereum.core.ez_nft_sales

where day >= '2022-11-01'

group by 1, 2

order by 1, 4 desc