select block_timestamp::date as date, avg(price) as eth_price, sum(amount_in_usd) as eth_volume_usd
from ethereum.core.ez_dex_swaps s
join ethereum.core.fact_hourly_token_prices p
on s.block_timestamp::date = p.hour::date
where symbol_in = 'WETH'
and symbol_out = 'stETH'
group by 1