Returns A Quarterly Change Series For One Item With Data Codes

The following sample query builds a quarterly change series for all available dates for quarterly EPS (EPSPXQ) for ICG Group Inc (GVKEY 122536) with data codes. Note: To build a time-series for quarterly sales (SALEQ), use c.item = 'SALEQ' and add", c.valuei AS saleq, c.datacode AS saleq_dc in the select statement

Enhancement Date: 8/25/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Snapshot
  • Associated Datasets
    Compustat® Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake