SELECT

block_timestamp::DATE AS date,

COUNT(*) sale_count,

AVG(price_usd) AS avg,

MAX(price_usd) AS max,

MEDIAN(price_usd) AS median,

MIN(price_usd) AS min,

SUM(price_usd) AS usd_vol

FROM

ethereum.core.ez_nft_sales

WHERE

nft_address ilike '0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769'

GROUP BY

1

SELECT

*,

SUM(sale_count) OVER (ORDER BY date) AS cumulative_sales,

SUM(usd_vol) OVER (ORDER BY date) AS cumulative_usd_vol,

CASE

WHEN date <= '2022-11-07' THEN 'Before Market Downturn'

ELSE 'Market Downturn'

END AS label

FROM

sales