Need to take a test drive?
100 API calls free
Free Trial
The Trade Alert US Option Prices data feed brings end of day (EOD) options prices from the United States directly to Excel or API, allowing developers and analysts to build apps and systematic analyses in Excel. Prices are released every morning. Users can access the most recent close data via a subscription or request a bulk download of historical data. Chat with our team for pricing on 3, 6, and 9 years of historical EOD options prices.
The free trial lasts 3 days and allows users to sample both historical and current option data. The $100/mo self-signup subscription includes a license for individual internal use of the most recent (non-historical) EOD options prices. Enterprise and display licenses are available up request. Chat with our team to receive a quote or a sample download of historical data.
Intrinio offers a variety of ways to access this data feed. Choose your preferred access method below:
Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio API uses HTTPS verbs and a RESTful endpoint structure, which makes it easy to request data from Intrinio. Basic Authentication is administered over HTTPS. Responses are delivered in JSON format.
If you need additional help in using the API, chat with us.
For a quick guide to getting started with our API, please see the Tutorial.
For private/trusted environments, use Basic Authentication over HTTPS.
You can find your API Username and API Password on your Account page. You must include these credentials with every request in order to receive access to the API.
To include the credentials in your HTTPS request, specify an Authorization header, with the value Basic (key) , replacing (key) with the Base-64 encoded string API_USERNAME:API_PASSWORD .
If your credentials are not authorized, a status code of 401 will be returned.
For public/untrusted environments (such as client-side JavaScript), use our public key authentication over HTTPS.
You can create a Public Access Key on your Account page. Make sure to specify all domains from which this key may be used. Any domain not listed will be rejected by the API. For development purposes, localhost is listed as a domain by default. Make sure to delete this domain before going to production.
To include a public key in your HTTPS request, specify it as the value of an X-Authorization-Public-Key header.
If your public key is not authorized, a status code of 401 will be returned.
Intrinio uses normal HTTP response codes to indicate the success or failure of an API request. A response code of 200 indicates success and codes in the 4xx range indicate an error that failed given the information provided, and codes in the 5xx range indicate an error with Intrinio’s servers (these are rare).
The Intrinio API uses the following error codes:
| Code | Meaning |
|---|---|
| 200 | OK – Everything worked as expected |
| 401 | Unauthorized – Your User/Password API Keys are incorrect |
| 403 | Forbidden – You are not subscribed to the data feed requested |
| 404 | Not Found – The endpoint requested does not exist |
| 429 | Too Many Requests – You have hit a limit. See limits |
| 500 | Internal Server Error – We had a problem with our server. Try again later. |
| 503 | Service Unavailable – You have hit your throttle limit or Intrinio may be experiencing high system load. |
Often there is too much information in our system to serve in a single request of reasonable size. Therefore we limit results to a certain number per request and provide you with paging information which can be used to retrieve the remaining pages of data.
In the Web API, you will notice that most requests contain paging information.
File Downloads may have paging information as well, listed in the first row.
In order to request the next page of data, append a page_number parameter to your request:
The Intrinio API employs several reasonable limits to ensure that stable, reliable service is provided to all users. These limits can vary based on which data feeds you are subscribed to, as well as which API call you are making. The limits are grouped as: daily calls, 10-minute calls, paging, throttling, and timeouts. If you hit an API limit, the response will contain a 429 code and an explanation of the limit.
Most data feed subscriptions have limited daily usage. This means that you can make up to a certain number of API calls in a 24-hour period (resetting at midnight Eastern). To view the limits for a data feed subscription, go to your Account page, click on Subscriptions, click on the subscription in question, and click on Limits.
Some data feed subscriptions have limited 10-minute usage. This means that you can make up to a certain number of API calls in a 10-minute period.
As an alternative to Daily Call Limits, some data feeds employ a 1-minute call limit. This means that you can make up to a certain number of API calls in a 1-minute period.
API endpoints that employ paging are limited by the maximum page size that you may request. This varies by endpoint:
| Endpoint | Maximum Page Size |
|---|---|
| /historical_data | 1,000 |
| All others | 100 |
Users enjoying free data feed subscriptions only are limited to 100 requests-per-second.
Each request must be fulfilled within 25 seconds, otherwise it will be dropped with a 503 error. Given the flexibility of our endpoints and the complexity of potential API calls, we leave it to the users to fashion requests which can be satisfied in a reasonable time.
The following endpoints will help you to check your API access, limits, and usage:
Note: this is limited to data feeds with daily API call limits.
Below are all of the API endpoints available for this data feed:
Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio Excel Add-In allows you to access a variety of datasets right in Excel, using simple, intuitive functions.
The Excel Add-in works on both Mac OS X and Microsoft Windows versions of Excel.
If you need additional help, chat with us.
For a quick guide to getting started with our Excel Add-In, please see the Tutorial.
Below are all the functions available for this data feed:
Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. The Intrinio Google Sheets Add-On allows you to access a variety of datasets right in Google Sheets, using simple, intuitive functions.
If you need additional help, chat with us.
For a quick guide to getting started with our Google Sheets Add-On, please see the Tutorial.
Below are all the functions available for this data feed:
Welcome to the Intrinio Financial Data Platform! Through our Data Marketplace, we offer a wide selection of financial data feeds sourced by our own proprietary processes as well as from many data vendors. All of our data is available for download in the CSV (comma-separated values) format.
If you need additional help, chat with us.
For a quick guide to getting started with our CSV Download functionality, please see the Tutorial.
When using the download links, your browser will prompt you for a username and password. These credentials correspond to your access keys, which can be found in your Account page.
Sometimes there is too much information in our system to put into a single file of reasonable size. Therefore we limit file downloads to 10,000 rows. In order to retrieve the rest of the rows, you will have to request the second "page" of results. The first row of each file will contain paging information: RESULT_COUNT: 6342 , PAGE_SIZE: 10000 , CURRENT_PAGE: 1, TOTAL_PAGES: 1 , API_CALL_CREDITS: 1
If the TOTAL_PAGES field in your file is greater than 1 and you want to see the other pages, append a page_number parameter to the URL:
https://api.intrinio.com/indices.csv?type=economic&page_number=1https://api.intrinio.com/indices.csv?type=economic&page_number=2https://api.intrinio.com/indices.csv?type=economic&page_number=3
To exclude the paging information from your file, include a hide_paging parameter in the URL:
https://api.intrinio.com/indices.csv?type=economic&page_number=1&hide_paging=true
URLs must be formatted correctly in order for file downloads to be processed successfully. Here are examples of correct URLs:
https://api.intrinio.com/indices.csvhttps://api.intrinio.com/indices.csv?type=economichttps://api.intrinio.com/indices.csv?type=economic&query=GDPhttps://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap,beta
Here are examples of incorrect URLs:
https://api.intrinio.com/indices.csv&type=economichttps://api.intrinio.com/indices.csv?type=economic?query=GDPhttps://api.intrinio.com/data_point.csv?identifier=AAPL&item=marketcap/beta
Here is a key to the different parts of a URL:
| https://api.intrinio.com | /data_point.csv | ? | identifier | = | AAPL | & | item | = | marketcap,beta |
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Below are all of the CSV file downloads available for this data feed:
Returns the master list of option contracts for a given ticker.
| Name | Description | Example |
|---|---|---|
| ticker | The option ticker symbol, corresponding to the underlying security. | AAPL |
| expiration | The contract expiration date. | 2018-04-03 |
| type |
The contract type.
Options:
put
call
|
put |
| page_number | An integer greater than or equal to 1 for specifying the page number for the return values. | 4 |
| page_size | An integer greater than or equal to 1 for specifying the number of results on each page. | 10 |
| hide_paging |
Hide first row of paging information.
Options:
true
|
true |
| Name | Description | Example |
|---|---|---|
| identifier | the contract identifier, used for Data Point and Historical Data endpoints | AAPL190118C00195000 |
| ticker | the option ticker symbol, corresponding to the underlying security | AAPL |
| expiration | the contract expiration date, in format YYYY-MM-DD | 2019-01-18 |
| strike | the contract strike price | 195 |
| type | the contract type, either put or call | call |
Not available for this access method
Returns all option contract expiration dates for a given ticker.
| Name | Description | Example |
|---|---|---|
| ticker | The option ticker symbol, corresponding to the underlying security. | AAPL |
| hide_paging |
Hide first row of paging information.
Options:
true
|
true |
Not available for this access method
Returns the current prices for the given option contract(s).
| Name | Description | Example |
|---|---|---|
| ticker | The option ticker symbol, corresponding to the underlying security. | AAPL |
| expiration | The contract expiration date. | 2017-02-17 |
| type |
The contract type, either put or call.
Options:
put
call
|
put |
| strike | The contract strike price. | 136 |
| hide_paging |
Hide first row of paging information.
Options:
true
|
true |
| Name | Description | Example |
|---|---|---|
| date | the price date, in the format YYYY-MM-DD | 2017-02-14 |
| expiration | the contract expiration date, in the format YYYY-MM-DD | 2017-02-17 |
| strike | the contract strike price | 136 |
| type | the contract type, either put or call | call |
| close | the closing price of the contract | 0.43 |
| close_bid | the closing bid price of the contract | 0.42 |
| close_ask | the closing ask price of the contract | 0.44 |
| volume | the closing volume of the contract | 19349 |
| volume_bid | the closing bid volume of the contract | 7075 |
| volume_ask | the closing ask volume of the contract | 6815 |
| trades | the number of trades executed that day | 915 |
| open_interest | the open interest at the end of the day | 8538 |
| open_interest_change | the change in open interest from the previous day | 3074 |
| next_day_open_interest | the open interest at the start of the next day | 12625 |
| implied_volatility | the implied volatility of the contract | 0.169001 |
| implied_volatility_change | the change in implied volatility that day | -0.009107 |
| delta | the delta of the contract vs the underlying security | 0.321807 |
Not available for this access method
Returns the historical prices for the given option contract.
| Name | Description | Example |
|---|---|---|
| ticker | The option ticker symbol, corresponding to the underlying security. | AAPL |
| expiration | The contract expiration date. | 2017-01-20 |
| type |
The contract type.
Options:
put
call
|
put |
| strike | The contract strike price. | 145 |
| page_number | An integer greater than or equal to 1 for specifying the page number for the return values. | - |
| page_size | An integer greater than or equal to 1 for specifying the number of results on each page. | 10 |
| hide_paging |
Hide first row of paging information.
Options:
true
|
true |
| Name | Description | Example |
|---|---|---|
| date | the price date, in the format YYYY-MM-DD | 2017-02-14 |
| expiration | the contract expiration date, in the format YYYY-MM-DD | 2017-02-17 |
| strike | the contract strike price | 136 |
| type | the contract type, either put or call | call |
| close | the closing price of the contract | 0.43 |
| close_bid | the closing bid price of the contract | 0.42 |
| close_ask | the closing ask price of the contract | 0.44 |
| volume | the closing volume of the contract | 19349 |
| volume_bid | the closing bid volume of the contract | 7075 |
| volume_ask | the closing ask volume of the contract | 6815 |
| trades | the number of trades executed that day | 915 |
| open_interest | the open interest at the end of the day | 8538 |
| open_interest_change | the change in open interest from the previous day | 3074 |
| next_day_open_interest | the open interest at the start of the next day | 12625 |
| implied_volatility | the implied volatility of the contract | 0.169001 |
| implied_volatility_change | the change in implied volatility that day | -0.009107 |
| delta | the delta of the contract vs the underlying security | 0.321807 |
Not available for this access method
Returns the most recent data point for a selected identifier (ticker symbol, stock market index symbol, CIK ID, etc.) for a selected tag. Income statement, cash flow statement, and ratios are returned as trailing twelve months values. All other data points are returned as their most recent value, either as of the last release financial statement or the most recent reported value.
| Name | Description | Example |
|---|---|---|
| identifier | An identifier, which can be a security ticker, SEC CIK ID, FRED Series ID, etc. | AAPL |
| item | An item, which can be a data tag or a special code. | marketcap |
| hide_paging |
Hide first row of paging information.
Options:
true
|
- |
| Name | Description | Example |
|---|---|---|
| identifier | the ticker or identifier for the data point | AAPL |
| item | the requested standardized tag or series ID | name |
Not available for this access method
Not available for this access method
Returns the historical data for for a selected identifier (ticker symbol or index symbol) for a selected tag. Income statement, cash flow statement, and ratios are returned as trailing twelve months values by default, but can be changed with the type parameter. All other historical data points are returned as their value on a certain day based on filings reported as of that date.
| Name | Description | Example |
|---|---|---|
| identifier | An identifier, which can be a security ticker, SEC CIK ID, FRED Series ID, etc. | AAPL |
| item | An item, which can be a data tag or a special code. | marketcap |
| start_date | The earliest date for which to return data. | 2018-04-02 |
| end_date | The latest date for which to return data. | 2018-5-03 |
| frequency |
The frequency of the historical prices & valuation data.
Options:
daily
weekly
monthly
quarterly
yearly
|
yearly |
| type | The type of historical data to fetch. For financial statements, the type reflects the type of financial statement. For Sector data, the type reflect the aggretation (mean, median, max, min) type of the data. | FY |
| sequence | An integer 0 or greater for calling a single historical data point from the first entry, based on sort order. | 0 |
| show_date |
If true, the function will return the date value, and if false the function will return the data point value for a given query.
Options:
Yes
|
Yes |
| page_number | An integer greater than or equal to 1 for specifying the page number for the return values. | 4 |
| page_size | An integer greater than or equal to 1 for specifying the number of results on each page. | 10 |
| hide_paging |
Hide first row of paging information.
Options:
true
|
true |
| Name | Description | Example |
|---|---|---|
| identifier | the ticker or identifier for the data point | @MUSK_51244-TSLA:US |
| item | the requested standardized tag or series ID | comp_total_summary |
| date | the date associated with the value of the data tag | 2016-12-31 |
| value | the value of the Intrinio tag of the financial data point | 45936 |
Not available for this access method