date(hour) as "Date",

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

from ethereum.core.fact_hourly_token_prices

where "Date" between '2022-05-04' and '2022-05-15'

and symbol = 'WETH'

group by "Date"),

luna as (select

date(hour) as "Date",

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

from ethereum.core.fact_hourly_token_prices

where "Date" between '2022-05-04' and '2022-05-15'

and symbol = 'LUNA'

group by "Date"),

ust as (select

date(hour) as "Date",

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

from ethereum.core.fact_hourly_token_prices

where "Date" between '2022-05-04' and '2022-05-15'

and symbol = 'UST'

group by "Date")

select eth."Average WETH price, USD", luna."Average LUNA price, USD", ust."Average UST price, USD", eth."Date"

from eth

join luna

on eth."Date"=luna."Date"

join ust

on eth."Date"=ust."Date"