question

simon avatar image
1 Like"
simon asked ·

What are the possible values of "sector", "industry_category" and "industry_group"?

Hello,

I want to query the sector, industry_category and industry_group via the data point (text). It would be good to know every possible value, which the three endpoints can return. Has anyone a list with every sectorname, etc.?

Thanks in advance

apiindustriessectors
10 |600 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

1 Answer

· Write an Answer
mkelly avatar image
1 Like"
mkelly answered ·

Hi, Intrinio has recently started providing users with direct database access through Snowflake. This is an excellent example of a basic use case for this new integrated tool. For example:

SELECT DISTINCT sector_name FROM companies ;
SECTOR_NAME

Services
Healthcare
Basic Materials
Conglomerates
Industrial Goods
Utilities
Financial
Technology
Consumer Goods

The industry category information:

SELECT DISTINCT industry_category_name FROM companies ;
INDUSTRY_CATEGORY_NAME

Diversified Services
Health Services
Banking
Energy
Internet
Financial Services
Telecommunications
Retail
Materials & Construction
Metals & Mini
...

and the industry group information:

SELECT DISTINCT industry_group_name FROM companies ;
INDUSTRY_GROUP_NAME

Rental & Leasing Services
Medical Appliances & Equipment
Oil & Gas Equipment & Services
Medical Laboratories & Research
Internet Software & Services
Savings & Loans
Closed-End Fund - Equity
Closed-End Fund - Debt
Conglomerates
Grocery Stores
...

These are the top 10 responses or each of the categories you asked about. For more information on Snowflake, watch the webinar by the Intrinio CTO here. https://blog.intrinio.com/announcing-direct-database-access-with-snowflake/ or read about it on the intrinio blog. https://blog.intrinio.com/direct-database-access-with-snowflake/ . As always you can talk to our live support team for access information.

· Share
10 |600 characters needed characters left characters exceeded

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.