get_historical_results

Returns historical publishable results for one or more (index, datetime) lookups, queried from Trino. Prefer get_recent_results when the target falls within its in-memory cache window (roughly the last year for daily RR indices, the last hour for RTI indices) — it answers from memory and keeps load off Trino; use this tool for older history or exact-point lookups outside that window. Maximum 4 queries per call — make multiple calls for larger batches. All datetimes must be in UTC (ISO 8601, e.g. 2024-02-18T16:00:00Z). Returned timestamps are also UTC.

Parameters

Field	Type	Required	Description
queries	array<object>	Yes	One entry per result to look up. Each entry specifies an index and the exact computeForTime of the result. Maximum 4 entries per call. Maximum 4 items.

queries[] item

Field	Type	Required	Description
indexId	string	Yes	e.g. BRTI, BRR, BRRNY
datetime	string	Yes	Exact computeForTime in ISO 8601 UTC format, e.g. 2024-02-18T16:00:00Z

Example request

{
  "method": "tools/call",
  "params": {
    "name": "get_historical_results",
    "arguments": {
      "queries": [
        {
          "indexId": "<indexId>",
          "datetime": "<datetime>"
        }
      ]
    }
  }
}