price1 as (select

date_trunc('day',hour) as period,

avg(price) as price_usd

from bitcoin.price.ez_prices_hourly where symbol in ('BTC')

group by 1),

price2 as (select

date_trunc('day',hour) as period,

avg(price) as price_usd

from ethereum.price.ez_prices_hourly

group by 1)

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 where p2.price_usd<1000 and p2.price_usd>0 and p1.period>='2018-01-01'