[eis]

That does not get you hourly time slots.

You either want something like

    floor(timestamp / 3600)

or

    timestamp - timestamp % 3600