hour,

avg(case when token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2' then price end) as weth_price,

avg(case when token_address = '0x5e74c9036fb86bd7ecdcb084a0673efc32ea31cb' then price end) as seth_price,

(seth_price - weth_price) / weth_price * 100 as discount,

seth_price / weth_price as ratio

from ethereum.core.fact_hourly_token_prices

where token_address = '0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2'

or token_address = '0x5e74c9036fb86bd7ecdcb084a0673efc32ea31cb'

group by 1

order by hour desc