yasmin-n-d-r-htvl by token HAZF
Updated 2024-01-08
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
›
⌄
WITH api AS (
SELECT
livequery.live.udf_api('https://api.llama.fi/protocol/vapordex') AS response
),
flattened_data AS (
SELECT
TO_VARCHAR(TO_TIMESTAMP(VALUE:"date"), 'YYYY-MM-DD') AS date,
VALUE:tokens:USDT AS tvl_usdt,
VALUE:tokens:WAVAX AS tvl_WAVAX
FROM
api,
LATERAL FLATTEN(input => response:data:tokens)
)
SELECT
date AS formatted_date,
SUM(tvl_usdt) AS total_liquidity_usdt,
SUM(tvl_WAVAX) AS total_liquidity_WAVAX
FROM
flattened_data
WHERE
formatted_date < '2024-01-07'
GROUP BY
date
ORDER BY
date;
QueryRunArchived: QueryRun has been archived