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.
uw_earnings2,225 rowsexportable| symboltext | report_date ↓date | report_timetext | ending_fiscal_quarterdate | date_sourcetext | expected_movenumeric | expected_move_percnumeric | street_mean_estnumeric | actual_eps |
|---|
| 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 |
|---|
| META | 2012-05-30 | premarket | 2012-03-31 | company | — | — | — | 0.06 | -0.09620808523973675964 | -0.09875000000000000000 | -0.06967741935483870968 | — | -0.02253814147018030513 | -0.03883495145631067961 | -0.10301664355062413315 | -0.04993065187239944521 | — | — | — | — | {"source":"company","actual_eps":"0.06","report_date":"2012-05-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":"-0.09620808523973675964","pre_earnings_move_1w":"-0.06967741935483870968","pre_earnings_move_2w":null,"pre_earnings_move_3d":"-0.09875000000000000000","ending_fiscal_quarter":"2012-03-31","post_earnings_move_1d":"-0.02253814147018030513","post_earnings_move_1w":"-0.10301664355062413315","post_earnings_move_2w":"-0.04993065187239944521","post_earnings_move_3d":"-0.03883495145631067961"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/META | {"ticker":"META"} | 2026-09-15 | 2026-09-15 08:45 |