Returns Dual Listed Companies With Both US And Non-US Security Listings

This query returns all companies that have both an a U.S. security listing (IID of 01) and a non-U.S. security listing (IID of 01C), meaning they are double-followed Canadian companies

Enhancement Date: 7/1/2020

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

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake