price1 as (select

date_trunc('day',hour) as period,

symbol,

avg(price) as price_usd

from bitcoin.price.ez_prices_hourly

where symbol in ('BTC')

group by 1,2),

price2 as (select

date_trunc('day',hour) as period,

symbol,

avg(price) as price_usd

from ethereum.price.ez_prices_hourly

where symbol in ('{{asset symbol}}')

group by 1,2)

select p1.period, p1.price_usd as btc_price, p2.price_usd as alt_price

from price1 p1 join price2 p2 on p1.period=p2.period