DiamondPinnacle Pin Tracker: AOTC LE IV
Updated 2024-04-05
999
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 Pinnacle Pin Tracker: AOTC LE III @ https://flipsidecrypto.xyz/edit/queries/72a531a7-7e07-40e5-8dfe-3bdf28dfbc6e
-- forked from Pinnacle Pin Tracker: AOTC LE @ https://flipsidecrypto.xyz/edit/queries/1614d114-4597-444a-927e-051a0342659a
-- forked from Pinnacle Pin Tracker: Up LE @ https://flipsidecrypto.xyz/edit/queries/87a5efca-24fa-445b-8fdf-008fd42c27d9
WITH res AS (
SELECT
livequery.live.udf_api(
'GET',
'https://science.flipsidecrypto.xyz/googlesheets/readsheet',
{ 'Content-Type': 'application/json' },
{ 'sheets_id': '1-fZ31E_mYW_Shewwu_KI9OgZuj4_7UwTuuLvqSWlZ8k',
'tab_name': 'Clones' }
) AS result
FROM
DUAL
),
flattened_data AS (
SELECT
TO_TIMESTAMP_NTZ(f.value:"Timestamp") AS "Timestamp",
f.value:"Username" :: VARCHAR AS "Username",
f.value:"Serial Number" :: NUMBER AS "Serial Number",
f.value:"Wallet Address" :: VARCHAR AS "Wallet Address",
CASE
WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-ANAK-S6' THEN 'Anakin Skywalker'
WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-PADM-S6' THEN 'Padmé Amidala'
WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-OBIW-S6' THEN 'Obi-Wan Kenobi'
WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-COUN-S6' THEN 'Count Dooku'
WHEN TRY_PARSE_JSON(f.value):"Render"::VARCHAR = 'LEV1-EP2S-JANG-S6' THEN 'Jango Fett'
ELSE TRY_PARSE_JSON(f.value):"Render"::VARCHAR
END AS "Render",
f.value:"Total Minted" :: NUMBER AS "Total Minted",
f.value:"Total Burned" :: NUMBER AS "Total Burned",
f.value:"Variant" :: VARCHAR AS "Variant",
f.value:"Edition" :: NUMBER AS "Edition",
QueryRunArchived: QueryRun has been archived