new 'hourly_avg' aggregation