There are many kinds of “stock prices” and there are also many ways to access those prices. This article explains the different types of stock price data available through the Intrinio Financial Data Marketplace and the different ways investors or developers can access those prices as well as the cost for subscribing.
What Stock Prices and Access Methods are Available?
Here are quick links to articles explaining the various types of prices sold in the marketplace:
- Real-time stock prices from major US exchanges including NASDAQ, NYSE, options, FX, and commodities
- Real-time stock prices from the IEX exchange, the most affordable stock prices on the market
- End of day (High, Low, Open, Close, Adjusted) prices from International Exchanges
- EOD prices from the United States, including fundamentals and valuation metrics
- EOD Options prices for the United States
- Over the counter (OTC) prices from various markets
And here are links to articles explaining the various access methods:
How Developers Can Access Stock Prices
If you are unfamiliar with Intrinio’s REST API, this article will give you a great introduction with links to the documentation and other useful tools. The REST API is used for pulling historical stock prices for US and International stocks. The prices endpoint makes it easy to get multiple high/low/open/close (HLOC) datapoints in a single API call:
The JSON output looks like this:
For US securities, you can just vary the ticker parameter and for international securities, you simply add the exchange. You can also get real-time stock prices via REST-API:
If you are interested in pulling prices for a specific range of dates, the historical_data endpoint can be used as well as the prices endpoint:
To see EOD or real-time prices via REST-API, you simply need to have a subscription to the proper data feed. If you try to pull data from an exchange and aren’t subscribed, the API response will tell you which data feed you need to add to your account from the marketplace. There are plenty of SDKs that wrap the Intrinio API to make your life easier; just pick one from your favorite language. Additionally, you can simply add “.csv” to your API call to convert the output from JSON to a CSV file:
If you are using the API, it can be helpful to note that the securities endpoint can be called with an optional parameter, last_crsp_adj_date, that returns a list of securities that have adjusted their stock prices due to a corporate event. This parameter is useful for configuring your application to only update historical prices if they have changed.
Pulling EOD prices via REST API makes sense for EOD prices or real-time prices if you don’t need to update the data very often. If you want to truly stream a high volume of real-time prices, a websocket API will work better. Whereas the REST API limits the number of calls you can use in a certain time-span, websocket subscriptions allow an unlimited number of price updates from a limited number of stocks.
Intrinio is working to expand websocket coverage to all North American exchanges and currently offers websocket connections from the IEX and NASDAQ exchanges. Startups, individuals, developers, and enterprises have self-signup options and can use our excellent SDKs to get started immediately.
These websocket options make it easy to stream prices from popular exchanges. If you have questions about which exchange, API type, subscription, or SDK you need, feel free to chat with our team.
How Investors Can Access Stock Prices
Typically, non-developers prefer to download financial data to Excel for analysis. Real-time as well as historical EOD stock prices for US and international exchanges and even options prices are available in both formats. In Excel, users can simply use the IntrinioSecurityPrices template that comes with the download:
Alternatively, Excel users can use the “datapoint” function to build custom templates:
To get the most recent close price:
Or the most recent real-time price:
A second formula, “=intriniohistoricaldata” can be used in Excel to pull historical stock prices as well as other data.
=intriniohistoricalprices("AAPL", "low", 1, "2006-01-01", "2016-01-01", "daily")
The historical data include adjusted data points that account for splits, reverse splits, and dividends. Index prices don’t include adjusted figures since indexes don’t have splits or dividends.
How much does this cost?
For most users, Intrinio lists the different subscription plans right on each product page. Details of the price, what’s included, the limits, and terms, are transparent and you don’t need to talk to a salesperson. Just go to the marketplace, search for the data you need, hit view-data, and you’ll see all of the information.
For most data feeds, Excel users and API users can choose between individual and professional. Not all plan types are available for all data feeds. This table explains the basics of each data feed:
|Plan Type||Cost||Data Allotment||Redistribution||Notes|
|Individual||Low to medium||Low to medium||No||For internal use, users that don’t need an excessive amount of data|
|Startup||Low||High||Yes||Our Startup Program offers 90% of all data feeds for three months to help startups get off the ground|
|Developer||Low||High||Yes||May also be eligible for the Startup Program|
|Enterprise||Custom||High||Yes||For bigger companies with unique needs; tell us your use case and we will provide you with a quote|
When choosing a plan for a prices data feed, you need to ask 3 questions:
- Do I need to redistribute this data or is it for my own, internal use?
- Do I qualify as a startup, making less than $10,000/month with less than $200,000 in funding? If so, do I qualify for the startup program as well?
- Do I need a large amount of data or just a few datapoints (this article explains how we count data points)?
It’s important to note that websocket APIs are priced slightly differently than rest APIs. Your typical data feeds (found via Rest APIs and on Excel) are priced based on two things: how the data is used and the amount of data used in a given period of time. On the other hand, websocket APIs (like NASDAQ and IEX), are priced in terms of concurrent connections and connections from specific points in time.
The $50/mo IEX plan, for example, allows for up to 10 concurrent connections at a time, meaning the real time prices for up to 10 stocks can be obtained with a continuous flow of new prices as they are updated on the exchange. The plan allows for a total of 1,000 total daily connections, meaning a user can connect to up to 1,000 different security pricing feeds over the course of a day, changing them as necessary. Here are the prices for IEX websocket access:
|Plan||Cost||Concurrent Connections||Daily Connections||Redistribution|
Stock prices are complicated – there are many types of stock prices, many access methods, and even different exchanges and legal requirements to consider. Our support team is really experienced at helping all types of users find the right data, the right subscription, and the right syntax to start pulling data. Just ask, and we will make it easy for you.