flipside

    Token price Final 1 copy
    the_defi_freakToken price Final 1 copy
    Updated 2024-10-19
    -- forked from jackguy / Token price Final 1 @ https://flipsidecrypto.xyz/jackguy/q/NVvMm9cxyk54/token-price-final-1

    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 }}'
    QueryRunArchived: QueryRun has been archived