DiamondMoment Dashboard V copy
    Updated 2023-07-21
    -- forked from Moment Dashboard V @ https://flipsidecrypto.xyz/edit/queries/0240a840-76c1-4cf6-804c-118184f1a57b

    -- forked from Moment Dashboard @ https://flipsidecrypto.xyz/edit/queries/287c51f1-c289-4cdd-b5e0-38fab8ea433b

    WITH
    updated_metadata AS (
    SELECT
    moment_stats_full['ID'] AS "unique_id",
    CASE
    WHEN 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",
    CONCAT(
    'https://nflallday.com/listing/moment/',
    "marketplace_id"
    ) AS "Moment Listing",
    MOMENT_DESCRIPTION AS "Description"
    FROM
    flow.core.dim_allday_metadata
    )
    SELECT
    "marketplace_id"::NUMBER as "ID",
    "Player",
    "Team",
    "Series",
    "Set Name",
    "Tier",
    Run a query to Download Data