Thanks, this looks exactly what I want. Sensible interval origins [1] too (January 1, 2000 for months and years, and January 3 2000, a Monday, for weeks) and also configurable.

[1] https://docs.timescale.com/use-timescale/latest/time-buckets...