time_series_range

utility

Generates time series sequences

Syntax

time_series_range(start, end, interval)

start (string)

Start date/time

end (string)

End date/time

interval (string)

Interval (e.g., "1 day", "1 hour", "30 minutes")

array

Array of timestamps at the specified interval

Generate daily sequence

Input:

time_series_range("2024-01-01", "2024-01-07", "1 day")

Output:

["2024-01-01", "2024-01-02", "2024-01-03", "2024-01-04", "2024-01-05", "2024-01-06", "2024-01-07"]

Generate hourly sequence

Input:

time_series_range("2024-01-01 00:00", "2024-01-01 23:00", "1 hour")

Output:

["2024-01-01 00:00", "2024-01-01 01:00", ..., "2024-01-01 23:00"]

The time_series_range() function generates a sequence of timestamps from a start to an end date/time at a specified interval.

Use time_series_range() to create time-based scaffolds for data analysis, generate date ranges, or create time series templates.