hlooGetting Started
    Updated 2024-05-08
    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
    No Data to Display
    0
    2B
    1s