V3_STOCK_HISTORY_EOD()

FreeValueStandardPro

Since the equity SIPs only generate a partial EOD report, Theta Data generates a national EOD report at 17:15 ET each day. created represents the datetime the report was generated and last_trade represents the datetime of the last trade. The quote in the response represents the last NBBO reported by CTA or UTP at the time of report generation. You can read more about EOD & OHLC data here. Theta Data plans to avail SIP EOD reports in the near future.

Example

=THETADATA.V3_STOCK_HISTORY_EOD("AAPL", "20240101", "20240131")

Parameters

symbolRequired  -

The stock or index symbol, or underlying symbol for options.

Type: string

Behavior: Required.

start_dateRequired  -

The start date (inclusive).

Type: string

Behavior: Required.

end_dateRequired  -

The end date (inclusive).

Type: string

Behavior: Required.

Returns

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