In [3]:
import pandas as pd
url = 'https://finance.yahoo.com/quote/%5EDJI/components?p=%5EDJI'
df = pd.read_html(url)[0]
names=df[['Symbol','Company Name']]
symbol=names['Symbol'].values
full_name=names['Company Name'].values
print(symbol)
print(full_name)
['DD' 'UTX' 'AAPL' 'CSCO' 'KO' 'MMM' 'MSFT' 'DIS' 'MCD' 'GE' 'PG' 'XOM'
'JNJ' 'WMT' 'VZ' 'HD' 'V' 'NKE' 'AXP' 'CAT' 'BA' 'JPM' 'TRV' 'PFE' 'MRK'
'UNH' 'INTC' 'CVX' 'GS' 'IBM']
['E. I. du Pont de Nemours and Company' 'United Technologies Corporation'
'Apple Inc.' 'Cisco Systems, Inc.' 'The Coca-Cola Company' '3M Company'
'Microsoft Corporation' 'The Walt Disney Company' "McDonald's Corporation"
'General Electric Company' 'The Procter & Gamble Company'
'Exxon Mobil Corporation' 'Johnson & Johnson' 'Wal-Mart Stores, Inc.'
'Verizon Communications Inc.' 'The Home Depot, Inc.' 'Visa Inc.'
'NIKE, Inc.' 'American Express Company' 'Caterpillar Inc.'
'The Boeing Company' 'JPMorgan Chase & Co.'
'The Travelers Companies, Inc.' 'Pfizer Inc.' 'Merck & Co., Inc.'
'UnitedHealth Group Incorporated' 'Intel Corporation'
'Chevron Corporation' 'The Goldman Sachs Group, Inc.'
'International Business Machines Corporation']
In [4]:
import pandas_datareader.data as web
import datetime
start = datetime.datetime(2016, 1, 1)
end = datetime.datetime(2016, 1, 31)
#web.DataReader("F", 'google', start, end)
data_exchange={}
for s in symbol:
data_exchange[s]=web.get_data_google(s,start,end)
data_exchange
Out[4]:
{'AAPL': Open High Low Close Volume
Date
2016-10-20 116.86 117.38 116.33 117.06 24125801
2016-10-21 116.81 116.91 116.28 116.60 23192665
2016-10-24 117.10 117.74 117.00 117.65 23538673
2016-10-25 117.95 118.36 117.31 118.25 48128970
2016-10-26 114.31 115.70 113.31 115.59 66134219
2016-10-27 115.39 115.86 114.10 114.48 34562045
2016-10-28 113.87 115.21 113.45 113.72 37861662
2016-10-31 113.65 114.23 113.20 113.54 26419398
2016-11-01 113.46 113.77 110.53 111.49 43825812
2016-11-02 111.40 112.35 111.23 111.59 28331709
2016-11-03 110.98 111.46 109.55 109.83 26932602
2016-11-04 108.53 110.25 108.11 108.84 30836997
2016-11-07 110.08 110.51 109.46 110.41 32560000
2016-11-08 110.31 111.72 109.70 111.06 24254179
2016-11-09 109.88 111.32 108.05 110.88 59176361
2016-11-10 111.09 111.09 105.83 107.79 57134541
2016-11-11 107.12 108.87 106.55 108.43 34143898
2016-11-14 107.71 107.81 104.08 105.71 51175504
2016-11-15 106.57 107.68 106.16 107.11 32264510
2016-11-16 106.70 110.23 106.60 109.99 58840522
2016-11-17 109.81 110.35 108.83 109.95 26964598
2016-11-18 109.72 110.54 109.66 110.06 28428917
2016-11-21 110.12 111.99 110.01 111.73 29264571
2016-11-22 111.95 112.42 111.40 111.80 25965534
2016-11-23 111.36 111.51 110.33 111.23 27426394
2016-11-25 111.47 111.87 110.95 111.79 11475922
2016-11-28 111.43 112.46 111.39 111.57 27193983
2016-11-29 110.78 112.03 110.07 111.46 28528750
2016-11-30 111.60 112.20 110.27 110.52 36162258
2016-12-01 110.36 110.94 109.03 109.49 37086862
... ... ... ... ... ...
2017-09-06 162.71 162.99 160.52 161.91 21651726
2017-09-07 162.09 162.24 160.36 161.26 21928502
2017-09-08 160.86 161.15 158.53 158.63 28611535
2017-09-11 160.50 162.05 159.89 161.50 31580798
2017-09-12 162.61 163.96 158.77 160.86 71714046
2017-09-13 159.87 159.96 157.91 159.65 44907361
2017-09-14 158.99 159.40 158.09 158.28 23760749
2017-09-15 158.47 160.97 158.00 159.88 49114602
2017-09-18 160.11 160.50 158.00 158.67 28269435
2017-09-19 159.51 159.77 158.44 158.73 20810632
2017-09-20 157.90 158.26 153.83 156.07 52951364
2017-09-21 155.80 155.80 152.75 153.39 37511661
2017-09-22 151.54 152.27 150.56 151.89 46645443
2017-09-25 149.99 151.83 149.16 150.55 44387336
2017-09-26 151.78 153.92 151.69 153.14 36660045
2017-09-27 153.80 154.72 153.54 154.23 25182779
2017-09-28 153.89 154.28 152.70 153.28 22005455
2017-09-29 153.21 154.13 152.00 154.12 26299810
2017-10-02 154.26 154.45 152.72 153.81 18698842
2017-10-03 154.01 155.09 153.91 154.48 16230293
2017-10-04 153.63 153.86 152.46 153.48 20163750
2017-10-05 154.18 155.44 154.05 155.39 21283769
2017-10-06 154.97 155.49 154.56 155.30 17407558
2017-10-09 155.81 156.73 155.48 155.84 16262923
2017-10-10 156.06 158.00 155.10 155.90 15617014
2017-10-11 155.97 156.98 155.75 156.55 16905640
2017-10-12 156.35 157.37 155.73 156.00 16125054
2017-10-13 156.73 157.28 156.41 156.99 16394188
2017-10-16 157.90 160.00 157.65 159.88 24121452
2017-10-17 159.78 160.87 159.23 160.47 18997275
[250 rows x 5 columns],
'AXP': Open High Low Close Volume
Date
2016-10-20 65.34 67.78 64.75 66.78 25870728
2016-10-21 66.45 67.59 66.40 67.36 8561225
2016-10-24 67.69 67.93 67.07 67.09 5174043
2016-10-25 66.93 67.38 66.61 66.74 3882253
2016-10-26 66.50 67.07 66.14 66.80 3621817
2016-10-27 67.00 67.22 66.43 66.93 4751290
2016-10-28 67.15 67.22 66.30 66.45 4994491
2016-10-31 66.81 66.83 66.31 66.42 3233384
2016-11-01 66.77 66.81 65.73 66.25 3761564
2016-11-02 65.76 66.03 65.14 65.45 3658990
2016-11-03 65.53 65.76 65.04 65.33 3796470
2016-11-04 65.50 66.08 65.03 65.51 3429896
2016-11-07 66.85 67.33 66.65 67.00 4012053
2016-11-08 66.79 67.26 66.31 67.07 3955973
2016-11-09 67.16 69.00 67.06 68.74 9319120
2016-11-10 69.24 70.40 69.05 70.11 9419195
2016-11-11 69.97 70.59 69.65 70.50 4656115
2016-11-14 70.80 72.68 70.62 72.42 8084104
2016-11-15 72.13 72.48 71.24 72.47 4431192
2016-11-16 71.95 72.40 71.28 71.68 4663671
2016-11-17 71.36 72.00 71.32 71.78 3779687
2016-11-18 71.53 71.60 70.77 71.00 5430609
2016-11-21 71.31 71.67 70.96 71.54 3368167
2016-11-22 71.82 71.88 70.87 71.72 4086200
2016-11-23 71.94 72.92 71.51 72.88 4691260
2016-11-25 72.97 73.18 72.46 72.86 1900447
2016-11-28 72.53 72.77 71.97 72.13 4467747
2016-11-29 72.20 72.26 71.38 71.49 3814802
2016-11-30 72.00 72.33 71.78 72.04 4812489
2016-12-01 72.45 72.77 71.78 72.53 4298162
... ... ... ... ... ...
2017-09-06 85.57 85.84 85.00 85.23 2823281
2017-09-07 85.27 85.52 84.08 84.41 2905386
2017-09-08 84.18 85.00 84.02 84.25 3462112
2017-09-11 84.97 86.12 84.97 85.69 3397496
2017-09-12 85.97 86.60 85.81 86.55 3333342
2017-09-13 86.42 86.77 86.39 86.64 2396472
2017-09-14 86.54 86.80 86.16 86.19 2764916
2017-09-15 86.52 86.99 86.07 86.99 7791555
2017-09-18 87.08 87.87 86.95 87.87 3395073
2017-09-19 87.97 89.23 87.88 89.00 4043778
2017-09-20 89.25 89.38 88.27 88.43 4251024
2017-09-21 88.45 88.80 88.04 88.42 2877759
2017-09-22 88.30 88.71 88.10 88.40 2770085
2017-09-25 88.28 88.64 87.84 88.21 2863068
2017-09-26 88.47 88.77 88.20 88.69 2197846
2017-09-27 89.68 89.74 89.03 89.49 2868330
2017-09-28 89.23 90.31 89.23 90.14 2458773
2017-09-29 90.04 90.77 89.93 90.46 2996260
2017-10-02 90.44 91.17 90.10 90.54 4466395
2017-10-03 90.59 91.64 90.59 91.43 2912299
2017-10-04 91.60 91.61 90.90 91.01 3091679
2017-10-05 90.96 91.62 90.77 91.16 2990958
2017-10-06 91.25 91.58 91.09 91.55 1891848
2017-10-09 91.59 91.96 91.50 91.69 1653721
2017-10-10 91.88 92.34 91.78 91.89 2247195
2017-10-11 91.86 92.62 91.86 92.44 283559
2017-10-12 91.63 92.23 91.42 91.61 3279018
2017-10-13 91.50 92.92 91.26 92.86 3224158
2017-10-16 93.04 93.35 90.81 91.96 4293977
2017-10-17 91.94 92.10 91.58 91.69 2939556
[250 rows x 5 columns],
'BA': Open High Low Close Volume
Date
2016-10-20 135.92 136.75 135.37 135.84 2539711
2016-10-21 134.72 136.19 134.25 135.63 2205772
2016-10-24 136.41 138.88 136.41 137.45 3814247
2016-10-25 137.53 139.42 137.35 139.02 5209103
2016-10-26 138.43 146.19 136.72 145.54 13272044
2016-10-27 145.83 146.23 141.78 143.31 7857081
2016-10-28 143.72 144.00 142.17 143.01 4636070
2016-10-31 143.05 143.35 142.15 142.43 3075889
2016-11-01 142.95 143.90 141.81 142.41 3245017
2016-11-02 142.00 142.87 140.59 140.75 2782065
2016-11-03 140.76 140.90 139.35 140.02 2280825
2016-11-04 139.11 140.85 138.80 139.54 2951457
2016-11-07 141.50 143.10 141.49 143.03 3228202
2016-11-08 141.92 143.31 141.29 142.20 2823805
2016-11-09 141.60 145.85 141.54 145.09 5494382
2016-11-10 146.51 149.34 146.39 147.69 6508251
2016-11-11 147.12 148.60 146.56 148.52 3585163
2016-11-14 148.21 150.09 148.21 149.99 4490877
2016-11-15 148.44 149.45 147.19 148.11 3856601
2016-11-16 147.30 148.41 146.14 146.44 3559655
2016-11-17 146.83 147.12 145.00 145.33 3639049
2016-11-18 145.18 146.60 144.46 146.35 2214419
2016-11-21 147.21 148.49 146.52 147.02 2825906
2016-11-22 147.90 149.76 147.88 149.52 3770004
2016-11-23 149.61 150.81 149.03 149.74 3071074
2016-11-25 150.00 150.15 149.03 150.04 962387
2016-11-28 149.00 150.09 148.32 149.77 4728764
2016-11-29 149.83 152.11 149.11 151.64 3945635
2016-11-30 151.59 153.08 150.56 150.56 3990972
2016-12-01 150.74 152.69 150.39 152.39 2843930
... ... ... ... ... ...
2017-09-06 237.53 237.86 234.34 234.62 4252704
2017-09-07 234.75 236.54 234.29 236.31 2994514
2017-09-08 235.75 239.39 235.21 238.78 3404151
2017-09-11 239.50 241.85 239.31 240.59 3628146
2017-09-12 240.59 241.71 238.95 240.58 2702732
2017-09-13 240.00 243.48 237.09 241.93 4529090
2017-09-14 243.00 245.61 242.50 245.23 4995155
2017-09-15 247.36 249.95 246.21 249.00 9033301
2017-09-18 249.97 253.79 248.91 253.08 5192959
2017-09-19 253.08 255.17 251.63 252.46 4124716
2017-09-20 253.26 256.69 252.25 255.46 3853153
2017-09-21 256.13 256.99 254.42 256.04 2809374
2017-09-22 256.31 259.30 256.13 256.45 3475566
2017-09-25 256.97 256.97 251.50 254.32 3479166
2017-09-26 254.60 256.48 253.54 253.70 2173606
2017-09-27 255.27 258.77 253.97 255.28 3812914
2017-09-28 254.11 255.80 251.17 254.27 2586076
2017-09-29 253.85 255.26 252.59 254.21 2531131
2017-10-02 254.65 255.99 253.53 255.99 2685053
2017-10-03 255.99 258.26 254.69 255.46 3163415
2017-10-04 256.12 257.13 254.07 255.76 3030983
2017-10-05 255.28 258.99 254.78 258.89 3940198
2017-10-06 258.00 258.90 257.06 258.58 2736358
2017-10-09 259.00 259.00 257.11 258.39 2146782
2017-10-10 259.74 261.06 257.20 260.93 2740651
2017-10-11 261.32 261.32 259.02 260.39 361602
2017-10-12 260.95 262.98 260.00 261.91 2577900
2017-10-13 262.90 263.79 260.74 260.74 2243903
2017-10-16 261.50 262.00 259.69 259.75 1818869
2017-10-17 256.49 259.05 256.26 258.62 2515865
[250 rows x 5 columns],
'CAT': Open High Low Close Volume
Date
2016-10-20 87.06 87.27 86.23 86.63 4576568
2016-10-21 85.73 86.62 85.36 86.33 3592524
2016-10-24 86.12 87.13 85.54 85.99 5096454
2016-10-25 85.86 87.65 83.88 84.48 11639239
2016-10-26 83.81 84.39 82.88 84.13 6582085
2016-10-27 84.28 84.34 82.71 83.01 5003224
2016-10-28 83.32 84.17 83.00 83.88 4974567
2016-10-31 84.19 84.38 83.41 83.46 4679376
2016-11-01 83.47 83.65 81.65 82.24 5139628
2016-11-02 82.15 82.15 80.33 81.11 5228562
2016-11-03 81.64 81.67 80.68 81.27 3859001
2016-11-04 81.34 82.90 80.59 82.31 5745833
2016-11-07 83.74 84.16 82.97 83.75 3786427
2016-11-08 83.77 85.00 83.06 84.68 3407727
2016-11-09 89.78 93.20 89.36 91.20 19281888
2016-11-10 92.04 94.95 91.84 93.45 14174371
2016-11-11 93.39 94.34 91.82 93.01 7369906
2016-11-14 93.25 95.50 93.02 94.17 7552789
2016-11-15 93.46 94.46 92.64 94.44 4645386
2016-11-16 93.77 94.40 92.84 93.35 3297156
2016-11-17 93.50 93.50 92.40 92.78 3939078
2016-11-18 93.01 93.40 91.90 92.34 4715937
2016-11-21 93.13 93.85 92.78 92.90 3783223
2016-11-22 93.40 93.71 92.80 93.62 3172772
2016-11-23 94.81 96.42 94.22 96.18 6571098
2016-11-25 95.96 96.44 95.21 95.81 2006880
2016-11-28 95.51 95.86 94.47 94.90 4916004
2016-11-29 94.00 94.57 93.63 94.04 3806021
2016-11-30 95.75 95.90 94.35 95.56 4641863
2016-12-01 96.00 97.39 94.05 96.24 9361618
... ... ... ... ... ...
2017-09-06 118.75 119.18 116.98 116.98 4292595
2017-09-07 117.38 117.93 116.50 117.77 3270114
2017-09-08 117.23 118.85 117.00 117.82 2786971
2017-09-11 118.82 118.92 117.47 118.87 3527473
2017-09-12 119.19 121.39 119.06 120.94 5554631
2017-09-13 120.50 121.00 119.41 119.63 2532234
2017-09-14 119.79 120.79 119.21 120.48 2904856
2017-09-15 121.01 121.57 120.31 121.37 4610125
2017-09-18 123.62 124.43 122.85 123.83 4349014
2017-09-19 123.96 124.93 123.76 124.74 3050029
2017-09-20 124.97 125.28 124.18 124.85 3151576
2017-09-21 124.52 125.04 123.82 124.79 2615367
2017-09-22 124.58 125.42 124.35 124.43 2616709
2017-09-25 124.37 124.78 123.65 124.32 3268466
2017-09-26 124.70 125.07 124.32 124.51 2302141
2017-09-27 125.21 125.42 124.34 124.52 2116077
2017-09-28 123.91 125.28 123.62 125.23 2067779
2017-09-29 125.35 125.55 124.51 124.71 2273463
2017-10-02 124.40 124.83 123.95 124.72 2502628
2017-10-03 124.98 125.53 124.35 125.51 2166124
2017-10-04 125.69 127.09 125.60 126.74 2792495
2017-10-05 126.80 126.91 126.01 126.40 2496551
2017-10-06 126.12 126.99 125.98 126.93 2697410
2017-10-09 126.92 126.93 125.94 126.88 1979639
2017-10-10 127.52 128.29 127.27 128.19 4414772
2017-10-11 128.17 128.41 127.67 127.88 177592
2017-10-12 128.40 130.16 128.38 129.99 3372320
2017-10-13 131.00 131.41 129.20 130.71 3478191
2017-10-16 131.25 132.12 130.94 131.47 2914192
2017-10-17 131.14 131.47 130.32 130.54 2380342
[250 rows x 5 columns],
'CSCO': Open High Low Close Volume
Date
2016-10-20 30.28 30.37 30.04 30.16 17315335
2016-10-21 30.01 30.20 29.92 30.15 15140452
2016-10-24 30.34 30.50 30.30 30.46 14115340
2016-10-25 30.50 30.51 30.23 30.34 15257768
2016-10-26 30.59 30.86 30.32 30.55 18008646
2016-10-27 30.60 30.67 30.36 30.38 16926192
2016-10-28 30.36 30.80 30.35 30.59 19946832
2016-10-31 30.34 30.77 30.32 30.68 23225406
2016-11-01 30.85 30.86 30.23 30.48 17542055
2016-11-02 30.43 30.68 30.23 30.39 19173984
2016-11-03 30.50 30.56 30.24 30.32 15937140
2016-11-04 29.98 30.50 29.63 30.19 18524002
2016-11-07 30.71 31.06 30.61 30.94 23061116
2016-11-08 30.94 31.20 30.72 31.00 19399814
2016-11-09 31.04 31.49 30.70 31.36 38564143
2016-11-10 31.41 31.76 30.81 31.00 38345220
2016-11-11 30.93 31.47 30.92 31.36 23150319
2016-11-14 31.43 31.67 31.35 31.37 22917565
2016-11-15 31.27 31.85 31.27 31.70 24160155
2016-11-16 31.62 31.89 31.51 31.57 27097140
2016-11-17 29.91 30.05 29.61 30.05 75252307
2016-11-18 30.11 30.36 30.00 30.18 38748563
2016-11-21 30.30 30.33 30.01 30.05 27481710
2016-11-22 30.08 30.19 29.85 29.89 26769272
2016-11-23 29.83 29.95 29.56 29.71 24496763
2016-11-25 29.60 30.14 29.55 30.09 17678862
2016-11-28 30.08 30.09 29.82 29.92 21468918
2016-11-29 29.94 30.10 29.79 29.83 23553735
2016-11-30 29.76 29.95 29.68 29.82 26224892
2016-12-01 29.84 29.85 29.40 29.45 25996185
... ... ... ... ... ...
2017-09-06 31.75 31.91 31.63 31.87 16962308
2017-09-07 31.96 31.97 31.74 31.76 14751706
2017-09-08 31.68 31.78 31.46 31.48 15339455
2017-09-11 31.71 32.30 31.67 32.19 22440819
2017-09-12 32.30 32.47 32.19 32.41 18923132
2017-09-13 32.34 32.39 31.96 32.18 22705140
2017-09-14 31.91 32.22 31.91 32.19 18194803
2017-09-15 32.20 32.50 32.12 32.44 29336087
2017-09-18 32.43 32.66 32.26 32.52 17290893
2017-09-19 32.46 32.65 32.40 32.49 12927654
2017-09-20 32.55 32.75 32.39 32.60 19865366
2017-09-21 32.72 32.90 32.50 32.70 19870012
2017-09-22 32.66 33.53 32.64 33.37 28234858
2017-09-25 33.31 33.84 33.20 33.72 32396906
2017-09-26 33.76 34.10 33.67 33.76 26138300
2017-09-27 33.78 33.92 33.30 33.48 22310041
2017-09-28 33.22 33.46 33.22 33.35 15496862
2017-09-29 33.31 33.67 33.24 33.63 14802671
2017-10-02 33.61 33.77 33.52 33.75 16555183
2017-10-03 33.72 33.90 33.61 33.85 13346858
2017-10-04 33.53 33.56 33.29 33.44 14652192
2017-10-05 33.58 33.67 33.41 33.59 14524809
2017-10-06 33.65 33.78 33.52 33.75 15464652
2017-10-09 33.77 33.89 33.61 33.76 8728444
2017-10-10 33.88 33.91 33.47 33.55 18011029
2017-10-11 33.38 33.63 33.25 33.59 12561374
2017-10-12 33.26 33.46 33.17 33.26 17905601
2017-10-13 33.40 33.57 33.32 33.47 13578818
2017-10-16 33.60 33.64 33.47 33.54 10509057
2017-10-17 33.59 33.67 33.46 33.60 9303117
[250 rows x 5 columns],
'CVX': Open High Low Close Volume
Date
2016-10-20 101.64 102.22 100.69 101.87 4820916
2016-10-21 101.06 101.56 100.63 101.30 5622393
2016-10-24 101.56 101.58 100.06 100.66 6077327
2016-10-25 100.75 101.67 100.52 100.77 4730708
2016-10-26 100.32 101.53 99.87 101.19 6353691
2016-10-27 101.51 101.98 99.92 99.92 9897827
2016-10-28 101.12 105.03 100.95 103.82 17435396
2016-10-31 103.82 105.46 103.78 104.75 12340755
2016-11-01 105.51 106.74 105.45 106.48 12755638
2016-11-02 105.65 106.05 104.25 105.39 8405190
2016-11-03 105.53 106.19 104.95 105.39 5703175
2016-11-04 105.25 105.49 104.38 104.78 7085448
2016-11-07 106.00 106.98 105.78 106.85 7333808
2016-11-08 106.57 108.19 106.42 107.29 8050007
2016-11-09 106.04 108.26 105.69 107.64 9161840
2016-11-10 107.54 108.50 107.24 107.79 8739595
2016-11-11 107.48 107.65 105.94 106.64 7939479
2016-11-14 106.15 106.73 105.59 106.59 7656040
2016-11-15 107.49 109.06 107.40 108.96 12156546
2016-11-16 108.20 109.00 107.74 108.35 7723662
2016-11-17 109.00 110.10 107.59 108.12 6624283
2016-11-18 108.57 109.67 108.15 109.20 6815483
2016-11-21 110.36 111.00 110.07 110.18 8476768
2016-11-22 110.79 111.00 109.31 110.62 6440518
2016-11-23 110.40 111.47 110.04 111.00 4490251
2016-11-25 110.54 111.22 110.12 111.00 3238554
2016-11-28 110.95 111.57 110.38 110.50 6406714
2016-11-29 109.10 109.72 108.40 109.34 7461924
2016-11-30 112.05 112.98 111.30 111.56 17301924
2016-12-01 112.79 114.91 112.53 113.29 11792281
... ... ... ... ... ...
2017-09-06 110.00 112.23 109.80 111.79 8577257
2017-09-07 112.18 112.87 111.36 111.80 5937757
2017-09-08 111.59 111.75 110.53 110.78 4033102
2017-09-11 111.83 112.57 111.52 112.52 5973396
2017-09-12 112.82 112.95 111.86 112.49 5110085
2017-09-13 112.49 114.32 112.28 114.18 5889386
2017-09-14 114.26 115.34 114.18 114.45 5819075
2017-09-15 114.83 114.91 113.63 114.63 8387623
2017-09-18 114.42 115.22 114.32 115.19 4954613
2017-09-19 115.25 116.42 115.19 116.34 6187969
2017-09-20 116.50 117.15 116.20 116.37 5378172
2017-09-21 116.22 116.52 115.83 116.47 4334537
2017-09-22 116.41 117.83 116.27 117.29 5307066
2017-09-25 117.23 118.33 117.02 117.99 5980338
2017-09-26 117.79 118.03 117.25 117.52 4874703
2017-09-27 117.46 117.60 116.77 117.45 3872739
2017-09-28 117.17 118.13 117.02 117.62 4948991
2017-09-29 117.17 117.52 116.73 117.50 4874786
2017-10-02 116.42 117.79 115.53 117.43 4285626
2017-10-03 117.08 118.25 117.01 117.82 3892189
2017-10-04 117.82 117.87 117.13 117.58 3443437
2017-10-05 117.45 118.69 117.33 118.58 5470900
2017-10-06 117.95 118.15 116.80 117.03 3533322
2017-10-09 117.34 118.08 117.01 117.71 2951938
2017-10-10 118.40 119.82 118.29 118.80 5683126
2017-10-11 119.21 119.25 118.58 118.75 302197
2017-10-12 118.49 119.65 118.31 119.14 3929664
2017-10-13 119.79 120.00 119.07 119.16 4640071
2017-10-16 119.84 120.89 119.43 120.13 5500652
2017-10-17 120.23 120.74 119.83 120.22 4844293
[250 rows x 5 columns],
'DD': Open High Low Close Volume
Date
2016-10-20 69.17 69.73 69.01 69.46 1390622
2016-10-21 68.74 69.79 68.63 69.70 1824762
2016-10-24 69.98 70.17 69.60 70.14 2579046
2016-10-25 70.05 70.15 69.06 69.62 3288168
2016-10-26 69.14 69.25 68.57 68.68 2723680
2016-10-27 68.90 70.45 68.78 69.84 4170958
2016-10-28 70.16 70.35 69.11 69.45 2649098
2016-10-31 69.67 69.72 68.78 68.79 2453015
2016-11-01 69.00 69.02 67.92 68.44 3724496
2016-11-02 68.49 68.56 68.01 68.36 3055737
2016-11-03 68.61 68.70 68.29 68.50 2507180
2016-11-04 68.69 68.93 68.17 68.61 3505804
2016-11-07 69.44 69.72 68.88 69.51 3047079
2016-11-08 69.66 69.71 69.11 69.26 4316596
2016-11-09 66.20 70.37 66.19 70.28 5745565
2016-11-10 69.97 71.22 69.79 70.95 4866673
2016-11-11 70.73 70.90 67.72 69.21 5739800
2016-11-14 69.63 69.96 68.60 69.07 3368465
2016-11-15 69.13 69.17 67.48 68.64 2202480
2016-11-16 68.37 69.64 68.28 68.88 1836607
2016-11-17 69.20 69.25 68.26 69.17 1876517
2016-11-18 69.02 69.07 68.46 68.84 1842077
2016-11-21 69.18 70.15 69.10 70.07 3007480
2016-11-22 70.06 71.20 69.81 70.91 3726657
2016-11-23 70.68 70.86 70.26 70.32 3139201
2016-11-25 70.69 71.00 70.30 71.00 1591899
2016-11-28 70.89 71.06 70.29 70.89 2835013
2016-11-29 70.77 71.33 70.35 71.20 2473001
2016-11-30 71.58 73.69 71.11 73.61 5184790
2016-12-01 73.75 74.60 73.47 73.62 4813769
... ... ... ... ... ...
2017-07-21 84.83 85.04 84.25 84.54 1754081
2017-07-24 84.49 85.15 84.11 84.35 2004098
2017-07-25 85.80 86.36 85.12 85.49 2212436
2017-07-26 85.14 85.35 84.20 84.81 1494247
2017-07-27 85.16 85.98 84.02 84.59 2191217
2017-07-28 84.98 85.50 83.37 83.98 2356861
2017-07-31 NaN NaN 82.21 82.21 2183481
2017-08-01 82.60 82.84 81.95 82.66 3300875
2017-08-02 82.23 82.54 81.77 82.32 1490906
2017-08-03 82.36 82.60 81.02 81.33 1897273
2017-08-04 81.50 82.13 81.39 82.01 2247933
2017-08-07 81.95 82.23 81.47 81.79 1652190
2017-08-08 81.59 81.95 80.93 81.12 1561215
2017-08-09 81.20 81.62 80.93 81.33 1518954
2017-08-10 81.03 81.19 80.10 80.81 2415683
2017-08-11 81.04 81.25 80.69 80.97 1947088
2017-08-14 81.29 81.79 81.00 81.15 1608078
2017-08-15 81.21 81.66 81.01 81.58 1917170
2017-08-16 81.75 82.03 81.40 82.01 2432595
2017-08-17 81.68 81.95 80.86 80.86 3381232
2017-08-18 80.76 81.42 80.48 81.18 1952437
2017-08-21 81.33 81.92 80.87 81.83 1673950
2017-08-22 82.15 83.16 82.01 83.01 1694306
2017-08-23 82.82 83.47 82.60 82.76 2605133
2017-08-24 82.84 82.92 82.35 82.39 2039688
2017-08-25 82.68 82.92 82.33 82.66 1441643
2017-08-28 82.86 83.04 82.33 82.88 1408303
2017-08-29 82.51 82.60 82.10 82.24 1832308
2017-08-30 81.73 83.28 81.66 83.19 1719022
2017-08-31 83.54 85.16 83.31 83.93 34861021
[218 rows x 5 columns],
'DIS': Open High Low Close Volume
Date
2016-10-20 91.66 92.32 91.44 92.03 6153205
2016-10-21 91.33 94.19 90.60 93.03 13814538
2016-10-24 93.49 94.15 92.80 93.37 7280985
2016-10-25 93.14 93.36 92.64 92.75 6380747
2016-10-26 92.39 93.72 91.90 93.49 7152845
2016-10-27 93.80 94.34 93.31 94.02 6646969
2016-10-28 93.89 94.40 93.53 93.85 7309117
2016-10-31 93.72 93.82 92.31 92.69 9957559
2016-11-01 92.78 92.99 91.66 92.39 6449806
2016-11-02 91.91 92.56 91.69 91.91 6716247
2016-11-03 92.26 94.13 92.24 93.37 7751400
2016-11-04 93.50 93.79 92.36 92.45 7456486
2016-11-07 93.77 94.48 92.95 94.43 6996093
2016-11-08 94.53 94.85 93.90 94.38 6226852
2016-11-09 92.29 94.92 92.11 94.64 8635729
2016-11-10 94.89 96.06 94.23 94.96 13777923
2016-11-11 97.18 98.32 95.78 97.68 23008062
2016-11-14 97.56 98.31 97.45 97.92 13208417
2016-11-15 97.90 98.14 97.42 97.70 7184595
2016-11-16 98.33 99.17 98.10 99.12 9702404
2016-11-17 99.05 99.50 98.26 99.37 8651917
2016-11-18 99.05 99.37 98.14 98.24 8586121
2016-11-21 98.11 98.27 97.00 97.63 10771076
2016-11-22 97.50 97.93 97.27 97.71 5323683
2016-11-23 97.67 98.28 97.59 98.26 6166487
2016-11-25 98.71 99.07 98.50 98.82 4396763
2016-11-28 98.52 99.20 98.32 98.97 7106669
2016-11-29 99.23 99.68 98.97 99.67 8396803
2016-11-30 99.40 100.29 99.00 99.12 11369177
2016-12-01 99.13 99.75 98.62 98.94 9958086
... ... ... ... ... ...
2017-09-06 101.76 102.04 100.89 101.50 7530956
2017-09-07 101.55 101.86 96.20 97.06 26419407
2017-09-08 96.49 97.49 96.26 97.07 13147662
2017-09-11 97.90 98.02 96.96 97.09 9610290
2017-09-12 97.59 98.36 97.12 97.89 9151729
2017-09-13 98.24 98.95 98.02 98.82 7615303
2017-09-14 98.79 98.84 97.54 97.90 9710030
2017-09-15 98.05 98.93 98.00 98.52 23870293
2017-09-18 98.39 98.72 97.72 98.10 7013634
2017-09-19 98.23 98.67 98.08 98.43 6970280
2017-09-20 98.76 99.28 98.62 99.21 6459058
2017-09-21 99.19 99.39 98.75 98.89 4958036
2017-09-22 98.55 98.99 98.53 98.60 6359080
2017-09-25 98.60 99.64 98.42 99.57 7492545
2017-09-26 99.64 99.74 98.61 98.63 6220508
2017-09-27 98.97 99.52 98.02 99.24 7519224
2017-09-28 98.77 99.05 98.00 98.05 7149615
2017-09-29 97.89 98.59 97.66 98.57 8185858
2017-10-02 99.31 100.44 99.11 99.86 6923319
2017-10-03 100.05 100.85 99.91 100.79 5447727
2017-10-04 100.74 100.93 100.20 100.55 5126136
2017-10-05 100.64 100.87 100.02 100.11 4736650
2017-10-06 99.95 100.27 99.34 100.07 4360212
2017-10-09 100.81 100.98 99.45 99.57 5429606
2017-10-10 99.99 100.07 98.66 99.58 7704374
2017-10-11 99.58 99.58 98.70 98.90 437459
2017-10-12 97.56 97.82 96.81 96.93 11018249
2017-10-13 96.80 97.68 96.80 97.38 6857969
2017-10-16 97.64 98.27 97.54 98.13 4911623
2017-10-17 98.40 98.47 97.86 98.36 5942501
[250 rows x 5 columns],
'GE': Open High Low Close Volume
Date
2016-10-20 29.10 29.20 28.96 29.07 28433328
2016-10-21 28.44 29.00 28.33 28.98 64153187
2016-10-24 29.00 29.21 28.90 28.92 31139738
2016-10-25 28.94 29.01 28.62 28.65 26480722
2016-10-26 28.59 29.07 28.55 28.87 24357188
2016-10-27 28.89 28.96 28.61 28.63 25432889
2016-10-28 28.88 29.59 28.87 29.22 67870824
2016-10-31 29.48 29.65 29.09 29.10 43563696
2016-11-01 29.00 29.20 28.71 28.88 32010770
2016-11-02 28.86 28.86 28.40 28.49 30873251
2016-11-03 28.60 28.60 28.19 28.28 23000683
2016-11-04 28.22 28.81 28.22 28.44 35864921
2016-11-07 28.85 29.33 28.83 29.31 41254153
2016-11-08 29.37 29.62 29.29 29.42 35829370
2016-11-09 29.32 29.81 29.07 29.63 54046508
2016-11-10 29.85 30.84 29.83 30.41 81324772
2016-11-11 30.49 30.77 30.37 30.71 42712372
2016-11-14 30.74 30.85 30.48 30.51 37740534
2016-11-15 30.48 30.77 30.24 30.75 40185971
2016-11-16 30.65 30.78 30.54 30.74 25265840
2016-11-17 30.70 30.87 30.66 30.79 17834070
2016-11-18 30.75 30.90 30.52 30.67 28583868
2016-11-21 30.69 30.88 30.58 30.87 22136288
2016-11-22 30.93 31.24 30.88 31.18 27721315
2016-11-23 31.24 31.38 31.18 31.34 24624934
2016-11-25 31.45 31.49 31.29 31.44 13162239
2016-11-28 31.33 31.43 31.21 31.25 22092675
2016-11-29 31.28 31.35 30.98 31.05 31423689
2016-11-30 31.18 31.27 30.75 30.76 45636890
2016-12-01 30.64 31.46 30.62 31.39 44701975
... ... ... ... ... ...
2017-09-06 24.89 25.02 24.82 24.92 55024972
2017-09-07 24.51 24.55 23.83 24.02 80108579
2017-09-08 23.95 24.00 23.58 23.82 44604454
2017-09-11 23.80 23.89 23.62 23.72 43306557
2017-09-12 23.82 23.91 23.71 23.91 49662623
2017-09-13 23.93 24.18 23.92 24.11 38629676
2017-09-14 24.10 24.27 23.94 24.26 42084528
2017-09-15 24.10 24.17 23.75 23.93 66559977
2017-09-18 23.96 24.55 23.93 24.46 52504484
2017-09-19 24.46 24.47 24.02 24.20 45340484
2017-09-20 24.20 24.41 24.19 24.32 39770268
2017-09-21 24.33 24.84 24.17 24.75 52115545
2017-09-22 24.84 25.04 24.77 24.87 39717546
2017-09-25 24.92 25.18 24.85 25.11 42487988
2017-09-26 25.15 25.21 24.92 24.93 40753220
2017-09-27 25.00 25.05 24.28 24.37 56322448
2017-09-28 24.39 24.45 24.16 24.24 36154413
2017-09-29 24.22 24.29 24.01 24.18 33673712
2017-10-02 24.22 24.61 24.10 24.57 42501167
2017-10-03 24.61 24.83 24.33 24.80 33907539
2017-10-04 24.88 24.89 24.43 24.48 32149416
2017-10-05 24.39 24.57 24.15 24.54 34758948
2017-10-06 24.41 24.54 24.13 24.39 40729835
2017-10-09 24.10 24.15 23.25 23.43 140302771
2017-10-10 23.70 23.86 23.32 23.36 80571106
2017-10-11 23.13 23.27 23.02 23.08 10458121
2017-10-12 23.05 23.09 22.83 23.05 59948728
2017-10-13 23.15 23.23 22.96 22.98 40391802
2017-10-16 22.99 23.48 22.93 23.36 49757813
2017-10-17 23.22 23.25 23.00 23.19 58639089
[250 rows x 5 columns],
'GS': Open High Low Close Volume
Date
2016-10-20 174.00 175.79 173.80 174.51 2471135
2016-10-21 172.84 174.90 172.51 174.67 2004401
2016-10-24 175.50 175.79 174.35 175.12 1943200
2016-10-25 175.04 175.96 174.64 175.55 2423299
2016-10-26 174.79 177.90 173.93 177.07 2533800
2016-10-27 178.19 178.85 176.57 177.75 3021949
2016-10-28 178.51 178.51 175.46 177.14 2042775
2016-10-31 177.68 178.50 177.23 178.24 1828180
2016-11-01 179.00 179.18 176.61 178.06 2900633
2016-11-02 177.07 177.50 176.07 176.58 2104770
2016-11-03 176.77 177.97 176.21 176.21 1972746
2016-11-04 176.33 177.34 174.73 175.92 1846465
2016-11-07 179.00 181.50 179.00 181.48 3338783
2016-11-08 180.11 182.68 178.46 181.92 2646158
2016-11-09 185.00 193.54 183.45 192.63 7823835
2016-11-10 194.53 204.67 194.00 200.87 11345422
2016-11-11 198.25 205.00 198.25 203.94 6290179
2016-11-14 204.15 211.77 204.15 209.18 8248097
2016-11-15 206.56 211.20 205.17 211.19 4893793
2016-11-16 207.35 208.08 204.83 206.26 5276156
2016-11-17 206.26 209.69 205.67 209.63 3560820
2016-11-18 209.87 212.07 209.72 210.35 4278161
2016-11-21 211.46 211.69 209.18 211.08 2860229
2016-11-22 211.36 211.95 209.89 211.11 2945664
2016-11-23 211.50 213.41 209.37 212.31 3734360
2016-11-25 211.36 212.75 211.00 211.38 1973959
2016-11-28 210.00 211.76 209.60 210.35 3297394
2016-11-29 209.99 212.92 209.92 211.75 2577591
2016-11-30 215.20 220.77 214.97 219.29 6507871
2016-12-01 220.93 227.16 220.35 226.63 7606546
... ... ... ... ... ...
2017-09-06 218.98 221.02 217.61 218.83 3613562
2017-09-07 218.73 218.81 214.64 215.84 3594587
2017-09-08 215.51 219.28 215.40 217.21 3120862
2017-09-11 220.07 221.89 218.99 221.06 2971497
2017-09-12 222.54 227.69 222.02 225.95 3745841
2017-09-13 225.25 227.14 224.72 226.56 2383468
2017-09-14 226.10 228.10 226.05 226.85 1986626
2017-09-15 227.15 227.21 223.82 225.22 4365813
2017-09-18 226.30 229.00 225.66 227.53 2466828
2017-09-19 228.01 230.14 227.33 228.91 1858009
2017-09-20 229.50 231.65 228.50 229.79 2682253
2017-09-21 229.89 232.10 229.40 231.29 1800822
2017-09-22 230.64 231.49 228.88 231.03 1861843
2017-09-25 230.77 231.86 228.36 230.26 2261753
2017-09-26 230.86 231.44 229.03 229.94 1770007
2017-09-27 234.07 235.60 232.91 234.76 3052297
2017-09-28 235.00 236.20 233.50 235.47 2121841
2017-09-29 235.01 237.60 234.57 237.19 1902308
2017-10-02 237.20 241.10 237.10 240.65 2501272
2017-10-03 241.07 242.71 239.69 241.62 2010771
2017-10-04 241.62 242.88 240.12 240.31 1840415
2017-10-05 241.00 246.32 240.12 246.06 3521265
2017-10-06 246.30 247.08 244.61 246.02 2396134
2017-10-09 245.15 246.35 242.02 242.80 2165180
2017-10-10 242.80 243.73 241.70 242.60 2187050
2017-10-11 242.00 242.50 241.35 241.89 149411
2017-10-12 242.33 243.42 238.75 239.80 2148150
2017-10-13 239.00 239.45 236.84 238.53 2491012
2017-10-16 238.60 242.76 238.35 242.41 2969192
2017-10-17 244.44 244.89 235.19 236.09 7088445
[250 rows x 5 columns],
'HD': Open High Low Close Volume
Date
2016-10-20 125.95 127.08 125.57 126.25 3543223
2016-10-21 125.31 126.80 125.25 126.60 3234121
2016-10-24 127.23 128.14 127.23 127.78 3824784
2016-10-25 126.27 126.27 123.29 123.34 8731869
2016-10-26 122.83 123.75 122.40 122.71 5456080
2016-10-27 122.71 123.46 121.85 122.26 4261602
2016-10-28 122.70 124.09 122.21 123.58 4497717
2016-10-31 123.35 123.50 121.62 122.01 5671525
2016-11-01 121.69 122.25 119.20 119.89 7492561
2016-11-02 119.93 121.29 119.82 120.29 4846031
2016-11-03 120.34 120.93 120.08 120.18 5113496
2016-11-04 120.54 121.90 120.06 120.91 4607581
2016-11-07 122.50 123.98 122.31 123.75 5510441
2016-11-08 123.95 125.42 123.60 124.25 6105908
2016-11-09 120.95 126.26 120.32 126.02 8052506
2016-11-10 126.72 130.10 126.51 129.03 8736986
2016-11-11 129.06 130.13 128.72 129.85 5496122
2016-11-14 130.50 130.64 126.94 127.67 11438461
2016-11-15 127.07 127.67 122.92 124.40 13445388
2016-11-16 123.60 125.70 123.28 125.33 9793361
2016-11-17 125.87 129.14 125.70 128.93 6739135
2016-11-18 128.93 129.36 127.72 128.33 4428888
2016-11-21 128.28 128.90 127.41 128.22 4072116
2016-11-22 128.38 131.30 128.38 130.98 5535796
2016-11-23 131.36 131.99 130.86 131.21 3610508
2016-11-25 131.86 132.14 131.07 131.57 2545977
2016-11-28 131.25 131.65 130.17 130.64 4858978
2016-11-29 130.35 130.78 129.25 129.62 4127122
2016-11-30 129.34 130.32 128.81 129.40 6973817
2016-12-01 129.34 130.35 129.00 129.47 5398674
... ... ... ... ... ...
2017-09-06 154.86 157.03 154.14 156.56 8126012
2017-09-07 158.17 159.28 156.79 157.93 8273080
2017-09-08 159.09 160.69 157.52 159.66 10088630
2017-09-11 158.42 158.74 156.22 158.37 8847928
2017-09-12 159.06 160.93 158.71 159.91 5794570
2017-09-13 160.39 161.38 159.55 160.02 4713676
2017-09-14 160.35 160.85 159.33 159.38 5290796
2017-09-15 159.98 159.99 158.29 158.40 9124244
2017-09-18 159.00 159.00 157.69 157.81 4010587
2017-09-19 157.80 158.32 157.16 157.66 3713412
2017-09-20 157.57 159.39 157.36 158.68 4599197
2017-09-21 158.87 159.56 158.72 159.19 3082093
2017-09-22 159.14 160.09 159.01 159.97 3576479
2017-09-25 160.05 161.43 159.75 161.10 4897741
2017-09-26 161.55 162.00 160.79 161.26 3222646
2017-09-27 161.38 161.69 160.14 160.92 3896420
2017-09-28 160.72 162.45 160.66 162.36 4614080
2017-09-29 162.50 163.61 162.15 163.56 3467426
2017-10-02 164.20 164.25 163.22 164.02 2721377
2017-10-03 164.06 165.28 164.00 165.17 3046381
2017-10-04 165.49 166.08 164.91 165.29 2746513
2017-10-05 165.07 166.25 164.26 166.12 3504865
2017-10-06 166.18 166.63 165.74 165.85 2916301
2017-10-09 166.14 166.63 165.42 165.71 2131837
2017-10-10 165.70 165.80 164.64 165.16 2755438
2017-10-11 165.19 165.86 165.19 165.38 195708
2017-10-12 165.41 165.41 164.47 164.59 3397775
2017-10-13 164.92 166.07 164.35 164.47 3259004
2017-10-16 164.47 164.67 163.26 164.22 2586716
2017-10-17 164.22 164.92 161.51 163.35 4189197
[250 rows x 5 columns],
'IBM': Open High Low Close Volume
Date
2016-10-20 151.28 152.90 151.02 151.52 4023103
2016-10-21 150.58 151.15 149.56 149.63 4414206
2016-10-24 150.40 151.52 150.40 150.57 2666740
2016-10-25 150.69 151.16 149.83 150.88 2647487
2016-10-26 150.71 152.94 150.26 151.81 2811728
2016-10-27 152.82 154.06 152.02 153.35 4229336
2016-10-28 154.05 154.44 152.18 152.61 3654496
2016-10-31 152.76 154.33 152.76 153.69 3553172
2016-11-01 153.50 153.91 151.74 152.79 3191924
2016-11-02 152.48 153.34 151.67 151.95 3074438
2016-11-03 152.51 153.74 151.80 152.37 2878803
2016-11-04 152.40 153.64 151.87 152.43 2470368
2016-11-07 153.99 156.11 153.84 155.72 3804943
2016-11-08 154.56 155.93 153.06 155.17 3921944
2016-11-09 152.96 155.56 151.00 154.81 5403688
2016-11-10 157.66 161.16 157.59 160.22 7715807
2016-11-11 159.97 161.34 159.33 161.27 4446630
2016-11-14 161.25 161.86 157.58 158.21 5196498
2016-11-15 158.42 159.15 157.55 158.67 3476996
2016-11-16 158.46 159.55 158.03 159.29 2252806
2016-11-17 159.22 159.93 158.85 159.80 2258716
2016-11-18 159.80 160.72 159.21 160.39 2981633
2016-11-21 160.69 163.00 160.37 162.77 4637097
2016-11-22 163.00 163.00 161.95 162.67 2770789
2016-11-23 161.94 162.38 161.36 161.98 2256165
2016-11-25 161.83 163.19 161.83 163.14 1605344
2016-11-28 163.20 164.66 162.70 164.52 4449355
2016-11-29 164.00 164.41 163.03 163.53 3148196
2016-11-30 163.35 163.80 162.21 162.22 4397817
2016-12-01 161.95 162.20 158.30 159.82 4635665
... ... ... ... ... ...
2017-09-06 143.88 144.47 143.50 143.82 3273344
2017-09-07 144.10 144.64 142.41 142.90 4188158
2017-09-08 143.15 143.15 141.64 142.45 3366169
2017-09-11 143.54 145.13 143.01 144.86 4613381
2017-09-12 145.11 146.37 144.51 145.76 5238148
2017-09-13 145.35 146.29 145.34 145.99 4100980
2017-09-14 145.86 146.38 145.51 145.54 3756861
2017-09-15 144.82 145.17 144.08 144.82 7397233
2017-09-18 144.81 145.48 144.27 144.55 3019514
2017-09-19 144.79 144.98 144.22 144.39 3464383
2017-09-20 144.93 145.88 144.42 145.88 5447519
2017-09-21 145.65 145.89 145.10 145.26 2555596
2017-09-22 145.59 145.59 144.59 145.13 2792323
2017-09-25 145.12 146.03 144.91 145.87 5213144
2017-09-26 146.36 147.42 145.94 146.56 4488620
2017-09-27 146.68 146.90 145.03 145.66 3486610
2017-09-28 145.33 145.86 144.21 145.66 2774788
2017-09-29 145.45 145.69 144.92 145.08 2654731
2017-10-02 145.35 146.86 145.21 146.66 2973224
2017-10-03 146.69 147.20 146.34 146.78 2302724
2017-10-04 147.00 147.02 146.11 146.48 2244433
2017-10-05 146.68 147.54 146.48 146.72 2686539
2017-10-06 146.64 146.85 146.32 146.48 2623184
2017-10-09 146.50 147.79 146.35 147.39 2682556
2017-10-10 147.71 148.95 147.65 148.50 4032601
2017-10-11 148.40 148.47 148.01 148.04 254256
2017-10-12 147.56 147.89 146.77 147.03 3264344
2017-10-13 147.48 147.85 146.94 147.10 2506584
2017-10-16 147.22 147.67 146.51 146.83 3052091
2017-10-17 146.63 147.12 146.18 146.54 6372393
[250 rows x 5 columns],
'INTC': Open High Low Close Volume
Date
2016-10-20 35.41 35.67 35.10 35.43 25669479
2016-10-21 35.21 35.40 34.81 35.15 20813248
2016-10-24 35.43 35.49 35.11 35.26 21524741
2016-10-25 35.14 35.25 35.01 35.10 17860312
2016-10-26 35.04 35.20 34.74 34.92 19977604
2016-10-27 35.10 35.23 34.75 34.81 14634685
2016-10-28 34.87 35.17 34.71 34.74 22296428
2016-10-31 34.92 35.08 34.84 34.87 19188602
2016-11-01 34.90 35.16 34.27 34.52 25368222
2016-11-02 34.60 34.90 34.47 34.60 21416408
2016-11-03 34.45 34.52 33.87 33.93 19400032
2016-11-04 33.53 33.93 33.42 33.61 21914746
2016-11-07 34.24 34.75 34.15 34.69 19296598
2016-11-08 34.60 34.95 34.49 34.74 14833126
2016-11-09 34.13 34.85 33.67 34.75 25999427
2016-11-10 34.95 34.95 34.02 34.50 28250229
2016-11-11 34.57 34.87 34.34 34.61 22665026
2016-11-14 34.56 34.73 34.20 34.48 22558941
2016-11-15 34.64 35.29 34.61 34.91 20676112
2016-11-16 34.90 34.92 34.54 34.84 18565450
2016-11-17 34.81 35.02 34.63 35.02 15748521
2016-11-18 34.90 35.00 34.64 34.95 16806853
2016-11-21 35.10 35.20 34.84 34.98 14259526
2016-11-22 35.18 35.50 35.11 35.48 22327447
2016-11-23 35.48 35.52 35.10 35.20 15843618
2016-11-25 35.11 35.45 35.11 35.44 6372836
2016-11-28 35.43 35.66 35.21 35.51 13549048
2016-11-29 35.64 35.64 35.27 35.31 19581040
2016-11-30 35.20 35.30 34.70 34.70 27016070
2016-12-01 34.86 34.93 33.56 33.76 29618687
... ... ... ... ... ...
2017-09-06 35.22 35.94 35.11 35.76 28076438
2017-09-07 35.88 35.95 35.33 35.54 16297077
2017-09-08 35.19 35.54 35.08 35.19 14125018
2017-09-11 35.49 36.00 35.14 35.77 20037575
2017-09-12 35.88 36.34 35.74 36.09 19489892
2017-09-13 36.00 36.40 35.97 36.33 15509787
2017-09-14 36.19 36.70 36.16 36.48 18093946
2017-09-15 36.55 37.08 36.22 37.00 33596072
2017-09-18 37.00 37.33 36.80 37.00 19393834
2017-09-19 37.20 37.30 37.02 37.23 23850525
2017-09-20 37.23 37.29 36.66 37.07 23957476
2017-09-21 36.99 37.27 36.85 37.20 22954158
2017-09-22 36.95 37.22 36.95 37.18 21631754
2017-09-25 37.05 37.23 36.85 37.16 23180838
2017-09-26 37.21 37.64 37.00 37.47 29790369
2017-09-27 37.62 37.69 37.10 37.54 25727062
2017-09-28 37.32 37.88 37.29 37.83 21171441
2017-09-29 37.84 38.15 37.70 38.08 23217336
2017-10-02 38.12 39.09 38.08 39.04 37394514
2017-10-03 38.95 39.70 38.95 39.38 34002193
2017-10-04 39.39 39.40 38.86 39.34 28368824
2017-10-05 39.50 39.65 39.21 39.53 17710277
2017-10-06 39.60 39.89 39.42 39.63 18887536
2017-10-09 39.68 39.88 39.52 39.86 18494080
2017-10-10 39.93 39.95 39.38 39.65 29890017
2017-10-11 39.48 39.67 39.06 39.30 30754708
2017-10-12 39.35 39.39 38.98 39.19 18286944
2017-10-13 39.44 39.81 39.28 39.67 16829366
2017-10-16 39.71 39.79 39.44 39.76 12489135
2017-10-17 39.56 39.86 39.37 39.79 15532818
[250 rows x 5 columns],
'JNJ': Open High Low Close Volume
Date
2016-10-20 114.83 115.70 114.59 114.87 6973009
2016-10-21 114.11 114.24 112.99 113.44 8422032
2016-10-24 113.93 114.19 113.44 113.61 6141858
2016-10-25 113.64 114.16 113.09 113.96 5594989
2016-10-26 113.64 115.22 113.60 114.56 6429241
2016-10-27 114.98 116.55 114.79 115.70 7548667
2016-10-28 115.82 115.91 114.57 115.33 8813324
2016-10-31 115.28 116.23 114.50 115.99 8552528
2016-11-01 114.76 115.94 114.63 115.34 7591930
2016-11-02 115.52 115.76 114.83 114.86 6591318
2016-11-03 114.88 115.44 114.75 115.03 6227110
2016-11-04 115.04 115.94 115.04 115.11 7160570
2016-11-07 115.89 116.72 115.84 116.66 6398177
2016-11-08 116.48 117.57 116.47 117.05 6675268
2016-11-09 120.00 122.50 118.10 120.31 16219977
2016-11-10 120.77 121.10 119.02 119.54 11905170
2016-11-11 119.49 119.49 118.13 118.47 8134783
2016-11-14 118.58 118.99 116.50 116.60 10054905
2016-11-15 116.40 116.69 115.82 116.32 7446670
2016-11-16 116.65 116.78 116.08 116.36 6594838
2016-11-17 116.68 116.68 116.12 116.57 5702591
2016-11-18 115.79 115.92 114.81 115.36 7717773
2016-11-21 115.44 115.68 114.80 115.00 5843313
2016-11-22 114.59 115.00 112.27 112.74 11649748
2016-11-23 112.25 113.43 111.56 113.07 8467037
2016-11-25 113.60 114.23 113.38 114.13 3433340
2016-11-28 113.79 114.12 113.05 113.13 9065730
2016-11-29 112.95 113.41 112.16 112.48 7799649
2016-11-30 112.19 112.52 111.30 111.30 11178468
2016-12-01 111.36 111.54 111.00 111.38 8143287
... ... ... ... ... ...
2017-09-06 130.54 131.00 130.21 130.67 5601903
2017-09-07 130.86 132.52 130.25 132.19 3800234
2017-09-08 132.00 132.34 130.87 130.98 4854414
2017-09-11 131.37 133.34 131.02 133.21 5724233
2017-09-12 133.83 133.88 131.93 132.63 5465190
2017-09-13 132.67 133.75 131.85 132.45 4679486
2017-09-14 132.14 134.47 131.99 134.18 6274510
2017-09-15 134.79 135.45 134.18 134.45 15522011
2017-09-18 134.44 135.77 134.11 135.38 5261593
2017-09-19 135.02 135.79 134.35 135.22 4903837
2017-09-20 133.25 134.29 132.34 133.22 8705535
2017-09-21 133.31 133.82 131.38 131.75 6051811
2017-09-22 131.99 132.39 131.27 131.39 4334862
2017-09-25 131.47 131.76 130.83 131.17 6017418
2017-09-26 131.50 131.94 130.82 130.94 4516193
2017-09-27 131.00 131.09 129.43 129.75 5761051
2017-09-28 129.91 130.27 129.29 129.47 3992740
2017-09-29 129.58 130.47 129.05 130.01 5736925
2017-10-02 130.16 131.33 130.02 131.22 4492936
2017-10-03 131.65 132.40 131.36 132.10 3900761
2017-10-04 132.40 133.18 132.10 132.89 3589047
2017-10-05 132.89 133.31 132.36 133.19 3741108
2017-10-06 133.00 133.25 132.48 133.22 2469506
2017-10-09 133.66 133.82 133.17 133.45 3751097
2017-10-10 133.56 134.13 132.92 133.90 4184588
2017-10-11 134.88 136.39 134.37 136.04 1023583
2017-10-12 136.34 137.52 136.02 136.83 5172806
2017-10-13 136.60 137.42 136.34 136.43 4106625
2017-10-16 136.45 137.26 135.54 136.12 5120140
2017-10-17 137.67 141.12 137.06 140.79 11717348
[250 rows x 5 columns],
'JPM': Open High Low Close Volume
Date
2016-10-20 68.08 68.68 67.94 68.26 14122005
2016-10-21 67.81 68.53 67.70 68.49 12175674
2016-10-24 68.97 69.05 68.50 68.87 10197123
2016-10-25 68.88 68.93 68.38 68.80 9945050
2016-10-26 68.37 69.25 68.37 69.13 9801266
2016-10-27 69.49 69.77 69.10 69.23 14210699
2016-10-28 69.53 69.55 68.46 69.11 12766498
2016-10-31 69.43 69.58 69.23 69.26 14336299
2016-11-01 69.48 69.78 68.33 68.97 15564491
2016-11-02 68.65 68.85 68.01 68.68 12449788
2016-11-03 68.86 69.19 68.22 68.38 10369670
2016-11-04 68.49 68.56 67.64 67.76 13571306
2016-11-07 69.08 69.97 69.00 69.88 16515137
2016-11-08 69.70 70.54 69.24 70.03 17531748
2016-11-09 71.46 74.15 71.32 73.25 50948378
2016-11-10 74.22 77.25 74.22 76.65 56192320
2016-11-11 76.30 76.72 75.77 76.69 27574323
2016-11-14 77.25 80.44 77.25 79.51 46130653
2016-11-15 78.37 79.41 77.78 79.36 28126307
2016-11-16 78.22 78.35 76.88 77.40 26054926
2016-11-17 77.93 78.46 77.60 78.02 19226190
2016-11-18 77.96 78.42 77.55 77.71 19769965
2016-11-21 78.00 78.17 77.29 78.05 11983529
2016-11-22 78.34 78.56 77.76 78.53 14410100
2016-11-23 78.87 79.24 77.89 78.86 13401387
2016-11-25 79.10 79.45 78.47 78.83 6185719
2016-11-28 78.18 78.87 78.02 78.32 13007242
2016-11-29 78.39 79.16 78.39 78.92 14144062
2016-11-30 79.92 80.53 79.70 80.17 25351899
2016-12-01 80.65 82.28 80.65 81.79 23823632
... ... ... ... ... ...
2017-09-06 90.00 90.52 89.64 90.11 11845663
2017-09-07 90.11 90.13 88.08 88.53 14592255
2017-09-08 88.31 89.42 88.24 88.42 14242198
2017-09-11 89.39 90.25 88.95 89.79 13219047
2017-09-12 90.17 91.25 90.10 90.89 14003776
2017-09-13 90.61 91.50 90.32 91.15 12485428
2017-09-14 91.20 91.53 90.74 90.97 10562826
2017-09-15 91.08 91.71 90.76 91.62 18171794
2017-09-18 91.93 93.14 91.85 92.92 11318699
2017-09-19 92.71 94.36 92.52 93.94 12626131
2017-09-20 94.10 95.29 93.71 94.60 15311581
2017-09-21 94.46 95.37 94.19 95.03 10851489
2017-09-22 94.70 94.98 94.43 94.83 8358310
2017-09-25 94.51 94.88 93.45 94.12 10463432
2017-09-26 93.78 94.03 93.34 93.70 9358111
2017-09-27 94.97 95.72 94.58 95.18 14928264
2017-09-28 95.59 95.88 94.91 95.38 10270398
2017-09-29 95.30 95.52 95.02 95.51 11438412
2017-10-02 95.77 96.88 95.46 96.84 13797213
2017-10-03 96.83 97.43 96.77 97.35 9633452
2017-10-04 97.30 97.44 96.28 96.36 12166633
2017-10-05 96.00 97.40 95.55 97.09 14236219
2017-10-06 97.55 97.64 96.47 96.92 10231853
2017-10-09 96.96 97.07 96.14 96.41 7765100
2017-10-10 96.46 97.18 96.24 97.13 10631527
2017-10-11 96.83 96.91 96.22 96.26 1493431
2017-10-12 97.30 97.50 95.62 95.99 18251616
2017-10-13 95.48 96.71 94.96 95.86 13190576
2017-10-16 96.34 97.95 96.34 97.84 12434009
2017-10-17 98.07 98.18 97.32 97.62 10335687
[250 rows x 5 columns],
'KO': Open High Low Close Volume
Date
2016-10-20 41.97 42.11 41.89 41.93 10620494
2016-10-21 41.85 42.17 41.68 42.13 14401515
2016-10-24 42.32 42.77 42.25 42.56 13439196
2016-10-25 42.64 42.88 42.43 42.54 16484713
2016-10-26 43.00 43.03 42.41 42.44 16886249
2016-10-27 42.63 42.64 41.90 42.12 14537030
2016-10-28 42.26 42.47 42.10 42.23 13398353
2016-10-31 42.12 42.41 42.12 42.40 13327475
2016-11-01 42.40 42.42 41.91 42.12 12223368
2016-11-02 42.10 42.34 42.01 42.05 12034271
2016-11-03 42.22 42.22 41.96 42.03 11257978
2016-11-04 41.85 42.04 41.69 41.69 14464185
2016-11-07 42.04 42.50 42.04 42.46 14038532
2016-11-08 42.37 42.98 42.37 42.88 12036581
2016-11-09 41.76 42.32 41.70 42.27 21350962
2016-11-10 41.86 42.26 40.86 40.94 33245534
2016-11-11 40.95 41.13 40.63 41.03 13420962
2016-11-14 41.13 41.42 40.85 41.17 19514172
2016-11-15 41.18 41.52 41.17 41.44 16553962
2016-11-16 41.40 41.65 41.16 41.26 12681351
2016-11-17 41.28 41.30 41.00 41.12 12398821
2016-11-18 41.03 41.20 40.90 40.91 16345262
2016-11-21 40.74 41.36 40.73 41.36 12307041
2016-11-22 41.45 41.70 41.24 41.37 12743512
2016-11-23 41.22 41.31 41.03 41.12 9294081
2016-11-25 41.39 41.58 41.24 41.53 7402652
2016-11-28 41.51 41.79 41.27 41.75 19424412
2016-11-29 41.52 41.52 41.14 41.15 11421921
2016-11-30 41.00 41.20 40.35 40.35 22410367
2016-12-01 40.31 40.39 39.88 40.17 20409864
... ... ... ... ... ...
2017-09-06 45.98 46.04 45.79 45.96 9238867
2017-09-07 46.01 46.32 45.96 46.28 9418365
2017-09-08 46.19 46.37 46.02 46.30 10534915
2017-09-11 46.35 46.59 46.22 46.52 10430254
2017-09-12 46.50 46.75 46.45 46.72 8567619
2017-09-13 46.68 46.98 46.65 46.87 10217985
2017-09-14 46.40 46.46 45.94 46.11 13768837
2017-09-15 46.30 46.36 46.00 46.18 16141413
2017-09-18 46.15 46.24 45.91 46.11 8535331
2017-09-19 46.14 46.19 45.89 45.98 7297932
2017-09-20 45.76 46.14 45.55 45.78 11026594
2017-09-21 45.71 45.79 45.36 45.40 7555292
2017-09-22 45.45 45.63 45.37 45.49 8024827
2017-09-25 45.50 45.76 45.35 45.69 9215326
2017-09-26 45.69 45.87 45.56 45.57 6480138
2017-09-27 45.47 45.50 44.38 44.64 14642578
2017-09-28 44.67 45.00 44.65 44.91 8789517
2017-09-29 44.86 45.11 44.79 45.01 10082221
2017-10-02 45.05 45.26 44.74 44.80 10707763
2017-10-03 44.86 45.26 44.76 45.19 12038102
2017-10-04 45.11 45.56 44.94 45.50 14060338
2017-10-05 45.51 45.74 45.50 45.52 10215323
2017-10-06 45.39 45.52 45.28 45.49 5437871
2017-10-09 45.55 45.65 45.34 45.41 5268348
2017-10-10 45.60 45.90 45.52 45.87 6310445
2017-10-11 45.88 46.10 45.87 46.05 599515
2017-10-12 45.98 46.14 45.94 46.11 7710216
2017-10-13 46.25 46.38 46.15 46.18 7126020
2017-10-16 46.12 46.75 46.10 46.62 12708563
2017-10-17 46.53 46.63 46.31 46.52 7699367
[250 rows x 5 columns],
'MCD': Open High Low Close Volume
Date
2016-10-20 111.30 111.30 110.33 110.57 7250742
2016-10-21 113.27 114.50 112.75 113.93 10108048
2016-10-24 114.25 114.50 112.64 113.57 6173488
2016-10-25 113.50 113.54 112.67 112.72 4878955
2016-10-26 112.27 112.70 111.40 112.11 3763114
2016-10-27 112.17 112.49 111.78 112.08 2960726
2016-10-28 112.26 112.35 111.53 112.10 3304686
2016-10-31 112.46 112.73 111.79 112.57 4181577
2016-11-01 112.65 112.77 111.95 112.25 3935634
2016-11-02 112.10 112.77 111.82 112.39 3512534
2016-11-03 112.74 112.85 111.52 111.72 3890687
2016-11-04 111.99 112.00 110.83 111.04 3457385
2016-11-07 112.00 113.28 111.88 112.82 3842380
2016-11-08 113.01 114.25 113.00 114.11 3300157
2016-11-09 112.09 115.42 111.80 114.98 5099493
2016-11-10 115.03 115.04 113.78 114.51 4437714
2016-11-11 114.67 114.96 114.17 114.22 4331192
2016-11-14 114.99 118.75 114.72 117.86 7093249
2016-11-15 117.58 118.48 117.02 118.32 4447865
2016-11-16 118.86 119.60 118.46 119.21 5371085
2016-11-17 118.89 119.50 118.28 119.45 2833579
2016-11-18 119.26 120.24 118.91 120.00 3655358
2016-11-21 119.80 120.50 118.96 119.50 3603269
2016-11-22 119.50 120.29 118.88 119.69 3699103
2016-11-23 119.73 120.76 119.73 120.14 2872059
2016-11-25 120.08 120.99 119.92 120.66 1709105
2016-11-28 120.38 121.87 120.23 121.82 5931717
2016-11-29 120.38 120.79 119.02 120.68 6370935
2016-11-30 120.22 120.49 119.27 119.27 5696096
2016-12-01 118.96 118.96 117.87 118.47 4444978
... ... ... ... ... ...
2017-09-06 159.23 159.37 158.22 158.22 4143348
2017-09-07 158.47 160.06 158.33 159.90 2965378
2017-09-08 159.53 160.38 159.18 159.71 2984223
2017-09-11 160.00 161.72 159.92 161.53 2333557
2017-09-12 160.21 160.72 155.77 156.33 10324140
2017-09-13 156.74 157.78 156.00 157.00 4705601
2017-09-14 157.00 157.35 156.05 157.00 3109655
2017-09-15 157.79 158.00 156.88 156.92 7425112
2017-09-18 157.72 157.79 156.35 156.68 3832243
2017-09-19 157.27 157.90 156.33 157.43 3554601
2017-09-20 157.90 159.89 157.76 159.88 3641093
2017-09-21 159.87 160.09 158.51 159.03 2503437
2017-09-22 158.88 159.74 158.56 158.91 2442658
2017-09-25 158.47 158.69 156.10 156.26 3661538
2017-09-26 156.25 156.84 153.27 153.35 6420043
2017-09-27 153.51 154.69 153.44 154.05 3892677
2017-09-28 156.16 158.31 155.48 157.49 4210238
2017-09-29 157.51 158.04 156.12 156.68 3670057
2017-10-02 156.00 157.18 155.80 156.96 2406969
2017-10-03 156.75 157.46 156.36 156.86 2188429
2017-10-04 156.83 157.42 156.65 157.21 1823061
2017-10-05 157.30 158.92 157.30 158.80 2796033
2017-10-06 158.58 160.13 158.58 159.60 3548478
2017-10-09 159.61 160.49 159.50 160.12 2120035
2017-10-10 159.69 161.58 159.59 160.58 2910445
2017-10-11 160.90 163.24 160.58 162.73 648618
2017-10-12 162.99 164.40 162.77 163.91 3023607
2017-10-13 164.45 165.51 164.08 165.37 2957929
2017-10-16 165.44 165.74 164.44 165.01 2133063
2017-10-17 164.92 166.02 164.75 165.40 2379725
[250 rows x 5 columns],
'MMM': Open High Low Close Volume
Date
2016-10-20 169.57 170.34 168.99 169.86 1210539
2016-10-21 168.11 169.56 167.72 169.50 2013555
2016-10-24 172.65 173.44 170.90 171.27 2668523
2016-10-25 169.47 169.89 165.11 166.23 3826166
2016-10-26 165.69 167.79 165.41 166.51 2174852
2016-10-27 166.87 166.95 165.28 165.76 1486376
2016-10-28 166.55 167.18 165.14 165.77 1934281
2016-10-31 166.46 166.54 165.18 165.30 2289132
2016-11-01 165.40 165.81 163.85 164.25 2455784
2016-11-02 164.70 166.37 163.91 165.73 2233414
2016-11-03 166.14 167.64 165.26 166.83 2504984
2016-11-04 167.21 167.85 166.42 166.48 1927527
2016-11-07 168.15 169.89 167.98 169.74 1930929
2016-11-08 169.90 172.05 169.78 171.03 1956187
2016-11-09 165.84 171.00 165.84 170.39 3659314
2016-11-10 170.16 174.67 169.79 174.28 3280034
2016-11-11 174.05 175.13 173.73 175.08 1868162
2016-11-14 175.23 175.51 171.90 172.91 2607032
2016-11-15 173.16 174.25 171.91 174.24 2177504
2016-11-16 173.13 173.23 171.57 172.01 2022623
2016-11-17 172.01 173.25 172.01 172.77 1782191
2016-11-18 172.51 173.28 172.29 172.96 1711068
2016-11-21 171.42 171.98 170.72 171.52 1993936
2016-11-22 171.67 172.08 171.28 171.91 1553303
2016-11-23 172.08 172.75 171.76 172.25 1477958
2016-11-25 172.21 173.99 172.21 173.49 945845
2016-11-28 173.56 173.77 172.28 172.50 1677696
2016-11-29 172.54 173.29 172.15 172.77 1483189
2016-11-30 172.20 173.19 171.59 171.74 2595787
2016-12-01 171.64 172.74 171.45 172.63 1756890
... ... ... ... ... ...
2017-09-06 201.75 202.25 201.24 202.05 2236180
2017-09-07 201.47 204.71 201.47 204.46 1701542
2017-09-08 204.35 206.12 203.16 205.69 1473989
2017-09-11 206.46 209.78 206.09 209.56 1806743
2017-09-12 209.91 210.96 209.26 209.64 1441453
2017-09-13 209.12 210.29 208.57 209.49 1129646
2017-09-14 209.15 211.91 208.74 211.43 1984226
2017-09-15 212.59 214.12 210.66 213.35 3636437
2017-09-18 214.00 214.04 212.57 213.76 1272436
2017-09-19 214.23 214.65 212.85 213.56 1429651
2017-09-20 211.77 212.60 208.31 210.51 2987210
2017-09-21 210.90 211.62 210.24 210.44 1382444
2017-09-22 209.64 211.30 209.28 210.76 1493283
2017-09-25 210.98 211.22 209.37 210.73 1609155
2017-09-26 211.26 212.83 210.93 211.03 1224628
2017-09-27 211.09 211.38 208.16 209.48 1841463
2017-09-28 208.30 209.88 208.25 209.55 2092803
2017-09-29 209.06 209.90 208.73 209.90 1632249
2017-10-02 210.73 212.79 210.03 212.76 1292105
2017-10-03 212.62 214.60 211.38 214.57 1634888
2017-10-04 214.85 216.94 214.50 216.52 1636447
2017-10-05 216.49 217.61 215.90 216.37 1740484
2017-10-06 216.00 216.54 215.27 216.52 1650834
2017-10-09 215.96 217.21 215.69 216.68 1054620
2017-10-10 217.38 217.60 216.55 216.75 1171324
2017-10-11 216.75 216.86 216.30 216.32 87083
2017-10-12 216.60 217.64 216.29 217.59 1907960
2017-10-13 218.83 219.76 216.80 217.72 1461703
2017-10-16 217.70 218.73 217.20 218.72 1185228
2017-10-17 218.49 218.72 216.47 217.75 2150810
[250 rows x 5 columns],
'MRK': Open High Low Close Volume
Date
2016-10-20 61.95 62.26 61.69 61.92 6323380
2016-10-21 61.55 61.90 61.03 61.20 7406681
2016-10-24 61.40 61.48 60.64 60.75 9942972
2016-10-25 60.27 62.19 59.55 61.95 15188534
2016-10-26 61.74 61.85 60.55 60.87 9957770
2016-10-27 61.15 62.06 61.00 61.29 10350697
2016-10-28 61.02 61.07 58.45 58.84 20358443
2016-10-31 59.09 59.15 58.37 58.72 14254834
2016-11-01 59.00 59.58 58.51 59.30 14347359
2016-11-02 59.06 59.51 58.75 58.84 10724665
2016-11-03 59.18 59.22 58.29 58.43 11323033
2016-11-04 58.69 59.26 58.61 58.82 11318595
2016-11-07 59.52 60.21 59.48 60.05 10478263
2016-11-08 59.82 60.78 59.52 60.51 7942104
2016-11-09 63.96 65.00 62.76 64.18 27851126
2016-11-10 64.54 65.46 64.52 64.96 17862251
2016-11-11 64.08 64.51 63.58 63.95 14059705
2016-11-14 64.00 64.09 63.24 63.53 10124450
2016-11-15 63.68 63.73 63.08 63.65 7290447
2016-11-16 63.70 63.95 62.45 62.63 10780233
2016-11-17 62.51 62.79 62.12 62.70 8361274
2016-11-18 62.57 62.62 61.73 61.87 7696863
2016-11-21 61.94 62.39 61.72 62.30 6836678
2016-11-22 62.50 62.65 61.20 61.70 9592213
2016-11-23 60.33 61.70 59.82 61.64 10242995
2016-11-25 61.82 62.40 61.75 62.21 3501268
2016-11-28 61.78 62.06 61.62 61.80 7449431
2016-11-29 61.95 62.46 61.92 62.19 10034927
2016-11-30 62.31 62.32 60.99 61.19 12530731
2016-12-01 61.30 61.37 60.65 60.76 8398879
... ... ... ... ... ...
2017-09-06 63.89 64.33 63.76 64.00 7148699
2017-09-07 64.09 64.42 63.78 64.32 6856376
2017-09-08 63.99 64.53 63.94 64.27 7365817
2017-09-11 64.94 65.31 64.68 65.13 10291625
2017-09-12 65.12 65.62 65.12 65.46 7354151
2017-09-13 65.36 65.55 65.30 65.45 5628692
2017-09-14 64.99 66.17 64.91 66.12 9959122
2017-09-15 66.17 66.38 65.75 66.16 14685767
2017-09-18 66.02 66.41 65.80 65.99 10543216
2017-09-19 66.02 66.16 65.68 65.95 7009284
2017-09-20 66.07 66.31 65.19 65.79 9450016
2017-09-21 65.85 65.93 65.52 65.60 5968693
2017-09-22 65.63 65.70 65.06 65.13 7465921
2017-09-25 65.16 65.40 65.04 65.18 5573399
2017-09-26 65.10 65.32 64.72 64.76 6976185
2017-09-27 64.68 64.75 64.32 64.57 6644554
2017-09-28 64.27 64.66 64.17 64.29 7022769
2017-09-29 64.29 64.53 63.33 64.03 11449603
2017-10-02 64.21 64.68 63.89 64.55 6743391
2017-10-03 64.55 64.58 63.78 64.37 6507064
2017-10-04 64.42 64.62 64.33 64.60 6414724
2017-10-05 64.42 64.80 64.33 64.60 9150023
2017-10-06 64.70 64.90 64.37 64.55 7488442
2017-10-09 64.67 64.74 64.12 64.33 5451299
2017-10-10 64.31 64.48 64.20 64.46 4921049
2017-10-11 64.34 64.34 63.93 63.93 639308
2017-10-12 63.79 63.98 63.56 63.83 6158543
2017-10-13 63.95 64.16 63.38 63.39 7341381
2017-10-16 63.49 63.73 63.26 63.34 7449197
2017-10-17 63.21 63.31 62.88 63.22 7028492
[250 rows x 5 columns],
'MSFT': Open High Low Close Volume
Date
2016-10-20 57.50 57.52 56.66 57.25 49455612
2016-10-21 60.28 60.45 59.48 59.66 80032206
2016-10-24 59.94 61.00 59.93 61.00 54066978
2016-10-25 60.85 61.37 60.80 60.99 35137164
2016-10-26 60.81 61.20 60.47 60.63 29911608
2016-10-27 60.61 60.83 60.09 60.10 28479856
2016-10-28 60.01 60.52 59.58 59.87 33574684
2016-10-31 60.16 60.42 59.92 59.92 26434697
2016-11-01 59.97 60.02 59.25 59.80 24532986
2016-11-02 59.82 59.93 59.30 59.43 22147005
2016-11-03 59.53 59.64 59.11 59.21 21600427
2016-11-04 58.65 59.28 58.52 58.71 28697016
2016-11-07 59.78 60.52 59.78 60.42 31664798
2016-11-08 60.55 60.78 60.15 60.47 22935355
2016-11-09 60.00 60.59 59.20 60.17 49632479
2016-11-10 60.48 60.49 57.63 58.70 57822394
2016-11-11 58.23 59.12 58.01 59.02 38767843
2016-11-14 59.02 59.08 57.28 58.12 41328422
2016-11-15 58.33 59.49 58.32 58.87 35904126
2016-11-16 58.94 59.66 58.81 59.65 27332475
2016-11-17 60.41 60.95 59.96 60.64 31463728
2016-11-18 60.78 61.14 60.30 60.35 27686311
2016-11-21 60.50 60.97 60.42 60.86 19652595
2016-11-22 60.98 61.26 60.80 61.12 23206700
2016-11-23 61.01 61.10 60.25 60.40 21848913
2016-11-25 60.30 60.53 60.13 60.53 8409616
2016-11-28 60.34 61.02 60.21 60.61 20732619
2016-11-29 60.65 61.41 60.52 61.09 22366721
2016-11-30 60.86 61.18 60.22 60.26 34655435
2016-12-01 60.11 60.15 58.94 59.20 34542121
... ... ... ... ... ...
2017-09-06 73.74 74.04 73.35 73.40 16535785
2017-09-07 73.68 74.60 73.60 74.34 17471200
2017-09-08 74.33 74.44 73.84 73.98 14703816
2017-09-11 74.31 74.94 74.31 74.76 17910383
2017-09-12 74.76 75.24 74.37 74.68 14394850
2017-09-13 74.93 75.23 74.55 75.21 13380802
2017-09-14 75.00 75.49 74.52 74.77 15733914
2017-09-15 74.83 75.39 74.07 75.31 38578441
2017-09-18 75.23 75.97 75.04 75.16 23306959
2017-09-19 75.21 75.71 75.01 75.44 16093344
2017-09-20 75.35 75.55 74.31 74.94 21587878
2017-09-21 75.11 75.24 74.11 74.21 19186140
2017-09-22 73.99 74.51 73.85 74.41 14111365
2017-09-25 74.09 74.25 72.92 73.26 24149163
2017-09-26 73.67 73.81 72.99 73.26 18019577
2017-09-27 73.55 74.17 73.17 73.85 19375099
2017-09-28 73.54 73.97 73.31 73.87 10883787
2017-09-29 73.94 74.54 73.88 74.49 17079114
2017-10-02 74.71 75.01 74.30 74.61 15304762
2017-10-03 74.67 74.88 74.20 74.26 12190403
2017-10-04 74.09 74.72 73.71 74.69 13317681
2017-10-05 75.22 76.12 74.96 75.97 21195261
2017-10-06 75.67 76.03 75.54 76.00 13959814
2017-10-09 75.97 76.55 75.86 76.29 11386502
2017-10-10 76.33 76.63 76.14 76.29 13944545
2017-10-11 76.36 76.46 75.95 76.42 15388898
2017-10-12 76.49 77.29 76.37 77.12 16876538
2017-10-13 77.59 77.87 77.29 77.49 15335742
2017-10-16 77.42 77.81 77.35 77.65 12380093
2017-10-17 77.47 77.62 77.25 77.59 16823989
[250 rows x 5 columns],
'NKE': Open High Low Close Volume
Date
2016-10-20 51.77 52.36 51.69 51.89 6590489
2016-10-21 51.74 51.87 51.25 51.77 9161003
2016-10-24 52.16 52.29 51.83 51.87 7578184
2016-10-25 50.97 51.44 50.71 51.05 14975302
2016-10-26 50.95 52.27 50.90 51.97 12401117
2016-10-27 52.34 52.34 51.69 51.89 7939188
2016-10-28 52.12 52.50 51.79 52.02 9096719
2016-10-31 50.88 51.15 50.00 50.18 17931262
2016-11-01 50.50 50.51 49.14 49.62 14100431
2016-11-02 49.24 50.27 49.01 49.72 10775938
2016-11-03 49.98 50.00 49.31 49.73 7678690
2016-11-04 49.80 50.45 49.76 49.96 9925196
2016-11-07 50.48 50.93 50.28 50.91 8358692
2016-11-08 51.10 51.49 50.95 51.08 8111362
2016-11-09 50.07 51.27 49.80 51.12 9058575
2016-11-10 51.29 51.37 50.33 50.39 12316075
2016-11-11 50.22 50.85 50.18 50.77 6300607
2016-11-14 51.18 51.19 50.21 50.21 8063943
2016-11-15 50.46 50.64 49.75 50.13 9299754
2016-11-16 50.00 50.80 49.95 50.68 6760291
2016-11-17 50.94 51.67 50.72 51.59 7641504
2016-11-18 51.39 51.89 50.96 51.10 7461602
2016-11-21 51.00 51.42 50.95 51.28 5357204
2016-11-22 51.47 51.75 51.05 51.71 5228142
2016-11-23 51.71 51.85 51.20 51.34 4148968
2016-11-25 51.68 51.74 51.35 51.52 2736767
2016-11-28 51.44 51.44 50.61 51.01 8602118
2016-11-29 51.20 51.37 50.57 50.63 6065682
2016-11-30 50.52 50.81 50.07 50.07 8198418
2016-12-01 50.11 51.25 50.06 50.65 7610063
... ... ... ... ... ...
2017-09-06 53.12 53.34 52.71 52.76 7407562
2017-09-07 52.76 52.85 52.34 52.39 6905762
2017-09-08 52.25 52.51 52.11 52.20 8563283
2017-09-11 52.38 53.13 52.32 53.03 8649915
2017-09-12 53.77 54.09 53.30 53.40 7823691
2017-09-13 53.45 53.64 53.04 53.52 6085952
2017-09-14 53.54 53.89 53.12 53.73 7497401
2017-09-15 53.86 54.06 53.52 53.87 10046827
2017-09-18 53.87 54.16 53.40 53.50 8166438
2017-09-19 52.78 54.05 52.51 53.33 14707174
2017-09-20 53.49 53.64 53.04 53.56 7058002
2017-09-21 53.55 53.64 53.09 53.19 8065367
2017-09-22 53.02 53.61 52.80 53.24 10962392
2017-09-25 53.08 53.56 53.00 53.23 12262360
2017-09-26 53.18 53.97 52.98 53.70 16183717
2017-09-27 52.17 52.69 51.03 52.67 36088002
2017-09-28 52.80 53.03 52.33 52.63 11334704
2017-09-29 52.59 52.82 51.76 51.85 12189882
2017-10-02 52.16 52.21 51.66 51.87 7516205
2017-10-03 52.00 52.05 51.40 51.47 8126729
2017-10-04 51.51 52.13 51.40 52.08 8204280
2017-10-05 52.01 52.32 51.78 52.18 5287422
2017-10-06 52.20 52.46 52.12 52.42 5360267
2017-10-09 52.23 52.30 51.50 51.52 6875105
2017-10-10 51.58 51.82 51.37 51.53 8372726
2017-10-11 51.39 51.52 51.06 51.13 833886
2017-10-12 50.98 51.12 50.35 50.83 10658445
2017-10-13 50.83 51.07 50.40 50.98 16227948
2017-10-16 50.80 51.40 50.64 51.37 9299326
2017-10-17 51.50 52.04 51.38 52.00 9492675
[250 rows x 5 columns],
'PFE': Open High Low Close Volume
Date
2016-10-20 32.49 32.74 32.49 32.54 19292363
2016-10-21 32.42 32.45 32.18 32.18 18834961
2016-10-24 32.30 32.36 32.05 32.13 19586374
2016-10-25 32.02 32.37 31.98 32.28 19336056
2016-10-26 32.28 32.60 32.15 32.40 17102660
2016-10-27 32.58 32.81 32.37 32.48 18253037
2016-10-28 32.52 32.56 31.88 31.93 28508651
2016-10-31 32.04 32.04 31.61 31.71 35949424
2016-11-01 30.94 31.72 30.75 31.07 54350118
2016-11-02 30.99 31.04 30.36 30.63 36084519
2016-11-03 30.70 30.70 29.83 29.89 36329216
2016-11-04 29.91 30.37 29.90 30.00 35028231
2016-11-07 30.23 30.44 30.08 30.38 30877493
2016-11-08 30.13 30.45 29.96 30.00 35451303
2016-11-09 33.01 33.37 31.50 32.12 118753768
2016-11-10 33.32 33.83 32.85 33.49 67275205
2016-11-11 33.22 33.34 32.19 32.59 35803589
2016-11-14 32.85 32.90 32.13 32.38 30568352
2016-11-15 32.76 32.76 31.88 32.23 29614279
2016-11-16 32.20 32.33 31.93 31.96 22641562
2016-11-17 32.01 32.12 31.68 31.73 26073099
2016-11-18 31.95 31.95 31.44 31.48 24156427
2016-11-21 31.51 31.69 31.49 31.57 21872759
2016-11-22 31.93 31.99 31.05 31.33 26434849
2016-11-23 31.18 31.45 30.63 31.42 21270415
2016-11-25 31.60 31.74 31.55 31.69 10452948
2016-11-28 31.69 31.84 31.50 31.54 17735150
2016-11-29 31.85 31.97 31.61 31.92 21642215
2016-11-30 31.98 32.36 31.75 32.14 38519485
2016-12-01 32.25 32.25 31.40 31.46 30606411
... ... ... ... ... ...
2017-09-06 33.95 34.11 33.91 33.99 13212295
2017-09-07 34.04 34.13 33.81 33.99 17867050
2017-09-08 33.95 34.25 33.80 34.10 15442446
2017-09-11 34.09 34.34 33.98 34.32 16379498
2017-09-12 34.38 35.75 34.36 35.37 37256492
2017-09-13 35.26 35.43 34.97 35.06 20982433
2017-09-14 35.05 35.84 35.00 35.73 27426839
2017-09-15 35.60 35.72 35.24 35.36 28871059
2017-09-18 35.38 35.55 35.21 35.55 16936220
2017-09-19 35.66 35.66 35.35 35.45 15692161
2017-09-20 35.93 36.21 35.81 35.99 25680077
2017-09-21 36.06 36.19 35.91 35.97 15731081
2017-09-22 36.10 36.12 35.77 35.96 14605376
2017-09-25 35.90 36.03 35.44 35.51 22181960
2017-09-26 35.51 35.64 35.24 35.30 17559784
2017-09-27 35.25 35.52 35.19 35.45 14671645
2017-09-28 35.27 35.78 35.22 35.60 18062655
2017-09-29 35.64 35.70 35.35 35.70 16003652
2017-10-02 35.67 36.10 35.49 36.07 16642649
2017-10-03 36.02 36.20 35.75 36.14 13594288
2017-10-04 36.18 36.24 35.90 35.96 10849382
2017-10-05 35.88 36.00 35.75 36.00 13605723
2017-10-06 35.99 36.14 35.94 36.05 12060086
2017-10-09 36.06 36.15 35.93 36.14 9751519
2017-10-10 36.38 36.51 36.03 36.40 17739464
2017-10-11 36.37 36.42 36.20 36.34 1642256
2017-10-12 36.48 36.60 36.28 36.35 13994415
2017-10-13 36.37 36.49 36.25 36.34 12769294
2017-10-16 36.35 36.48 35.88 35.98 13581579
2017-10-17 35.93 36.33 35.75 36.20 14019661
[250 rows x 5 columns],
'PG': Open High Low Close Volume
Date
2016-10-20 85.38 85.52 84.79 84.93 10175116
2016-10-21 84.41 84.86 84.24 84.33 13974139
2016-10-24 84.39 84.70 84.06 84.10 10573198
2016-10-25 87.49 88.08 86.97 86.97 20761155
2016-10-26 86.91 87.74 86.78 87.40 8464058
2016-10-27 87.51 87.60 86.45 86.58 6598279
2016-10-28 86.87 87.23 86.45 86.84 7021059
2016-10-31 87.01 87.47 86.69 86.80 8207137
2016-11-01 86.58 86.99 86.48 86.85 8564471
2016-11-02 86.77 87.41 86.56 86.74 7773237
2016-11-03 86.80 86.98 86.47 86.60 6899931
2016-11-04 86.69 86.73 85.07 85.08 9378118
2016-11-07 86.02 86.57 85.60 86.56 8878455
2016-11-08 86.77 87.69 86.59 87.46 7674604
2016-11-09 85.26 86.54 84.31 85.93 11972512
2016-11-10 85.51 85.70 82.18 82.96 22095710
2016-11-11 82.67 84.06 82.65 83.58 8905669
2016-11-14 83.56 83.78 82.76 83.00 12862496
2016-11-15 84.58 84.58 82.88 83.62 9464037
2016-11-16 83.98 84.20 83.17 83.19 8542909
2016-11-17 83.27 83.50 82.93 83.07 9078077
2016-11-18 82.92 83.10 81.99 82.00 14565456
2016-11-21 82.10 82.75 81.71 82.64 11482061
2016-11-22 83.01 83.18 82.66 82.76 7426508
2016-11-23 82.59 82.93 82.52 82.68 10763830
2016-11-25 82.99 83.46 82.95 83.46 3883098
2016-11-28 83.13 83.36 82.76 83.07 6990064
2016-11-29 83.42 83.48 82.69 82.89 6183113
2016-11-30 82.52 82.83 82.26 82.46 12115474
2016-12-01 82.21 82.32 81.18 81.86 12516920
... ... ... ... ... ...
2017-09-06 92.79 92.91 92.36 92.72 6747154
2017-09-07 92.74 93.36 92.33 92.97 7735387
2017-09-08 92.76 93.15 92.51 92.84 6070073
2017-09-11 93.09 94.19 92.90 93.99 10177267
2017-09-12 93.72 93.98 93.21 93.51 5804047
2017-09-13 93.50 93.77 93.45 93.55 5369293
2017-09-14 93.23 93.65 93.18 93.55 5492335
2017-09-15 93.82 93.82 92.82 93.27 12428828
2017-09-18 93.17 93.50 92.86 93.15 6177688
2017-09-19 93.34 94.45 93.34 94.17 6587152
2017-09-20 94.17 94.67 93.83 94.40 5941516
2017-09-21 94.15 94.50 92.44 92.64 9376655
2017-09-22 92.55 93.00 92.08 92.24 6837699
2017-09-25 92.43 93.09 92.33 92.72 6436162
2017-09-26 92.82 92.84 92.20 92.65 4885203
2017-09-27 92.52 92.52 90.34 90.87 9517951
2017-09-28 90.86 91.12 90.63 90.89 4999771
2017-09-29 90.97 91.43 90.70 90.98 6634464
2017-10-02 91.26 92.40 91.24 91.77 7302440
2017-10-03 91.96 92.34 91.56 92.12 5909908
2017-10-04 92.12 92.80 92.02 92.42 6140711
2017-10-05 92.49 92.65 91.94 92.03 6912759
2017-10-06 92.00 92.35 91.88 92.33 5241920
2017-10-09 92.40 92.62 91.93 92.12 5148962
2017-10-10 92.37 93.04 89.86 91.62 17125589
2017-10-11 91.09 91.73 91.07 91.48 665676
2017-10-12 91.41 92.30 91.39 92.15 5984905
2017-10-13 92.70 93.51 92.59 93.04 6956656
2017-10-16 92.97 93.37 92.71 93.14 4159101
2017-10-17 93.04 93.09 92.40 92.80 5316062
[250 rows x 5 columns],
'TRV': Open High Low Close Volume
Date
2016-10-20 112.83 113.51 109.25 109.52 4606513
2016-10-21 108.53 109.22 106.86 108.35 3768289
2016-10-24 109.10 109.48 108.83 109.07 2524826
2016-10-25 109.36 109.90 108.77 109.03 2569774
2016-10-26 108.73 109.33 108.04 108.82 2644584
2016-10-27 109.32 109.32 107.97 108.02 2545986
2016-10-28 108.60 109.03 107.59 108.43 2245084
2016-10-31 108.93 109.02 107.88 108.18 2162143
2016-11-01 108.60 108.60 106.02 106.24 2564616
2016-11-02 106.28 106.59 105.35 105.62 1718577
2016-11-03 106.02 106.47 105.53 105.72 1691778
2016-11-04 106.07 106.07 104.57 104.67 1864913
2016-11-07 106.22 106.22 104.92 105.36 1804175
2016-11-08 105.43 108.16 105.16 108.01 2082597
2016-11-09 103.45 107.52 103.45 106.94 3662179
2016-11-10 107.30 109.79 106.64 109.62 2748905
2016-11-11 109.48 110.58 109.10 110.28 1962328
2016-11-14 110.77 112.25 110.65 112.18 3220149
2016-11-15 111.98 112.03 111.36 111.85 1823890
2016-11-16 111.45 111.56 110.70 111.35 1717250
2016-11-17 110.97 111.48 110.40 111.18 1505601
2016-11-18 111.25 112.12 110.82 111.82 1718010
2016-11-21 112.01 112.34 111.25 111.84 1388161
2016-11-22 111.94 112.62 111.83 112.40 1647657
2016-11-23 112.67 113.23 112.44 113.07 1004781
2016-11-25 113.47 113.88 113.10 113.45 686329
2016-11-28 113.35 114.24 113.35 113.81 1467312
2016-11-29 113.90 114.12 113.50 113.70 1783451
2016-11-30 113.61 114.01 113.18 113.35 2756400
2016-12-01 114.22 115.52 113.85 115.41 2347458
... ... ... ... ... ...
2017-09-06 116.00 118.40 115.45 117.73 3561916
2017-09-07 116.59 116.95 113.76 115.18 2715713
2017-09-08 114.71 120.83 114.48 119.76 4215429
2017-09-11 123.51 126.68 122.37 122.56 3440418
2017-09-12 122.55 123.19 121.32 122.48 1811467
2017-09-13 122.23 122.48 120.79 121.51 1561265
2017-09-14 121.47 121.47 118.75 119.96 1812922
2017-09-15 120.59 121.16 119.48 120.70 3062500
2017-09-18 120.72 121.08 120.13 120.72 1068628
2017-09-19 120.64 121.42 120.46 120.58 1248293
2017-09-20 121.07 121.98 119.90 121.91 1489348
2017-09-21 122.11 122.90 121.13 121.49 1209258
2017-09-22 121.49 122.17 121.05 122.04 1291782
2017-09-25 121.96 122.97 121.55 122.67 1136487
2017-09-26 122.67 123.49 122.24 122.57 1298467
2017-09-27 123.46 123.46 122.49 122.59 1091527
2017-09-28 122.41 123.26 122.25 122.80 1097060
2017-09-29 122.62 123.20 121.90 122.52 1285833
2017-10-02 122.87 123.47 121.72 123.32 1587243
2017-10-03 123.31 123.73 122.39 123.70 1275588
2017-10-04 123.71 124.29 123.28 123.90 836932
2017-10-05 123.98 124.84 123.70 124.44 1135716
2017-10-06 124.58 125.36 124.24 125.07 1152158
2017-10-09 124.80 125.49 124.35 124.95 723739
2017-10-10 124.88 125.95 124.77 125.94 967885
2017-10-11 125.64 126.16 125.61 126.12 91148
2017-10-12 126.02 126.50 125.46 125.95 1022192
2017-10-13 126.16 127.17 125.79 126.67 1087096
2017-10-16 127.33 129.62 126.90 128.82 1765934
2017-10-17 128.44 128.86 127.50 128.65 1808224
[250 rows x 5 columns],
'UNH': Open High Low Close Volume
Date
2016-10-20 144.49 145.88 143.98 145.07 5203669
2016-10-21 144.26 145.44 143.76 145.37 3331766
2016-10-24 146.00 146.22 144.02 144.69 2930159
2016-10-25 144.88 145.38 143.60 143.78 3095384
2016-10-26 143.75 143.78 141.88 142.23 3267632
2016-10-27 142.72 143.25 141.58 141.94 3358006
2016-10-28 141.66 142.35 139.44 140.35 4033636
2016-10-31 140.80 141.54 139.97 141.33 3761070
2016-11-01 141.51 141.51 138.82 139.43 3391410
2016-11-02 139.02 141.23 138.93 138.98 3149707
2016-11-03 139.18 140.34 137.65 137.83 2989689
2016-11-04 138.45 138.89 137.69 137.71 3520746
2016-11-07 139.60 142.44 139.55 141.93 3896555
2016-11-08 141.35 143.61 141.00 142.90 4389253
2016-11-09 139.54 144.19 136.22 141.90 8042434
2016-11-10 142.34 146.57 142.00 146.13 6075842
2016-11-11 146.71 147.50 146.01 146.42 4475449
2016-11-14 147.32 152.92 147.04 152.28 5740425
2016-11-15 153.51 153.96 151.51 152.23 4910721
2016-11-16 151.99 153.00 151.23 151.50 3899008
2016-11-17 151.82 151.92 150.19 150.77 4672899
2016-11-18 151.05 151.66 149.40 149.45 5664818
2016-11-21 149.72 150.66 148.56 150.41 3867791
2016-11-22 151.08 152.93 150.56 152.26 4992120
2016-11-23 152.01 153.74 150.96 153.54 2838847
2016-11-25 153.93 154.50 152.61 152.81 1664542
2016-11-28 152.74 152.85 150.00 152.11 5029589
2016-11-29 156.94 158.12 155.18 157.59 5827435
2016-11-30 157.47 159.76 157.07 158.32 7142369
2016-12-01 159.12 161.72 159.12 160.94 5250234
... ... ... ... ... ...
2017-09-06 199.54 199.99 197.63 198.38 3040218
2017-09-07 197.77 199.48 197.07 198.17 2684599
2017-09-08 198.43 198.86 197.00 197.75 2205962
2017-09-11 199.25 200.42 198.78 199.58 3307919
2017-09-12 199.44 199.47 196.91 197.47 2554695
2017-09-13 197.80 200.76 197.78 198.33 2394409
2017-09-14 197.95 198.38 197.09 197.73 2378644
2017-09-15 198.52 199.71 197.20 198.18 4198691
2017-09-18 198.17 198.82 197.51 198.19 1915478
2017-09-19 198.44 198.60 192.39 194.65 3818982
2017-09-20 195.02 195.84 194.06 195.75 2788463
2017-09-21 195.63 196.13 194.90 195.21 1894964
2017-09-22 195.11 195.87 188.25 193.03 5660220
2017-09-25 193.27 196.31 190.92 191.75 3105892
2017-09-26 192.31 194.36 192.04 192.70 2775350
2017-09-27 193.20 195.62 191.74 194.49 3218558
2017-09-28 194.25 196.54 193.51 196.10 2088374
2017-09-29 195.82 196.09 194.48 195.85 2646297
2017-10-02 196.59 197.91 196.33 197.44 2893553
2017-10-03 197.50 199.44 197.26 198.63 2533804
2017-10-04 199.03 200.73 198.43 200.48 2286385
2017-10-05 199.93 199.93 196.56 197.90 4068977
2017-10-06 197.90 199.99 197.51 198.06 3361896
2017-10-09 198.01 198.32 195.78 196.30 3365386
2017-10-10 196.26 196.43 193.67 194.68 2499815
2017-10-11 194.63 195.57 193.78 193.93 200930
2017-10-12 195.01 195.36 192.73 192.92 2954744
2017-10-13 189.59 192.71 186.00 192.52 5435003
2017-10-16 192.48 193.32 191.36 193.20 2927432
2017-10-17 196.80 206.62 196.37 203.89 8949715
[250 rows x 5 columns],
'UTX': Open High Low Close Volume
Date
2016-10-20 99.75 100.18 99.27 99.29 3876682
2016-10-21 98.38 98.78 97.62 98.67 4094992
2016-10-24 99.34 99.86 99.08 99.52 4288098
2016-10-25 101.11 102.10 100.46 101.36 6752343
2016-10-26 101.00 101.82 100.75 101.01 3734107
2016-10-27 101.48 101.62 99.99 100.07 3549976
2016-10-28 100.52 102.14 100.52 101.84 4449945
2016-10-31 102.01 102.60 101.90 102.20 4014477
2016-11-01 102.41 102.92 101.30 102.01 4044502
2016-11-02 101.85 102.56 101.16 101.54 4115453
2016-11-03 101.80 101.91 100.72 101.05 2444223
2016-11-04 101.24 101.77 100.74 101.33 2607789
2016-11-07 102.97 103.34 102.51 103.05 4226225
2016-11-08 103.23 103.92 102.62 103.37 2524464
2016-11-09 101.09 105.29 101.09 104.81 5003877
2016-11-10 105.38 108.46 105.34 108.41 6105767
2016-11-11 107.90 108.92 107.00 108.86 4149869
2016-11-14 109.42 109.42 107.73 107.86 4138518
2016-11-15 107.85 108.02 106.66 107.68 3795579
2016-11-16 106.62 107.38 106.35 106.96 2707456
2016-11-17 107.03 107.44 106.61 106.70 2226541
2016-11-18 106.66 106.96 106.37 106.50 2677456
2016-11-21 106.85 107.06 106.21 106.85 2177429
2016-11-22 107.21 107.33 106.87 106.94 2640683
2016-11-23 107.37 108.28 107.37 108.11 2384904
2016-11-25 108.63 109.20 108.29 108.78 1008723
2016-11-28 108.50 108.98 108.29 108.45 2453510
2016-11-29 108.67 109.44 108.65 108.84 3133853
2016-11-30 109.03 110.00 107.72 107.72 4112076
2016-12-01 108.00 108.17 107.07 107.48 4055589
... ... ... ... ... ...
2017-09-06 111.00 111.09 109.10 109.61 9189124
2017-09-07 109.76 110.07 109.10 109.98 5153132
2017-09-08 110.11 110.34 109.35 109.55 4404054
2017-09-11 110.01 110.73 109.28 109.64 5623208
2017-09-12 110.07 110.31 109.70 109.86 3966418
2017-09-13 110.15 110.47 109.81 110.28 3820914
2017-09-14 110.27 113.28 110.10 113.14 7032766
2017-09-15 113.73 113.92 112.73 113.08 6529563
2017-09-18 113.40 113.64 112.65 112.77 4039640
2017-09-19 113.00 113.65 112.76 113.65 3328361
2017-09-20 113.23 114.23 113.22 114.10 3435302
2017-09-21 114.18 114.83 113.57 114.50 2565203
2017-09-22 114.42 115.12 114.13 115.01 2833424
2017-09-25 114.92 115.00 113.71 114.29 3700056
2017-09-26 114.58 115.01 114.23 114.72 4020190
2017-09-27 114.86 117.46 114.84 117.18 5537637
2017-09-28 116.99 117.04 115.38 115.84 6029160
2017-09-29 115.32 116.13 114.49 116.08 3270372
2017-10-02 116.14 117.65 115.94 117.58 2330829
2017-10-03 118.00 118.00 117.28 117.71 2211082
2017-10-04 117.87 118.22 117.52 117.63 2799863
2017-10-05 117.63 118.33 117.44 118.17 2676545
2017-10-06 117.90 118.28 117.60 118.23 1790491
2017-10-09 118.29 118.88 118.09 118.63 1749482
2017-10-10 118.61 118.82 117.75 118.12 2664954
2017-10-11 118.31 118.60 117.72 117.80 129159
2017-10-12 117.67 118.93 117.63 118.82 2375601
2017-10-13 119.07 119.95 118.72 118.72 3472976
2017-10-16 118.84 119.50 118.40 119.01 2163578
2017-10-17 118.63 119.37 118.18 119.36 2026513
[250 rows x 5 columns],
'V': Open High Low Close Volume
Date
2016-10-20 83.05 83.10 82.17 82.50 6945209
2016-10-21 82.02 82.54 81.58 82.35 8043196
2016-10-24 83.27 83.59 82.71 83.17 16266997
2016-10-25 82.15 82.99 81.70 82.03 15085850
2016-10-26 81.62 82.26 81.41 81.75 8748420
2016-10-27 81.96 82.27 81.61 81.92 7039234
2016-10-28 82.52 83.36 82.11 82.22 10919564
2016-10-31 82.44 82.90 82.36 82.51 10024036
2016-11-01 82.64 82.69 81.33 81.62 10881514
2016-11-02 80.89 81.38 80.52 80.58 9170944
2016-11-03 80.75 81.13 80.54 80.65 7563109
2016-11-04 80.65 81.24 80.32 80.36 7588118
2016-11-07 81.64 82.53 81.45 82.51 7277898
2016-11-08 82.39 83.16 82.15 82.88 7151960
2016-11-09 81.81 83.30 81.22 83.24 12158464
2016-11-10 83.30 83.96 81.42 81.87 17171681
2016-11-11 81.59 82.63 81.52 81.88 7367994
2016-11-14 82.02 82.22 77.30 78.38 21773523
2016-11-15 78.23 79.54 77.80 78.57 18523447
2016-11-16 78.79 80.19 78.76 80.08 9997671
2016-11-17 80.32 81.20 80.18 81.07 7863718
2016-11-18 81.15 81.50 80.53 80.82 7920808
2016-11-21 81.23 81.78 80.90 81.69 8942057
2016-11-22 81.69 81.69 79.26 79.93 18133893
2016-11-23 79.98 79.99 78.95 79.57 12861961
2016-11-25 79.99 80.37 79.74 80.13 6495826
2016-11-28 79.66 80.01 79.05 79.08 11793084
2016-11-29 79.12 79.58 78.95 79.15 8575239
2016-11-30 79.45 79.45 77.28 77.32 15353872
2016-12-01 77.57 77.62 75.25 75.43 21052986
... ... ... ... ... ...
2017-09-06 103.34 103.74 103.10 103.18 6372227
2017-09-07 103.71 105.44 103.61 104.56 6508616
2017-09-08 104.33 104.77 104.06 104.43 5787188
2017-09-11 105.48 106.15 105.15 106.15 6955980
2017-09-12 106.64 106.64 105.76 106.21 5212380
2017-09-13 106.26 106.26 105.24 105.83 6215736
2017-09-14 105.50 106.84 105.50 106.08 8154048
2017-09-15 105.74 106.14 104.95 105.30 12622921
2017-09-18 105.35 105.52 104.62 104.83 7330304
2017-09-19 105.13 105.93 104.83 105.41 9754361
2017-09-20 105.50 105.76 104.46 104.97 8198591
2017-09-21 105.00 105.61 104.65 105.31 4777558
2017-09-22 105.21 105.68 105.06 105.56 4959424
2017-09-25 105.50 105.65 102.75 103.02 9395348
2017-09-26 103.11 104.02 102.88 102.94 6263608
2017-09-27 103.07 104.12 102.90 103.89 8276543
2017-09-28 103.75 104.98 103.74 104.58 5947771
2017-09-29 104.75 105.43 104.68 105.24 7676288
2017-10-02 105.54 105.99 105.10 105.44 4885565
2017-10-03 105.65 105.90 105.29 105.59 4411064
2017-10-04 105.71 105.74 104.90 105.31 4146782
2017-10-05 105.60 106.25 105.15 106.24 4396081
2017-10-06 106.29 106.96 105.87 106.73 4587001
2017-10-09 106.60 107.65 106.54 107.01 4786966
2017-10-10 107.58 107.60 106.82 107.31 4015646
2017-10-11 107.70 108.18 107.60 107.99 492980
2017-10-12 108.50 108.71 107.90 108.11 6496053
2017-10-13 108.50 109.26 108.40 108.66 5154563
2017-10-16 108.79 109.05 107.16 108.30 5552165
2017-10-17 108.25 108.42 107.30 107.54 5979405
[250 rows x 5 columns],
'VZ': Open High Low Close Volume
Date
2016-10-20 49.54 49.57 48.90 49.14 27098224
2016-10-21 48.79 48.92 47.95 48.20 24784972
2016-10-24 48.71 48.93 48.13 48.21 19414749
2016-10-25 48.20 48.29 47.78 47.84 16441160
2016-10-26 47.74 48.05 47.58 47.63 15049207
2016-10-27 47.74 48.70 47.63 48.54 22330679
2016-10-28 48.56 48.77 48.10 48.21 10660111
2016-10-31 48.24 48.30 48.05 48.10 12459394
2016-11-01 48.32 48.38 47.53 47.66 13229438
2016-11-02 47.75 47.75 46.86 46.94 16488191
2016-11-03 46.98 47.27 46.79 46.87 12605073
2016-11-04 46.97 47.28 46.89 47.08 14410194
2016-11-07 47.39 47.47 46.94 47.46 14705231
2016-11-08 47.56 47.85 47.46 47.65 9482397
2016-11-09 47.01 48.08 46.47 47.86 20871873
2016-11-10 47.86 47.88 46.36 46.69 24311742
2016-11-11 46.70 46.90 46.51 46.69 16425481
2016-11-14 46.71 46.85 46.01 46.18 21820205
2016-11-15 46.51 47.37 46.38 47.37 18672172
2016-11-16 47.49 47.98 47.32 47.93 17328411
2016-11-17 47.95 48.17 47.81 47.84 12436332
2016-11-18 47.85 48.20 47.56 48.07 12820589
2016-11-21 48.06 48.36 47.92 48.31 10773257
2016-11-22 48.56 49.61 48.37 49.49 22030008
2016-11-23 49.30 50.65 49.29 50.23 21470215
2016-11-25 50.22 50.80 50.17 50.67 8087235
2016-11-28 50.47 51.20 50.45 51.12 15982434
2016-11-29 51.03 51.15 50.77 50.96 11532765
2016-11-30 50.55 50.73 49.90 49.90 20698891
2016-12-01 49.80 49.99 49.31 49.87 12982813
... ... ... ... ... ...
2017-09-06 47.47 47.56 46.62 46.91 14081939
2017-09-07 47.00 47.21 46.07 46.20 16591072
2017-09-08 46.18 46.39 45.71 46.11 14152041
2017-09-11 46.23 46.34 46.12 46.30 11073655
2017-09-12 46.50 46.95 46.38 46.79 11173160
2017-09-13 46.78 47.26 46.68 47.25 12772690
2017-09-14 47.24 47.59 47.01 47.18 11808457
2017-09-15 47.42 47.90 47.06 47.86 24626478
2017-09-18 47.91 48.24 47.51 48.09 18810166
2017-09-19 48.09 49.55 48.01 49.34 30817991
2017-09-20 49.30 49.64 49.08 49.48 18755912
2017-09-21 49.37 49.44 48.84 48.94 14315783
2017-09-22 49.19 50.08 49.02 49.90 20646413
2017-09-25 49.87 50.32 49.74 49.90 13698567
2017-09-26 49.96 50.08 49.40 49.51 12007462
2017-09-27 49.19 49.72 49.12 49.51 13772944
2017-09-28 49.24 49.56 49.14 49.41 8231789
2017-09-29 49.30 49.83 49.01 49.49 13021697
2017-10-02 49.39 49.70 49.25 49.36 9525757
2017-10-03 49.45 50.02 49.43 49.85 10218605
2017-10-04 49.64 50.08 49.38 49.90 9887485
2017-10-05 49.96 50.03 49.68 49.77 12230644
2017-10-06 49.04 49.20 48.66 48.81 13239635
2017-10-09 48.89 49.09 48.65 49.05 10702938
2017-10-10 49.28 49.49 49.06 49.14 10843879
2017-10-11 49.14 49.32 49.12 49.21 703042
2017-10-12 48.44 48.85 48.13 48.35 17087942
2017-10-13 48.34 48.48 47.83 47.86 20105054
2017-10-16 47.90 48.35 47.70 48.09 10394675
2017-10-17 48.09 48.49 47.87 48.40 14842814
[250 rows x 5 columns],
'WMT': Open High Low Close Volume
Date
2016-10-20 68.98 69.08 68.57 68.73 6294027
2016-10-21 68.34 68.63 67.99 68.34 7844583
2016-10-24 68.62 69.37 68.39 69.19 7163632
2016-10-25 69.01 69.87 69.00 69.36 7629748
2016-10-26 69.30 69.81 69.14 69.59 5050540
2016-10-27 69.60 70.00 69.39 69.83 7131613
2016-10-28 69.80 70.21 69.73 69.99 6952858
2016-10-31 70.06 70.17 69.85 70.02 6389047
2016-11-01 69.98 70.06 69.14 69.30 8838603
2016-11-02 69.20 69.97 69.20 69.45 7645275
2016-11-03 69.63 70.08 69.35 69.63 6803940
2016-11-04 69.71 69.94 69.13 69.16 7262105
2016-11-07 69.62 69.84 69.16 69.78 9755441
2016-11-08 69.71 70.04 69.47 69.79 7621295
2016-11-09 69.30 71.50 69.29 71.10 16779465
2016-11-10 71.25 72.09 71.00 71.39 14321300
2016-11-11 71.11 71.28 70.60 71.23 8223872
2016-11-14 71.16 71.31 70.19 70.49 12917474
2016-11-15 70.79 71.42 70.35 71.42 9725063
2016-11-16 71.75 72.06 71.33 71.39 11192448
2016-11-17 69.08 69.52 68.12 69.19 23250871
2016-11-18 68.93 69.40 68.44 68.54 11135265
2016-11-21 68.61 69.40 68.42 69.37 8355966
2016-11-22 69.73 70.42 69.73 70.12 10984049
2016-11-23 70.22 70.88 70.18 70.83 7442950
2016-11-25 71.11 71.65 70.98 71.23 4234383
2016-11-28 70.93 71.52 70.80 71.19 7099193
2016-11-29 71.38 71.79 71.20 71.37 7310092
2016-11-30 70.92 71.16 70.16 70.43 9326127
2016-12-01 70.25 70.73 70.05 70.67 6849803
... ... ... ... ... ...
2017-09-06 79.88 80.40 79.72 80.08 8426125
2017-09-07 80.32 80.76 80.00 80.12 6820752
2017-09-08 79.74 79.88 77.73 78.88 9999593
2017-09-11 79.15 79.35 78.66 79.08 7000240
2017-09-12 79.30 79.91 79.17 79.61 6004985
2017-09-13 79.61 80.68 79.59 79.86 8823746
2017-09-14 79.79 79.82 79.22 79.68 6939333
2017-09-15 79.81 80.75 79.27 80.38 13317757
2017-09-18 80.21 81.12 79.95 80.00 8176067
2017-09-19 80.18 80.46 79.70 80.05 6174358
2017-09-20 80.17 80.56 79.87 80.50 5318194
2017-09-21 80.57 80.57 79.72 80.01 6430256
2017-09-22 79.89 80.08 79.24 79.53 5755262
2017-09-25 78.92 80.10 78.86 79.15 8547808
2017-09-26 79.04 79.54 78.92 79.39 5835332
2017-09-27 79.42 79.57 78.67 79.29 6238543
2017-09-28 79.00 79.08 78.12 78.95 12372825
2017-09-29 78.85 79.00 77.98 78.14 10353361
2017-10-02 77.90 78.83 77.50 78.45 7709220
2017-10-03 78.83 79.66 78.75 79.22 7936742
2017-10-04 79.27 79.78 79.07 79.09 6173376
2017-10-05 79.17 79.81 79.08 79.41 5138671
2017-10-06 78.78 79.17 78.25 79.00 6246655
2017-10-09 79.50 81.38 79.40 80.53 13493044
2017-10-10 82.68 84.88 82.61 84.13 25123962
2017-10-11 84.58 84.80 84.10 84.63 1712675
2017-10-12 85.70 86.37 85.06 86.10 12876987
2017-10-13 86.24 86.95 86.24 86.62 9389049
2017-10-16 86.58 86.62 85.02 85.74 9300326
2017-10-17 85.50 86.36 85.32 85.98 5851546
[250 rows x 5 columns],
'XOM': Open High Low Close Volume
Date
2016-10-20 86.79 87.50 86.60 87.21 6866873
2016-10-21 86.42 86.82 85.70 86.62 10736170
2016-10-24 86.74 87.32 86.07 86.91 8354850
2016-10-25 86.67 87.65 86.60 86.72 6835886
2016-10-26 86.25 87.45 85.95 87.09 8488064
2016-10-27 87.28 87.66 86.80 86.92 9071099
2016-10-28 85.28 86.36 84.14 84.78 19072186
2016-10-31 83.88 84.40 82.99 83.32 16663771
2016-11-01 83.50 83.92 83.27 83.65 13050607
2016-11-02 83.30 83.88 82.94 83.45 11226097
2016-11-03 83.68 83.88 83.05 83.66 8836546
2016-11-04 83.63 84.33 82.76 83.57 13877124
2016-11-07 84.49 85.47 84.40 85.45 13576246
2016-11-08 84.73 85.83 84.49 85.31 9735164
2016-11-09 84.05 86.71 83.66 86.25 15901269
2016-11-10 85.91 87.99 85.66 87.05 14106227
2016-11-11 86.53 86.73 84.89 85.67 13812176
2016-11-14 85.30 85.65 84.32 85.28 12607502
2016-11-15 85.77 87.06 85.77 86.82 12883542
2016-11-16 86.74 86.78 85.58 85.75 8201169
2016-11-17 86.44 86.88 85.02 85.23 8200464
2016-11-18 85.21 85.65 84.83 85.28 8457804
2016-11-21 86.44 86.69 86.14 86.49 8861469
2016-11-22 86.69 87.24 85.97 86.68 9390248
2016-11-23 86.54 87.08 86.31 86.92 6061281
2016-11-25 86.71 87.14 86.54 87.12 5043042
2016-11-28 86.95 87.13 86.37 86.47 7449634
2016-11-29 85.42 86.08 85.08 85.90 9181096
2016-11-30 87.60 88.19 87.20 87.30 22696209
2016-12-01 87.98 88.50 87.24 87.24 13005560
... ... ... ... ... ...
2017-09-06 77.89 79.22 77.58 78.78 18574383
2017-09-07 79.02 79.33 78.61 79.03 9836447
2017-09-08 79.01 79.04 78.63 78.82 8436033
2017-09-11 79.41 79.42 78.90 79.25 12955773
2017-09-12 79.40 79.69 79.24 79.50 7644403
2017-09-13 79.50 79.77 79.38 79.77 8369659
2017-09-14 79.85 80.23 79.77 80.09 9072627
2017-09-15 80.12 80.21 79.55 80.07 16043707
2017-09-18 79.79 80.14 79.70 80.09 8594362
2017-09-19 80.06 80.39 79.98 80.22 9277072
2017-09-20 80.28 80.66 80.26 80.55 10606860
2017-09-21 80.49 80.53 79.76 79.89 11984170
2017-09-22 79.72 80.30 79.67 79.92 10205789
2017-09-25 80.03 81.00 79.98 80.98 10496637
2017-09-26 80.71 81.00 80.56 80.89 8755080
2017-09-27 80.89 81.45 80.79 81.43 9575460
2017-09-28 81.63 82.45 81.56 82.19 15581727
2017-09-29 81.94 82.06 81.58 81.98 9943991
2017-10-02 81.30 81.82 81.24 81.63 6777857
2017-10-03 81.41 81.97 81.30 81.76 6081997
2017-10-04 81.80 81.87 81.45 81.79 6357088
2017-10-05 81.72 82.24 81.59 82.02 7375872
2017-10-06 81.77 81.89 81.36 81.71 6070620
2017-10-09 81.84 82.18 81.76 82.03 7489884
2017-10-10 82.34 82.74 82.09 82.26 7218534
2017-10-11 82.16 82.45 82.14 82.22 460321
2017-10-12 82.31 82.50 82.17 82.43 6647544
2017-10-13 82.73 83.08 82.36 82.41 7180046
2017-10-16 82.70 82.95 82.54 82.81 5734007
2017-10-17 82.63 82.97 82.54 82.96 6444106
[250 rows x 5 columns]}
In [5]:
data_exchange={}
for s in symbol:
data_exchange[s]=web.get_data_yahoo(s,start,end)
data_exchange
---------------------------------------------------------------------------
RemoteDataError Traceback (most recent call last)
<ipython-input-5-c60b8f9776a5> in <module>()
2
3 for s in symbol:
----> 4 data_exchange[s]=web.get_data_yahoo(s,start,end)
5 data_exchange
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\data.py in get_data_yahoo(*args, **kwargs)
38
39 def get_data_yahoo(*args, **kwargs):
---> 40 return YahooDailyReader(*args, **kwargs).read()
41
42
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\yahoo\daily.py in read(self)
113 """ read one data from specified URL """
114 try:
--> 115 df = super(YahooDailyReader, self).read()
116 if self.ret_index:
117 df['Ret_Index'] = _calc_return_index(df['Adj Close'])
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in read(self)
179 if isinstance(self.symbols, (compat.string_types, int)):
180 df = self._read_one_data(self.url,
--> 181 params=self._get_params(self.symbols))
182 # Or multiple symbols, (e.g., ['GOOG', 'AAPL', 'MSFT'])
183 elif isinstance(self.symbols, DataFrame):
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in _read_one_data(self, url, params)
77 """ read one data from specified URL """
78 if self._format == 'string':
---> 79 out = self._read_url_as_StringIO(url, params=params)
80 elif self._format == 'json':
81 out = self._get_response(url, params=params).json()
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in _read_url_as_StringIO(self, url, params)
88 Open url (and retry)
89 """
---> 90 response = self._get_response(url, params=params)
91 text = self._sanitize_response(response)
92 out = StringIO()
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in _get_response(self, url, params, headers)
137 if params is not None and len(params) > 0:
138 url = url + "?" + urlencode(params)
--> 139 raise RemoteDataError('Unable to read URL: {0}'.format(url))
140
141 def _get_crumb(self, *args):
RemoteDataError: Unable to read URL: https://query1.finance.yahoo.com/v7/finance/download/CSCO?period1=1451595600&period2=1454273999&interval=1d&events=history&crumb=eeTLRz5nc%5Cu002Ft
In [8]:
f = web.DataReader("F", 'yahoo', start, end)
f
Out[8]:
Open
High
Low
Close
Adj Close
Volume
Date
2015-12-31
14.14
14.16
14.04
14.09
12.627838
19881000
2016-01-04
13.87
14.00
13.75
13.97
12.520291
38618500
2016-01-05
13.97
14.00
13.51
13.72
12.296234
50267500
2016-01-06
13.56
13.56
13.05
13.11
11.749536
61285500
2016-01-07
12.90
13.04
12.60
12.70
11.382083
57846700
2016-01-08
13.05
13.10
12.50
12.54
11.238686
46199400
2016-01-11
12.80
12.82
12.55
12.77
11.444819
41153600
2016-01-12
13.03
13.04
12.58
12.85
11.516519
50983700
2016-01-13
12.73
12.84
12.06
12.20
10.933969
102174700
2016-01-14
12.19
12.31
11.82
12.19
10.925006
62938600
2016-01-15
11.81
12.00
11.58
11.97
10.727839
69030000
2016-01-19
12.15
12.16
11.82
11.95
10.709912
41142600
2016-01-20
11.79
12.07
11.47
11.90
10.665099
59879000
2016-01-21
12.01
12.28
11.86
12.01
10.763686
48841800
2016-01-22
12.26
12.36
12.03
12.14
10.880196
44537800
2016-01-25
12.30
12.31
11.93
11.98
10.736798
96738600
2016-01-26
12.14
12.30
12.04
12.26
10.987742
45846800
2016-01-27
12.05
12.10
11.73
11.85
10.978478
42064200
2016-01-28
12.03
12.06
11.20
11.71
10.848774
75699800
2016-01-29
11.83
11.94
11.65
11.94
11.061858
52137400
In [10]:
data_exchange={}
for s in symbol:
data_exchange[s]=web.DataReader(s, 'yahoo', start, end)
data_exchange
---------------------------------------------------------------------------
RemoteDataError Traceback (most recent call last)
<ipython-input-10-b1d56cc3eccf> in <module>()
2
3 for s in symbol:
----> 4 data_exchange[s]=web.DataReader(s, 'yahoo', start, end)
5 data_exchange
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\data.py in DataReader(name, data_source, start, end, retry_count, pause, session, access_key)
119 adjust_price=False, chunksize=25,
120 retry_count=retry_count, pause=pause,
--> 121 session=session).read()
122
123 elif data_source == "yahoo-actions":
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\yahoo\daily.py in read(self)
113 """ read one data from specified URL """
114 try:
--> 115 df = super(YahooDailyReader, self).read()
116 if self.ret_index:
117 df['Ret_Index'] = _calc_return_index(df['Adj Close'])
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in read(self)
179 if isinstance(self.symbols, (compat.string_types, int)):
180 df = self._read_one_data(self.url,
--> 181 params=self._get_params(self.symbols))
182 # Or multiple symbols, (e.g., ['GOOG', 'AAPL', 'MSFT'])
183 elif isinstance(self.symbols, DataFrame):
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in _read_one_data(self, url, params)
77 """ read one data from specified URL """
78 if self._format == 'string':
---> 79 out = self._read_url_as_StringIO(url, params=params)
80 elif self._format == 'json':
81 out = self._get_response(url, params=params).json()
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in _read_url_as_StringIO(self, url, params)
88 Open url (and retry)
89 """
---> 90 response = self._get_response(url, params=params)
91 text = self._sanitize_response(response)
92 out = StringIO()
~\AppData\Local\Continuum\anaconda3\lib\site-packages\pandas_datareader\base.py in _get_response(self, url, params, headers)
137 if params is not None and len(params) > 0:
138 url = url + "?" + urlencode(params)
--> 139 raise RemoteDataError('Unable to read URL: {0}'.format(url))
140
141 def _get_crumb(self, *args):
RemoteDataError: Unable to read URL: https://query1.finance.yahoo.com/v7/finance/download/KO?period1=1451595600&period2=1454273999&interval=1d&events=history&crumb=P%5Cu002FBWWwiTPCr
In [20]:
d={}
for i in ['DD', 'UTX', 'AAPL', 'CSCO', 'KO']:
d[i]=web.DataReader('i', 'yahoo', start, end)
d
Out[20]:
{'AAPL': Open High Low Close Adj Close Volume
Date
2015-12-31 4.19 4.24 4.03 4.16 4.16 157200
2016-01-04 4.16 4.25 3.97 4.24 4.24 554800
2016-01-05 4.26 4.27 3.98 4.15 4.15 199800
2016-01-06 4.04 4.07 3.96 4.02 4.02 175300
2016-01-07 3.95 3.95 3.50 3.53 3.53 220600
2016-01-08 3.65 3.66 3.44 3.52 3.52 383100
2016-01-11 3.55 3.55 3.39 3.46 3.46 279300
2016-01-12 3.54 3.58 3.26 3.34 3.34 196100
2016-01-13 3.34 3.34 2.70 3.02 3.02 609800
2016-01-14 3.09 3.20 2.93 3.11 3.11 225300
2016-01-15 3.04 3.06 2.94 3.01 3.01 222800
2016-01-19 3.07 3.10 3.01 3.05 3.05 329300
2016-01-20 3.02 3.51 2.98 3.22 3.22 595300
2016-01-21 3.18 3.40 3.09 3.13 3.13 260500
2016-01-22 3.20 3.30 3.08 3.11 3.11 191000
2016-01-25 3.20 3.20 3.05 3.11 3.11 207200
2016-01-26 3.16 3.29 3.09 3.29 3.29 256700
2016-01-27 3.30 3.34 3.13 3.15 3.15 188200
2016-01-28 3.21 3.40 3.16 3.31 3.31 811100
2016-01-29 3.36 3.49 3.14 3.34 3.34 685300,
'CSCO': Open High Low Close Adj Close Volume
Date
2015-12-31 4.19 4.24 4.03 4.16 4.16 157200
2016-01-04 4.16 4.25 3.97 4.24 4.24 554800
2016-01-05 4.26 4.27 3.98 4.15 4.15 199800
2016-01-06 4.04 4.07 3.96 4.02 4.02 175300
2016-01-07 3.95 3.95 3.50 3.53 3.53 220600
2016-01-08 3.65 3.66 3.44 3.52 3.52 383100
2016-01-11 3.55 3.55 3.39 3.46 3.46 279300
2016-01-12 3.54 3.58 3.26 3.34 3.34 196100
2016-01-13 3.34 3.34 2.70 3.02 3.02 609800
2016-01-14 3.09 3.20 2.93 3.11 3.11 225300
2016-01-15 3.04 3.06 2.94 3.01 3.01 222800
2016-01-19 3.07 3.10 3.01 3.05 3.05 329300
2016-01-20 3.02 3.51 2.98 3.22 3.22 595300
2016-01-21 3.18 3.40 3.09 3.13 3.13 260500
2016-01-22 3.20 3.30 3.08 3.11 3.11 191000
2016-01-25 3.20 3.20 3.05 3.11 3.11 207200
2016-01-26 3.16 3.29 3.09 3.29 3.29 256700
2016-01-27 3.30 3.34 3.13 3.15 3.15 188200
2016-01-28 3.21 3.40 3.16 3.31 3.31 811100
2016-01-29 3.36 3.49 3.14 3.34 3.34 685300,
'DD': Open High Low Close Adj Close Volume
Date
2015-12-31 4.19 4.24 4.03 4.16 4.16 157200
2016-01-04 4.16 4.25 3.97 4.24 4.24 554800
2016-01-05 4.26 4.27 3.98 4.15 4.15 199800
2016-01-06 4.04 4.07 3.96 4.02 4.02 175300
2016-01-07 3.95 3.95 3.50 3.53 3.53 220600
2016-01-08 3.65 3.66 3.44 3.52 3.52 383100
2016-01-11 3.55 3.55 3.39 3.46 3.46 279300
2016-01-12 3.54 3.58 3.26 3.34 3.34 196100
2016-01-13 3.34 3.34 2.70 3.02 3.02 609800
2016-01-14 3.09 3.20 2.93 3.11 3.11 225300
2016-01-15 3.04 3.06 2.94 3.01 3.01 222800
2016-01-19 3.07 3.10 3.01 3.05 3.05 329300
2016-01-20 3.02 3.51 2.98 3.22 3.22 595300
2016-01-21 3.18 3.40 3.09 3.13 3.13 260500
2016-01-22 3.20 3.30 3.08 3.11 3.11 191000
2016-01-25 3.20 3.20 3.05 3.11 3.11 207200
2016-01-26 3.16 3.29 3.09 3.29 3.29 256700
2016-01-27 3.30 3.34 3.13 3.15 3.15 188200
2016-01-28 3.21 3.40 3.16 3.31 3.31 811100
2016-01-29 3.36 3.49 3.14 3.34 3.34 685300,
'KO': Open High Low Close Adj Close Volume
Date
2015-12-31 4.19 4.24 4.03 4.16 4.16 157200
2016-01-04 4.16 4.25 3.97 4.24 4.24 554800
2016-01-05 4.26 4.27 3.98 4.15 4.15 199800
2016-01-06 4.04 4.07 3.96 4.02 4.02 175300
2016-01-07 3.95 3.95 3.50 3.53 3.53 220600
2016-01-08 3.65 3.66 3.44 3.52 3.52 383100
2016-01-11 3.55 3.55 3.39 3.46 3.46 279300
2016-01-12 3.54 3.58 3.26 3.34 3.34 196100
2016-01-13 3.34 3.34 2.70 3.02 3.02 609800
2016-01-14 3.09 3.20 2.93 3.11 3.11 225300
2016-01-15 3.04 3.06 2.94 3.01 3.01 222800
2016-01-19 3.07 3.10 3.01 3.05 3.05 329300
2016-01-20 3.02 3.51 2.98 3.22 3.22 595300
2016-01-21 3.18 3.40 3.09 3.13 3.13 260500
2016-01-22 3.20 3.30 3.08 3.11 3.11 191000
2016-01-25 3.20 3.20 3.05 3.11 3.11 207200
2016-01-26 3.16 3.29 3.09 3.29 3.29 256700
2016-01-27 3.30 3.34 3.13 3.15 3.15 188200
2016-01-28 3.21 3.40 3.16 3.31 3.31 811100
2016-01-29 3.36 3.49 3.14 3.34 3.34 685300,
'UTX': Open High Low Close Adj Close Volume
Date
2015-12-31 4.19 4.24 4.03 4.16 4.16 157200
2016-01-04 4.16 4.25 3.97 4.24 4.24 554800
2016-01-05 4.26 4.27 3.98 4.15 4.15 199800
2016-01-06 4.04 4.07 3.96 4.02 4.02 175300
2016-01-07 3.95 3.95 3.50 3.53 3.53 220600
2016-01-08 3.65 3.66 3.44 3.52 3.52 383100
2016-01-11 3.55 3.55 3.39 3.46 3.46 279300
2016-01-12 3.54 3.58 3.26 3.34 3.34 196100
2016-01-13 3.34 3.34 2.70 3.02 3.02 609800
2016-01-14 3.09 3.20 2.93 3.11 3.11 225300
2016-01-15 3.04 3.06 2.94 3.01 3.01 222800
2016-01-19 3.07 3.10 3.01 3.05 3.05 329300
2016-01-20 3.02 3.51 2.98 3.22 3.22 595300
2016-01-21 3.18 3.40 3.09 3.13 3.13 260500
2016-01-22 3.20 3.30 3.08 3.11 3.11 191000
2016-01-25 3.20 3.20 3.05 3.11 3.11 207200
2016-01-26 3.16 3.29 3.09 3.29 3.29 256700
2016-01-27 3.30 3.34 3.13 3.15 3.15 188200
2016-01-28 3.21 3.40 3.16 3.31 3.31 811100
2016-01-29 3.36 3.49 3.14 3.34 3.34 685300}
In [17]:
symbol
Out[17]:
array(['DD', 'UTX', 'AAPL', 'CSCO', 'KO', 'MMM', 'MSFT', 'DIS', 'MCD',
'GE', 'PG', 'XOM', 'JNJ', 'WMT', 'VZ', 'HD', 'V', 'NKE', 'AXP',
'CAT', 'BA', 'JPM', 'TRV', 'PFE', 'MRK', 'UNH', 'INTC', 'CVX', 'GS',
'IBM'], dtype=object)
In [ ]:
Content source: Diyago/Machine-Learning-scripts
Similar notebooks: