TOTAL_OWNED_LIQUIDITY | |
|---|---|
1 | 5377474.17580962 |
Flipside TeamTotal
Updated 6 hours ago
99
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
›
⌄
with final as (select
d.value:"CHAIN" as "Chain",
d.value:"POOL" as "Liquidity pool",
d.value:"VALUE" as "Value USD"
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:"VALUE" as "Value USD"
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:"VALUE" as "Value USD"
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
Last run: about 6 hours agoAuto-refreshes every 12 hours
1
20B
5s