select date_trunc('day', hour) as date, avg(price) as price

from ethereum.token_prices_hourly

where token_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'

group by date

),

eth as (

select date_trunc('day', hour) as date1, avg(price) as price

from ethereum.token_prices_hourly

where symbol = 'ETH'

group by date1

select date, eth.price-steth.price as price_difference

from steth, eth

where date = date1