select

livequery.live.udf_api(

'GET',

'https://api.llama.fi/protocol/echelon-market',

{ 'content-type': 'application/json;charset=utf-8' },

{ }

) as response

to_timestamp(value:date) AS day,

ZEROIFNULL(value:tokens:APT) AS APT,

ZEROIFNULL(value:tokens:CAKE) AS CAKE,

ZEROIFNULL(value:tokens:ETH) AS ETH,

ZEROIFNULL(value:tokens:MOD) AS MOD,

ZEROIFNULL(value:tokens:STAPT) AS STAPT,

ZEROIFNULL(value:tokens:STHAPT) AS STHAPT,

ZEROIFNULL(value:tokens:THL) AS THL,

ZEROIFNULL(value:tokens:USDC) AS USDC,

ZEROIFNULL(value:tokens:USDCET) AS USDCET,

ZEROIFNULL(value:tokens:USDT) AS USDT,

datas,

LATERAL FLATTEN (input => response:data:tokensInUsd)