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,341 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 |
|---|
| TSM | 2025-01-16 | unknown | 2024-12-31 | company | 3.19 | — | 2.16 | 2.24 | 0.03863636363636363636 | 0.06669646404449741756 | 0.03703167246040942449 | 0.06553229487052286933 | -0.01531728665207877462 | 0.03915452302248708040 | 0.04576563154709250896 | -0.03091391591787327157 | — | — | — | — | {"source":"company","actual_eps":"2.24","report_date":"2025-01-16","report_time":"unknown","expected_move":"3.19","street_mean_est":"2.16","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.03863636363636363636","pre_earnings_move_1w":"0.03703167246040942449","pre_earnings_move_2w":"0.06553229487052286933","pre_earnings_move_3d":"0.06669646404449741756","ending_fiscal_quarter":"2024-12-31","post_earnings_move_1d":"-0.01531728665207877462","post_earnings_move_1w":"0.04576563154709250896","post_earnings_move_2w":"-0.03091391591787327157","post_earnings_move_3d":"0.03915452302248708040"} | 2026-10-01 06:30 | — | — | uw_earnings | /api/earnings/TSM | {"ticker":"TSM"} | 2026-10-01 | 2026-10-01 06:30 |