select hg from readings where time > "04:00" and time < "4:30"; . . . and so on