DiamondMoment Dashboard II
Updated 2023-04-19
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
›
⌄
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