Hossein2023-10-31 02:22 AM
    Updated 2023-10-30
    -- Common Table Expression for GraphQL query
    WITH graphql AS (

    --Part 1
    SELECT
    livequery.live.udf_api('https://api.flipsidecrypto.com/api/v2/queries/058c9fab-1b3b-4595-b3c3-095044fb2cf7/data/latest'):data
    AS response

    UNION ALL

    --Part 2
    SELECT
    livequery.live.udf_api('https://api.flipsidecrypto.com/api/v2/queries/d348b2b2-b65c-403a-bceb-d636f7b9ee03/data/latest'):data
    AS response

    UNION ALL

    --Part 3
    SELECT
    livequery.live.udf_api('https://api.flipsidecrypto.com/api/v2/queries/95995d1e-0e91-4184-88f4-ed475c0e9a22/data/latest'):data
    AS response

    UNION ALL

    --Part 4
    SELECT
    livequery.live.udf_api('https://api.flipsidecrypto.com/api/v2/queries/5fcb0af8-90e7-451f-a9df-4906146faf99/data/latest'):data
    AS response

    UNION ALL

    --Part 5
    SELECT
    livequery.live.udf_api('https://api.flipsidecrypto.com/api/v2/queries/cf5f2f3f-1f6b-4418-a55c-2db017c95464/data/latest'):data
    AS response

    Run a query to Download Data