No Data to Display
hlooGetting Started
Updated 2024-05-08
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/d2dbb72c-b8b7-431c-b122-e33ec53dd669/data/latest'
) :"data" AS data
),
all_data as (
SELECT
FLATTENED.VALUE:DATE as DATE,
FLATTENED.VALUE:TOKEN AS TOKEN,
FLATTENED.VALUE:PRICE AS PRICE
FROM
live_data,
LATERAL FLATTEN(INPUT => live_data.data) AS FLATTENED
),
tab1 as (
SELECT
date,
price as token_1_price
FROM
all_data
WHERE
token LIKE '{{ token1 }}'
AND date between '{{ start_date }}'
and '{{ end_date }}'
),
tab2 as (
SELECT
date,
price as token_2_price
FROM
all_data
WHERE
token LIKE '{{ token2 }}'
AND date between '{{ start_date }}'
and '{{ end_date }}'
Last run: 28 days ago
0
2B
1s