select TIME_FORMAT(created, '%H') as `Hour`, min(value), max(value) from test3 where time_to_sec(timediff(now(),created))< 24*3600 group by `Hour`;