with current_price_tab AS (

SELECT

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

value[1]::string as price,

'WKLAY' :: 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)

UNION all

SELECT

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

value[1]::string as price,

'WETH' :: string AS token_contract

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

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

),

data_tab AS (

SELECT

log.value:POOL_ADDRESS::string AS lp_contract

,log.value:LP_PAIR::string AS pair

,log.value:SYMBOL0::string AS symbol

,log.value:TOKEN_ADDRESS0::string AS Lp_token

,log.value:TOKEN_DECIMAL0::string AS Lp_token_decimal

FROM (SELECT livequery.live.udf_api( 'https://flipsidecrypto.xyz/api/v1/queries/df78eb24-21c0-47d9-ae2e-2c8fe625d6cc/data/latest') as resp )

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

),