rmasChart - Kyrie Irving - What makes a Top Shots moment valuable: Offseason Rumors & Moves
    Updated 2022-10-13
    WITH

    -- 7M+ NFTs
    dim_nft AS (
    SELECT nft_id -- Unique PK
    , nbatopshot_id -- Unique PK
    , set_name -- NFT partial composite key
    , set_series_number -- NFT partial composite key
    , player -- NFT partial composite key
    , play_category -- NFT partial composite key
    , moment_date -- NFT partial composite key
    , total_circulation -- NFT partial composite key
    , serial_number -- NFT partial composite key

    , (CASE WHEN total_circulation <= 120 THEN 'Legendary'
    WHEN total_circulation <= 1800 THEN 'Rare'
    WHEN total_circulation <= 1858 THEN 'Fandom'
    ELSE 'Common' END) AS moment_tier
    , concat(set_name, ' (Series ', set_series_number, ') | ',
    player, ' - ', play_category, ' (', moment_date::date::string, ') | ',
    moment_tier, ' (', total_circulation, ')') AS moment_pseudo_id
    , team -- Moment attribute
    , season -- Moment attribute
    , play_type -- Moment attribute
    FROM flow.core.dim_topshot_metadata
    WHERE set_name IS NOT NULL
    AND set_series_number IS NOT NULL
    AND player IS NOT NULL
    AND play_category IS NOT NULL
    AND moment_date IS NOT NULL
    AND total_circulation IS NOT NULL
    Run a query to Download Data