Returns Latest Annual Fundamentals On Given Date

This sample query returns the latest annual financials data for 500 companies for a filing date on or before the given observation date. Note: The population of 500 companies is generated using a TOP 500 in a select statement

Enhancement Date: 5/25/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Premium Capital StructureFinl Premium DetailFinl Premium MarketFinl Premium RatioFinl Premium StatementFinl Premium SupplementalFinl Premium CoreBase CompanyBase Data Item MasterBase Fondation Company Daily
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake