BLOCK_TIMESTAMP::date AS date,

SUM(PRICE) AS FLOW_VOLUME,

CASE

WHEN

date >= '2022-05-17' AND date <= '2022-05-29'

THEN

'Conference Finals'

ELSE

'Other days'

END AS NBA_Conference_Finals,

AVG(FLOW_VOLUME) OVER(ORDER BY date ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS MA5

FROM flow.core.fact_nft_sales

WHERE date >= '2022-05-12'

AND date <= '2022-06-3'

AND NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'

GROUP BY date

ORDER BY date ASC