(SELECT

avg (price) as prices ,BLOCK_TIMESTAMP::date as date

FROM ethereum.nft.ez_nft_sales

WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL in ('ETH','WETH')

and NFT_ADDRESS=lower('0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d')

group by date)

select

date,

avg(prices) over(

order by date

rows between 100 preceding and current row ) floor

from a