SELECT

date_trunc('day', block_timestamp) as date,

sum(price) AS daily_volume,

sum(daily_volume) OVER (ORDER BY date ASC) AS cumulative_volume

FROM flow.core.fact_nft_sales

WHERE block_timestamp BETWEEN '2021-10-20' AND '2022-06-18'

AND nft_collection = 'A.0b2a3299cc857e29.TopShot'

GROUP BY date

ORDER BY date ASC

SELECT *,

CASE

WHEN date BETWEEN '2021-10-20' AND '2022-04-12' THEN 'Regular Season'

WHEN date BETWEEN '2022-04-13' AND '2022-04-15' THEN 'Play-In'

WHEN date BETWEEN '2022-04-16' AND '2022-04-30' THEN 'Round 1'

WHEN date BETWEEN '2022-05-01' AND '2022-05-16' THEN 'Conference Semis'

WHEN date BETWEEN '2022-05-17' AND '2022-05-30' THEN 'Conference Finals'

WHEN date BETWEEN '2022-05-31' AND '2022-06-02' THEN 'Pause'

WHEN date BETWEEN '2022-06-03' AND '2022-06-18' THEN 'NBA Finals' -- added 1 day after to check for any decrease in volume

ELSE NULL

END AS playoffs_phase

FROM prep

ORDER BY date ASC