added daily/hourly averages with clipping bug