nft_id,

avg(price) as avg_price

from flow.core.ez_nft_sales

where NFT_COLLECTION ='A.e4cf4bdc1751c65d.AllDay'

and currency='A.ead892083b3e2c6c.DapperUtilityCoin'

and TX_SUCCEEDED ='TRUE'

and BLOCK_TIMESTAMP >='2022-11-24' and BLOCK_TIMESTAMP <='2022-11-30'

group by 1