Flipside TeamTotal fee
    Updated 2024-06-26
    with share as (select
    d.value:"CHAIN" as "Chain",
    d.value:"POOL" as "Liquidity pool",
    d.value:"LIQUIDITY_SHARE" as "Share"
    from (
    select livequery.live.udf_api(
    'https://flipsidecrypto.xyz/api/v1/queries/d2dd33e7-dc7b-4e07-9dd1-ab932245b4c0/data/latest'
    ):"data" as data
    ) responses join lateral flatten (input => responses.data) d

    union all

    select
    d.value:"CHAIN" as "Chain",
    d.value:"POOL" as "Liquidity pool",
    d.value:"LIQUIDITY_SHARE" as "Share"
    from (
    select livequery.live.udf_api(
    'https://flipsidecrypto.xyz/api/v1/queries/e6211b4d-c59b-40d2-949c-c96b91dade78/data/latest'
    ):"data" as data
    ) responses join lateral flatten (input => responses.data) d

    union all

    select
    d.value:"CHAIN" as "Chain",
    d.value:"POOL" as "Liquidity pool",
    d.value:"LIQUIDITY_SHARE" as "Share"
    from (
    select livequery.live.udf_api(
    'https://flipsidecrypto.xyz/api/v1/queries/1f5b7e89-d473-40aa-a599-1615294672a7/data/latest'
    ):"data" as data
    ) responses join lateral flatten (input => responses.data) d

    union all

    QueryRunArchived: QueryRun has been archived