Skip to main content
Version: Upcoming

StockEarnForecastHist

Description

SpiderRock Stock Earnings Forecast records contain SpiderRock's forecast of upcoming earnings announcement dates for each security. Each record lists the nearest earnings event plus the next eight projected earnings announcements, with the announcement date, type (estimate, announced, released), and time of day (before market, after market, etc.) for each.

Start Dates

US start dates
Start Date
2010-01-04
EU start dates
Start Date
2026-03-31

Schema Definition

Field NameData TypeDescription
ticker_atstringUnderlying asset type
ticker_tsstringUnderlying ticker source
ticker_tkstringUnderlying ticker
tradingDatedateTrading date
securityIDbigintSpiderRock security ID
nearEarnDatetimestampNearest (current or most recent) forecast earnings announcement date
nearEarnTypestringNearest earnings announcement type (estimate, announced, released)
nearEarnTimestringNearest earnings announcement time (before market, after market, etc.)
nextEarnDate1AdjtimestampAdjusted forecast date of the first upcoming earnings announcement
nextEarnDate2AdjtimestampAdjusted forecast date of the second upcoming earnings announcement
nextEarnDate1timestampForecast date of the first upcoming earnings announcement
nextEarnType1stringType of the first upcoming earnings announcement (estimate, announced, released)
nextEarnTime1stringTime of the first upcoming earnings announcement (before market, after market, etc.)
nextEarnDate2timestampForecast date of the second upcoming earnings announcement
nextEarnType2stringType of the second upcoming earnings announcement (estimate, announced, released)
nextEarnTime2stringTime of the second upcoming earnings announcement (before market, after market, etc.)
nextEarnDate3timestampForecast date of the third upcoming earnings announcement
nextEarnType3stringType of the third upcoming earnings announcement (estimate, announced, released)
nextEarnTime3stringTime of the third upcoming earnings announcement (before market, after market, etc.)
nextEarnDate4timestampForecast date of the fourth upcoming earnings announcement
nextEarnType4stringType of the fourth upcoming earnings announcement (estimate, announced, released)
nextEarnTime4stringTime of the fourth upcoming earnings announcement (before market, after market, etc.)
nextEarnDate5timestampForecast date of the fifth upcoming earnings announcement
nextEarnType5stringType of the fifth upcoming earnings announcement (estimate, announced, released)
nextEarnTime5stringTime of the fifth upcoming earnings announcement (before market, after market, etc.)
nextEarnDate6timestampForecast date of the sixth upcoming earnings announcement
nextEarnType6stringType of the sixth upcoming earnings announcement (estimate, announced, released)
nextEarnTime6stringTime of the sixth upcoming earnings announcement (before market, after market, etc.)
nextEarnDate7timestampForecast date of the seventh upcoming earnings announcement
nextEarnType7stringType of the seventh upcoming earnings announcement (estimate, announced, released)
nextEarnTime7stringTime of the seventh upcoming earnings announcement (before market, after market, etc.)
nextEarnDate8timestampForecast date of the eighth upcoming earnings announcement
nextEarnType8stringType of the eighth upcoming earnings announcement (estimate, announced, released)
nextEarnTime8stringTime of the eighth upcoming earnings announcement (before market, after market, etc.)

Differences to V7

  • timestamp, timestamp_us and timestamp_cst removed (redundant timezone variants)
  • the _us and _cst timezone-variant copies of every earnings-date column removed (nearEarnDate, nextEarnDate1Adj, nextEarnDate2Adj, nextEarnDate1 through nextEarnDate8)