SELECT

hour::date as date,

avg(price)::string as price,

'WKLAY' :: string AS token_symbol,

FROM kaia.price.ez_prices_hourly

WHERE symbol = 'KLAY'

AND hour::date >= current_date - interval '365 day'

GROUP BY 1

UNION all

SELECT

hour::date as date,

avg(price)::string as price,

'M-BTC' :: string AS token_symbol,

FROM ethereum.price.ez_prices_hourly

WHERE token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' -- WBTC

AND hour::date >= current_date - interval '365 day'

GROUP BY 1

UNION all

SELECT

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

log.value[1]::string as price,

'KSP' :: string AS token_symbol

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

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

UNION all

SELECT