US Equities Trade and Quote Extended Second Bar
Changed onThe U.S. Equities Trade and Quote Extended Second Bar dataset provides a high-granularity, event-driven view of U.S. equity market activity at one-second resolution, derived from consolidated trade and quote (TAQ) data. Each bar contains approximately 90 calculated metrics, capturing detailed price behavior, quote dynamics, and short-horizon order-flow characteristics.In addition to standard Open, High, Low, Close, and Volume (OHLCV) measures, the dataset includes a rich set of market microstructure analytics, such as trade classification at bid/mid/ask, uptick and downtick statistics, bid-ask spread measures, and time-weighted bid and ask metrics. These features are designed to support fine-grained intraday analysis, short-horizon signal research, and execution-sensitive modeling. Unlike continuous minute bar, this dataset uses an event-based bar construction: a one-second bar is generated only when trading or quote activity occurs. Seconds with no activity do not produce a bar, preserving the true temporal density of market events and avoiding artificial carry-forward behavior. Data is derived from Equity Securities Information Processor (SIP) feeds and includes all eligible trades and top-of-book quotes, including off-exchange trades reported to FINRA Trade Reporting Facilities (TRF). Coverage spans all exchange-traded U.S. equity issue types, including common and preferred stocks, ETFs, ETNs, ADRs, warrants, units, etc.
For more details, please refer to the dataset documentation: US Equities Trade and Quote Extended Second Bar Guide (algoseek and Excluding FINRA TRF aggregation logic).
Aggregation Logic Options
This dataset is available with different aggregation logic variants, which may affect how certain data fields are calculated.
algoseek
algoseek core team comes from a high-frequency background and uses accepted de facto standards for calculating OHLC bars. See documentation for details on included/excluded fields.
Excluding FINRA TRF
Excludes all trades that are done off the public ("lit") exchanges. These trades from dark pools, internal crossing, OTC deals, etc. These are trades that are not normally possible to participate in, so they can skew the backtesting if Client is only executing on public exchanges. Removing these trades provides a more realistic view of actual trades taking place, but does lose insight into the whole market.
<details> <summary>**Advanced Filtering**</summary>You can provide one or multiple filter expressions based on the dataset's columns to narrow down the results. For example, StartDate.gt=2023-01-01&StartDate.lt=2023-12-31, Ticker=AAPL.
Please refer to the <a href="https://algoseek.com/docs/rest-api/tutorial/advanced-filtering">Advanced Filtering Guide</a> for the extensive reference.
</details> <details> <summary>**Optimizing Performance**</summary>Some queries to this endpoint may be slow due to the size of the data chunk requested. If this becomes an issue, consider narrowing down the response data with query parameters.
For more details, please refer to the <a href="https://algoseek.com/docs/rest-api/tutorial/optimizing-query-performance">Query Performance Guide</a>.
</details>Request
- Base URLhttps://api.algoseek.com
- AuthAPI key in header X-API-KEY
- TypeScriptA function with typed inputs. Its response is checked against the schema.
Path parameters
Dataset's security identifier
Query parameters
Aggregation logic variant of the dataset
A string representing the time period for which to retrieve data. The format and accepted values depend on the dataset. If not provided, data for all available periods will be returned.
Sorting criteria for the results. Provide a column name with optional prefix '+' for ascending order, or prefix with '-' for descending order. Multiple sorting fields may be supported depending on the dataset. If sort prefix is not provided, the ascending order is applied.
A comma-separated list of columns to include in the response. Use this parameter to select only specific fields from the dataset. If not provided, all available columns will be returned.
Number of records to skip before returning results. To be used with the limit parameter for pagination. If not provided, defaults to 0.
Maximum number of records to return. Default and maximum values depend on the response format; see format_limits in the schema for details.
Note the lowercase which is used for the consistency with other projects and tools
The type of the data to return
Response
JSON, CSV file, or gzip-compressed CSV file, depending on the value of response_format query parameter
Example response
{
"data": [
{
"TradeDate": "2026-01-09",
"BarDateTime": "2026-01-09 04:00:00",
"Ticker": "A",
"ASID": 1010000000001000,
"HighBidTimeOffset": 0.009660616,
"HighBidPrice": 140.42,
"HighBidSize": 100,
"HighAskTimeOffset": 0.002699086,
"HighAskPrice": 153.16,
"HighAskSize": 100,
"LowBidTimeOffset": 0.002699086,
"LowBidPrice": 138.32,
"LowBidSize": 100,
"LowAskTimeOffset": 0.009500339,
"LowAskPrice": 148.7,
"LowAskSize": 2000,
"CloseBarTimeOffset": 0.999999999,
"CloseBidPrice": 138.85,
"CloseBidSize": 100,
"CloseAskPrice": 148.7,
"CloseAskSize": 2000,
"MinSpread": 8.28,
"MaxSpread": 14.84,
"NBBOQuoteCount": 10,
"TotalQuoteCount": 41,
"ExchangesBidCount": 20,
"ExchangesAskCount": 21,
"TimeWeightSpread": 9.7379,
"TimeWeightBid": 138.9934,
"TimeWeightBidSize": 100,
"TimeWeightAsk": 148.7313,
"TimeWeightAskSize": 1987,
"SpreadValidTime": 998
}
],
"pagination": {
"limit": 1000,
"next_offset": 2000,
"offset": 1000
}
}Changes
- info
endpoint added
- info