with a as

(SELECT

sum(PRICE) as volume ,MIN (PRICE) as prices ,DATE_TRUNC('day',BLOCK_TIMESTAMP) as date

FROM ethereum.core.ez_nft_sales

WHERE EVENT_TYPE = 'sale'

and CURRENCY_SYMBOL = 'ETH'

and LOWER(NFT_ADDRESS)=lower('0x60bb1e2aa1c9acafb4d34f71585d7e959f387769')

group by date HAVING prices >0.1)

, B AS (

SELECT * FROM (SELECT

PRICESS ,DATE ,

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

((PRICESS-a)/PRICESS)*100 as PRICE_daily_var ,'+' AS TITLE

FROM

(SELECT avg(prices) over( order by date rows between 1 preceding and current row ) PRICESS, DATE

FROM A )

) WHERE PRICE_daily_var > 0 )

/*Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals.

, C AS (

SELECT * FROM (SELECT

PRICESS ,DATE ,