That does not get you hourly time slots.

You either want something like

    floor(timestamp / 3600)

or

    timestamp - timestamp % 3600

that's clever, thanks!