SELECT hour as time, symbol as token, price

FROM ethereum.core.fact_hourly_token_prices

WHERE hour > TO_DATE('2020-01-01') AND

symbol = 'WETH'

),

steth_prices AS (

SELECT hour as time, symbol as token, price

FROM ethereum.core.fact_hourly_token_prices

WHERE hour > TO_DATE('2020-01-01') AND

symbol = 'stETH'

SELECT DATE_TRUNC('week', e.time) as date, avg(e.price) as eth_price, avg(s.price) as steth_price, ABS(eth_price / steth_price) as relative_price

FROM eth_prices e

JOIN steth_prices s ON s.time = e.time

GROUP BY date

ORDER BY date