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
active:endpoint = /api/earnings/PANW×
| 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 | 2014-09-09 | postmarket | 2014-07-31 | company | 0.29 | — | — | 0.02 | -0.00800000000000000000 | 0.02338376891334250344 | -0.00534759358288770053 | 0.04274702172389628591 | 0.10618279569892473118 | 0.11962365591397849462 | 0.10147849462365591398 | 0.09139784946236559140 | — | — | — | — | {"source":"company","actual_eps":"0.02","report_date":"2014-09-09","report_time":"postmarket","expected_move":"0.29","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.00800000000000000000","pre_earnings_move_1w":"-0.00534759358288770053","pre_earnings_move_2w":"0.04274702172389628591","pre_earnings_move_3d":"0.02338376891334250344","ending_fiscal_quarter":"2014-07-31","post_earnings_move_1d":"0.10618279569892473118","post_earnings_move_1w":"0.10147849462365591398","post_earnings_move_2w":"0.09139784946236559140","post_earnings_move_3d":"0.11962365591397849462"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |
| PANW | 2014-05-28 | postmarket | 2014-04-30 | company | 0.27 | — | — | 0.02 | -0.00086206896551724138 | 0.04320432043204320432 | 0.09442870632672332389 | 0.15668662674650698603 | 0.05263157894736842105 | 0.05953408110440034513 | 0.08369283865401207938 | 0.12424503882657463330 | — | — | — | — | {"source":"company","actual_eps":"0.02","report_date":"2014-05-28","report_time":"postmarket","expected_move":"0.27","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.00086206896551724138","pre_earnings_move_1w":"0.09442870632672332389","pre_earnings_move_2w":"0.15668662674650698603","pre_earnings_move_3d":"0.04320432043204320432","ending_fiscal_quarter":"2014-04-30","post_earnings_move_1d":"0.05263157894736842105","post_earnings_move_1w":"0.08369283865401207938","post_earnings_move_2w":"0.12424503882657463330","post_earnings_move_3d":"0.05953408110440034513"} | 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 |
| PANW | 2013-11-25 | postmarket | 2013-10-31 | company | — | — | — | 0.01 | 0.01721854304635761589 | 0.04774897680763983629 | 0.03643724696356275304 | 0.12445095168374816984 | 0.07421875000000000000 | 0.08203125000000000000 | 0.07421875000000000000 | 0.13281250000000000000 | — | — | — | — | {"source":"company","actual_eps":"0.01","report_date":"2013-11-25","report_time":"postmarket","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.01721854304635761589","pre_earnings_move_1w":"0.03643724696356275304","pre_earnings_move_2w":"0.12445095168374816984","pre_earnings_move_3d":"0.04774897680763983629","ending_fiscal_quarter":"2013-10-31","post_earnings_move_1d":"0.07421875000000000000","post_earnings_move_1w":"0.07421875000000000000","post_earnings_move_2w":"0.13281250000000000000","post_earnings_move_3d":"0.08203125000000000000"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |
| PANW | 2013-09-09 | postmarket | 2013-07-31 | company | — | — | — | 0.01 | 0.04551539491298527443 | 0.01825293350717079531 | -0.02375000000000000000 | -0.01637279596977329975 | 0.02304737516005121639 | 0.00896286811779769526 | 0.01280409731113956466 | 0.01280409731113956466 | — | — | — | — | {"source":"company","actual_eps":"0.01","report_date":"2013-09-09","report_time":"postmarket","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.04551539491298527443","pre_earnings_move_1w":"-0.02375000000000000000","pre_earnings_move_2w":"-0.01637279596977329975","pre_earnings_move_3d":"0.01825293350717079531","ending_fiscal_quarter":"2013-07-31","post_earnings_move_1d":"0.02304737516005121639","post_earnings_move_1w":"0.01280409731113956466","post_earnings_move_2w":"0.01280409731113956466","post_earnings_move_3d":"0.00896286811779769526"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |
| PANW | 2013-05-30 | postmarket | 2013-04-30 | company | 0.29 | — | — | 0.01 | -0.00657174151150054765 | 0.03894616265750286369 | 0.04372842347525891830 | 0.00554323725055432373 | -0.10804851157662624035 | -0.19073869900771775083 | -0.17309812568908489526 | -0.16868798235942668137 | — | — | — | — | {"source":"company","actual_eps":"0.01","report_date":"2013-05-30","report_time":"postmarket","expected_move":"0.29","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.00657174151150054765","pre_earnings_move_1w":"0.04372842347525891830","pre_earnings_move_2w":"0.00554323725055432373","pre_earnings_move_3d":"0.03894616265750286369","ending_fiscal_quarter":"2013-04-30","post_earnings_move_1d":"-0.10804851157662624035","post_earnings_move_1w":"-0.17309812568908489526","post_earnings_move_2w":"-0.16868798235942668137","post_earnings_move_3d":"-0.19073869900771775083"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |
| PANW | 2013-02-28 | postmarket | 2013-01-31 | company | 0.31 | — | — | 0.01 | 0.05595854922279792746 | 0.06813417190775681342 | 0.11978021978021978022 | 0.09687836383207750269 | -0.04219823356231599607 | -0.07065750736015701668 | -0.07752698724239450442 | -0.07458292443572129539 | — | — | — | — | {"source":"company","actual_eps":"0.01","report_date":"2013-02-28","report_time":"postmarket","expected_move":"0.31","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.05595854922279792746","pre_earnings_move_1w":"0.11978021978021978022","pre_earnings_move_2w":"0.09687836383207750269","pre_earnings_move_3d":"0.06813417190775681342","ending_fiscal_quarter":"2013-01-31","post_earnings_move_1d":"-0.04219823356231599607","post_earnings_move_1w":"-0.07752698724239450442","post_earnings_move_2w":"-0.07458292443572129539","post_earnings_move_3d":"-0.07065750736015701668"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |
| PANW | 2012-12-06 | postmarket | 2012-10-31 | company | 0.30 | — | — | 0.01 | -0.01497695852534562212 | -0.00696864111498257840 | -0.08163265306122448980 | -0.07467532467532467532 | 0.00000000000000000000 | -0.04678362573099415205 | -0.04561403508771929825 | 0.00935672514619883041 | — | — | — | — | {"source":"company","actual_eps":"0.01","report_date":"2012-12-06","report_time":"postmarket","expected_move":"0.30","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.01497695852534562212","pre_earnings_move_1w":"-0.08163265306122448980","pre_earnings_move_2w":"-0.07467532467532467532","pre_earnings_move_3d":"-0.00696864111498257840","ending_fiscal_quarter":"2012-10-31","post_earnings_move_1d":"0.00000000000000000000","post_earnings_move_1w":"-0.04561403508771929825","post_earnings_move_2w":"0.00935672514619883041","post_earnings_move_3d":"-0.04678362573099415205"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |
| PANW | 2012-09-10 | postmarket | 2012-07-31 | company | — | — | — | 0.01 | 0.01441899915182357930 | 0.02485004284490145673 | 0.11463187325256290774 | 0.12617702448210922787 | -0.07190635451505016722 | -0.05267558528428093645 | -0.05351170568561872910 | -0.09866220735785953177 | — | — | — | — | {"source":"company","actual_eps":"0.01","report_date":"2012-09-10","report_time":"postmarket","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.01441899915182357930","pre_earnings_move_1w":"0.11463187325256290774","pre_earnings_move_2w":"0.12617702448210922787","pre_earnings_move_3d":"0.02485004284490145673","ending_fiscal_quarter":"2012-07-31","post_earnings_move_1d":"-0.07190635451505016722","post_earnings_move_1w":"-0.05351170568561872910","post_earnings_move_2w":"-0.09866220735785953177","post_earnings_move_3d":"-0.05267558528428093645"} | 2026-09-15 08:45 | — | — | uw_earnings | /api/earnings/PANW | {"ticker":"PANW"} | 2026-09-15 | 2026-09-15 08:45 |