lanokaia_dex_dominance_tvl
Updated 2024-11-06
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
›
⌄
-- forked from cristinatinto / Kaiaswap 2 @ https://flipsidecrypto.xyz/cristinatinto/q/Cxy0dCMllNhP/kaiaswap-2
with tab1 as (select
livequery.live.udf_api(
'GET',
'https://api.llama.fi/protocol/kaiaswap',
{'content-type': 'application/json;charset=utf-8'},
{}
) as response)
,
kai_tvl as ( SELECT *
FROM (
SELECT
TO_TIMESTAMP(v.value:date::INT) AS date,
'Kaia-swap' as project,
v.value:totalLiquidityUSD::FLOAT AS TVL
FROM
tab1,
LATERAL FLATTEN(input => response['data']['chainTvls']['Klaytn']['tvl']) AS v
))
,
tab2 as (
select
livequery.live.udf_api('GET',
'https://api.llama.fi/protocol/dragonswap',{'content-type': 'application/json;charset=utf-8'},{}) as response
),
ds_tvl as ( SELECT *
FROM (
SELECT
TO_TIMESTAMP(v.value:date::INT) AS date,
'Dragon-swap' as project,
v.value:totalLiquidityUSD::FLOAT AS TVL
FROM
QueryRunArchived: QueryRun has been archived