avg(price) as price

from base.price.ez_prices_hourly where symbol='BTCB'

group by 1 order by 1 desc