DATE(hour) as "Date",

AVG(price) as "Average UNI price, USD"

FROM ethereum.core.fact_hourly_token_prices

WHERE "Date" BETWEEN '2022-01-01' AND '2022-12-31'

AND symbol = 'UNI'

GROUP BY "Date"),

sushiswap as (select

date(hour) as "Date",

avg(price) as "Average SUSHI price, USD"

from ethereum.core.fact_hourly_token_prices

where "Date" between '2022-01-01' and '2022-12-31'

and symbol = 'SUSHI'

group by "Date")

select uniswap."Date", sushiswap."Date", uniswap."Average UNI price, USD", sushiswap."Average SUSHI price, USD"

from uniswap

join sushiswap

on uniswap."Date"=sushiswap."Date"

order by uniswap."Average UNI price, USD"