date_trunc('week',block_timestamp) as week,

count(*) as sales,

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

count(distinct buyer_address) as nft_buyers,

count(distinct seller_address) as nft_sellers,

SUM(PRICE_USD) AS sales_volume,

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

AVG(PRICE_USD) AS average_sale_price,

sum(creator_fee_usd) as creator_fees,

sum(creator_fees) over (order by week) as total_creator_fees,

sum(platform_fee_usd) as platform_fees,

sum(platform_fees) over (order by week) as total_platform_fee,

sum(total_fees_usd) as fees,

sum(fees) over (order by week) as total_cumulative_fees

FROM arbitrum.nft.ez_nft_sales

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

group by 1

order by 1 desc