SELECT defillama.get('/v2/chains', {}) AS resp_chains

SELECT

SUM(chain.value:tvl::FLOAT) AS total_tvl

FROM

chains_data,

LATERAL FLATTEN(input => chains_data.resp_chains['data']) chain;