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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PANW | 2020-11-16 | premarket | 2020-10-31 | company | — | — | — | -0.16 | 0.02691116932603000714 | 0.06600741656365883807 | 0.03479721622270218383 | 0.16951451044209384323 | 0.07653061224489795918 | 0.08673469387755102041 | 0.12871057513914656772 | 0.14146567717996289425 | — | — | — | — | {"source":"company","actual_eps":"-0.16","report_date":"2020-11-16","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.02691116932603000714","pre_earnings_move_1w":"0.03479721622270218383","pre_earnings_move_2w":"0.16951451044209384323","pre_earnings_move_3d":"0.06600741656365883807","ending_fiscal_quarter":"2020-10-31","post_earnings_move_1d":"0.07653061224489795918","post_earnings_move_1w":"0.12871057513914656772","post_earnings_move_2w":"0.14146567717996289425","post_earnings_move_3d":"0.08673469387755102041"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |
| PANW | 2014-02-24 | premarket | 2014-01-31 | company | 0.03 | — | — | 0.02 | 0.00656275635767022149 | -0.00081433224755700326 | 0.01154163231657048640 | 0.11952554744525547445 | 0.04319478402607986960 | 0.03341483292583537082 | -0.03341483292583537082 | 0.04726976365118174409 | — | — | — | — | {"source":"company","actual_eps":"0.02","report_date":"2014-02-24","report_time":"premarket","expected_move":"0.03","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.00656275635767022149","pre_earnings_move_1w":"0.01154163231657048640","pre_earnings_move_2w":"0.11952554744525547445","pre_earnings_move_3d":"-0.00081433224755700326","ending_fiscal_quarter":"2014-01-31","post_earnings_move_1d":"0.04319478402607986960","post_earnings_move_1w":"-0.03341483292583537082","post_earnings_move_2w":"0.04726976365118174409","post_earnings_move_3d":"0.03341483292583537082"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |