Pine AnalyticsdeBridge Final 1
    Updated 2024-10-11
    WITH live_data AS (
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/8bcbd7e0-3af3-46a6-80ea-7f98df57c615/data/latest'):"data" AS data

    UNION all
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/f4317389-70e7-4409-aa02-ec64feca1d8c/data/latest'):"data" AS data
    UNION all
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/0fc79bb7-cc23-4c10-9eb2-0310473c4b21/data/latest'):"data" AS data
    UNION all
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/91a7f28c-7410-47f3-8ff3-94b16f3d13d5/data/latest'):"data" AS data
    UNION all
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/79d2fa13-ec35-49e8-b8e6-22952b6d7842/data/latest'):"data" AS data

    UNION all

    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/2dd4c065-cd83-4806-a853-38521010b293/data/latest'):"data" AS data
    UNION all
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/f951167b-3c89-4d86-83ec-1e945b656512/data/latest'):"data" AS data

    UNION all
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/3564e793-fa41-4cda-96db-998d799255e1/data/latest'):"data" AS data

    ), all_data as (
    SELECT
    FLATTENED.VALUE:DATE as DATE,
    FLATTENED.VALUE:CHAIN AS CHAIN,
    FLATTENED.VALUE:VOLUME_USD AS VOLUME_USD,
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived