Dec 4, 2023
Megatechs go kaboom
Mega techs have smashed it this year. In fact, they performed so well that most of the performance of the S&P 500 year-to-date was delivered by just seven companies.
If you remove these companies from the S&P 500, the index would have effectively flatlined for a large part of the year.
Dataset
ID | Date | S&P 500 | S&P 493 | Magnificent 7 |
---|---|---|---|---|
1 | 03.01.2023 | 0 | 0 | 0 |
2 | 04.01.2023 | 0.753897058 | 0.883220275 | -0.909154163 |
3 | 05.01.2023 | -0.41943536 | 0.124187186 | -2.806994052 |
4 | 06.01.2023 | 1.855062512 | 1.898660923 | -0.424048375 |
5 | 09.01.2023 | 1.776875251 | 1.572562274 | 0.557404693 |
6 | 10.01.2023 | 2.487098017 | 2.097524985 | 1.579121634 |
7 | 11.01.2023 | 3.803998257 | 2.840180398 | 4.328926351 |
8 | 12.01.2023 | 4.158582943 | 3.081055997 | 4.920093134 |
9 | 13.01.2023 | 4.574890047 | 3.294144069 | 6.081126627 |
10 | 17.01.2023 | 4.362551654 | 2.957750993 | 6.330075908 |
11 | 18.01.2023 | 2.738399164 | 1.548189867 | 5.338105901 |
12 | 19.01.2023 | 1.953647282 | 0.863328319 | 4.881386393 |
13 | 20.01.2023 | 3.88244727 | 2.059862354 | 8.361126353 |
14 | 23.01.2023 | 5.116710463 | 2.816539186 | 10.47349205 |
15 | 24.01.2023 | 5.041919595 | 2.78440814 | 10.26117322 |
16 | 25.01.2023 | 5.022830846 | 2.887055662 | 9.624276077 |
17 | 26.01.2023 | 6.178906779 | 3.441547191 | 12.04432719 |
18 | 27.01.2023 | 6.443806266 | 3.264896405 | 13.71461152 |
19 | 30.01.2023 | 5.063364113 | 2.449097931 | 11.07806804 |
20 | 31.01.2023 | 6.6017513 | 3.590783288 | 12.87808318 |
21 | 01.02.2023 | 7.715985206 | 4.245584095 | 15.05099267 |
22 | 02.02.2023 | 9.299342677 | 4.56129058 | 21.61239147 |
23 | 03.02.2023 | 8.167590534 | 3.757684408 | 19.58839701 |
24 | 06.02.2023 | 7.503391445 | 3.300912599 | 18.26893572 |
25 | 07.02.2023 | 8.887229991 | 4.055829052 | 21.62152588 |
26 | 08.02.2023 | 7.680680596 | 3.294280082 | 18.94799409 |
27 | 09.02.2023 | 6.729882134 | 2.621590128 | 17.27779328 |
28 | 10.02.2023 | 6.964182165 | 3.064609255 | 16.46037744 |
29 | 13.02.2023 | 8.1887733 | 3.88141303 | 18.76519517 |
30 | 14.02.2023 | 8.158435596 | 3.654184921 | 19.34391215 |
31 | 15.02.2023 | 8.45837794 | 3.798081471 | 19.94358572 |
32 | 16.02.2023 | 6.962873405 | 2.821827383 | 17.62593197 |
33 | 17.02.2023 | 6.666863726 | 2.722132989 | 16.34322088 |
34 | 21.02.2023 | 4.529128122 | 1.183998608 | 13.68668084 |
35 | 22.02.2023 | 4.36464567 | 0.968831664 | 13.85187888 |
36 | 23.02.2023 | 4.920849683 | 1.206113141 | 15.76723846 |
37 | 24.02.2023 | 3.815240828 | 0.547221477 | 13.74609447 |
38 | 27.02.2023 | 4.134265537 | 0.659697066 | 14.41105083 |
39 | 28.02.2023 | 3.818113716 | 0.361701295 | 14.43318241 |
40 | 01.03.2023 | 3.327545633 | 0.154744138 | 13.09232541 |
41 | 02.03.2023 | 4.110995139 | 0.781487381 | 14.42267808 |
42 | 03.03.2023 | 5.792152124 | 1.825587991 | 17.52468421 |
43 | 06.03.2023 | 5.864848975 | 1.778122718 | 18.29393058 |
44 | 07.03.2023 | 4.242266998 | 0.432670729 | 17.12624047 |
45 | 08.03.2023 | 4.389748333 | 0.484136953 | 18.03338581 |
46 | 09.03.2023 | 2.46278061 | -1.049234041 | 16.3044376 |
47 | 10.03.2023 | 0.979310286 | -2.205112102 | 14.62318569 |
48 | 13.03.2023 | 0.826855661 | -2.65756878 | 15.97448695 |
49 | 14.03.2023 | 2.488145025 | -1.673311977 | 19.09963976 |
50 | 15.03.2023 | 1.772687218 | -2.636002936 | 20.4732842 |
51 | 16.03.2023 | 3.560019783 | -1.641077202 | 24.51350575 |
52 | 17.03.2023 | 2.418844566 | -2.75028529 | 24.43790279 |
53 | 20.03.2023 | 3.332257171 | -1.79934482 | 24.25337037 |
54 | 21.03.2023 | 4.673736569 | -0.938785975 | 26.20965866 |
55 | 22.03.2023 | 2.95046942 | -2.422583841 | 25.29665752 |
56 | 23.03.2023 | 3.257728055 | -2.446198758 | 27.11935955 |
57 | 24.03.2023 | 3.840081738 | -1.934718365 | 27.5246659 |
58 | 27.03.2023 | 4.011101608 | -1.459806746 | 25.88549287 |
59 | 28.03.2023 | 3.847404412 | -1.457893688 | 25.15485114 |
60 | 29.03.2023 | 5.325907831 | -0.444217182 | 27.47081434 |
61 | 30.03.2023 | 5.927873768 | -0.077839972 | 28.74612016 |
62 | 31.03.2023 | 7.457106017 | 0.969122214 | 30.85754241 |
63 | 03.04.2023 | 7.854573355 | 1.405158327 | 31.22345383 |
64 | 04.04.2023 | 7.229343404 | 0.795697085 | 31.15654606 |
65 | 05.04.2023 | 6.962088148 | 0.872509136 | 29.55915564 |
66 | 06.04.2023 | 7.344922907 | 0.859724773 | 31.62609565 |
67 | 10.04.2023 | 7.451870975 | 1.161600948 | 30.77512825 |
68 | 11.04.2023 | 7.447427574 | 1.471161584 | 29.07555456 |
69 | 12.04.2023 | 7.003144919 | 1.22581202 | 28.23684985 |
70 | 13.04.2023 | 8.422294459 | 1.94958098 | 31.51340042 |
71 | 14.04.2023 | 8.197928239 | 1.747696025 | 31.54270125 |
72 | 17.04.2023 | 8.555647566 | 2.113682208 | 31.46077081 |
73 | 18.04.2023 | 8.648486559 | 2.195883272 | 31.80504475 |
74 | 19.04.2023 | 8.639331621 | 2.113445629 | 32.38144108 |
75 | 20.04.2023 | 7.992650768 | 1.765216329 | 31.41768087 |
76 | 21.04.2023 | 8.09018853 | 1.834247908 | 31.46543681 |
77 | 24.04.2023 | 8.182235882 | 2.034129317 | 31.07951227 |
78 | 25.04.2023 | 6.471781817 | 0.831607965 | 28.51826576 |
79 | 26.04.2023 | 6.062803772 | -0.127206465 | 31.50622046 |
80 | 27.04.2023 | 8.138044471 | 0.966558712 | 36.38446495 |
81 | 28.04.2023 | 9.030529677 | 1.778402456 | 36.77444091 |
82 | 01.05.2023 | 8.988432282 | 1.779147278 | 37.02050555 |
83 | 02.05.2023 | 7.725663648 | 0.682255849 | 36.07140335 |
84 | 03.05.2023 | 6.971766591 | 0.04091582 | 35.40098812 |
85 | 04.05.2023 | 6.199566041 | -0.626356254 | 34.77766874 |
86 | 05.05.2023 | 8.161576621 | 0.619260111 | 38.16367982 |
87 | 08.05.2023 | 8.21047957 | 0.573321055 | 38.67251368 |
88 | 09.05.2023 | 7.714938197 | 0.252745176 | 37.80124696 |
89 | 10.05.2023 | 8.197928239 | 0.266762341 | 40.16579469 |
90 | 11.05.2023 | 8.014357038 | -0.116196484 | 40.96476238 |
91 | 12.05.2023 | 7.843337168 | -0.12189452 | 40.2630066 |
92 | 15.05.2023 | 8.162355493 | 0.140098481 | 40.84834493 |
93 | 16.05.2023 | 7.472530237 | -0.782930378 | 42.06923348 |
94 | 17.05.2023 | 8.750467722 | 0.144080529 | 43.79658149 |
95 | 18.05.2023 | 9.777621181 | 0.651352071 | 46.72799499 |
96 | 19.05.2023 | 9.618897274 | 0.557488196 | 46.17694219 |
97 | 22.05.2023 | 9.635892007 | 0.430085544 | 46.59018508 |
98 | 23.05.2023 | 8.405555094 | -0.401002074 | 44.59990966 |
99 | 24.05.2023 | 7.612178162 | -1.148428201 | 44.52436167 |
100 | 25.05.2023 | 8.554600558 | -1.26114259 | 51.5962374 |
101 | 26.05.2023 | 9.971138961 | -0.475899774 | 54.90270397 |
102 | 30.05.2023 | 9.972964841 | -0.67485588 | 56.06797649 |
103 | 31.05.2023 | 9.301181325 | -1.107252353 | 54.06639597 |
104 | 01.06.2023 | 10.37828474 | -0.542863487 | 57.1771154 |
105 | 02.06.2023 | 11.98256961 | 0.880036556 | 57.59519951 |
106 | 05.06.2023 | 11.75820339 | 0.624807554 | 57.42869424 |
107 | 06.06.2023 | 12.02127061 | 0.887896261 | 57.01021011 |
108 | 07.06.2023 | 11.59424444 | 1.11512268 | 52.86810095 |
109 | 08.06.2023 | 12.28486134 | 1.427766584 | 54.65162461 |
110 | 09.06.2023 | 12.41377104 | 1.435899857 | 54.89179528 |
111 | 12.06.2023 | 13.46159653 | 2.011247514 | 57.48347225 |
112 | 13.06.2023 | 14.24816791 | 2.591464186 | 58.75507639 |
113 | 14.06.2023 | 14.34178578 | 2.477894397 | 60.62569917 |
114 | 15.06.2023 | 15.73425576 | 3.47925386 | 62.72980783 |
115 | 16.06.2023 | 15.3093236 | 3.270764661 | 61.45319419 |
116 | 20.06.2023 | 14.76332154 | 2.625178422 | 61.96092253 |
117 | 21.06.2023 | 14.1613556 | 2.425328991 | 60.12752301 |
118 | 22.06.2023 | 14.58498538 | 2.324830683 | 62.7114911 |
119 | 23.06.2023 | 13.70740089 | 1.687113416 | 61.58679109 |
120 | 26.06.2023 | 13.19721417 | 1.819647565 | 58.17706701 |
121 | 27.06.2023 | 14.49398503 | 2.616428074 | 60.97355156 |
122 | 28.06.2023 | 14.45344538 | 2.459834482 | 61.04738357 |
123 | 29.06.2023 | 14.96545798 | 3.068943854 | 60.36929944 |
124 | 30.06.2023 | 16.3759697 | 3.935284094 | 63.65224193 |
125 | 03.07.2023 | 16.51220847 | 4.043781505 | 63.13234505 |
126 | 05.07.2023 | 16.28287534 | 3.732891976 | 63.57823444 |
127 | 06.07.2023 | 15.36162294 | 2.896592108 | 63.26685649 |
128 | 07.07.2023 | 15.0311003 | 2.677837536 | 62.93725489 |
129 | 10.07.2023 | 15.30775309 | 3.346410636 | 61.23444939 |
130 | 11.07.2023 | 16.0851823 | 4.027299066 | 62.01544968 |
131 | 12.07.2023 | 16.94551669 | 4.423274517 | 65.1849615 |
132 | 13.07.2023 | 17.93606316 | 4.801476348 | 69.05366103 |
133 | 14.07.2023 | 17.81524862 | 4.620553176 | 69.08347268 |
134 | 17.07.2023 | 18.26947147 | 4.83483535 | 70.57683992 |
135 | 18.07.2023 | 19.11122784 | 5.350465844 | 72.720209 |
136 | 19.07.2023 | 19.39208144 | 5.671013686 | 72.70909795 |
137 | 20.07.2023 | 18.58536153 | 5.703750054 | 68.61643659 |
138 | 21.07.2023 | 18.6237944 | 5.980509897 | 66.65326566 |
139 | 24.07.2023 | 19.10234104 | 6.309419064 | 66.9574958 |
140 | 25.07.2023 | 19.43757523 | 6.403835402 | 68.66729576 |
141 | 26.07.2023 | 19.41900998 | 6.42271443 | 68.48771665 |
142 | 27.07.2023 | 18.65178272 | 5.800140524 | 68.55951796 |
143 | 28.07.2023 | 19.82380638 | 6.315286655 | 72.2841973 |
144 | 31.07.2023 | 19.99979315 | 6.509049771 | 72.08366226 |
145 | 01.08.2023 | 19.67998319 | 6.328247092 | 71.61102028 |
146 | 02.08.2023 | 18.02366711 | 5.378037843 | 67.07903826 |
147 | 03.08.2023 | 17.7229459 | 5.082915742 | 66.97830762 |
148 | 04.08.2023 | 17.09900555 | 4.585600343 | 66.55612386 |
149 | 07.08.2023 | 18.15571784 | 5.497488549 | 67.92098406 |
150 | 08.08.2023 | 17.65730358 | 5.181045564 | 66.6960293 |
151 | 09.08.2023 | 16.82914554 | 4.832191225 | 63.52240458 |
152 | 10.08.2023 | 16.85843624 | 4.824310121 | 63.62243245 |
153 | 11.08.2023 | 16.73343366 | 4.904366239 | 62.05772683 |
154 | 14.08.2023 | 17.40470644 | 5.122898577 | 65.78002114 |
155 | 15.08.2023 | 16.04857531 | 4.067175439 | 64.4836081 |
156 | 16.08.2023 | 15.17178246 | 3.480749003 | 62.94791236 |
157 | 17.08.2023 | 14.28347252 | 2.873574015 | 61.57882392 |
158 | 18.08.2023 | 14.26647779 | 2.980628055 | 61.07873473 |
159 | 21.08.2023 | 15.05253843 | 3.114724086 | 65.38965241 |
160 | 22.08.2023 | 14.73298383 | 2.798491958 | 64.70492154 |
161 | 23.08.2023 | 16.00019587 | 3.517209304 | 68.14087546 |
162 | 24.08.2023 | 14.43906817 | 2.548352211 | 65.18087774 |
163 | 25.08.2023 | 15.20786594 | 3.142067009 | 65.24004613 |
164 | 28.08.2023 | 15.92959942 | 3.667386941 | 66.69409477 |
165 | 29.08.2023 | 17.61154166 | 4.631130773 | 70.71275068 |
166 | 30.08.2023 | 18.06236811 | 4.881121251 | 71.95075829 |
167 | 31.08.2023 | 17.87383001 | 4.605093598 | 72.48097651 |
168 | 01.09.2023 | 18.08590026 | 4.891151343 | 72.22080488 |
169 | 05.09.2023 | 17.59062703 | 4.19452685 | 72.89654725 |
170 | 06.09.2023 | 16.77083229 | 3.867675999 | 69.77351748 |
171 | 07.09.2023 | 16.39585009 | 3.739189629 | 68.21652085 |
172 | 08.09.2023 | 16.56190306 | 3.820348989 | 68.46923284 |
173 | 11.09.2023 | 17.34560155 | 4.130705548 | 69.95841604 |
174 | 12.09.2023 | 16.67721442 | 3.89633483 | 67.58407044 |
175 | 13.09.2023 | 16.82208462 | 3.823849765 | 68.88321734 |
176 | 14.09.2023 | 17.80688532 | 4.575451955 | 70.01050819 |
177 | 15.09.2023 | 16.37439919 | 3.65236022 | 66.35316606 |
178 | 18.09.2023 | 16.45833861 | 3.667064903 | 67.01678857 |
179 | 19.09.2023 | 16.20783549 | 3.447950141 | 66.57378765 |
180 | 20.09.2023 | 15.11608673 | 2.993328886 | 62.71737179 |
181 | 21.09.2023 | 13.22807537 | 1.602773991 | 59.72174128 |
182 | 22.09.2023 | 12.96814918 | 1.386550698 | 60.14607457 |
183 | 25.09.2023 | 13.42262739 | 1.623473574 | 61.38626577 |
184 | 26.09.2023 | 11.75139784 | 0.502767301 | 58.45773193 |
185 | 27.09.2023 | 11.777024 | 0.514443674 | 58.80158775 |
186 | 28.09.2023 | 12.43574545 | 0.961343177 | 60.02176797 |
187 | 29.09.2023 | 12.13109157 | 0.56970378 | 60.36724128 |
188 | 02.10.2023 | 12.13999114 | 0.042337474 | 63.65670375 |
189 | 03.10.2023 | 10.59873106 | -0.937927324 | 60.36788413 |
190 | 04.10.2023 | 11.49565967 | -0.532608676 | 62.59588313 |
191 | 05.10.2023 | 11.35026597 | -0.737479832 | 63.16265072 |
192 | 06.10.2023 | 12.66585745 | 0.037502466 | 66.54048888 |
193 | 09.10.2023 | 13.3760866 | 0.620886038 | 67.09795104 |
194 | 10.10.2023 | 13.96654821 | 1.162847039 | 67.51869071 |
195 | 11.10.2023 | 14.45580753 | 1.284075603 | 70.01104671 |
196 | 12.10.2023 | 13.74086685 | 0.631063032 | 69.79947356 |
197 | 13.10.2023 | 13.17001749 | 0.515954985 | 66.87487427 |
198 | 16.10.2023 | 14.36898246 | 1.398052236 | 68.82921245 |
199 | 17.10.2023 | 14.35774627 | 1.586138655 | 66.98637509 |
200 | 18.10.2023 | 12.825373 | 0.520476982 | 64.14067489 |
201 | 19.10.2023 | 11.86829248 | -0.255677935 | 63.90911236 |
202 | 20.10.2023 | 10.46039828 | -1.177913697 | 61.37880884 |
203 | 23.10.2023 | 10.27420956 | -1.633915475 | 63.47269353 |
204 | 24.10.2023 | 11.07543906 | -1.067908801 | 64.76058597 |
205 | 25.10.2023 | 9.48265851 | -1.993051527 | 60.23877558 |
206 | 26.10.2023 | 8.187202788 | -2.466359675 | 55.59654363 |
207 | 27.10.2023 | 7.667873897 | -3.377087495 | 57.74045899 |
208 | 30.10.2023 | 8.960967466 | -2.548767644 | 60.81996379 |
209 | 31.10.2023 | 9.666485079 | -1.871152588 | 60.67538911 |
210 | 01.11.2023 | 10.81864111 | -1.425289314 | 64.87239442 |
211 | 02.11.2023 | 12.90852078 | 0.226945604 | 67.04246786 |
212 | 03.11.2023 | 13.96915296 | 1.029111229 | 69.03876218 |
213 | 06.11.2023 | 14.16894003 | 0.925836349 | 71.00296902 |
214 | 07.11.2023 | 14.49319339 | 0.909460589 | 72.89187911 |
215 | 08.11.2023 | 14.60824939 | 0.867299488 | 74.04092479 |
216 | 09.11.2023 | 13.68177472 | 0.157471196 | 73.6342245 |
217 | 10.11.2023 | 15.45707946 | 1.256997788 | 77.758247 |
218 | 13.11.2023 | 15.36057594 | 1.232295903 | 77.23688247 |
219 | 14.11.2023 | 17.56108096 | 2.912678377 | 80.10787239 |
220 | 15.11.2023 | 17.74882743 | 3.154238378 | 79.27096237 |
221 | 16.11.2023 | 17.88899886 | 3.049321373 | 81.24278488 |
222 | 17.11.2023 | 18.04013834 | 3.321437714 | 80.64436175 |
223 | 20.11.2023 | 18.91248779 | 3.802906219 | 83.30702094 |
224 | 21.11.2023 | 18.67217385 | 3.722168601 | 82.10498678 |
225 | 22.11.2023 | 19.15411688 | 4.07165134 | 82.79758519 |
Data sources
I had to reconstruct the index using S&P methodology. Stock data and fundamental data was download using a python script linked to an API service. There is no web link for it.
15
0
291