date_trunc('day',block_timestamp) as week,

PLATFORM_NAME,

count(*) as sales,

sum(sales) over (partition by PLATFORM_NAME order by week) as total_sales,

count(distinct buyer_address) as n_buyers,

count(distinct seller_address) as n_sellers,

count(*) / count(DISTINCT buyer_address) AS trades_per_user,

SUM(total_price) AS sales_volume,

sum(sales_volume) over (partition by PLATFORM_NAME order by week) as total_sales_volume,

AVG(total_price) AS average_sale_price,

FROM

aptos.nft.ez_nft_sales

where date_trunc('day',block_timestamp)<date_trunc('day',current_date)

and date_trunc('day',block_timestamp)>=date_trunc('day',current_date)-7

and PLATFORM_NAME is not NULL

group by 1,2

order by 1 desc