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,341 rowsCSV — whole table, not this view

Sources in this table

uw_earnings2,341 rowsexportable

report_dateto

column equals (exact text)

sort

chart against report_date

reset

active:endpoint = /api/earnings/TSM×report_time = postmarket×

symboltext	report_date ↓date	report_timetext	ending_fiscal_quarterdate	date_sourcetext	expected_movenumeric	expected_move_percnumeric	street_mean_estnumeric

TSM	2024-07-18	postmarket	2024-06-30	company	3.95	0.022973	1.37	1.48	0.00391355140186915888	-0.07207644962747003563	-0.06845528455284552846	-0.05819496958737465067	-0.03549194158375516379	-0.01192761971257345668	-0.06743468900913481119	-0.07965322627567347414	0.11561866125760649087	0.04413145539906103286	-0.59606986899563318777	-0.27692307692307692308	{"source":"company","actual_eps":"1.48","report_date":"2024-07-18","report_time":"postmarket","expected_move":"3.95","street_mean_est":"1.37","long_straddle_1d":"0.11561866125760649087","long_straddle_1w":"0.04413145539906103286","short_straddle_1d":"-0.59606986899563318777","short_straddle_1w":"-0.27692307692307692308","expected_move_perc":"0.022973","pre_earnings_move_1d":"0.00391355140186915888","pre_earnings_move_1w":"-0.06845528455284552846","pre_earnings_move_2w":"-0.05819496958737465067","pre_earnings_move_3d":"-0.07207644962747003563","ending_fiscal_quarter":"2024-06-30","post_earnings_move_1d":"-0.03549194158375516379","post_earnings_move_1w":"-0.06743468900913481119","post_earnings_move_2w":"-0.07965322627567347414","post_earnings_move_3d":"-0.01192761971257345668"}	2026-10-01 06:30	—	—	uw_earnings	/api/earnings/TSM	{"ticker":"TSM"}	2026-10-01	2026-10-01 06:30
TSM	2024-04-18	postmarket	2024-03-31	company	2.28	0.017236	1.29	1.38	-0.04862259943897000647	-0.05615812758669901527	-0.10142663043478260870	-0.05291422024917657167	-0.03455054056097376578	0.00876994027368261889	0.03258486429273455810	0.02993876162395100930	0.43636363636363636364	-0.18257956448911222781	-0.74045801526717557252	0.06357388316151202749	{"source":"company","actual_eps":"1.38","report_date":"2024-04-18","report_time":"postmarket","expected_move":"2.28","street_mean_est":"1.29","long_straddle_1d":"0.43636363636363636364","long_straddle_1w":"-0.18257956448911222781","short_straddle_1d":"-0.74045801526717557252","short_straddle_1w":"0.06357388316151202749","expected_move_perc":"0.017236","pre_earnings_move_1d":"-0.04862259943897000647","pre_earnings_move_1w":"-0.10142663043478260870","pre_earnings_move_2w":"-0.05291422024917657167","pre_earnings_move_3d":"-0.05615812758669901527","ending_fiscal_quarter":"2024-03-31","post_earnings_move_1d":"-0.03455054056097376578","post_earnings_move_1w":"0.03258486429273455810","post_earnings_move_2w":"0.02993876162395100930","post_earnings_move_3d":"0.00876994027368261889"}
TSM	2023-10-19	postmarket	2023-09-30	company	1.26	0.013586	1.16	1.29	0.03694196428571428571	0.01852663889497917123	0.00530188270937026618	0.06756290934160634264	-0.01722096652674631364	-0.01366914218060488645	-0.05876654827252179529	-0.02615434291249596384	0.07534246575342465753	0.61583577712609970674	-0.30827067669172932331	-0.76635514018691588785	{"source":"company","actual_eps":"1.29","report_date":"2023-10-19","report_time":"postmarket","expected_move":"1.26","street_mean_est":"1.16","long_straddle_1d":"0.07534246575342465753","long_straddle_1w":"0.61583577712609970674","short_straddle_1d":"-0.30827067669172932331","short_straddle_1w":"-0.76635514018691588785","expected_move_perc":"0.013586","pre_earnings_move_1d":"0.03694196428571428571","pre_earnings_move_1w":"0.00530188270937026618","pre_earnings_move_2w":"0.06756290934160634264","pre_earnings_move_3d":"0.01852663889497917123","ending_fiscal_quarter":"2023-09-30","post_earnings_move_1d":"-0.01722096652674631364","post_earnings_move_1w":"-0.05876654827252179529","post_earnings_move_2w":"-0.02615434291249596384","post_earnings_move_3d":"-0.01366914218060488645"}
TSM	2022-01-28	postmarket	2021-12-31	company	—	—	—	1.15	0.01326785560437666925	-0.03952633728052266231	-0.05625100304926978013	-0.16422683342808413872	0.04302355241901198878	0.05518238245047189865	0.02865402601819573166	0.02856899923475894907	-0.02816901408450704225	-0.48767605633802816901	-0.23935091277890466531	0.36511156186612576065	{"source":"company","actual_eps":"1.15","report_date":"2022-01-28","report_time":"postmarket","expected_move":null,"street_mean_est":null,"long_straddle_1d":"-0.02816901408450704225","long_straddle_1w":"-0.48767605633802816901","short_straddle_1d":"-0.23935091277890466531","short_straddle_1w":"0.36511156186612576065","expected_move_perc":null,"pre_earnings_move_1d":"0.01326785560437666925","pre_earnings_move_1w":"-0.05625100304926978013","pre_earnings_move_2w":"-0.16422683342808413872","pre_earnings_move_3d":"-0.03952633728052266231","ending_fiscal_quarter":"2021-12-31","post_earnings_move_1d":"0.04302355241901198878","post_earnings_move_1w":"0.02865402601819573166","post_earnings_move_2w":"0.02856899923475894907","post_earnings_move_3d":"0.05518238245047189865"}
TSM	2021-01-14	postmarket	2020-12-31	company	—	—	—	1.08	0.06055522938880643561	0.03140293637853879443	0.04134069010970753202	0.15966617755014291735	-0.00964808224573781453	0.03313562672977596331	0.06097271648863599149	-0.00490312376442157004	—	—	—	—	{"source":"company","actual_eps":"1.08","report_date":"2021-01-14","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.06055522938880643561","pre_earnings_move_1w":"0.04134069010970753202","pre_earnings_move_2w":"0.15966617755014291735","pre_earnings_move_3d":"0.03140293637853879443","ending_fiscal_quarter":"2020-12-31","post_earnings_move_1d":"-0.00964808224573781453","post_earnings_move_1w":"0.06097271648863599149","post_earnings_move_2w":"-0.00490312376442157004","post_earnings_move_3d":"0.03313562672977596331"}
TSM	2020-07-16	postmarket	2020-06-30	company	—	—	—	0.78	0.00802300938521963523	0.02335945904454527307	0.02794072244627889172	0.13596042306345632848	-0.00285328127453041892	0.01832106922980108790	0.01171347049134381085	0.20033037993708503108	—	—	—	—	{"source":"company","actual_eps":"0.78","report_date":"2020-07-16","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.00802300938521963523","pre_earnings_move_1w":"0.02794072244627889172","pre_earnings_move_2w":"0.13596042306345632848","pre_earnings_move_3d":"0.02335945904454527307","ending_fiscal_quarter":"2020-06-30","post_earnings_move_1d":"-0.00285328127453041892","post_earnings_move_1w":"0.01171347049134381085","post_earnings_move_2w":"0.20033037993708503108","post_earnings_move_3d":"0.01832106922980108790"}
TSM	2020-04-15	postmarket	2020-03-31	company	—	—	—	0.75	-0.01915860162016991378	—	-0.01213447384177943289	0.06772737045673532575	0.05517519130267481071	0.05900120821779181126	0.06625050342526661164	0.09706000805648681004	—	—	—	—	{"source":"company","actual_eps":"0.75","report_date":"2020-04-15","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.01915860162016991378","pre_earnings_move_1w":"-0.01213447384177943289","pre_earnings_move_2w":"0.06772737045673532575","pre_earnings_move_3d":null,"ending_fiscal_quarter":"2020-03-31","post_earnings_move_1d":"0.05517519130267481071","post_earnings_move_1w":"0.06625050342526661164","post_earnings_move_2w":"0.09706000805648681004","post_earnings_move_3d":"0.05900120821779181126"}
TSM	2016-04-11	postmarket	2016-03-31	company	—	—	—	0.38	0.00909810126685526475	-0.00429352068403962081	-0.01315280464028189968	-0.00468201326474003480	0.00235201881319576661	-0.00823206585852571912	-0.00039200313800073497	-0.01960015680131246038	—	—	—	—	{"source":"company","actual_eps":"0.38","report_date":"2016-04-11","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.00909810126685526475","pre_earnings_move_1w":"-0.01315280464028189968","pre_earnings_move_2w":"-0.00468201326474003480","pre_earnings_move_3d":"-0.00429352068403962081","ending_fiscal_quarter":"2016-03-31","post_earnings_move_1d":"0.00235201881319576661","post_earnings_move_1w":"-0.00039200313800073497","post_earnings_move_2w":"-0.01960015680131246038","post_earnings_move_3d":"-0.00823206585852571912"}