Returns GICS Classifications For Segments

The following sample SQL query demonstrates how to provide the GICS classifications for each segment associated to a filing date. The sample query below retrieves company information for International Business Machines (companyId 112350). Note: This query uses the GICS package (in the SymbolHelper files) and the S&P Capital IQ Key Documents package

Enhancement Date: 5/25/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Premium Segment ProfilesBase Foundation Company
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake