time_bucket rounds a timestamp to a fixed window

The function returns the start of the fixed-width interval a timestamp falls into, aligned to an origin you choose. Generally available, and it removes the date_trunc-and-arithmetic dance from most time-series grouping.

Read the original