freemartianAmnis TVL
Updated 2025-01-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH datas AS (
SELECT livequery.live.udf_api(
'GET',
'https://api.llama.fi/protocol/amnis-finance',
{'content-type':'application/json;charset=utf-8'},
{}
) AS res
)
SELECT
to_timestamp(value:date) AS day,
value:totalLiquidityUSD AS liquidity
FROM datas,
LATERAL FLATTEN (input => res:data:tvl)
WHERE day BETWEEN '{{start_time}}' AND '{{end_time}}'
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived