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 Marketplace and the different ways investors, developers, startups, and enterprises can access those prices as well as the cost for subscribing.
What Stock Prices and Access Methods are Available?
Here are quick references to various types of stock pricing data 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
And here are links to articles explaining the various access methods:
How Can Developers Access Stock Prices
The REST-API is used for pulling historical stock prices at a point in time. 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 day or minute, 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 sign up options as well as some excellent real time 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 Can Investors Access Stock Prices
Typically, non-developers prefer to download financial data to Excel or CSV donwload 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, both Excel and CSV users can use the "datapoint" endpoint to build custom templates:
To get the most recent close price:
Excel: =intriniodatapoint("AAPL", "close_price")
Or the most recent real-time price:
Excel: =intriniodatapoint("AAPL", "last_price")
A second formula, "=intriniohistoricaldata" can be used in Excel to pull historical stock prices as well as other data, so you can drag your formula down to pull a range of prices:
=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.
If you have questions about the proper syntax, feel free to try the API explorer, it builds the syntax for you, and you can always chat with our team.
How much does this cost?
For most users, Intrinio lists the different subscription plans right on each product page. Details of the price, whats included, the limits, and terms, are transparent and you don't need to talk to a sales person. Just go to the marketplace, search for the data you need, hit more info, and you'll see all of the information.
For most data feeds, Excel users and API users can choose between non-pro, professional, startup, and enterprise. These plans vary based on the data feed, and not all plan types are available for all data feeds.
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 daily datapoints (this article explains how we count data points)?
Its important to note that websocket APIs are priced slightly differently than rest APIs. Whereas data feeds that are available in Excel and via Rest API are priced based on the amount of data used per day and how the data is used, websocket APIs, including the NASDAQ and IEX exchanges, are priced in terms of concurrent connections and daily connections.
The professional IEX plan, for example, allows for up to 100 concurrent connections at a time, meaning the real time prices for up to 100 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 100,000 total daily connections, meaning a user can connect to up to 100,000 different security pricing feeds over the course of a day, changing them as necessary.
The NASDAQ websocket has similar plans: non-pro and professional. The most affordable one streams up to 50 tickers in real time with the highest one streaming up to 3,500 tickers. For plans and pricing click here, for additional add-ons click here.
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.
There are many reasons to work with Intrinio in addition to free chat support. Probably the best reason to work with Intrinio is that we are the good guys- we are here to help you get the data you need so you can be successful.