Updated 2023-05-14
    with a as

    (SELECT
    sum(PRICE) as volume ,MIN (PRICE) 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 >0.1)

    , 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

    round(Avg(PRICESS),1) as "Avg 180D ",
    round(min(PRICESS),1) as "min 180D ",
    round(sum(PRICESS),1) as "volume 180D"
    FROM b
    WHERE date BETWEEN DATEADD(HOUR, -4320, GETDATE()) AND GETDATE() AND PRICESS >0

    Run a query to Download Data