select date_trunc('week',BLOCK_TIMESTAMP)as week

,MARKETPLACE,sum(SALES_AMOUNT)as total_sales_volume_sol

,count(distinct tx_id)as total_sales_count

,count(distinct mint)as total_sold_nft_count

,count(distinct PURCHASER)as total_unique_buyers

,count(distinct seller)as total_unique_sellers

from solana.core.fact_nft_sales

where (MARKETPLACE='coral cube' or MARKETPLACE='hyperspace')

and SUCCEEDED='TRUE'

group by 1,2)

select MARKETPLACE,avg(total_sales_volume_sol) as avg_weekly_sol_volume

,avg(total_sales_count) as avg_weekly_sales_count

,avg(total_sold_nft_count) as avg_weekly_sold_nft_count

,avg(total_unique_buyers)as avg_weekly_unique_buyers

,avg(total_unique_sellers)as avg_weekly_unique_sellers

from tab1

group by 1