Query editor
1WITH json_data AS (2 SELECT3 JSON_PARSE(HTTP_GET('https://api.llama.fi/tvl/synfutures-v3')) AS parsed_data4), tvl_data AS (5 SELECT6 FLOOR(TRY_CAST(parsed_data AS DOUBLE)) AS tvl7 FROM json_data8)9SELECT10 tvl11FROM tvl_data
WITH json_data AS (
SELECT
JSON_PARSE(HTTP_GET('https://api.llama.fi/tvl/synfutures-v3')) AS parsed_data
), tvl_data AS (
FLOOR(TRY_CAST(parsed_data AS DOUBLE)) AS tvl
FROM json_data
)
tvl
FROM tvl_data