CarlOwOs(1) FLOW Usage During the NBA Playoffs
    Updated 2022-07-12
    SELECT block_timestamp::DATE AS date
    , CASE
    WHEN date BETWEEN '2022-05-17' AND '2022-05-29' THEN 'Conference Finals'
    WHEN date BETWEEN '2022-04-16' AND '2022-05-16' THEN 'Playoffs'
    ELSE 'Off-season' END AS phase
    , COUNT(DISTINCT tx_id) AS sales
    FROM flow.core.fact_nft_sales
    WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'
    AND date between '2022-04-16' and '2022-06-15'
    AND tx_succeeded = TRUE
    GROUP BY 1

    Run a query to Download Data