with btc as (
select
hour::date as day
,avg(price) as price
from ethereum.core.fact_hourly_token_prices
where hour::date >='2022-01-01'
and symbol = 'WBTC'
group by 1
order by 1
)
,algo as (
select
block_hour::date as day
,avg(price_usd) as price
from flipside_prod_db.algorand.prices_swap
where block_hour::date >= '2022-01-01'
and asset_id = 0
group by 1
order by 1
)
select 'BTC' as type ,* from btc
union all
select 'ALGO' as type ,* from algo