select date_trunc('week',BLOCK_TIMESTAMP)as week

,max(PRICE) as ceiling

,min(PRICE) as floor

,avg(PRICE) as avg

from flow.nft.ez_nft_sales

where NFT_COLLECTION='A.87ca73a41bb50ad5.Golazos'

and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'

and TX_SUCCEEDED='true'

and date_trunc('week',BLOCK_TIMESTAMP)>='2023-01-01'

group by 1