trunc(block_timestamp,'day') as date,

marketplace,

avg(SALES_AMOUNT),

sum(sales_amount) as volume_sol,

count(distinct TX_ID) as trades,

count(distinct PURCHASER) as num_buyer,

count(distinct SELLER) as num_seller

from solana.core.fact_nft_sales sales

where succeeded

and date>='2022-11-07' and date<='2022-11-14'

group by 1,2