V3_STOCK_SNAPSHOT_OHLC()

ValueStandardPro

Provides a real-time Open, High, Low, Close for the current day.

Returns a real-time session OHLC from the Nasdaq Basic feed if the account has a stocks standard or pro subscription.
Returns a 15-minute delayed session OHLC from the UTP & CTA feeds if the account has the stocks value subscription.
Theta Data resets its snapshot cache at midnight ET every day. This endpoint may not work on a weekend where there were no eligible messages sent over exchange feeds. We recommend using historic requests during the weekend.

Example

=THETADATA.V3_STOCK_SNAPSHOT_OHLC("AAPL", "nqb", "")

symbol -

The stock or index symbol, or underlying symbol for options. Specify '*' for all symbols or a comma separated list when appropriate.

Type: string

Behavior: Optional - leave blank for all symbols.

venue -

Used to specify the venue of the real time or historic request. nqb = Nasdaq Basic; utp_cta = merged UTP & CTA.

Type: string

Behavior: Optional (default: nqb).

Enumnqb, utp_cta

min_time -

Filters snapshots to include only data with a timestamp greater or equal to the specified value (HH:mm:ss.SSS format).

Type: string

Behavior: Optional.

A grid (string[][]) - a header row followed by one row per result. See the REST API reference for the full response schema.