US Equities Trade Only
The U.S. Equities Trade-Only dataset provides a tick-by-tick record of executed trades for U.S. exchange-listed equity securities, derived from the consolidated Equity SIP Last Sale. The dataset captures trades executed on all U.S. public equity exchanges, as well as off-exchange trades reported to FINRA Trade Reporting Facilities (TRF). For each trade, core attributes such as price, size (volume), market center, and sales condition codes are provided, enabling detailed analysis of execution act
GEThttps://api.devalgoseek.com/api/v1/data/us-equity/eq-trades/:trade_date/:ticker#
The U.S. Equities Trade-Only dataset provides a tick-by-tick record of executed trades for U.S. exchange-listed equity securities, derived from the consolidated Equity SIP Last Sale. The dataset captures trades executed on all U.S. public equity exchanges, as well as off-exchange trades reported to FINRA Trade Reporting Facilities (TRF). For each trade, core attributes such as price, size (volume), market center, and sales condition codes are provided, enabling detailed analysis of execution activity and trade reporting context. Data spans the entire trading session, including pre-market (from 4:00 a.m.), regular market hours, and after-hours trading (through 8:00 p.m.), offering a complete view of daily trade flow without quote information. The dataset is delivered as trade-only data (no bids or asks), making it suitable for execution analysis, volume studies, and trade-based signal research where quote dynamics are not required.
For more details, please refer to the dataset documentation: US Equities Trade Only Guide.
Note: This dataset has an adjusted version available. By default, the endpoint returns price and volume values 'as-is' based on information published on the exchange. The adjusted version includes backward-adjusted data that accounts for corporate actions such as dividends and stock splits, which affect fields based on price and volume. You can control this behavior by using the adjusted query parameter in your API requests.
Advanced Filtering
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 Advanced Filtering Guide for the extensive reference.
Request#
Path Parameters#
Trading date in YYYY-MM-DD format
2024-01-15Dataset's security identifier
AAPLQuery Parameters#
- Adjustment enabled
- Adjustment disabled
- JSON
- CSV Gzip
Flag to indicate whether to return adjusted price and volume data
falseReturn the adjusted data
trueReturn unadjusted data (default behavior)
falseSorting 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.
Possible values: >= 0
Number of records to skip before returning results. To be used with the limit parameter for pagination. If not provided, defaults to 0.
0100Possible values: >= 0 and <= 100000
Maximum number of records to return. Used to control response size and pagination. If not provided, a default limit is applied by the server.
10000100Possible values: [json, csv, csv_gzip]
The type of the data to return
jsonJSON format (default)
jsonCompressed CSV format
csv_gzipResponses#
- 200
- 403
- 422
- 429
JSON, CSV file, or gzip-compressed CSV file, depending on the value of response_format query parameter
- application/json
- text/csv
- application/gzip
- Schema
- Example (auto)
Schema
- Array [
- ]
data object[]required
The trading day
2023-08-02Event timestamp (EST) with a nanosecond resolution (milliseconds before 2016)
2023-08-02 12:29:37.425851482The type of the trade event
TRADESymbol name
AAPLA unique identifier for a security
1010000000001033The price of Trade. Can be up to 4 decimal places for sub-penny prices
191.935The number of shares
1The exchange or reporting venue
FINRACondition flags applicable to the trade encoded as unsigned int
2147483649pagination objectrequired
The number of records skipped to fetch the current page
0The maximum number of records in the current page
The number of records to skip to fetch the next page
{
"data": [
{
"TradeDate": "2023-08-02",
"EventDateTime": "2023-08-02 12:29:37.425851482",
"EventType": "TRADE",
"Ticker": "AAPL",
"ASID": 1010000000001033,
"Price": 191.935,
"Quantity": 1,
"Exchange": "FINRA",
"ConditionCode": 2147483649
}
],
"pagination": {
"limit": 1000,
"next_offset": 2000,
"offset": 1000
}
}
- Schema
- Example (auto)
Schema
"string"
- Schema
- Example (auto)
Schema
"string"
Forbidden
- application/json
Validation Error
- application/json
- Schema
- Example (auto)
Schema
- Array [
- Array [anyOf
- string
- integer
- ]
- ]
detail object[]
loc object[]required
{
"detail": [
{
"loc": [
"string",
0
],
"msg": "string",
"type": "string",
"ctx": {}
}
]
}
Request rejected because the identity or team exceeded a configured monthly or per-minute usage quota. When available, the response includes rate-limit headers describing the current quota.
Response Headers
Configured quota limit for the resource that was exceeded.
Remaining quota before the limit is reached. This is 0 when the request is rejected.
Number of seconds left in the current quota period before usage resets.
- application/json
- csharp
- curl
- dart
- go
- http
- java
- javascript
- kotlin
- c
- nodejs
- objective-c
- ocaml
- php
- postman-cli
- powershell
- python
- r
- ruby
- rust
- shell
- swift
- HTTPCLIENT
- RESTSHARP
var client = new HttpClient();
var request = new HttpRequestMessage(HttpMethod.Get, "https://api.devalgoseek.com/api/v1/data/us-equity/eq-trades/:trade_date/:ticker");
request.Headers.Add("Accept", "application/json");
request.Headers.Add("X-API-KEY", "<X-API-KEY>");
var response = await client.SendAsync(request);
response.EnsureSuccessStatusCode();
Console.WriteLine(await response.Content.ReadAsStringAsync());
Click the Send API Request button above and see the response here!