0xHaM-dTVL by Defilama Error
Updated 2024-04-04
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
›
-- WITH
-- json as (
-- SELECT defillama.get('/protocol/liquidswap', {}) as resp
-- )
-- SELECT
-- TO_TIMESTAMP(value:date::string) as date,
-- VALUE:totalLiquidityUSD as tvl
-- FROM
-- json,
-- LATERAL FLATTEN(input => resp:data:tvl)
-- ORDER BY 1 DESC
-- /*
-- WITH
-- json as (
SELECT defillama.get('/protocol/merkle.trade', {}) as resp
-- )
-- SELECT
-- TO_TIMESTAMP(value:date::string) as date,
-- VALUE:totalLiquidityUSD as tvl
-- FROM
-- json,
-- LATERAL FLATTEN(input => resp:data:tvl)
-- ORDER BY 1 DESC
-- SELECT*
-- FROM external.defillama.fact_options_volume
-- -- WHERE CHAIN = 'aptos'
-- WHERE PROTOCOL ilike '%Merkle%'
--*/
QueryRunArchived: QueryRun has been archived