Returns Index Constituents And Identifiers

The following sample query returns the constituents of the SP 500 Index as of a specified date and their corresponding identifiers, including Company ID (companyId), Trading Item ID (tradingItemId), and GVKEY.

Enhancement Date: 7/1/2020

  • SourceMarket Intelligence
  • Data Packages Required
    S&P TSX 60 Constituent Name History
  • Associated Datasets
    インデックスデータ

Query Types

  • MSSQL
  • PostGreSQL