vertex as (

SELECT defillama.get('/protocol/vertex', {}) as resp

)

SELECT *

FROM (

SELECT

TO_TIMESTAMP(v.value:date::INT) AS date,

'Vertex' as protocol,

v.value:totalLiquidityUSD::FLOAT AS TVL

FROM

vertex,

LATERAL FLATTEN(input => resp['data']['chainTvls']['Arbitrum']['tvl']) AS v

WHERE date < date(current_date)

AND date > '2023-10-01'

ORDER BY date DESC