adjusting timezone for xaxis labels, aggregating records by hour, discarding date