select date_trunc('week',BLOCK_TIMESTAMP)as date

,sum(PRICE_USD) as volume

,avg(PRICE_USD) as avg_volume

,count(distinct BUYER_ADDRESS) as buyers

,count(distinct SELLER_ADDRESS) as sellers

,count(distinct TOKENID) as nft_sold

,count(distinct TX_HASH) as sale_count

from bsc.nft.ez_nft_sales

where PROJECT_NAME='SPACE ID'

group by 1