with blast_tvl as (
SELECT
LiveQuery.live.udf_Api(
'https://api.llama.fi/v2/historicalChainTvl/BLast'
) :data as repsonse
)
SELECT
date_trunc('day',to_timestamp(value:date)) AS block_timestamp,
value:tvl as "Defi Tvl (USD)"
FROM
blast_tvl,
LATERAL FLATTEN (input => repsonse)