No Data to Display
hessDaily Net Change
Updated 2025-02-21
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 dragon_swap AS (
SELECT
livequery.live.udf_api(
'GET',
'https://api.llama.fi/protocol/dragon-swap',
{'content-type': 'application/json;charset=utf-8'},
{}
) AS response
),
tvl_dragon AS (
SELECT
TO_TIMESTAMP(v.value:date::INT) AS date,
'Dragon-swap' AS project,
v.value:totalLiquidityUSD::FLOAT AS TVL
FROM
dragon_swap,
LATERAL FLATTEN(input => response['data']['chainTvls']['Sei']['tvl']) AS v
),
final AS (
SELECT '2024-05-28'::date AS day, AVG(31) AS tvl_USD
FROM tvl_dragon
GROUP BY 1
UNION ALL
SELECT '2024-05-29'::date AS day, AVG(2360000) AS tvl_USD
FROM tvl_dragon
GROUP BY 1
UNION ALL
SELECT '2024-05-30'::date AS day, AVG(4370000) AS tvl_USD
FROM tvl_dragon
GROUP BY 1
UNION ALL
SELECT '2024-05-31'::date AS day, AVG(5370000) AS tvl_USD
FROM tvl_dragon
GROUP BY 1
UNION ALL
SELECT '2024-06-01'::date AS day, AVG(5600000) AS tvl_USD
Last run: about 2 months ago
0
2B
2s