defi__joshAPI
Updated 2024-12-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
⌄
with XTZ AS(
SELECT
defillama.get('chain/Tezos', {}) as resp
)
SELECT
*
FROM (
SELECT
-- to_timestamp(v.value:date::INT) as date,
-- v.value:totalLiquidityUSD :: NUMERIC AS TVL
*
FROM XTZ,
-- lateral flatten(input => resp['data'] ['tvl']) AS v
)
/*
WHERE date <= current_date
order by date desc;
*/
QueryRunArchived: QueryRun has been archived