WITH raw_data AS (
SELECT
defillama.get('/v2/historicalChainTvl/Sui', {}) AS resp
),
sui_tvl AS (
SELECT
value:date::int as tvl_dt,
value:tvl::string as tvl
from raw_data, LATERAL FLATTEN (
input => resp:data:date,
input => resp:data:tvl
)
)
select * from sui_tvl