With stETH_Price AS (
SELECT HOUR AS Hours,
AVG(PRICE) AS stETH_Price
FROM ethereum.core.fact_hourly_token_prices
WHERE token_Address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
GROUP BY 1
),
WETH_Price AS (
SELECT HOUR AS hours1,
AVG(PRICE) AS ETH_Price
FROM ethereum.core.fact_hourly_token_prices
WHERE Symbol = 'WETH'
GROUP BY 1
)
SELECT Hours , (( ETH_Price / stETH_Price ) - 1) * 100 AS PROFIT_LOSS_PCT
FROM stETH_Price
JOIN WETH_Price ON stETH_Price.hours = WETH_Price.hours1