select 'Last 60 Days' as status,
case when symbol = 'WETH' then 'ETH' else 'MATIC' end as token,
avg(price) as average_price
from ethereum.core.fact_hourly_token_prices
where symbol in ('WETH','MATIC')
and hour::date = '2022-09-25'
group by 1,2
UNION
select 'Today' as status,
case when symbol = 'WETH' then 'ETH' else 'MATIC' end as token,
avg(price) as average_price
from ethereum.core.fact_hourly_token_prices
where symbol in ('WETH','MATIC')
and hour::date = '2022-11-24'
group by 1,2