trunc(hour,'day') as date,

CASE

when token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then 'ETH'

when token_address = '0xe95a203b1a91a908f9b9ce46459d101078c2c3cb' then 'aETH'

when token_address = '0xae78736cd615f374d3085123a210448e74fc6393' then 'rETH'

when token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' then 'stETH'

end as token_symbol,

avg(price) as price

from ethereum.core.fact_hourly_token_prices

where token_address in ('0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2','0xe95a203b1a91a908f9b9ce46459d101078c2c3cb','0xae78736cd615f374d3085123a210448e74fc6393','0xae7ab96520de3a18e5e111b5eaab095312d7fe84')

group by 1,2

order by 1 asc