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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORCL | 2026-09-10 | postmarket | 2026-08-31 | company | 15.96 | 0.104363 | 1.74 | 1.63 | -0.05376477139144960713 | -0.03678045093840534072 | -0.00714100233705531031 | 0.00658154534684743978 | -0.01739244148031907938 | -0.08231986399895383811 | — | — | -0.89894736842105263158 | — | 0.86809651474530831099 | — | {"source":"company","actual_eps":"1.63","report_date":"2026-09-10","report_time":"postmarket","expected_move":"15.96","street_mean_est":"1.74","long_straddle_1d":"-0.89894736842105263158","long_straddle_1w":null,"short_straddle_1d":"0.86809651474530831099","short_straddle_1w":null,"expected_move_perc":"0.104363","pre_earnings_move_1d":"-0.05376477139144960713","pre_earnings_move_1w":"-0.00714100233705531031","pre_earnings_move_2w":"0.00658154534684743978","pre_earnings_move_3d":"-0.03678045093840534072","ending_fiscal_quarter":"2026-08-31","post_earnings_move_1d":"-0.01739244148031907938","post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":"-0.08231986399895383811"} | 2026-09-16 06:30 | 2026-09-18 06:30 | changed | uw_earnings | /api/earnings/ORCL | {"ticker":"ORCL"} | 2026-09-16 | 2026-09-16 06:30 |
| ORCL | 2026-09-10 | postmarket | 2026-08-31 | company | 15.96 | 0.104363 | 1.74 | 1.63 | -0.05376477139144960713 | -0.03678045093840534072 | -0.00714100233705531031 | 0.00658154534684743978 | -0.01739244148031907938 | — | — | — | -0.89894736842105263158 | — | 0.86809651474530831099 | — | {"source":"company","actual_eps":"1.63","report_date":"2026-09-10","report_time":"postmarket","expected_move":"15.96","street_mean_est":"1.74","long_straddle_1d":"-0.89894736842105263158","long_straddle_1w":null,"short_straddle_1d":"0.86809651474530831099","short_straddle_1w":null,"expected_move_perc":"0.104363","pre_earnings_move_1d":"-0.05376477139144960713","pre_earnings_move_1w":"-0.00714100233705531031","pre_earnings_move_2w":"0.00658154534684743978","pre_earnings_move_3d":"-0.03678045093840534072","ending_fiscal_quarter":"2026-08-31","post_earnings_move_1d":"-0.01739244148031907938","post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-15 08:45 | 2026-09-16 06:30 | changed | uw_earnings | /api/earnings/ORCL | {"ticker":"ORCL"} | 2026-09-15 | 2026-09-15 08:45 |
| ORCL | 2026-12-09 | unknown | 2026-11-30 | estimation | — | — | 1.90 | — | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"estimation","actual_eps":null,"report_date":"2026-12-09","report_time":"unknown","expected_move":null,"street_mean_est":"1.90","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":"2026-11-30","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-17 06:30 | 2026-09-18 06:30 | changed | uw_earnings | /api/earnings/ORCL | {"ticker":"ORCL"} | 2026-09-17 | 2026-09-17 06:30 |
| ORCL | 2026-12-09 | unknown | 2026-11-30 | estimation | — | — | 1.92 | — | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"estimation","actual_eps":null,"report_date":"2026-12-09","report_time":"unknown","expected_move":null,"street_mean_est":"1.92","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":"2026-11-30","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-16 06:30 | 2026-09-17 06:30 | changed | uw_earnings | /api/earnings/ORCL | {"ticker":"ORCL"} | 2026-09-16 | 2026-09-16 06:30 |
| ORCL | 2026-12-09 | unknown | 2026-11-30 | estimation | — | — | 1.91 | — | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"estimation","actual_eps":null,"report_date":"2026-12-09","report_time":"unknown","expected_move":null,"street_mean_est":"1.91","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":"2026-11-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 | 2026-09-16 06:30 | changed | uw_earnings | /api/earnings/ORCL | {"ticker":"ORCL"} | 2026-09-15 | 2026-09-15 08:45 |