Time Series functions in BigQuery

I've posted some time ago about "rounding" timestamps and datetime values, but in the past few months BigQuery has added Time Series functions (in preview for now), making for a cleaner and simpler approach of this problem. We now have DATE_BUCKET,...