with tab1 as (select

livequery.live.udf_api(

'GET',

'https://api.llama.fi/protocol/kaiaswap',

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

{}

) as response)

,

tvl as ( SELECT *

FROM (

SELECT

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

'Kaia-swap' as project,

v.value:totalLiquidityUSD::FLOAT AS TVL

FROM

tab1,

LATERAL FLATTEN(input => response['data']['chainTvls']['Klaytn']['tvl']) AS v

select *,

case

when day < '2024-06-30' then 5000000

when day >= '2024-06-30' and day < '2024-08-31' then 10000000

when day >= '2024-08-31' and day < '2024-10-31' then 20000000

when day >= '2024-10-31' and day < '2025-12-31' then 30000000

end as milestone

from (

select date::date as day,

max(tvl) as TVL

from tvl

group by 1

)

order by 1 desc