(select

HOUR,

case

when TOKEN_ADDRESS = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'Eth1111111111111111111111111111111111111111'

when TOKEN_ADDRESS = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' then 'AKEWE7Bgh87GPp171b4cJPSSZfmZwQ3KaqYqXoKLNAEE'

when TOKEN_ADDRESS = 'gu7ns9xcwgnpiadj69iusfrrfawjddpjembovhv1d4kn' then 'GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'

when TOKEN_ADDRESS = '0xdac17f958d2ee523a2206206994597c13d831ec7' then 'CEBP3CqAbW4zdZA57H2wfaSG1QNdzQ72GiQEbQXyW9Tm'

when TOKEN_ADDRESS = '0x2260fac5e5542a773aa44fbcfedf7c193bc2c599' then '7UTjr1VC6Z9DPsWD6mh5wPzNtufN17VnzpKS3ASpfAji'

when TOKEN_ADDRESS = '0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88' then 'F72PqK74jc28zjC7kWDk6ykJ2ZAbjNzn2jaAY9v9M6om'

when TOKEN_ADDRESS = 'So11111111111111111111111111111111111111112' then 'BeRUj3h7BqkbdfFU7FBNYbodgf8GCHodzKvF9aVjNNfL'

when TOKEN_ADDRESS = 'EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm' then '841P4tebEgNux2jaWSjCoi9LhrVr9eHGjLc758Va3RPH'

when TOKEN_ADDRESS = 'orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE' then '2tGbYEm4nuPFyS6zjDTELzEhvVKizgKewi6xT7AaSKzn'

when TOKEN_ADDRESS = 'ezSoL6fY1PVdJcJsUpe5CM3xkfmy3zoVCABybm5WtiC' then 'Fu5P5ikrnQ8BKZECJ1XeeDAaTgWJUrcjw8JmFrNA8TJk'

when TOKEN_ADDRESS = 'kySo1nETpsZE2NWe5vj2C64mPSciH1SppmHb4XieQ7B' then '8jN7xMDqJucigQphWHvqAPQPAmk7VJKKsqLmgCkE7XzP'

when TOKEN_ADDRESS = '0x04c154b66cb340f3ae24111cc767e0184ed00cc6' then '6AjQBsySS1FtQmA7a4oYc6GYpHBTDqtSswptsVSTz3Tv'

when TOKEN_ADDRESS = 'ibc/698350B8A61D575025F3ED13E9AC9C0F45C89DEFE92F76D5838F1D3C1A7FF7C9' then 'V5m1Cc9VK61mKL8xVYrjR7bjD2BC5VpADLa6ws3G8KM'

when TOKEN_ADDRESS = 'ibc/D79E7D83AB399BFFF93433E54FAA480C191248FC556924A2A8351AE2638B3877' then '9RryNMhAVJpAwAGjCAMKbbTFwgjapqPkzpGMfTQhEjf8'

when TOKEN_ADDRESS = 'hgd4dc6qycj3uanmdiuc4qanheetsavk6dy91b3f8gnl' then 'HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'

when TOKEN_ADDRESS = 'laihkxa47apns599tyeyasy2refezbne4heunanhsmx' then 'LaihKXA47apnS599tyEyasY2REfEzBNe4heunANhsMx'

when TOKEN_ADDRESS = 'J1toso1uCk3RLmjorhTtrVwY9HJ7X8V9yYac6Y7kGCPn' then 'JAh5pFYn1Kbh7kCuqZab8viVFdNgTmpS6hzFstSGNBvG'

end as token_address_on_eclipse,

case

when SYMBOL = 'WETH' then 'ETH'

when SYMBOL = 'TETH' then 'tETH'

when SYMBOL = 'WEETHS' then 'weETHs'

when SYMBOL = 'STTIA' then 'stTIA'

when SYMBOL = 'KYSOL' then 'kySOL'

when SYMBOL = 'EZSOL' then 'ezSOL'

when SYMBOL = 'PXETH' then 'apxETH'

when SYMBOL = 'JITOSOL' then 'JitoSOL'

else symbol end as token_symbol,

PRICE

from crosschain.price.ez_prices_hourly

where TOKEN_ADDRESS in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2','0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48','EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm','So11111111111111111111111111111111111111112',

'0x917cee801a67f933f2e6b33fc0cd1ed2d5909d88','0x2260fac5e5542a773aa44fbcfedf7c193bc2c599','0xdac17f958d2ee523a2206206994597c13d831ec7','orcaEKTdK7LKz57vaAYr9QeNsVEPfiu6QeMU1kektZE',