Returns CIQ Period Last Market Cap

This query pulls the Period Last Market Cap (dataItemId = 100010) using the S&P Capital IQ files in Xpressfeed for a specific period end date and a specific company

Enhancement Date: 9/23/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Latest DetailFinl Latest MarketFinl Latest RatioFinl Latest StatementFinl Latest SupplementalFinl Latest Core
  • Associated Datasets
    S&P Capital IQ 财务数据

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake