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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MSFT | 1996-04-18 | premarket | 1996-03-31 | company | — | — | — | 0.00 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.00","report_date":"1996-04-18","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":"1996-03-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/MSFT | {"ticker":"MSFT"} | 2026-09-15 | 2026-09-15 08:45 |
| MSFT | 1996-07-22 | premarket | 1996-06-30 | company | — | — | — | 0.00 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.00","report_date":"1996-07-22","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":"1996-06-30","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/MSFT | {"ticker":"MSFT"} | 2026-09-15 | 2026-09-15 08:45 |
| MSFT | 1996-10-21 | premarket | 1996-09-30 | company | — | — | — | 0.00 | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":"0.00","report_date":"1996-10-21","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":"1996-09-30","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/MSFT | {"ticker":"MSFT"} | 2026-09-15 | 2026-09-15 08:45 |
| MSFT | 2009-10-23 | premarket | 2009-09-30 | company | 1.57 | — | — | 0.40 | 0.00037622272385252069 | 0.00872534142640364188 | -0.00449269936353425683 | 0.03583950136345929100 | 0.05377961639714178263 | 0.07521624670928920647 | 0.06130124106807070327 | 0.07070327190673185408 | — | — | — | — | {"source":"company","actual_eps":"0.40","report_date":"2009-10-23","report_time":"premarket","expected_move":"1.57","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.00037622272385252069","pre_earnings_move_1w":"-0.00449269936353425683","pre_earnings_move_2w":"0.03583950136345929100","pre_earnings_move_3d":"0.00872534142640364188","ending_fiscal_quarter":"2009-09-30","post_earnings_move_1d":"0.05377961639714178263","post_earnings_move_1w":"0.06130124106807070327","post_earnings_move_2w":"0.07070327190673185408","post_earnings_move_3d":"0.07521624670928920647"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/MSFT | {"ticker":"MSFT"} | 2026-09-15 | 2026-09-15 08:45 |
| MSFT | 2021-07-27 | premarket | 2021-06-30 | company | — | — | — | 2.18 | -0.00214036662408948113 | 0.02718550106609808102 | 0.04346413486877730046 | 0.04229770662051060147 | -0.00868361875108112783 | -0.00882200311364815776 | -0.01463414634146341463 | -0.00249091852620653866 | -0.10695187165775401070 | -0.47102803738317757009 | -0.02197802197802197802 | 0.35885167464114832536 | {"source":"company","actual_eps":"2.18","report_date":"2021-07-27","report_time":"premarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":"-0.10695187165775401070","long_straddle_1w":"-0.47102803738317757009","short_straddle_1d":"-0.02197802197802197802","short_straddle_1w":"0.35885167464114832536","expected_move_perc":null,"pre_earnings_move_1d":"-0.00214036662408948113","pre_earnings_move_1w":"0.04346413486877730046","pre_earnings_move_2w":"0.04229770662051060147","pre_earnings_move_3d":"0.02718550106609808102","ending_fiscal_quarter":"2021-06-30","post_earnings_move_1d":"-0.00868361875108112783","post_earnings_move_1w":"-0.01463414634146341463","post_earnings_move_2w":"-0.00249091852620653866","post_earnings_move_3d":"-0.00882200311364815776"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/MSFT | {"ticker":"MSFT"} | 2026-09-15 | 2026-09-15 08:45 |