StangFAST001 - ALLdomains [ number ]
Updated 2023-09-27
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 001 - ALLdomains @ https://flipsidecrypto.xyz/edit/queries/d50c8b3d-33b3-47ca-9806-e5958eac429b
with
final AS
(
SELECT
a.value:"BT"::timestamp AS dt
, a.value:"TX"::text AS tx
, a.value:"US"::text AS sg
, a.value:"TK"::text AS tk
, a.value:"NM"::text AS nm
, a.value:"DM"::text AS dm
, a.value:"CH"::number AS cm
, a.value:"AM"::float AS am
FROM
(
--- base 1
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/222502d4-4183-4b9e-845b-7ffba5f83ffd/data/latest' ):"data" AS data
UNION
--- base 2
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/2934b49b-7e7a-4b2a-be0b-781e4e7accce/data/latest' ):"data" AS data
UNION
--- base 3
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/cf80d13f-a7c5-4f13-ba8d-b0624beec8b3/data/latest' ):"data" AS data
UNION
--- base 4
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/838ff35e-7bc6-4ef9-8255-54114f0350fa/data/latest' ):"data" AS data
UNION
--- base 5 - part 1
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/1a1ce85e-d875-40d7-88a2-3902aee4a06a/data/latest' ):"data" AS data
UNION
--- base 5 - part 2
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/7247fda8-f29e-48a9-83e2-2a955135ded1/data/latest' ):"data" AS data
UNION
--- base 5 - part 3
Run a query to Download Data