group by time interval

Assume I have a table like

how can I create a table like

where the groups are created of timeintervals with the length of 1 second.

Thank you in advance!