SELECT

TO_TIMESTAMP(value[0] :: string) as date,

value[1]::string as price,

'Klay' :: string AS token_contract

FROM (SELECT livequery.live.udf_api('https://api.coingecko.com/api/v3/coins/klay-token/market_chart?vs_currency=usd&days=365&interval=daily&precision=3') as resp)

,LATERAL FLATTEN (input => resp:data:prices)

),

current_price_tab_Stake AS (

select * from( values

( 'KKULP' , '0.000133'),

( 'WKLAY' , '0.151546'),

('KKAKDOG', '0.00000007667'),

( 'iUSD' , '1'),

( 'KKAK' , '0.00003351'),

( 'TT' , '0.0001925'),

( 'PER' , '0.0102403'),

( 'USDT' , '1'),

( 'USDC.e', '1'),

( 'USDC' , '1')

) AS a ( symbol, current_price)

),

data_tab_st AS (

SELECT

log.value:PAIR AS pair

,log.value:CONTRACT_ADDRESS::string AS lp_contract

,log.value:SYMBOL0 AS symbol0

,log.value:SYMBOL1 AS symbol1

,log.value:TOKEN_ADDRESS0 AS token_address0

,log.value:TOKEN_ADDRESS1 AS token_address1

,log.value:DECIMAL0::varchar AS decimal0

,log.value:DECIMAL1::varchar AS decimal1

FROM (SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/v1/queries/5170c0dd-f8ae-4e1d-a3bf-1da759b66b72/data/latest') as resp )