DiamondBurn Portal III (May 1-8)
    Updated 2023-06-10
    WITH
    updated_metadata AS (
    SELECT
    nft_id as "ID",
    moment_stats_full['id'] AS "UniqueID",
    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"
    FROM
    flow.core.dim_allday_metadata
    ),
    mints as (
    SELECT
    "UniqueID"
    FROM
    flow.core.fact_events x
    join updated_metadata y on x.event_data:id::STRING = y."ID"
    and "Player" in (
    'Jalen Ramsey',
    'Mike Evans'
    )
    WHERE
    event_contract = 'A.e4cf4bdc1751c65d.AllDay'
    AND event_type in ('MomentNFTMinted')
    group by
    1
    ),
    Run a query to Download Data