flipside

    FLOW Usage During the NBA Playoffs
    eferFLOW Usage During the NBA Playoffs
    Updated 2022-07-10
    SELECT
    sales.BLOCK_TIMESTAMP::date AS date,
    sales.TX_ID,
    sales.PRICE,
    sales.NFT_ID,
    metadata.team,
    metadata.NBATOPSHOT_ID,
    metadata.SET_NAME,
    metadata.player
    FROM flow.core.fact_nft_sales sales
    LEFT JOIN (
    SELECT NFT_ID, TEAM, NBATOPSHOT_ID, SET_NAME, PLAYER FROM flow.core.dim_topshot_metadata
    ) metadata
    ON metadata.NFT_ID=sales.NFT_ID
    WHERE date >= '2022-05-12'
    AND date <= '2022-06-3'
    AND NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot'
    -- AND PRICE != CAST(PRICE AS INT)
    AND TEAM IS NOT NULL
    ORDER BY price DESC
    LIMIT 1000
    Run a query to Download Data