Flipside TeamTotal fee - chain, pools
Updated 2024-06-29
999
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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