V3_STOCK_SNAPSHOT_TRADE()

StandardPro

Returns a real-time last trade from the Nasdaq Basic feed if the account has a stocks standard or pro 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_TRADE("AAPL", "nqb", "")

Parameters

symbolRequired  -

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

Type: string

Behavior: Required.

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.

Returns

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