select date_trunc('day',hour) as date,
'OP' as token,
avg(price) as price
from optimism.core.fact_hourly_token_prices
where hour >= '2022-12-15'
and symbol ilike 'OP'
group by 1,2
UNION ALL
select date_trunc('day',hour) as date,
'ETH' as token,
avg(price) as price
from optimism.core.fact_hourly_token_prices
where hour >= '2022-12-15'
and symbol like '%ETH%'
group by 1,2