Returns Compustat Public Companies

The following sample query a public or formerly public company that has at least one entry in the security data group trading on an exchange NOTE: Uncomment the second query to return companies that have pricing in the sec_dprc data group.

Enhancement Date: 7/1/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Core
  • Associated Datasets
    Compustat® Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake