AssetDatapointIntervalQuery

Aggregates numeric or boolean datapoints from the inclusive range into aligned time buckets and returns buckets in chronological order. Use this to summarize a series at a regular resolution. Numeric attributes support every formula; boolean attributes support every formula except DIFFERENCE and are aggregated as 1 for true and 0 for false.

type stringrequired

Aggregates numeric or boolean datapoints from the inclusive range into aligned time buckets and returns buckets in chronological order. Use this to summarize a series at a regular resolution. Numeric attributes support every formula; boolean attributes support every formula except DIFFERENCE and are aggregated as 1 for true and 0 for false.

Possible values: [all, interval, lttb, nearest]

all

Returns every stored datapoint in the inclusive range, ordered from newest to oldest. Use this when the complete series is needed without aggregation or downsampling. Supports numeric, boolean, text, and JSON-compatible complex attribute values.

interval

lttb

Downsamples numeric or boolean datapoints from the inclusive range with the Largest-Triangle-Three-Buckets (LTTB) algorithm while preserving the series' visual shape. Use this to reduce a large series for charts. Results are chronological; boolean values are processed as 1 for true and 0 for false. Other attribute value types are rejected.

amountOfPointsinteger<int32>required

Requested maximum number of representative datapoints after downsampling. Fewer points are returned when the range contains fewer datapoints.

Example: 500

nearest

Returns at most one numeric datapoint: the closest value at or before the requested time. Use fromTimestamp as a Unix-seconds timestamp at the HTTP API boundary. toTimestamp, fromTime, and toTime are ignored. The equality boundary is inclusive.

fromTimestring<date-time>

Inclusive lower range bound for all, interval, and lttb as an ISO local or offset date-time. A local value is interpreted in the server time zone; an offset value is converted to the server time zone. Takes precedence over fromTimestamp and is ignored by nearest.

Example: 2026-01-01T00:00:00Z

fromTimestampinteger<int64>

Inclusive lower range bound as Unix time in milliseconds for all, interval, and lttb; ignored when fromTime is supplied. For nearest this is instead the requested time in Unix seconds and is the only time field used.

Example: 1767225600000

toTimestring<date-time>

Inclusive upper range bound for all, interval, and lttb as an ISO local or offset date-time. A local value is interpreted in the server time zone; an offset value is converted to the server time zone. Takes precedence over toTimestamp and is ignored by nearest.

Example: 2026-01-02T00:00:00Z

toTimestampinteger<int64>

Inclusive upper range bound as Unix time in milliseconds for all, interval, and lttb; ignored when toTime is supplied and not used by nearest.

Example: 1767312000000

formulastringrequired

Aggregation applied per bucket: MIN, AVG, and MAX calculate the corresponding value; DIFFERENCE calculates the change between the last values of consecutive buckets; COUNT counts datapoints; SUM totals numeric values (or true values for booleans); MODE selects the most frequent value; and MEDIAN selects the middle value. DIFFERENCE is numeric only.

Possible values: [MIN, AVG, MAX, DIFFERENCE, COUNT, SUM, MODE, MEDIAN]

gapFillboolean

When true, returns empty buckets across the requested range using time-bucket gap filling; their aggregate is generally null. When false, only buckets containing datapoints are returned. Defaults to false.

Example: true

intervalstringrequired

PostgreSQL interval literal that sets the bucket width. Include a positive amount and unit, for example 1 hour, 5 minutes, or 1 day.

Example: 1 hour

AssetDatapointIntervalQuery

{
  "fromTime": "2026-01-01T00:00:00Z",
  "fromTimestamp": 1767225600000,
  "toTime": "2026-01-02T00:00:00Z",
  "toTimestamp": 1767312000000,
  "type": "string",
  "formula": "MIN",
  "gapFill": true,
  "interval": "1 hour"
}