DiamondMoment Dashboard V copy
Updated 2023-07-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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