About
The Query API (often referred to as the Data Out API) allows third-party systems to access a variety of data categories via a standard query interface.
Over 50 datasets can be accessed using the same API request structure.
A dataset can be filtered by any field within the dataset using compare filters, date range filters, and domain filters.
Both synchronous and asynchronous requests are supported to simplify access to large
1. How does the Equity API map to the data on the OTC Transparency website?
The key field in the Equity API datasets that allows aggregation of the data is the "summaryTypeCode" field.
The allowed values for this field for ATS data include (weeklysummary dataset):
- ATS_W_SMBL will return trade data aggregated by issue on a weekly basis
- ATS_W_SMBL_FIRM will return trade data aggregated by ATS and issue on a weekly basis
- ATS_W_FIRM will return trade data aggregated by ATS on a weekly basis
- ATS_W_VOL_STATS will return ATS statistics data on a weekly basis
The allowed values for this field for OTC (Non-ATS) data include: (weeklysummary and monthlysummary datatsets)
- OTC_W_SMBL will return trade data aggregated by issue on a weekly basis
- OTC_W_SMBL_FIRM will return trade data aggregated by firm and issue on a weekly basis
- OTC_W_FIRM will return trade data aggregated by firm on a weekly basis
- OTC_W_VOL_STATS will return OTC statistics data on a weekly basis
- OTC_M_SMBL will return trade data aggregated by issue on a monthly basis
- OTC_M_SMBL_FIRM will return trade data aggregated by firm and issue on a monthly basis
- OTC_M_FIRM will return data aggregated by firm on a monthly basis
- OTC_M_VOL_STATS will return OTC statistics data on a monthly basis
2. Does FINRA have any samples of query API calls?
While FINRA does not endorse any particular tool or programming language, please review this page for a basic example of how to use a common tool to call the API.
3. Is there any registration data that is not available via the FINRA API?
Yes, for security and privacy reasons, Social Security Numbers (SSN) is not available in the FINRA API.
4. What is the difference between the Composite Individual and Composite Individual Seed datasets?
The Composite Individual Seed dataset contains complete information for all individual's associated with the firm and is intended to be used to initially populate a customer's database or in data recovery scenarios. It is not intended to be consumed on a regular basis.
The Composite Individual dataset returns data for single individual and is intended for daily use in combination with the Individual Delta dataset. The firm should use the Individual Delta to identify a list of individuals who have had recent data changes, and then call the Composite to retrieve updated data for each individual.