Returns Annual Historical Fundamentals For Specific Data Items

The following sample query returns specific S&P Capital IQ financial data items by either ticker or company ID. Note: In this sample query, the ticker symbol for Amazon (AMZN) is used. If you wish to query by company ID, you can uncomment c.companyId

Enhancement Date: 6/15/2026

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Premium CoreFinl Premium Capital StructureFinl Premium DetailFinl Premium MarketFinl Premium RatioFinl Premium SegmentsFinl Premium StatementFinl Premium SupplementalBase CompanyBase Data Item MasterBase Equity SecurityBase Foundation Company DailyBase Security
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake
  • Databricks