Use Date_TRUNC('granularity', column).

To group events into a summarised time:

SELECT DATE_TRUNC('hour', timestamp) as hour, name, count(event) * 100 / count(*)
group by timestamp, name, event