DATE(BLOCK_TIMESTAMP) AS Time,

CASE

WHEN BLOCK_TIMESTAMP >= '2022-05-17' AND BLOCK_TIMESTAMP <= '2022-05-29' THEN 'NBA Playoffs'

ELSE 'Other'

END AS "Dist",

SUM(PRICE) AS "Volume",

COUNT(TX_ID) AS "Sales"

FROM flow.core.fact_nft_sales

WHERE NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'

GROUP BY 1,2