added queries for individual hour tracking but not UI