with

a as (

select

hour,

price as btc,

symbol,'btc' as title

from ethereum.token_prices_hourly

where lower(symbol) = 'WBTC'

and hour > '2021-12-10 00:00:00.000'

group by 1,2,3,4),

b as (

select

hour,

price as eth,

symbol,'eth' as title

from ethereum.token_prices_hourly

where lower(symbol) = 'WETH'

and hour > '2021-12-10 00:00:00.000'

group by 1,2,3,4)

select btc , eth ,a.hour

from a inner join b on a.hour=b.hour