Flipside TeamTotal fee - chain, pools
    Updated 2024-06-29
    -- gnosis 6574ff
    -- polygon 8B77FF
    -- arb dcc7ff
    -- op ffa599
    -- eth ff88b0
    -- base b8a3ff
    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(
    QueryRunArchived: QueryRun has been archived