Returns Pure Canadian Companies

This query returns pure Canadian companies by searching for companies with IID ending with C and Stock Exchange Code (EXCHG) = 7-10 to represent the Canadian exchanges, which are both from the Security table, and Country of Incorporation (FIC) = CAN (Canada) from the Company table

Enhancement Date: 7/1/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Core
  • Associated Datasets
    Compustat® 財務情報

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake