flyingfishJLP Historical Virtual Price
    Updated 3 hours ago
    -- forked from JLP Price and Premium @ https://flipsidecrypto.xyz/edit/queries/1f4f5cd5-8be3-4b29-a1f9-2f7415a01037

    /*
    PREVIOUS QUERIES

    Before JLP Trading
    d70dac7b-923e-4cb7-95df-4223f6f6c288

    2023-11-13 -> 2023-12-31
    b2ca5f53-4c03-4755-a631-e604529b9adc

    2024-01-01 -> 2024-01-31
    bf214060-fbc9-4bf7-8ab7-eada0a5b3157

    2024-02-01 -> 2024-02-29
    2d1120ea-1074-4971-9e4f-bfcf3208344e

    2024-03-01 -> 2024-05-15
    674a1f32-0746-4a1a-aaf2-d1f2f117b988
    */

    WITH get_past_data AS (
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/d70dac7b-923e-4cb7-95df-4223f6f6c288/latest-run'):data:result:rows AS response
    UNION
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/b2ca5f53-4c03-4755-a631-e604529b9adc/latest-run'):data:result:rows AS response
    UNION
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/bf214060-fbc9-4bf7-8ab7-eada0a5b3157/latest-run'):data:result:rows AS response
    UNION
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/2d1120ea-1074-4971-9e4f-bfcf3208344e/latest-run'):data:result:rows AS response
    UNION
    SELECT
    livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/674a1f32-0746-4a1a-aaf2-d1f2f117b988/latest-run'):data:result:rows AS response
    Last run: about 3 hours ago
    No Data to Display
    0
    2B
    37s