select price as steth_price,hour as st_hour

from ethereum.core.fact_hourly_token_prices

where token_address= lower ('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')

and hour > '2020-12-26'

),

ETH_price as (

select price as eth_price,hour as eth_hour

from ethereum.core.fact_hourly_token_prices

where

symbol like 'WETH'

and hour > '2020-12-26'

select eth_hour as hourly_price,steth_price,eth_price, (STETH_price.steth_price) / (ETH_price.eth_price) as "RATE(STETH/ETH)"

from STETH_price,ETH_price

where st_hour=eth_hour

order by hourly_price desc