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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SPCX | 2026-11-03 | unknown | 2026-09-30 | estimation | — | — | 0.09 | — | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"estimation","actual_eps":null,"report_date":"2026-11-03","report_time":"unknown","expected_move":null,"street_mean_est":"0.09","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-09-30","post_earnings_move_1d":null,"post_earnings_move_1w":null,"post_earnings_move_2w":null,"post_earnings_move_3d":null} | 2026-09-18 06:30 | — | — | uw_earnings | /api/earnings/SPCX | {"ticker":"SPCX"} | 2026-09-18 | 2026-09-18 06:30 |
| SPCX | 2026-11-03 | unknown | 2026-09-30 | estimation | — | — | 0.10 | — | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"estimation","actual_eps":null,"report_date":"2026-11-03","report_time":"unknown","expected_move":null,"street_mean_est":"0.10","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-09-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/SPCX | {"ticker":"SPCX"} | 2026-09-17 | 2026-09-17 06:30 |
| SPCX | 2026-11-03 | unknown | 2026-09-30 | estimation | — | — | 0.09 | — | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"estimation","actual_eps":null,"report_date":"2026-11-03","report_time":"unknown","expected_move":null,"street_mean_est":"0.09","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-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 | 2026-09-17 06:30 | changed | uw_earnings | /api/earnings/SPCX | {"ticker":"SPCX"} | 2026-09-15 | 2026-09-15 08:45 |