WITH
json as (
SELECT
livequery.live.udf_api (
'https://api.llama.fi/protocol/prime-protocol'
) AS response
),
main as (
SELECT
TO_DATE(value:date::string) as dates,
value:tokens as tokens_json
FROM
json,
LATERAL FLATTEN(input => response:data:chainTvls:"{{chain}}-borrowed":tokensInUsd)
)
SELECT
DISTINCT dates,
f.key::string AS token,
f.value::double AS borrowed_volume
FROM main
,LATERAL FLATTEN(input => tokens_json) f
WHERE dates < current_date
ORDER BY dates DESC