(SELECT

sum(PRICE_usd) as volume ,MIN (PRICE_usd) as prices ,DATE_TRUNC('DAY',BLOCK_TIMESTAMP) as date --,percentile_cont(0.100) within group (order by PRICE) as doodles_estimated_floor

FROM ethereum.core.ez_nft_sales

WHERE EVENT_TYPE = 'sale' and CURRENCY_SYMBOL = 'ETH' and LOWER(NFT_ADDRESS)=lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')

group by date HAVING prices >100)

, B AS (SELECT PRICESS ,DATE ,volume ,

LAG(PRICESS,1) IGNORE NULLS OVER (ORDER BY date) as a,

((PRICESS-a)/PRICESS)*100 as PRICE_daily_var

FROM

(SELECT avg(prices) over(

order by date

rows between 1 preceding and current row ) PRICESS, DATE ,volume

FROM A ))

SELECT * FROM B