Earnings events (vintaged)
core.earnings_events
One row per change in what the vendor says about a report, not one per report. The current picture is superseded_at IS NULL (or core.earnings_current); two open dates for one ending_fiscal_quarter are a conflict the vendor has not resolved, and both are kept.
2,196 rowsCSV — whole table, not this view
Sources in this table
uw_earnings2,196 rowsexportable
| symboltext | report_date ↓date | report_timetext | ending_fiscal_quarterdate | date_sourcetext | expected_movenumeric | expected_move_percnumeric | street_mean_estnumeric | actual_epsnumeric | pre_earnings_move_1dnumeric | pre_earnings_move_3dnumeric | pre_earnings_move_1wnumeric | pre_earnings_move_2wnumeric | post_earnings_move_1dnumeric | post_earnings_move_3dnumeric | post_earnings_move_1wnumeric | post_earnings_move_2wnumeric | long_straddle_1dnumeric | long_straddle_1wnumeric | short_straddle_1dnumeric | short_straddle_1wnumeric | rawjsonb | vintage_tstimestamp with time zone | superseded_attimestamp with time zone | superseded_reasontext | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DELL | 2019-02-27 | premarket | 2019-02-01 | company | 0.87 | — | — | 0.94 | 0.00158770770756737243 | 0.02142428228296923253 | 0.03070436454264455000 | 0.05839564745576900997 | -0.00846135003674283515 | -0.00141022500612380586 | -0.02837946600412919481 | -0.03578402211568744095 | — | — | — | — | {"source":"company","actual_eps":"0.94","report_date":"2019-02-27","report_time":"premarket","expected_move":"0.87","street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":"0.00158770770756737243","pre_earnings_move_1w":"0.03070436454264455000","pre_earnings_move_2w":"0.05839564745576900997","pre_earnings_move_3d":"0.02142428228296923253","ending_fiscal_quarter":"2019-02-01","post_earnings_move_1d":"-0.00846135003674283515","post_earnings_move_1w":"-0.02837946600412919481","post_earnings_move_2w":"-0.03578402211568744095","post_earnings_move_3d":"-0.00141022500612380586"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2018-11-29 | premarket | 2018-11-02 | company | — | — | — | 0.79 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.79","report_date":"2018-11-29","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2018-11-02","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2018-09-06 | premarket | 2018-08-03 | company | — | — | — | 0.89 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.89","report_date":"2018-09-06","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2018-08-03","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2018-06-04 | premarket | 2018-05-04 | company | — | — | — | 0.78 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.78","report_date":"2018-06-04","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2018-05-04","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2018-03-08 | premarket | 2018-02-02 | company | — | — | — | 0.73 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.73","report_date":"2018-03-08","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2018-02-02","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2017-12-07 | premarket | 2017-11-03 | company | — | — | — | 0.73 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.73","report_date":"2017-12-07","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2017-11-03","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2017-09-07 | premarket | 2017-08-04 | company | — | — | — | 0.58 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.58","report_date":"2017-09-07","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2017-08-04","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2017-06-08 | premarket | 2017-05-05 | company | — | — | — | 0.38 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.38","report_date":"2017-06-08","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2017-05-05","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |
| DELL | 2017-03-30 | premarket | 2017-01-31 | company | — | — | — | -0.15 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"-0.15","report_date":"2017-03-30","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":null,"pre_earnings_move_1d":null,"pre_earnings_move_1w":null,"pre_earnings_move_2w":null,"pre_earnings_move_3d":null,"ending_fiscal_quarter":"2017-01-31","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/DELL | {"ticker":"DELL"} | 2026-09-15 | 2026-09-15 08:45 |