Point-In-Time Sample Query Which Returns The Average Lag For US Companies

The following sample SQL query uses the Premium Financials Instance Date package to calculate the average lag for US companies, based on the restatement and form types. The query limits the universe to US, Original 10-Q collection for post 2009 records

Enhancement Date: 5/25/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Financial Premium Intraday CoreFinl Latest CoreFinl Premium CoreBase CompanyBase Foundation Company Daily
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake