The US Sector and Industry Data Feed provides an easy to use API for accessing statistics and historical trend data for aggregated financial statement metrics by SIC code.  Quickly benchmark a company's performance to its sector or industry peer group using the full set of standardized Intrinio tags.  Statistics available for historical data include mean, median, min, max, 25th and 75th percentile for each metric and ratio.  The data is updated monthly and incorporates all filings up to the last day of the month.

IMPORTANT LINKS

WHAT DATA IS INCLUDED?

  • Statistics on industry and sector aggregates based on the company reported SIC
  • Current data is reported monthly based on new company filings with the SEC
  • Analyze trends through benchmarked historical time series data

ACCESS VIA API

If you're leveraging the REST API to access the US Sector and Industry Data Feed, you'll want to get started with the following tutorial:

Getting Started With the Intrinio API

To get started using the Sector and Industry data, you can query the index master to retrieve all Sector and Industry indices (SIC Indices):
https://api.intrinio.com/indices?type=sic

{
  "result_count": 565,
  "page_size": 250,
  "current_page": 1,
  "total_pages": 3,
  "api_call_credits": 1,
  "data": [
    {
      "symbol": "$SIC.1",
      "index_name": "Agriculture, Forestry, And Fishing",
      "continent": "North America",
      "country": "United States",
      "index_type": "sic"
    },
    {
      "symbol": "$SIC.10",
      "index_name": "Mining",
      "continent": "North America",
      "country": "United States",
      "index_type": "sic"
    },
    {
      "symbol": "$SIC.100",
      "index_name": "AGRICULTURAL PRODUCTION - CROPS",
      "continent": "North America",
      "country": "United States",
      "index_type": "sic"
    },
    {
      "symbol": "$SIC.1000",
      "index_name": "METAL MINING",
      "continent": "North America",
      "country": "United States",
      "index_type": "sic"
    },
    {
      "symbol": "$SIC.1040",
      "index_name": "Gold & Silver Ores",
      "continent": "North America",
      "country": "United States",
      "index_type": "sic"
    },
    ...
  ]
}


A specific SIC Index can be queried using the following API Call:
https://api.intrinio.com/indices?identifier=$SIC.3500

{
  "symbol": "$SIC.3500",
  "index_name": "INDUSTRIAL MACHINERY & EQUIPMENT",
  "continent": "North America",
  "country": "United States",
  "index_type": "sic"
}


Below is the API Call and example response for retrieving a data point request, which returns the median for the SIC Index, in this case the price to earnings ratio for the Industrial Machinery & Equipment industry SIC 3500:
https://api.intrinio.com/data_point?identifier=$SIC.3500&item=pricetoearnings

{
  "identifier": "$SIC.3500",
  "item": "pricetoearnings",
  "value": 27.1633
}


To explore the /data_point end point, including all of the available SIC Indices and the standardized tag, it is recommended that you check out the API Explorer.

The true power of the Sector and Industry Data Feed is through the /historical_data end point.  The ability to choose a statistic type provides immense flexibility and ability to understand the makeup of an industry.

Here is an example API Call for requesting the sum of total revenues for the Industrial Machinery industry quarterly for calendar year 2014:
https://api.intrinio.com/historical_data?identifier=$SIC.3500&item=totalrevenue&start_date=2014-01-01&end_date=2015-01-01&frequency=quarterly&type=sum

{
  "identifier": "$SIC.3500",
  "item": "totalrevenue",
  "result_count": 4,
  "page_size": 1000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "date": "2014-12-31",
      "value": 987869939216
    },
    {
      "date": "2014-09-30",
      "value": 958691241557
    },
    {
      "date": "2014-06-30",
      "value": 955775784459
    },
    {
      "date": "2014-03-31",
      "value": 958499841554
    }
  ]
}


Here, we can request the median return on invested capital for the Industrial Machinery industry on a yearly frequency.

https://api.intrinio.com/historical_data?identifier=$SIC.3500&item=roic&start_date=2009-01-01&end_date=2018-01-01&frequency=yearly&type=median

{
  "identifier": "$SIC.3500",
  "item": "roic",
  "result_count": 9,
  "page_size": 1000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "date": "2017-12-31",
      "value": 0.047753
    },
    {
      "date": "2016-12-31",
      "value": 0.04042
    },
    {
      "date": "2015-12-31",
      "value": 0.0704815
    },
    {
      "date": "2014-12-31",
      "value": 0.090681
    },
    {
      "date": "2013-12-31",
      "value": 0.096036
    },
    {
      "date": "2012-12-31",
      "value": 0.1094545
    },
    {
      "date": "2011-12-31",
      "value": 0.116769
    },
    {
      "date": "2010-12-31",
      "value": 0.1148725
    },
    {
      "date": "2009-12-31",
      "value": 0.107277
    }
  ]
}


We can also request the 25th percentile of the Industrial Machinery industry price to earnings ratio on a yearly basis.  

https://api.intrinio.com/historical_data.csv?identifier=$SIC.3500&item=pricetoearnings&frequency=yearly&type=25thpctl

{
  "identifier": "$SIC.3500",
  "item": "pricetoearnings",
  "result_count": 11,
  "page_size": 1000,
  "current_page": 1,
  "total_pages": 1,
  "api_call_credits": 1,
  "data": [
    {
      "date": "2017-12-31",
      "value": 19.2762
    },
    {
      "date": "2016-12-31",
      "value": 17.57075
    },
    {
      "date": "2015-12-31",
      "value": 13.5348
    },
    {
      "date": "2014-12-31",
      "value": 14.83125
    },
    {
      "date": "2013-12-31",
      "value": 15.884325
    },
    {
      "date": "2012-12-31",
      "value": 10.886
    },
    {
      "date": "2011-12-31",
      "value": 10.928
    },
    {
      "date": "2010-12-31",
      "value": 15.680625
    },
    {
      "date": "2009-12-31",
      "value": 14.2037
    },
    {
      "date": "2008-12-31",
      "value": 7.87075
    },
    {
      "date": "2007-12-31",
      "value": 15.729975
    }
  ]
}

You'll find the API Explorer incredibly helpful. Simply fill in the SIC Index, time frame, and type of data you're looking for and it will create an API call for you. You can copy and paste that syntax directly into the browser or into your codebase.

If you'd like to download a flat CSV file of the data, you'll want to get started with the following tutorial:

File Download Tutorial

Here is an example of a download link that will download the complete list of Institutional Owners for Tesla Motors (TSLA):

https://api.intrinio.com/securities/institutional_ownership.csv?identifier=TSLA

You'll find the Download Link Maker incredibly helpful. Simply fill in the security, time frame, and type of data you're looking for and it will create a download link for you. 

ACCESS VIA EXCEL

If you do not already have the Microsoft Excel add-in installed, follow this Tutorial to get started.  It is quite easy to get it running - you will need to install the Intrinio Excel add-in and add your API keys for your credentials to login.

There are two functions that give you the ability to access the US Sector and Industry Data Feed via Microsoft Excel:

The IntrinioDataPoint function will return the most recent median stat for a specified SIC Index and tag item combination.  

For example, to mimic the Data Point end point API call from above:

=IntrinioDataPoint("$SIC.3500","pricetoearnings")

27.1633


With IntrinioHistoricalData, you can add much more specificity to your request, such as defining which value in the sequence to put in a cell and what statistic to return a value for:

Again, to mimic the Historical Data end point API call from above:

=IntrinioHistoricalData("$SIC.3500","roic",0,"2009-01-01","2018-01-01","yearly","median")

0.047753


=IntrinioHistoricalData("$SIC.3500","pricetoearnings",5,,,"yearly","25thpctl")

10.886

HOW MUCH DOES THIS DATA COST?

Intrinio's underlying technology uses algorithms and machine learning to source data on US securities, which keeps costs extraordinarily low. Fortunately for you, we pass those cost savings on to the end user. We're proud to provide the most affordable US fundamentals data on the market.

  • Individual - $25/month (no redistribution)
  • Professional - $50/month (no redistribution)
  • Startup - $75/month (redistribution included)
  • Enterprise - $300/month (redistribution included)
  • Developer - FREE (for qualifying startups, redistribution included)

Each plan has an upper limit for the number of API Calls you can request each day. If you find that you're hitting the limit, it's very easy to upgrade. Our pricing is also month to month, because we're the good guys. If you're not using it, don't pay for it!

Should you need more data than is available on the Enterprise Plan, we are happy to provide you with a quote. Send our team a message!

Quotes are generally returned within 1 business day and are paid month to month, meaning users can cancel at anytime. A quote and a free trial are always made available before any subscription.

If you have any additional questions about the US Sector and Industry Data Feed, feel free to chat with a member of our team and get started with Intrinio!

Did this answer your question?