tickerbot_get_bars
OHLCV bars from 1-second through monthly. The prices underneath the table.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| to | No | Window end (inclusive): a bare `YYYY-MM-DD` means through the end of that day, same as series. Mutually exclusive with `asof` and `before` (400). | |
| asof | No | Point-in-time: the most recent bar whose period had closed at or before that moment. A bare `YYYY-MM-DD` means that day's close. A full timestamp means the last FINISHED bar — at 10:00 ET on a Wednesday the day's close has not happened, so `1d` returns Tuesday's bar. Returns one bar unless you also pass `limit`, which gives the last `limit` closed bars. Mutually exclusive with `before`/`cursor` (400). Unlimited depth. | |
| from | No | Window start (inclusive): `YYYY-MM-DD`, ISO timestamp, or epoch-ms. Combines with `to` for an explicit window; page within it using `cursor`. Mutually exclusive with `asof` and `before` (400). | |
| limit | No | Most-recent N bars. Max 1000 — an over-cap value is clamped, not an error. | |
| before | No | Return the N bars ending strictly before this date/timestamp — back-paging. Mutually exclusive with `cursor` (they are the same control — a 400 when both are sent). | |
| cursor | No | Continuation token from a prior response's `next_cursor`; sugar for `before` (sending both is a 400; a blank `cursor=` counts as absent), and the way to page inside a `from`/`to` window. | |
| ticker | Yes | Ticker symbol, or a comma-separated list (up to 50) for a bulk response keyed by symbol. | |
| session | No | Sub-hour intervals only. `all` (default) includes pre- and post-market bars. `regular` keeps bars whose start is in 09:30–16:00 ET (DST-aware). Why you might want it: the vendor buckets trades by SIP report time, and late-reported off-exchange (Form T) prints on thin names can land 20 min to hours late in a pre-market minute — a `$1.70` print at 08:13 ET on a `$3.85` stock. Daily high/low are untouched by those. `limit` counts after the filter; paging still works. | all |
| adjusted | No | Default `true`: prices are split-adjusted — restated after each later split, as the tape is, so a series is continuous across a split. `false` returns the price as it printed that day (a name that later did a 1:10 reverse split reads `21.4` adjusted and `2.14` on the tape), which is what a broker fill or a chart from that time shows. Volume scales the other way. Un-adjusted on read from the splits table; the store is untouched. | |
| interval | Yes | Bar interval. `2h`/`4h` roll up hourly bars; `1w`/`1mo` roll up daily bars into calendar weeks (Monday start) and months — the bar's `t` is the bucket start (UTC), and with `asof` the last bucket is the week/month to date. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| bars | Yes | OHLCV bars, chronological, in the compact array shape. Bulk requests key this by symbol instead. | |
| note | No | Present only when there is something to disclose about how the page was served: the first on-demand fetch for an untiered symbol (explains the latency; later calls are stored), or a `1s` page served from the local store because the provider could not be reached. Bulk responses carry `notes[symbol]` instead. | |
| as_of | Yes | Server time this response was assembled (ISO 8601). | |
| count | Yes | Bars returned in single-symbol mode; the number of SYMBOLS in bulk mode. | |
| notes | No | Bulk (comma-list) requests only: the per-symbol disclosures, keyed by symbol, in place of `note`. | |
| ticker | Yes | The symbol you asked for. | |
| session | Yes | The session filter applied: `all` (default) or `regular` (09:30–16:00 ET, sub-hour intervals only). | |
| adjusted | Yes | Whether the bars are split-adjusted — `true` unless you passed `adjusted=false`. | |
| coverage | Yes | Why the page looks the way it does: `covered` when bars were found, `no_data` when the vendor has none for the window, `not_in_minute_tier` when a sub-hour interval was asked of a symbol the minute store does not carry. | |
| interval | Yes | The bar size served. | |
| next_cursor | No | Opaque token for the next page; `null` on the last page. Absent on bulk (comma-list) requests, which are unpaged. Absent on bulk requests — page bulk symbol-by-symbol. |