Pine AnalyticsdeBridge Final 1
Updated 2024-10-11
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 live_data AS (
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/8bcbd7e0-3af3-46a6-80ea-7f98df57c615/data/latest'):"data" AS data
UNION all
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/f4317389-70e7-4409-aa02-ec64feca1d8c/data/latest'):"data" AS data
UNION all
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/0fc79bb7-cc23-4c10-9eb2-0310473c4b21/data/latest'):"data" AS data
UNION all
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/91a7f28c-7410-47f3-8ff3-94b16f3d13d5/data/latest'):"data" AS data
UNION all
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/79d2fa13-ec35-49e8-b8e6-22952b6d7842/data/latest'):"data" AS data
UNION all
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/2dd4c065-cd83-4806-a853-38521010b293/data/latest'):"data" AS data
UNION all
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/f951167b-3c89-4d86-83ec-1e945b656512/data/latest'):"data" AS data
UNION all
SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/3564e793-fa41-4cda-96db-998d799255e1/data/latest'):"data" AS data
), all_data as (
SELECT
FLATTENED.VALUE:DATE as DATE,
FLATTENED.VALUE:CHAIN AS CHAIN,
FLATTENED.VALUE:VOLUME_USD AS VOLUME_USD,
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived