Stock Prices From Intrinio

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 Fintech 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:

And here are links to articles explaining the various access methods:

How Can Developers 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:

https://api.intrinio.com/prices?ticker=AAPL

The JSON output looks like this:

Screen Shot 2017-10-24 at 11.42.08 AM

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:

https://api.intrinio.com/data_point?identifier=AAPL&item=last_price,last_timestamp,last_size,bid_price,ask_price

Screen Shot 2017-10-24 at 11.49.56 AM

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:

https://api.intrinio.com/historical_data?ticker=AAPL&item=close_price&start_date=2014-01-01&end_date=2015-01-01

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:

https://api.intrinio.com/prices.csv?ticker=AAPL

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, 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 and can use the documentation, as well as some 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.

Chat with Us If You Have Questions

How Can Investors Access Stock Prices

Typically, non-developers prefer to download financial data to Excel or Google Sheets 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:

stock prices in excel

Alternatively, both Excel and Google users can use the "datapoint" function to build custom templates:

To get the most recent close price:

=intriniodatapoint("AAPL", "close_price")

Or the most recent real-time price:

=intriniodatapoint("AAPL", "last_price")

This same "=intriniodatapoint("identifier", "tag") formula can be used to get international EOD prices and EOD options prices as well.

A second formula, "=intriniohistoricaldata" can be used in Excel to pull historical stock prices as well as other data. This article gives an overview of this function that uses a date range 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.

Chat with Us If You Have Questions

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 view-data, and you'll see all of the information.

Screen Shot 2017-10-24 at 1.48.38 PM

For most data feeds, Excel users and API users can choose between individual, professional, startup, enterprise, free, and developer plans. These plans vary based on the data feed, and not all plan types are available for all data feeds. This table explains the basics of each data feed:

Plan Type Cost Daily Data Allotment Redistribution Notes
Free $0 Low No  

Available on 4 data feeds

Individual Low Low No For internal use, users that don't need a lot of data
Professional Medium Medium No For internal use, users that need more daily data
Startup Low High Yes For companies with low revenues and little to no funding. Available for many data feeds
Developer $0 High Yes A program that provides 6 months of free data on select feeds, including pricing data, to get startups off the ground
Enterprise Custom High Yes For bigger companies with unique needs- tell us your use case and we will get you a quote in 24 hours

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 developer 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 $5/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
Individual $5 10 1,000 No
Professional $50 100 10,000 No
Startup $500 500 50,000 Yes
Enterprise $1000 Custom Custom Custom
Firehose Custom Unlimited Unlimited Custom

The NASDAQ websocket has similar plans with an individual, non-professional user paying $75/mo to stream up to 50 tickers in real time or $125/mo for a professional.

Wait, what?

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.

Chat with Us If You Have Questions

There are many reasons to work with Intrinio in addition to free chat support. This article explains all of the advantages. 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.

  • Harrison Delfino

    I recommend you use MarketXLS as an alternative.
    Yahoo Finance API has been discontinued.
    MarketXLS have regular updates and customer support unlike yahoo.
    It cost a little but it will definitely save you time.
    Hope it helps.

    • Rachel Carpenter

      Hey Harrison! Thanks for the info. We actually provide our own real time stock price data via Excel, API, Google Sheets, and Screener – this article was meant to educate our users on how to take advantage of those resources through the Intrinio Platform, which provides the most affordable data and tools on the entire market – with the most flexibility, and with customer support. I highly recommend you check it out! Chat us if you have questions.