with price_tab AS (

SELECT

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

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

'NPT' :: string AS token_symbol,

'0xe06597d02a2c3aa7a9708de2cfa587b128bd3815' :: string AS token_contract

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

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

UNION all

SELECT

hour::date as date,

avg(price)::string as price,

'nETH' :: string AS token_symbol,

'0x3f99650d1cde590d0d4f968d125594e9b876c22c' :: string AS token_contract

FROM ethereum.price.ez_prices_hourly

WHERE symbol = 'WETH'

AND token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

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,

'nFNSA' :: string AS token_symbol,

'0x19a16aa7c987fbda7dae021b05c1eb06524c7893' :: string AS token_contract

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

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

UNION all