V3_STOCK_FLAT_FILE_TRADE_QUOTE()

Pro

Bulk download all stock trade/quote ticks for a given date as a CSV stream. Returns one row per tick, grouped by symbol. Requires a Professional stock subscription.

Expected response time: ~30 minutes. Expected file size: ~14 GB. Make sure your client and connection can handle a long-running, multi-gigabyte download.

Only the 7 most recent calendar days are available; data for the previous day is typically ready by 12:30-1am ET. See Flat Files Getting Started for details, or contact sales for more history.

Example

=THETADATA.V3_STOCK_FLAT_FILE_TRADE_QUOTE("20260803")

Parameters

dateRequired  -

The date to fetch data for.

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.