I only want to see 24 values each day.

In normal circumstances this is not a problem as the db normally receives 1 new record each hour.

We have no idea...