select

hour :: date as date,

case

when token_address = '0x85f138bfee4ef8e540890cfb48f620571d67eda3' then 'A.231cc0dbbcffc4b7.ceAVAX'

when token_address = '0x418d75f65a02b3d53b2418fb8e1fe493759c7605' then 'A.231cc0dbbcffc4b7.ceBNB'

when token_address = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' then 'A.231cc0dbbcffc4b7.ceWBTC'

when token_address = '0x4e15361fd6b4bb609fa63c81a2be19d873717870' then 'A.231cc0dbbcffc4b7.ceFTM'

when token_address = '0x6b175474e89094c44da98b954eedeac495271d0f' then 'A.231cc0dbbcffc4b7.ceDAI'

when token_address = '0x4fabb145d64652a948d72533023f6e7a623c7c53' then 'A.231cc0dbbcffc4b7.ceBUSD'

when token_address = '0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0' then 'A.231cc0dbbcffc4b7.ceMATIC'

when token_address = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'A.231cc0dbbcffc4b7.ceUSDT'

when token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'A.231cc0dbbcffc4b7.ceWETH'

when token_address = '0xf1f955016ecbcd7321c7266bccfb96c68ea5e49b' then 'A.231cc0dbbcffc4b7.RLY'

else symbol

end as symbols,

avg(price) as price

from

ethereum.core.fact_hourly_token_prices

where

token_address in (

'0x2260fac5e5542a773aa44fbcfedf7c193bc2c599',

'0x85f138bfee4ef8e540890cfb48f620571d67eda3',

'0x418d75f65a02b3d53b2418fb8e1fe493759c7605',

'0x4e15361fd6b4bb609fa63c81a2be19d873717870',

'0x6b175474e89094c44da98b954eedeac495271d0f',

'0x4fabb145d64652a948d72533023f6e7a623c7c53',

'0x7d1afa7b718fb893db30a3abc0cfc608aacfebb0',

'0xdac17f958d2ee523a2206206994597c13d831ec7',

'0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2',

'0xf1f955016ecbcd7321c7266bccfb96c68ea5e49b'

)

and hour :: date >= CURRENT_DATE - 90

group by

1,

2