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,353 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 |
|---|
| TSM | 2026-10-15 | premarket | 2026-09-30 | company | 23.40 | 0.05128937504110129551 | 4.45 | — | — | — | — | — | — | — | — | — | — | — | — | — | {"source":"company","actual_eps":null,"report_date":"2026-10-15","report_time":"premarket","expected_move":"23.40","street_mean_est":"4.45","long_straddle_1d":null,"long_straddle_1w":null,"short_straddle_1d":null,"short_straddle_1w":null,"expected_move_perc":"0.05128937504110129551","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-10-01 06:30 | 2026-10-02 06:30 | changed | uw_earnings | /api/earnings/TSM | {"ticker":"TSM"} | 2026-10-01 | 2026-10-01 06:30 |