\n", " | Logo | \n", "Company | \n", "Prime Standard industry group | \n", "Ticker symbol | \n", "Index weighting (%)1 | \n", "Employees | \n", "
---|---|---|---|---|---|---|
0 | \n", "Adidas Logo.svg | \n", "Adidas | \n", "Clothing | \n", "ADS | \n", "2.04 | \n", "86,824 | \n", "
1 | \n", "NaN | \n", "Allianz | \n", "Insurance | \n", "ALV | \n", "6.66 | \n", "151,340 | \n", "
2 | \n", "BASF-Logo bw.svg | \n", "BASF | \n", "Chemicals | \n", "BAS | \n", "9.62 | \n", "111,141 | \n", "
3 | \n", "Bayer Logo.svg | \n", "Bayer | \n", "Pharmaceuticals and Chemicals | \n", "BAYN | \n", "7.55 | \n", "111,800 | \n", "
4 | \n", "Beiersdorf.svg | \n", "Beiersdorf | \n", "Consumer goods | \n", "BEI | \n", "0.86 | \n", "19,130 | \n", "
5 | \n", "BMW.svg | \n", "BMW | \n", "Manufacturing | \n", "BMW | \n", "3.26 | \n", "102,007 | \n", "
6 | \n", "NaN | \n", "Commerzbank | \n", "Banking | \n", "CBK | \n", "1.01 | \n", "56,221 | \n", "
7 | \n", "NaN | \n", "Continental | \n", "Manufacturing | \n", "CON | \n", "0.79 | \n", "170,000 | \n", "
8 | \n", "Daimler AG.svg | \n", "Daimler | \n", "Manufacturing | \n", "DAI | \n", "5.77 | \n", "267,274 | \n", "
9 | \n", "Deutsche Bank logo without wordmark.svg | \n", "Deutsche Bank | \n", "Banking | \n", "DBK | \n", "5.05 | \n", "100,474 | \n", "
10 | \n", "NaN | \n", "Deutsche Boerse | \n", "Securities | \n", "DB1 | \n", "1.47 | \n", "3,588 | \n", "
11 | \n", "NaN | \n", "Deutsche Lufthansa | \n", "Transport Aviation | \n", "LHA | \n", "0.83 | \n", "118,088 | \n", "
12 | \n", "Deutsche Post DHL.svg | \n", "Deutsche Post | \n", "Communications | \n", "DPW | \n", "1.90 | \n", "424,351 | \n", "
13 | \n", "Deutsche Telekom.svg | \n", "Deutsche Telekom | \n", "Communications | \n", "DTE | \n", "5.38 | \n", "235,132 | \n", "
14 | \n", "Logo E.ON.svg | \n", "E.ON | \n", "Energy | \n", "EOAN | \n", "6.24 | \n", "85,105 | \n", "
15 | \n", "Fresenius.svg | \n", "Fresenius | \n", "Medical | \n", "FRE | \n", "1.63 | \n", "149,351 | \n", "
16 | \n", "NaN | \n", "Fresenius Medical Care | \n", "Medical | \n", "FME | \n", "2.16 | \n", "73,450 | \n", "
17 | \n", "HeidelbergCement.svg | \n", "HeidelbergCement | \n", "Building | \n", "HEI | \n", "0.86 | \n", "53,440 | \n", "
18 | \n", "Henkel-Logo.svg | \n", "Henkel | \n", "Consumer goods | \n", "HEN3 | \n", "1.53 | \n", "47,753 | \n", "
19 | \n", "NaN | \n", "Infineon Technologies | \n", "Manufacturing | \n", "IFX | \n", "1.27 | \n", "26,658 | \n", "
20 | \n", "NaN | \n", "K+S | \n", "Chemicals | \n", "SDF | \n", "1.18 | \n", "15,170 | \n", "
21 | \n", "LanXess-Logo.svg | \n", "Lanxess | \n", "Chemicals | \n", "LXS | \n", "0.73 | \n", "14,650 | \n", "
22 | \n", "NaN | \n", "Linde | \n", "Industrial gases | \n", "LIN | \n", "3.81 | \n", "62,000 | \n", "
23 | \n", "NaN | \n", "Merck | \n", "Pharmaceuticals | \n", "MRK | \n", "0.97 | \n", "40,676 | \n", "
24 | \n", "NaN | \n", "Munich Re | \n", "Insurance | \n", "MUV2 | \n", "2.92 | \n", "46,915 | \n", "
25 | \n", "RWE AG.svg | \n", "RWE | \n", "Energy | \n", "RWE | \n", "2.19 | \n", "70,860 | \n", "
26 | \n", "SAP 2011 logo.svg | \n", "SAP | \n", "IT | \n", "SAP | \n", "7.70 | \n", "61,344 | \n", "
27 | \n", "Siemens AG logo.svg | \n", "Siemens | \n", "Industrial, electronics | \n", "SIE | \n", "9.96 | \n", "405,000 | \n", "
28 | \n", "ThyssenKruppLogo.jpg | \n", "ThyssenKrupp | \n", "Industrial, manufacturing | \n", "TKA | \n", "1.33 | \n", "180,050 | \n", "
29 | \n", "Volkswagen Group.svg | \n", "Volkswagen Group | \n", "Manufacturing | \n", "VOW3 | \n", "3.36 | \n", "549,763 | \n", "
\n", " | ADS.DE | \n", "ALV.DE | \n", "BAS.DE | \n", "BAYN.DE | \n", "BEI.DE | \n", "BMW.DE | \n", "CBK.DE | \n", "CON.DE | \n", "DAI.DE | \n", "DPW.DE | \n", "... | \n", "LIN.DE | \n", "LXS.DE | \n", "MRK.DE | \n", "MUV2.DE | \n", "RWE.DE | \n", "SAP.DE | \n", "SDF.DE | \n", "SIE.DE | \n", "TKA.DE | \n", "VOW3.DE | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Date | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2008-01-01 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2008-01-02 | \n", "-0.024964 | \n", "-0.013828 | \n", "-0.004819 | \n", "-0.017357 | \n", "-0.011592 | \n", "0.008921 | \n", "-0.014174 | \n", "-0.027002 | \n", "-0.027774 | \n", "-0.012551 | \n", "... | \n", "-0.002602 | \n", "NaN | \n", "-0.009738 | \n", "-0.001339 | \n", "NaN | \n", "-0.018394 | \n", "0.027944 | \n", "-0.014572 | \n", "0.000651 | \n", "NaN | \n", "
2008-03-24 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2008-03-25 | \n", "0.059161 | \n", "0.063979 | \n", "0.021526 | \n", "0.042070 | \n", "0.005485 | \n", "0.034733 | \n", "0.085254 | \n", "0.051949 | \n", "0.033861 | \n", "0.017208 | \n", "... | \n", "0.016638 | \n", "NaN | \n", "0.023906 | \n", "0.037229 | \n", "NaN | \n", "0.043075 | \n", "0.086051 | \n", "0.006614 | \n", "0.008448 | \n", "NaN | \n", "
2008-07-30 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-07-31 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-04 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-05 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-06 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-07 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-08 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-11 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-12 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-13 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-14 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-15 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-08-18 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
2008-12-25 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2008-12-26 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2008-12-29 | \n", "0.008490 | \n", "0.015703 | \n", "0.032535 | \n", "0.028312 | \n", "0.016954 | \n", "0.002039 | \n", "0.028874 | \n", "-0.017362 | \n", "0.028456 | \n", "0.024853 | \n", "... | \n", "0.000735 | \n", "0.040478 | \n", "0.036978 | \n", "0.003407 | \n", "0.024533 | \n", "0.004405 | \n", "0.049660 | \n", "0.016151 | \n", "0.017072 | \n", "NaN | \n", "
2008-12-30 | \n", "0.028965 | \n", "0.008009 | \n", "0.031973 | \n", "0.028596 | \n", "0.006284 | \n", "0.014156 | \n", "0.021310 | \n", "-0.014465 | \n", "0.040993 | \n", "0.040779 | \n", "... | \n", "-0.000735 | \n", "0.055458 | \n", "0.015596 | \n", "0.023986 | \n", "0.016446 | \n", "0.041753 | \n", "0.027268 | \n", "0.019653 | \n", "0.025074 | \n", "NaN | \n", "
2008-12-31 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2009-01-01 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2009-01-02 | \n", "0.024340 | \n", "0.028185 | \n", "0.005998 | \n", "0.030385 | \n", "0.006245 | \n", "0.033567 | \n", "0.018650 | \n", "0.052944 | \n", "0.038501 | \n", "-0.020705 | \n", "... | \n", "0.056607 | \n", "0.027758 | \n", "0.021146 | \n", "0.013646 | \n", "0.036144 | \n", "0.026624 | \n", "0.032468 | \n", "0.052301 | \n", "0.053766 | \n", "NaN | \n", "
2009-01-05 | \n", "0.002668 | \n", "-0.002751 | \n", "-0.011101 | \n", "0.000258 | \n", "0.030654 | \n", "-0.022087 | \n", "-0.031534 | \n", "0.001684 | \n", "-0.040328 | \n", "-0.013692 | \n", "... | \n", "0.010363 | \n", "0.012845 | \n", "0.011478 | \n", "-0.014104 | \n", "0.031566 | \n", "0.013861 | \n", "0.020986 | \n", "-0.010738 | \n", "-0.002410 | \n", "NaN | \n", "
2009-01-06 | \n", "0.046122 | \n", "-0.049828 | \n", "-0.003728 | \n", "0.033231 | \n", "0.012997 | \n", "-0.003480 | \n", "-0.024712 | \n", "-0.001010 | \n", "0.032834 | \n", "0.013692 | \n", "... | \n", "0.015684 | \n", "-0.009050 | \n", "0.002138 | \n", "-0.013957 | \n", "-0.011004 | \n", "0.010872 | \n", "0.019524 | \n", "0.022903 | \n", "0.026779 | \n", "NaN | \n", "
2009-01-07 | \n", "-0.012436 | \n", "-0.037478 | \n", "-0.037094 | \n", "-0.012048 | \n", "-0.026675 | \n", "0.011881 | \n", "-0.048868 | \n", "-0.032868 | \n", "-0.003102 | \n", "-0.030804 | \n", "... | \n", "-0.048342 | \n", "-0.033118 | \n", "0.017287 | \n", "0.006715 | \n", "-0.021167 | \n", "0.004794 | \n", "0.001288 | \n", "-0.019086 | \n", "-0.070546 | \n", "NaN | \n", "
2009-01-08 | \n", "-0.012593 | \n", "-0.055807 | \n", "0.006279 | \n", "0.006544 | \n", "-0.037681 | \n", "-0.006418 | \n", "-0.148420 | \n", "0.051224 | \n", "-0.011158 | \n", "-0.036248 | \n", "... | \n", "0.029388 | \n", "-0.015786 | \n", "0.014584 | \n", "0.007357 | \n", "-0.002627 | \n", "0.016601 | \n", "-0.016353 | \n", "-0.040001 | \n", "-0.003788 | \n", "NaN | \n", "
2009-01-09 | \n", "-0.031424 | \n", "0.060042 | \n", "-0.035779 | \n", "0.001755 | \n", "-0.013062 | \n", "0.022044 | \n", "-0.117069 | \n", "-0.039459 | \n", "0.003137 | \n", "-0.046946 | \n", "... | \n", "-0.068488 | \n", "0.000000 | \n", "-0.001725 | \n", "0.022648 | \n", "-0.041944 | \n", "0.010916 | \n", "-0.047979 | \n", "-0.042397 | \n", "-0.032136 | \n", "NaN | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
2009-10-09 | \n", "0.009944 | \n", "0.004640 | \n", "0.000638 | \n", "-0.005424 | \n", "0.003098 | \n", "-0.006504 | \n", "-0.007207 | \n", "0.000775 | \n", "0.006179 | \n", "-0.001787 | \n", "... | \n", "-0.002445 | \n", "-0.008889 | \n", "0.000653 | \n", "0.007571 | \n", "-0.003973 | \n", "0.004564 | \n", "-0.014710 | \n", "0.003682 | \n", "-0.003044 | \n", "NaN | \n", "
2009-10-12 | \n", "-0.002702 | \n", "0.010700 | \n", "0.022700 | \n", "0.025284 | \n", "0.010004 | \n", "0.020666 | \n", "0.014957 | \n", "0.033015 | \n", "0.002051 | \n", "-0.006281 | \n", "... | \n", "0.017275 | \n", "0.017700 | \n", "0.014249 | \n", "0.004240 | \n", "0.000398 | \n", "0.008163 | \n", "0.003561 | \n", "0.026117 | \n", "0.011691 | \n", "NaN | \n", "
2009-10-13 | \n", "-0.012708 | \n", "-0.014383 | \n", "-0.014127 | \n", "-0.017384 | \n", "-0.008458 | \n", "-0.009957 | \n", "-0.001188 | \n", "-0.008278 | \n", "-0.009264 | \n", "-0.011770 | \n", "... | \n", "-0.008672 | \n", "0.006557 | \n", "-0.005158 | \n", "-0.009459 | \n", "-0.011808 | \n", "-0.005132 | \n", "-0.014599 | \n", "-0.012611 | \n", "0.011556 | \n", "NaN | \n", "
2009-10-14 | \n", "0.041163 | \n", "0.016805 | \n", "0.071372 | \n", "0.029899 | \n", "0.007181 | \n", "0.025181 | \n", "0.032751 | \n", "0.049629 | \n", "0.017766 | \n", "0.018051 | \n", "... | \n", "0.014880 | \n", "0.060855 | \n", "0.009970 | \n", "0.013049 | \n", "-0.002419 | \n", "0.014125 | \n", "0.033291 | \n", "0.050205 | \n", "0.036763 | \n", "NaN | \n", "
2009-10-15 | \n", "0.015081 | \n", "-0.009181 | \n", "-0.012441 | \n", "0.000218 | \n", "0.012192 | \n", "-0.013627 | \n", "-0.006349 | \n", "-0.008666 | \n", "0.000000 | \n", "0.012445 | \n", "... | \n", "0.000000 | \n", "-0.012376 | \n", "0.007651 | \n", "-0.010915 | \n", "-0.019770 | \n", "-0.008090 | \n", "-0.009980 | \n", "-0.007963 | \n", "0.013040 | \n", "NaN | \n", "
2009-10-16 | \n", "-0.004038 | \n", "-0.013243 | \n", "-0.017742 | \n", "-0.026303 | \n", "-0.001516 | \n", "-0.009941 | \n", "-0.030573 | \n", "-0.027453 | \n", "0.001692 | \n", "-0.011551 | \n", "... | \n", "-0.010322 | \n", "-0.034202 | \n", "-0.007331 | \n", "-0.019040 | \n", "-0.002680 | \n", "-0.007246 | \n", "0.003788 | \n", "-0.028022 | \n", "-0.022519 | \n", "NaN | \n", "
2009-10-19 | \n", "0.012351 | \n", "-0.000825 | \n", "0.035175 | \n", "0.023244 | \n", "0.013312 | \n", "0.041660 | \n", "0.005359 | \n", "0.012103 | \n", "0.067640 | \n", "0.005348 | \n", "... | \n", "0.018866 | \n", "0.018302 | \n", "0.012399 | \n", "0.021169 | \n", "0.004736 | \n", "0.014441 | \n", "0.032415 | \n", "0.017540 | \n", "0.008658 | \n", "NaN | \n", "
2009-10-20 | \n", "-0.021935 | \n", "-0.016364 | \n", "-0.019820 | \n", "-0.020560 | \n", "-0.003499 | \n", "0.012594 | \n", "-0.009547 | \n", "-0.007640 | \n", "-0.016887 | \n", "-0.008032 | \n", "... | \n", "-0.009248 | \n", "-0.003380 | \n", "-0.001265 | \n", "0.003079 | \n", "0.011844 | \n", "-0.008398 | \n", "0.016079 | \n", "-0.007050 | \n", "-0.010731 | \n", "NaN | \n", "
2009-10-21 | \n", "-0.014994 | \n", "-0.006875 | \n", "0.009515 | \n", "0.013092 | \n", "0.002501 | \n", "0.013944 | \n", "-0.002401 | \n", "-0.014202 | \n", "0.005128 | \n", "0.001791 | \n", "... | \n", "0.006454 | \n", "-0.005942 | \n", "0.013199 | \n", "0.002858 | \n", "0.006475 | \n", "0.006305 | \n", "-0.002060 | \n", "0.002297 | \n", "-0.004575 | \n", "NaN | \n", "
2009-10-22 | \n", "-0.008627 | \n", "-0.000845 | \n", "-0.022446 | \n", "-0.005748 | \n", "-0.001750 | \n", "-0.000903 | \n", "-0.026798 | \n", "-0.023614 | \n", "-0.012223 | \n", "-0.026282 | \n", "... | \n", "-0.013518 | \n", "-0.020646 | \n", "-0.012567 | \n", "-0.016519 | \n", "-0.004852 | \n", "-0.016904 | \n", "-0.015327 | \n", "-0.019961 | \n", "-0.027468 | \n", "NaN | \n", "
2009-10-23 | \n", "-0.007798 | \n", "-0.004095 | \n", "-0.008816 | \n", "-0.006897 | \n", "-0.000250 | \n", "0.010490 | \n", "0.004926 | \n", "0.006403 | \n", "0.003876 | \n", "-0.003680 | \n", "... | \n", "-0.003408 | \n", "0.010376 | \n", "-0.008573 | \n", "-0.013197 | \n", "-0.010185 | \n", "0.001521 | \n", "0.019700 | \n", "-0.008134 | \n", "0.004702 | \n", "NaN | \n", "
2009-10-26 | \n", "-0.028403 | \n", "-0.044555 | \n", "-0.022230 | \n", "0.002898 | \n", "-0.007032 | \n", "-0.009286 | \n", "-0.038828 | \n", "-0.019593 | \n", "-0.028447 | \n", "-0.027092 | \n", "... | \n", "-0.004848 | \n", "-0.032790 | \n", "-0.040676 | \n", "-0.005569 | \n", "-0.001639 | \n", "-0.009774 | \n", "-0.035797 | \n", "-0.013521 | \n", "-0.016771 | \n", "NaN | \n", "
2009-10-27 | \n", "-0.009650 | \n", "-0.000740 | \n", "-0.001562 | \n", "0.011730 | \n", "-0.002271 | \n", "-0.032419 | \n", "-0.057835 | \n", "-0.064521 | \n", "-0.021795 | \n", "-0.019121 | \n", "... | \n", "0.007973 | \n", "-0.035742 | \n", "-0.003660 | \n", "0.014242 | \n", "-0.004110 | \n", "0.008862 | \n", "-0.012852 | \n", "0.005869 | \n", "-0.023696 | \n", "NaN | \n", "
2009-10-28 | \n", "-0.038258 | \n", "-0.015065 | \n", "-0.032738 | \n", "-0.009506 | \n", "-0.007861 | \n", "-0.039631 | \n", "-0.063547 | \n", "-0.055673 | \n", "-0.053973 | \n", "-0.032372 | \n", "... | \n", "-0.021935 | \n", "-0.051512 | \n", "-0.009714 | \n", "-0.003569 | \n", "0.005954 | \n", "-0.080423 | \n", "-0.031201 | \n", "-0.030452 | \n", "-0.062764 | \n", "NaN | \n", "
2009-10-29 | \n", "0.018674 | \n", "0.035578 | \n", "0.011245 | \n", "0.007303 | \n", "0.006850 | \n", "0.023967 | \n", "0.060158 | \n", "0.103127 | \n", "0.040321 | \n", "0.028503 | \n", "... | \n", "0.006213 | \n", "0.023485 | \n", "-0.003372 | \n", "-0.000975 | \n", "-0.007603 | \n", "-0.005621 | \n", "0.015722 | \n", "0.022372 | \n", "0.027514 | \n", "NaN | \n", "
2009-10-30 | \n", "-0.039029 | \n", "-0.045243 | \n", "-0.024908 | \n", "-0.021847 | \n", "-0.001012 | \n", "-0.019127 | \n", "-0.036644 | \n", "-0.055820 | \n", "-0.044624 | \n", "-0.024523 | \n", "... | \n", "-0.035482 | \n", "-0.030298 | \n", "-0.026349 | \n", "-0.030721 | \n", "-0.019370 | \n", "-0.024842 | \n", "-0.033675 | \n", "-0.048541 | \n", "-0.032253 | \n", "NaN | \n", "
2009-11-02 | \n", "0.037433 | \n", "0.008462 | \n", "-0.001639 | \n", "-0.002256 | \n", "-0.012223 | \n", "0.009290 | \n", "0.012596 | \n", "-0.015522 | \n", "-0.001079 | \n", "-0.001988 | \n", "... | \n", "0.024765 | \n", "-0.018729 | \n", "-0.006261 | \n", "0.003238 | \n", "0.002101 | \n", "0.016184 | \n", "0.000283 | \n", "0.004441 | \n", "0.008986 | \n", "NaN | \n", "
2009-11-03 | \n", "-0.001919 | \n", "-0.012567 | \n", "-0.005593 | \n", "-0.006345 | \n", "0.033013 | \n", "-0.064539 | \n", "-0.041170 | \n", "-0.030612 | \n", "-0.045253 | \n", "-0.010000 | \n", "... | \n", "0.001455 | \n", "-0.019086 | \n", "-0.002096 | \n", "-0.019016 | \n", "-0.013522 | \n", "0.008658 | \n", "0.010415 | \n", "-0.018670 | \n", "-0.016137 | \n", "NaN | \n", "
2009-11-04 | \n", "0.037076 | \n", "0.020809 | \n", "0.019602 | \n", "0.000909 | \n", "-0.031477 | \n", "0.024527 | \n", "0.043254 | \n", "0.050325 | \n", "0.030760 | \n", "0.035542 | \n", "... | \n", "0.025550 | \n", "0.101194 | \n", "0.014234 | \n", "0.013428 | \n", "0.004669 | \n", "0.005621 | \n", "0.025164 | \n", "0.012873 | \n", "0.031091 | \n", "NaN | \n", "
2009-11-05 | \n", "0.009822 | \n", "-0.007339 | \n", "0.024606 | \n", "0.023789 | \n", "0.004849 | \n", "0.015152 | \n", "-0.047611 | \n", "0.008054 | \n", "0.002915 | \n", "0.002906 | \n", "... | \n", "0.019369 | \n", "0.007306 | \n", "0.010970 | \n", "-0.011045 | \n", "-0.003181 | \n", "0.000000 | \n", "0.004632 | \n", "0.012518 | \n", "0.008774 | \n", "NaN | \n", "
2009-11-06 | \n", "0.000916 | \n", "0.006742 | \n", "-0.008559 | \n", "0.007512 | \n", "-0.003826 | \n", "0.008788 | \n", "0.011578 | \n", "-0.013647 | \n", "0.016601 | \n", "0.010582 | \n", "... | \n", "0.001667 | \n", "0.007253 | \n", "-0.000682 | \n", "-0.008422 | \n", "0.003181 | \n", "-0.009607 | \n", "0.001630 | \n", "-0.003067 | \n", "0.010519 | \n", "NaN | \n", "
2009-11-09 | \n", "0.016344 | \n", "0.041819 | \n", "0.024840 | \n", "0.026286 | \n", "0.005861 | \n", "0.011598 | \n", "0.055959 | \n", "0.050311 | \n", "0.021948 | \n", "0.040324 | \n", "... | \n", "0.015013 | \n", "0.050209 | \n", "0.014228 | \n", "0.011138 | \n", "0.019707 | \n", "0.001663 | \n", "0.007031 | \n", "0.027643 | \n", "0.025602 | \n", "NaN | \n", "
2009-11-10 | \n", "0.007179 | \n", "0.003431 | \n", "0.005883 | \n", "0.001500 | \n", "0.012372 | \n", "-0.022677 | \n", "-0.024795 | \n", "-0.033902 | \n", "-0.003156 | \n", "-0.000920 | \n", "... | \n", "-0.003698 | \n", "-0.042111 | \n", "0.002687 | \n", "-0.000452 | \n", "0.004763 | \n", "-0.002662 | \n", "-0.011655 | \n", "-0.001869 | \n", "-0.009804 | \n", "NaN | \n", "
2009-11-11 | \n", "0.023274 | \n", "-0.001571 | \n", "0.016231 | \n", "0.012129 | \n", "-0.000502 | \n", "0.009457 | \n", "0.017284 | \n", "0.032033 | \n", "0.017065 | \n", "0.007333 | \n", "... | \n", "0.001097 | \n", "0.023906 | \n", "0.004685 | \n", "0.010349 | \n", "0.010278 | \n", "0.018816 | \n", "-0.019546 | \n", "0.002056 | \n", "0.019952 | \n", "NaN | \n", "
2009-11-12 | \n", "-0.009068 | \n", "0.007405 | \n", "0.002730 | \n", "0.017403 | \n", "0.005009 | \n", "0.005180 | \n", "-0.016586 | \n", "-0.022424 | \n", "-0.010064 | \n", "-0.005495 | \n", "... | \n", "0.022229 | \n", "-0.021668 | \n", "-0.004350 | \n", "-0.008993 | \n", "0.002043 | \n", "0.001307 | \n", "0.017090 | \n", "0.000560 | \n", "-0.006165 | \n", "NaN | \n", "
2009-11-13 | \n", "0.005860 | \n", "0.007633 | \n", "0.007545 | \n", "0.006010 | \n", "0.010932 | \n", "0.008360 | \n", "-0.026122 | \n", "0.004090 | \n", "0.006605 | \n", "0.010050 | \n", "... | \n", "0.002811 | \n", "0.012880 | \n", "0.000670 | \n", "0.004731 | \n", "0.004073 | \n", "0.007483 | \n", "0.007623 | \n", "0.001678 | \n", "0.012292 | \n", "NaN | \n", "
2013-12-25 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2013-12-26 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
2013-12-27 | \n", "0.005758 | \n", "0.008803 | \n", "0.013479 | \n", "0.015156 | \n", "0.006796 | \n", "0.010228 | \n", "0.023408 | \n", "0.000566 | \n", "0.013505 | \n", "0.008271 | \n", "... | \n", "0.010478 | \n", "0.012822 | \n", "0.000000 | \n", "0.011221 | \n", "0.009760 | \n", "0.003925 | \n", "0.027870 | \n", "0.011901 | \n", "0.014455 | \n", "NaN | \n", "
2014-01-01 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "... | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "0.000000 | \n", "NaN | \n", "
252 rows \u00d7 28 columns
\n", "Warning: BokehJS previously loaded
" ], "metadata": {}, "output_type": "display_data" } ], "prompt_number": 46 }, { "cell_type": "code", "collapsed": false, "input": [ "dfclose = stx['Close']\n", "dfclose.ix[pd.Timestamp('20080807'):pd.Timestamp('20080815')].isnull().any(axis=1) #.all(axis=1)\n", "# dfclose.fillna(method='ffill', limit=0).isnull().any(axis=1) #.plot(kind='area')" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 47, "text": [ "Date\n", "2008-08-07 True\n", "2008-08-08 True\n", "2008-08-11 True\n", "2008-08-12 True\n", "2008-08-13 True\n", "2008-08-14 True\n", "2008-08-15 True\n", "dtype: bool" ] } ], "prompt_number": 47 }, { "cell_type": "markdown", "metadata": {}, "source": [ "For info on the difference between \"Close\" and \"Adj Close\", take a look at this [discussion thread](http://quant.stackexchange.com/questions/942/any-known-bugs-with-yahoo-finance-adjusted-close-data) or this [entry]()" ] }, { "cell_type": "code", "collapsed": false, "input": [ "def plot_close(stock):\n", " ig, axes = plt.subplots(nrows=2, ncols=1)\n", " stx.ix['Adj Close'][stock].plot(legend=True, ax=axes[0], x_compat=True, figsize=(14, 6))\n", " stx.ix['Close'][stock].plot(legend=True, ax=axes[0], x_compat=True, figsize=(14, 6))\n", " \n", " axes[0].set_title('Closing price')\n", " axes[0].set_ylabel('Price')\n", " stx.ix['Returns'][stock].plot(legend=False, ax=axes[1], x_compat=True, figsize=(14, 6))\n", " axes[1].set_title('Log returns')\n", "\n", "names_dict = OrderedDict(df_dax_info[['Symbol', 'Company']].set_index('Company').to_records() )\n", "interact(plot_close, stock=names_dict)" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 48, "text": [ "