DiamondMoment Dashboard II
    Updated 2023-04-19
    WITH
    updated_metadata AS (
    SELECT
    moment_stats_full['ID'] AS "unique_id",
    CASE
    when nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
    and player = 'N/A' THEN team
    ELSE player
    END AS "Player",
    team as "Team",
    series as "Series",
    moment_stats_full['flowID'] AS "marketplace_id",
    set_name AS "Set Name",
    moment_tier AS "Tier",
    total_circulation AS "Mint Count",
    play_type AS "Play Type",
    season AS "Season",
    week AS "Week"
    FROM
    flow.core.dim_allday_metadata
    )
    SELECT
    "marketplace_id"::NUMBER as "ID",
    "Player",
    "Team",
    "Series",
    "Set Name",
    "Tier",
    "Mint Count",
    "Play Type",
    "Season",
    "Week"
    FROM
    updated_metadata
    WHERE
    "Set Name" not in ('Genesis', 'Blank')
    Run a query to Download Data