In [22]:
#Импортируем перечень бумаг Доу Джонс
import pandas as pd
url = 'https://finance.yahoo.com/quote/RUB%3DX/chart?p=RUB%3DX'
df = pd.read_html(url)[0]
df
---------------------------------------------------------------------------
ValueError Traceback (most recent call last)
<ipython-input-22-8b1c6df52782> in <module>()
2 import pandas as pd
3 url = 'https://finance.yahoo.com/quote/RUB%3DX/chart?p=RUB%3DX'
----> 4 df = pd.read_html(url)[0]
5 df
~/anaconda3/lib/python3.6/site-packages/pandas/io/html.py in read_html(io, match, flavor, header, index_col, skiprows, attrs, parse_dates, tupleize_cols, thousands, encoding, decimal, converters, na_values, keep_default_na)
904 thousands=thousands, attrs=attrs, encoding=encoding,
905 decimal=decimal, converters=converters, na_values=na_values,
--> 906 keep_default_na=keep_default_na)
~/anaconda3/lib/python3.6/site-packages/pandas/io/html.py in _parse(flavor, io, match, attrs, encoding, **kwargs)
741 break
742 else:
--> 743 raise_with_traceback(retained)
744
745 ret = []
~/anaconda3/lib/python3.6/site-packages/pandas/compat/__init__.py in raise_with_traceback(exc, traceback)
342 if traceback == Ellipsis:
343 _, _, traceback = sys.exc_info()
--> 344 raise exc.with_traceback(traceback)
345 else:
346 # this version of raise is a syntax error in Python 3
ValueError: No tables found
In [7]:
#Выгружаем тикера и названия компаний
names=df[['Symbol','Company Name']]
symbol=names['Symbol'].values
full_name=names['Company Name'].values
print(symbol)
print(full_name)
['DD' 'GS' 'JNJ' 'JPM' 'VZ' 'IBM' 'V' 'AXP' 'HD' 'DIS' 'XOM' 'KO' 'PFE'
'CSCO' 'WMT' 'PG' 'CAT' 'TRV' 'UTX' 'MMM' 'MCD' 'BA' 'NKE' 'UNH' 'GE'
'AAPL' 'CVX' 'MRK' 'MSFT' 'INTC']
['E. I. du Pont de Nemours and Company' 'The Goldman Sachs Group, Inc.'
'Johnson & Johnson' 'JPMorgan Chase & Co.' 'Verizon Communications Inc.'
'International Business Machines Corporation' 'Visa Inc.'
'American Express Company' 'The Home Depot, Inc.'
'The Walt Disney Company' 'Exxon Mobil Corporation'
'The Coca-Cola Company' 'Pfizer Inc.' 'Cisco Systems, Inc.'
'Wal-Mart Stores, Inc.' 'The Procter & Gamble Company' 'Caterpillar Inc.'
'The Travelers Companies, Inc.' 'United Technologies Corporation'
'3M Company' "McDonald's Corporation" 'The Boeing Company' 'NIKE, Inc.'
'UnitedHealth Group Incorporated' 'General Electric Company' 'Apple Inc.'
'Chevron Corporation' 'Merck & Co., Inc.' 'Microsoft Corporation'
'Intel Corporation']
In [8]:
#грузим исторические данные на цену закрытия
import pandas_datareader.data as web
import datetime
start = datetime.datetime(2016, 1, 1)
end = datetime.datetime(2016, 1, 31)
data_exchange={}
# Экспорт с Yahoo
#for s in symbol:
# data_exchange[s]= web.DataReader(s,'yahoo', start, end)
#data_exchange
# Экспорт с Google
for s in symbol:
data_exchange[s]=web.get_data_google(s,start,end)
data_exchange
Out[8]:
{'AAPL': Open High Low Close Volume
Date
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
2016-12-02 109.17 110.09 108.85 109.90 26527997
2016-12-05 110.00 110.03 108.25 109.11 34324540
2016-12-06 109.50 110.36 109.19 109.95 26195462
2016-12-07 109.26 111.19 109.16 111.03 29998719
2016-12-08 110.86 112.43 110.60 112.12 27068316
2016-12-09 112.31 114.70 112.31 113.95 34402627
2016-12-12 113.29 115.00 112.49 113.30 26374377
... ... ... ... ... ...
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
2017-10-18 160.42 160.71 159.60 159.76 16374164
2017-10-19 156.75 157.08 155.02 155.98 42584166
2017-10-20 156.61 157.75 155.96 156.25 23974146
2017-10-23 156.89 157.69 155.50 156.17 21984327
2017-10-24 156.29 157.42 156.20 157.10 17757230
2017-10-25 156.91 157.55 155.27 156.41 21207098
2017-10-26 157.23 157.83 156.78 157.41 17000469
[250 rows x 5 columns], 'AXP': Open High Low Close Volume
Date
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
2016-12-02 72.52 72.66 71.43 71.86 2959077
2016-12-05 72.33 72.64 71.99 72.03 3929106
2016-12-06 72.47 72.74 72.08 72.31 3843944
2016-12-07 72.47 74.72 72.23 74.29 5801483
2016-12-08 74.80 75.20 73.99 74.91 3415782
2016-12-09 74.84 74.91 74.29 74.77 2566883
2016-12-12 74.70 74.70 73.15 73.58 3654947
... ... ... ... ... ...
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
2017-10-18 91.80 92.27 91.68 92.08 4720217
2017-10-19 90.40 92.95 90.04 91.90 6512126
2017-10-20 92.84 93.28 91.97 92.09 4442193
2017-10-23 92.22 93.09 92.22 92.38 2963132
2017-10-24 92.60 93.93 92.33 93.86 4481510
2017-10-25 94.00 94.24 93.27 93.53 4266092
2017-10-26 93.99 95.73 93.98 95.69 4136780
[250 rows x 5 columns], 'BA': Open High Low Close Volume
Date
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
2016-12-02 152.45 152.49 151.12 152.25 2105577
2016-12-05 153.24 153.75 151.85 152.16 2855946
2016-12-06 150.84 152.64 150.02 152.24 3476254
2016-12-07 151.67 154.31 151.07 154.14 2955753
2016-12-08 154.60 155.97 154.14 155.39 2928370
2016-12-09 155.65 156.88 155.42 156.49 2707872
2016-12-12 156.00 158.00 154.30 157.16 4250580
... ... ... ... ... ...
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
2017-10-18 258.47 260.73 256.66 260.04 2051651
2017-10-19 258.98 259.10 256.03 259.04 2589203
2017-10-20 260.36 264.83 259.44 264.75 3955922
2017-10-23 265.13 265.98 262.14 262.32 3302395
2017-10-24 263.24 267.21 263.24 266.00 4401597
2017-10-25 264.78 266.00 254.50 258.42 7895318
2017-10-26 259.72 261.44 257.31 259.27 3419137
[250 rows x 5 columns], 'CAT': Open High Low Close Volume
Date
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
2016-12-02 95.36 96.15 94.93 95.14 5038257
2016-12-05 95.87 95.99 94.15 94.45 4980335
2016-12-06 94.10 95.31 94.07 95.22 3663143
2016-12-07 95.25 97.33 94.93 97.33 4901054
2016-12-08 97.26 97.40 96.13 96.27 3861626
2016-12-09 96.23 96.30 95.19 95.53 6550220
2016-12-12 96.01 96.65 94.91 95.08 3597051
... ... ... ... ... ...
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
2017-10-18 130.50 131.65 130.50 131.29 2511437
2017-10-19 131.00 131.63 129.40 131.55 4837581
2017-10-20 131.34 131.91 130.48 131.36 3086775
2017-10-23 131.95 132.34 131.16 131.68 5549532
2017-10-24 140.06 140.44 136.63 138.24 18886700
2017-10-25 137.21 137.83 134.79 136.84 7438581
2017-10-26 136.88 138.24 136.85 136.94 5745354
[250 rows x 5 columns], 'CSCO': Open High Low Close Volume
Date
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
2016-12-02 29.31 29.56 29.12 29.25 27069499
2016-12-05 29.33 29.60 29.29 29.53 20865842
2016-12-06 29.42 29.59 29.24 29.33 27352068
2016-12-07 29.48 30.04 29.32 29.95 30180093
2016-12-08 30.11 30.33 29.92 29.95 21369897
2016-12-09 29.98 30.07 29.73 30.06 21361984
2016-12-12 30.08 30.20 30.02 30.17 17287809
... ... ... ... ... ...
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
2017-10-18 33.72 33.75 33.44 33.55 9971246
2017-10-19 33.51 33.89 33.45 33.75 13203111
2017-10-20 34.02 34.39 34.01 34.25 24361352
2017-10-23 34.45 34.68 34.27 34.35 22631966
2017-10-24 34.40 34.68 34.25 34.58 16280155
2017-10-25 34.73 34.73 34.16 34.30 17400891
2017-10-26 34.41 34.51 34.07 34.27 14616103
[250 rows x 5 columns], 'CVX': Open High Low Close Volume
Date
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
2016-12-02 113.20 113.81 112.28 113.00 6167368
2016-12-05 113.39 114.48 113.03 113.25 6909833
2016-12-06 112.39 113.48 112.21 112.76 6033609
2016-12-07 113.04 114.48 112.82 114.44 6434127
2016-12-08 114.73 115.40 114.20 115.17 5519718
2016-12-09 114.99 115.99 114.97 115.81 5771551
2016-12-12 117.77 118.99 116.57 117.15 10044655
... ... ... ... ... ...
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
2017-10-18 119.40 120.02 117.99 118.15 5505097
2017-10-19 118.06 118.74 117.95 118.20 4576638
2017-10-20 118.61 118.78 118.07 118.64 4924257
2017-10-23 118.72 119.30 118.45 118.93 3872393
2017-10-24 119.48 119.92 119.07 119.23 4472414
2017-10-25 119.00 119.44 118.14 118.44 4553104
2017-10-26 118.78 119.00 118.14 118.44 4092852
[250 rows x 5 columns], 'DD': Open High Low Close Volume
Date
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
2016-12-02 73.73 73.79 72.90 73.13 3233772
2016-12-05 73.48 74.04 72.65 72.89 3432101
2016-12-06 72.59 72.80 72.02 72.73 1981385
2016-12-07 72.58 74.02 72.50 73.82 3136881
2016-12-08 74.00 74.97 73.52 74.68 2861705
2016-12-09 74.90 74.98 74.20 74.85 2358921
2016-12-12 75.04 75.67 74.72 75.09 3652751
... ... ... ... ... ...
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
[211 rows x 5 columns], 'DIS': Open High Low Close Volume
Date
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
2016-12-02 98.79 99.08 98.25 98.50 7737193
2016-12-05 98.98 100.27 98.68 99.96 11331542
2016-12-06 99.95 100.72 99.82 100.66 8427531
2016-12-07 100.51 102.07 100.44 101.99 12255742
2016-12-08 101.47 103.96 101.47 103.38 16524763
2016-12-09 103.49 105.52 103.18 104.86 12173909
2016-12-12 104.61 104.70 103.73 104.06 7880201
... ... ... ... ... ...
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
2017-10-18 98.36 98.49 97.55 98.25 5404326
2017-10-19 98.19 99.30 98.11 99.01 5634272
2017-10-20 99.45 99.66 98.94 99.40 5938716
2017-10-23 99.12 99.18 98.63 98.70 5888226
2017-10-24 98.52 98.86 98.06 98.29 4966173
2017-10-25 98.05 98.22 97.45 97.80 5144415
2017-10-26 97.58 99.48 97.25 98.56 6167514
[250 rows x 5 columns], 'GE': Open High Low Close Volume
Date
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
2016-12-02 31.36 31.49 31.26 31.34 21401028
2016-12-05 31.43 31.45 31.06 31.11 22138326
2016-12-06 31.19 31.24 31.01 31.17 17573265
2016-12-07 31.01 31.60 30.93 31.60 32896981
2016-12-08 31.60 31.70 31.40 31.53 28145056
2016-12-09 31.45 31.92 31.35 31.78 31227376
2016-12-12 31.67 31.99 31.66 31.86 31040716
... ... ... ... ... ...
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
2017-10-18 23.20 23.28 23.07 23.12 34970681
2017-10-19 23.14 23.78 23.05 23.58 75574053
2017-10-20 22.14 23.84 22.10 23.83 192404370
2017-10-23 23.44 23.44 22.18 22.32 187340912
2017-10-24 22.12 22.31 21.75 21.89 133615914
2017-10-25 21.84 21.89 21.30 21.50 110518207
2017-10-26 21.57 21.65 21.20 21.32 86283723
[250 rows x 5 columns], 'GS': Open High Low Close Volume
Date
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
2016-12-02 226.00 226.25 221.22 223.36 5297420
2016-12-05 225.52 229.20 225.24 228.55 4599300
2016-12-06 230.18 232.67 227.90 231.38 5259347
2016-12-07 230.40 236.09 230.40 235.56 6595232
2016-12-08 236.88 242.42 236.00 241.45 7343669
2016-12-09 240.61 242.00 238.88 241.85 5456047
2016-12-12 240.50 242.83 236.37 237.17 5022038
... ... ... ... ... ...
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
2017-10-18 236.87 242.65 236.87 242.03 4235853
2017-10-19 240.35 240.99 238.10 239.99 2710875
2017-10-20 242.95 245.25 240.67 244.73 3022769
2017-10-23 244.39 245.33 241.38 242.13 1963295
2017-10-24 243.60 246.25 243.00 244.84 2285251
2017-10-25 246.16 246.50 240.80 241.71 2904307
2017-10-26 242.61 244.00 241.53 241.72 1948825
[250 rows x 5 columns], 'HD': Open High Low Close Volume
Date
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
2016-12-02 129.04 130.62 128.91 129.87 3738338
2016-12-05 130.32 130.46 129.56 129.68 4065425
2016-12-06 130.13 130.14 128.68 128.74 4292631
2016-12-07 128.75 133.06 128.75 132.46 6987286
2016-12-08 132.21 133.13 131.58 132.53 4975419
2016-12-09 132.51 133.40 131.10 133.39 5174577
2016-12-12 133.13 134.66 133.13 134.58 6276457
... ... ... ... ... ...
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
2017-10-18 163.42 164.24 163.35 163.45 2758595
2017-10-19 163.50 164.11 162.77 163.24 2676062
2017-10-20 163.97 164.15 162.74 163.43 4166481
2017-10-23 164.04 166.26 163.75 164.74 3995110
2017-10-24 164.67 166.46 164.65 166.03 3686663
2017-10-25 166.11 166.95 165.38 166.07 4189398
2017-10-26 166.39 167.94 166.11 167.65 3750464
[250 rows x 5 columns], 'IBM': Open High Low Close Volume
Date
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
2016-12-02 159.00 160.29 158.41 160.02 2740867
2016-12-05 160.85 161.15 159.59 159.84 3447052
2016-12-06 160.13 160.79 158.93 160.35 2858962
2016-12-07 160.60 165.18 160.39 164.79 4435050
2016-12-08 164.87 166.00 164.22 165.36 3266436
2016-12-09 165.18 166.72 164.60 166.52 3146930
2016-12-12 166.72 166.79 165.07 165.50 3392331
... ... ... ... ... ...
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
2017-10-18 157.12 161.23 156.95 159.53 30490192
2017-10-19 159.80 160.96 159.08 160.90 9914169
2017-10-20 161.07 162.48 159.77 162.07 7868803
2017-10-23 162.05 162.51 159.54 159.55 5779378
2017-10-24 159.65 159.70 155.17 155.88 8194690
2017-10-25 156.01 156.37 153.06 153.50 6921137
2017-10-26 154.31 155.12 153.54 153.60 4300543
[250 rows x 5 columns], 'INTC': Open High Low Close Volume
Date
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
2016-12-02 33.72 34.26 33.60 34.16 21492534
2016-12-05 34.31 34.42 33.96 34.39 14461972
2016-12-06 34.39 34.75 34.30 34.72 15297703
2016-12-07 34.67 35.57 34.45 35.50 21710273
2016-12-08 35.48 36.03 35.22 35.70 19966537
2016-12-09 35.75 35.90 35.59 35.76 16326925
2016-12-12 35.78 36.09 35.67 35.97 21985830
... ... ... ... ... ...
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
2017-10-18 39.80 40.29 39.60 40.25 21424554
2017-10-19 39.88 40.33 39.83 40.09 19222705
2017-10-20 40.33 40.45 40.10 40.43 18335672
2017-10-23 40.55 41.04 40.40 40.83 28646966
2017-10-24 41.00 41.05 40.72 40.95 19652417
2017-10-25 40.89 41.06 40.49 40.78 24031660
2017-10-26 40.91 41.58 40.71 41.35 38247395
[250 rows x 5 columns], 'JNJ': Open High Low Close Volume
Date
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
2016-12-02 111.72 112.53 111.44 111.96 6167740
2016-12-05 112.40 112.42 111.73 111.94 5451568
2016-12-06 112.24 113.20 111.85 112.06 6530358
2016-12-07 111.89 111.89 109.32 111.10 11761134
2016-12-08 110.54 111.20 109.93 110.99 7774945
2016-12-09 111.41 112.43 111.20 112.26 7672088
2016-12-12 112.69 115.40 112.58 115.36 9544614
... ... ... ... ... ...
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
2017-10-18 140.79 141.58 140.07 140.68 6827734
2017-10-19 140.71 142.98 140.54 142.04 9181291
2017-10-20 142.38 143.62 141.83 142.40 5634523
2017-10-23 142.13 144.35 142.08 143.62 6685964
2017-10-24 143.38 143.38 140.93 141.64 6585767
2017-10-25 141.16 143.23 140.96 142.36 6563580
2017-10-26 142.51 143.75 141.38 141.81 5841067
[250 rows x 5 columns], 'JPM': Open High Low Close Volume
Date
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
2016-12-02 81.80 81.83 80.90 81.60 16931504
2016-12-05 82.30 83.29 82.29 83.26 18529840
2016-12-06 83.60 83.81 82.43 83.69 16130043
2016-12-07 83.55 84.09 82.85 84.07 18996905
2016-12-08 84.23 85.50 83.94 85.12 20844853
2016-12-09 85.02 85.50 84.14 85.49 14567202
2016-12-12 85.36 85.79 84.29 84.73 14511332
... ... ... ... ... ...
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
2017-10-18 98.15 98.55 97.63 97.99 10158626
2017-10-19 97.19 98.20 97.09 98.11 9133863
2017-10-20 99.28 99.89 98.73 99.51 15326608
2017-10-23 99.51 99.99 99.24 99.34 9238624
2017-10-24 99.88 101.19 99.76 100.92 13000801
2017-10-25 101.25 101.45 100.19 101.02 14632741
2017-10-26 101.35 102.42 101.32 101.74 13054361
[250 rows x 5 columns], 'KO': Open High Low Close Volume
Date
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
2016-12-02 40.30 40.50 40.19 40.36 11176301
2016-12-05 40.34 40.69 40.31 40.62 15977847
2016-12-06 40.75 40.77 40.42 40.57 11303492
2016-12-07 40.54 41.29 40.51 41.29 13726520
2016-12-08 41.07 41.21 40.84 40.98 13077139
2016-12-09 41.50 42.22 41.29 42.00 28125775
2016-12-12 42.00 42.01 41.72 41.90 17561900
... ... ... ... ... ...
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
2017-10-18 46.41 46.54 46.24 46.40 6272155
2017-10-19 46.37 46.79 46.32 46.59 7515545
2017-10-20 46.58 46.59 46.28 46.38 9646790
2017-10-23 46.38 46.65 46.23 46.32 7153607
2017-10-24 46.26 46.29 45.95 46.18 9539484
2017-10-25 46.37 46.76 45.93 46.05 11994174
2017-10-26 46.32 46.75 46.22 46.23 10569064
[250 rows x 5 columns], 'MCD': Open High Low Close Volume
Date
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
2016-12-02 118.00 118.50 117.71 118.24 3348723
2016-12-05 119.45 120.34 119.03 119.29 5191935
2016-12-06 119.29 119.65 118.60 119.25 3367984
2016-12-07 119.41 120.13 118.46 119.92 4059907
2016-12-08 120.05 121.15 119.50 120.45 3255709
2016-12-09 120.57 121.27 120.21 121.26 2623713
2016-12-12 121.57 122.25 121.26 121.74 4172434
... ... ... ... ... ...
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
2017-10-18 165.29 166.25 163.89 165.77 2798259
2017-10-19 165.82 166.95 164.92 166.50 2478221
2017-10-20 167.23 167.90 165.50 166.30 5577713
2017-10-23 166.10 166.10 163.09 163.34 6214780
2017-10-24 165.26 166.48 163.59 163.88 7855167
2017-10-25 163.41 165.12 163.00 163.58 3716202
2017-10-26 164.14 164.65 163.75 164.01 2934412
[250 rows x 5 columns], 'MMM': Open High Low Close Volume
Date
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
2016-12-02 172.53 173.69 172.24 172.43 1871524
2016-12-05 172.63 172.95 171.08 171.62 2181327
2016-12-06 171.82 172.03 171.23 171.80 1467548
2016-12-07 172.38 176.06 171.97 176.05 3164316
2016-12-08 176.08 176.35 174.77 175.88 1790705
2016-12-09 175.36 178.87 175.30 178.49 2650644
2016-12-12 178.25 179.81 177.57 179.64 2296090
... ... ... ... ... ...
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
2017-10-18 217.52 218.64 217.37 218.27 1413913
2017-10-19 218.49 219.25 217.47 219.24 1369000
2017-10-20 219.95 221.32 219.19 221.32 1647816
2017-10-23 221.76 222.78 221.20 221.55 2161339
2017-10-24 229.00 238.90 228.99 234.65 6508396
2017-10-25 235.01 237.94 233.94 237.68 4114532
2017-10-26 238.26 238.80 232.31 232.94 3384956
[250 rows x 5 columns], 'MRK': Open High Low Close Volume
Date
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
2016-12-02 61.05 61.52 60.62 61.13 7993092
2016-12-05 61.52 61.53 59.84 60.25 12985234
2016-12-06 60.18 60.39 59.61 60.28 10659613
2016-12-07 59.70 60.06 58.62 60.06 14049574
2016-12-08 59.73 60.36 59.50 60.12 8586550
2016-12-09 60.49 61.51 60.40 61.23 10516352
2016-12-12 61.44 62.10 61.30 61.72 8246004
... ... ... ... ... ...
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
2017-10-18 64.09 64.11 63.41 63.51 7886855
2017-10-19 63.64 64.03 63.59 63.75 10071235
2017-10-20 63.85 63.99 63.57 63.88 10304201
2017-10-23 64.03 64.52 63.30 63.40 11582013
2017-10-24 63.31 63.31 62.36 63.11 10221095
2017-10-25 63.10 63.12 62.33 62.45 11016700
2017-10-26 62.29 62.69 61.80 61.99 10744312
[250 rows x 5 columns], 'MSFT': Open High Low Close Volume
Date
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
2016-12-02 59.08 59.47 58.80 59.25 25515665
2016-12-05 59.70 60.58 59.56 60.22 23552658
2016-12-06 60.43 60.46 59.80 59.95 19907035
2016-12-07 60.01 61.38 59.80 61.37 30808969
2016-12-08 61.30 61.58 60.84 61.01 21220753
2016-12-09 61.18 61.99 61.12 61.97 27349356
2016-12-12 61.82 62.30 61.72 62.17 20198081
... ... ... ... ... ...
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
2017-10-18 77.67 77.85 77.37 77.61 13300701
2017-10-19 77.57 77.93 77.35 77.91 15092758
2017-10-20 78.32 78.97 78.22 78.81 22866426
2017-10-23 78.99 79.34 78.76 78.83 20627173
2017-10-24 78.90 79.20 78.46 78.86 17517182
2017-10-25 78.58 79.10 78.01 78.63 20410808
2017-10-26 79.20 79.42 78.75 78.76 32120717
[250 rows x 5 columns], 'NKE': Open High Low Close Volume
Date
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
2016-12-02 50.26 50.68 50.10 50.46 6933279
2016-12-05 50.80 52.27 50.70 51.85 12031170
2016-12-06 50.83 51.10 50.26 50.57 12496332
2016-12-07 50.79 52.25 50.60 52.10 10412638
2016-12-08 52.15 52.47 51.45 51.55 9260850
2016-12-09 51.76 51.97 51.50 51.72 5869828
2016-12-12 51.50 51.90 50.94 51.54 11459541
... ... ... ... ... ...
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
2017-10-18 52.18 52.40 52.10 52.30 10890257
2017-10-19 51.66 52.80 51.48 52.69 12568217
2017-10-20 52.79 53.50 52.79 53.06 13020916
2017-10-23 53.06 53.95 53.00 53.66 12242580
2017-10-24 53.90 54.00 53.10 53.42 14767595
2017-10-25 53.43 55.90 52.67 54.94 24804028
2017-10-26 55.26 57.25 55.14 56.81 22185144
[250 rows x 5 columns], 'PFE': Open High Low Close Volume
Date
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
2016-12-02 31.54 31.73 31.36 31.63 19007839
2016-12-05 31.74 31.77 31.39 31.59 19300328
2016-12-06 31.65 31.70 31.43 31.56 17706806
2016-12-07 31.33 31.33 30.60 31.19 44053675
2016-12-08 30.84 31.10 30.51 30.94 35493010
2016-12-09 31.11 31.92 31.09 31.70 29350843
2016-12-12 31.70 32.65 31.66 32.40 32255700
... ... ... ... ... ...
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
2017-10-18 36.25 36.29 35.79 35.83 14418003
2017-10-19 35.89 36.38 35.84 36.24 19789423
2017-10-20 36.30 36.42 36.03 36.42 17502245
2017-10-23 36.30 36.78 36.30 36.40 15159383
2017-10-24 36.45 36.53 35.99 36.27 15015341
2017-10-25 36.20 36.35 35.92 36.16 16625693
2017-10-26 36.09 36.22 35.60 35.74 17432863
[250 rows x 5 columns], 'PG': Open High Low Close Volume
Date
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
2016-12-02 82.35 82.68 82.07 82.40 9079412
2016-12-05 82.56 83.08 82.48 82.99 8597543
2016-12-06 83.24 83.25 82.61 82.91 7327194
2016-12-07 82.74 84.28 82.71 84.18 8567706
2016-12-08 83.79 84.18 83.50 83.50 7522799
2016-12-09 83.52 84.40 83.47 84.37 8004453
2016-12-12 84.21 85.18 84.21 85.13 7494115
... ... ... ... ... ...
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
2017-10-18 92.78 92.95 92.01 92.77 7399662
2017-10-19 91.70 91.99 91.14 91.59 8584972
2017-10-20 89.72 89.96 87.59 88.25 19997800
2017-10-23 88.63 88.86 86.87 87.30 13358194
2017-10-24 87.37 87.42 86.78 86.98 11519038
2017-10-25 86.90 87.11 86.28 86.86 9024251
2017-10-26 87.19 87.77 87.10 87.50 6233848
[250 rows x 5 columns], 'TRV': Open High Low Close Volume
Date
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
2016-12-02 114.95 115.96 114.86 115.65 1885339
2016-12-05 116.05 116.12 114.80 115.87 2041512
2016-12-06 116.39 116.87 115.80 116.83 1785849
2016-12-07 116.48 118.36 116.22 117.99 2316808
2016-12-08 118.38 119.26 118.17 118.38 2046154
2016-12-09 118.70 119.19 117.87 119.19 2138835
2016-12-12 119.87 120.99 119.56 120.91 1890890
... ... ... ... ... ...
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
2017-10-18 128.70 130.16 128.47 130.02 1991720
2017-10-19 129.78 133.17 128.24 133.17 2970858
2017-10-20 134.00 134.11 132.53 133.32 1838805
2017-10-23 133.73 134.47 132.88 134.45 1790192
2017-10-24 134.04 134.40 132.72 133.19 1712252
2017-10-25 133.38 133.44 131.75 131.78 1628943
2017-10-26 132.72 132.89 130.75 131.94 1490813
[250 rows x 5 columns], 'UNH': Open High Low Close Volume
Date
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
2016-12-02 161.00 162.52 160.56 160.73 3480032
2016-12-05 160.19 160.67 156.23 157.63 5854226
2016-12-06 158.17 158.23 156.26 157.32 3216730
2016-12-07 157.89 159.98 156.35 159.40 4552337
2016-12-08 159.41 160.24 158.00 159.32 3407518
2016-12-09 159.52 160.16 157.71 160.12 4007213
2016-12-12 158.83 159.66 157.75 159.49 3471430
... ... ... ... ... ...
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
2017-10-18 203.80 207.80 203.68 205.23 4796337
2017-10-19 205.47 205.74 202.70 203.25 3471790
2017-10-20 204.26 208.21 203.69 207.49 5138814
2017-10-23 207.58 208.45 205.80 207.01 2261386
2017-10-24 206.38 208.23 205.88 208.15 3459875
2017-10-25 208.32 209.14 207.07 207.56 2908292
2017-10-26 207.92 211.70 207.58 209.15 4345993
[250 rows x 5 columns], 'UTX': Open High Low Close Volume
Date
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
2016-12-02 108.04 108.57 107.48 108.22 3124427
2016-12-05 108.72 108.80 107.36 107.42 3077760
2016-12-06 107.30 107.70 107.08 107.43 2179451
2016-12-07 107.50 109.84 107.08 109.68 4261795
2016-12-08 109.67 109.68 108.14 108.43 3168580
2016-12-09 108.54 109.99 108.06 109.79 3429005
2016-12-12 109.42 110.50 108.79 110.39 4478670
... ... ... ... ... ...
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
2017-10-18 119.50 119.50 118.60 119.18 1855599
2017-10-19 119.10 119.53 118.22 119.49 1631657
2017-10-20 119.96 120.93 119.76 120.93 2514652
2017-10-23 120.76 121.18 120.47 120.89 2577566
2017-10-24 119.95 123.28 118.95 119.74 5432516
2017-10-25 119.71 120.29 118.87 118.99 3687339
2017-10-26 119.45 120.07 119.00 119.93 3380834
[250 rows x 5 columns], 'V': Open High Low Close Volume
Date
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
2016-12-02 75.40 76.25 75.17 75.72 13629619
2016-12-05 76.63 77.60 76.55 77.31 12119198
2016-12-06 77.94 77.97 76.71 77.11 13896640
2016-12-07 77.27 79.49 77.25 79.31 13919763
2016-12-08 79.68 79.87 78.97 79.28 13320094
2016-12-09 79.15 79.93 78.83 79.14 10728310
2016-12-12 78.99 79.03 77.92 78.50 11942252
... ... ... ... ... ...
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
2017-10-18 107.62 108.00 107.46 107.80 4817276
2017-10-19 107.27 107.78 106.90 107.02 10840248
2017-10-20 107.70 107.70 106.97 107.55 7848922
2017-10-23 108.05 108.23 107.10 107.53 6316736
2017-10-24 107.56 108.64 107.18 108.41 10511238
2017-10-25 109.41 110.61 108.00 109.49 13261308
2017-10-26 110.38 110.74 109.67 109.80 7380110
[250 rows x 5 columns], 'VZ': Open High Low Close Volume
Date
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
2016-12-02 50.00 50.32 49.60 49.81 10650716
2016-12-05 49.74 50.08 49.74 49.75 13074713
2016-12-06 50.15 50.62 49.76 50.36 13581523
2016-12-07 50.72 51.43 50.44 51.38 16280568
2016-12-08 51.23 51.28 50.98 51.13 11502897
2016-12-09 51.09 51.63 50.92 51.49 10101462
2016-12-12 51.54 52.43 51.48 51.76 16186418
... ... ... ... ... ...
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
2017-10-18 48.33 48.85 47.76 48.65 20410445
2017-10-19 50.05 51.18 49.05 49.21 29173869
2017-10-20 49.45 49.59 48.93 49.53 16259580
2017-10-23 49.47 49.69 48.91 48.99 15659974
2017-10-24 49.16 49.28 48.72 48.94 11527916
2017-10-25 48.68 48.79 48.15 48.64 19256754
2017-10-26 48.86 49.43 48.75 48.89 14420059
[250 rows x 5 columns], 'WMT': Open High Low Close Volume
Date
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
2016-12-02 70.58 70.95 70.45 70.88 6674206
2016-12-05 70.90 70.99 69.81 69.94 10527877
2016-12-06 70.01 70.39 69.50 70.36 7778009
2016-12-07 69.93 70.65 69.90 70.60 6966249
2016-12-08 70.48 70.90 70.32 70.34 6844217
2016-12-09 70.27 70.43 69.74 70.08 10756653
2016-12-12 70.07 71.78 70.02 71.67 9084076
... ... ... ... ... ...
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
2017-10-18 86.15 86.37 86.01 86.22 5472088
2017-10-19 86.15 86.66 85.77 86.40 7028958
2017-10-20 86.60 87.45 86.28 87.44 7617753
2017-10-23 87.34 88.92 87.26 88.65 10586033
2017-10-24 88.69 88.80 87.91 87.98 7700872
2017-10-25 87.85 88.60 87.43 88.48 6408003
2017-10-26 88.66 89.11 88.02 88.62 6484941
[250 rows x 5 columns], 'XOM': Open High Low Close Volume
Date
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
2016-12-02 87.19 87.99 86.60 87.04 9706646
2016-12-05 87.39 87.82 86.92 87.48 11741074
2016-12-06 87.27 87.87 86.70 87.56 11293620
2016-12-07 87.63 88.15 87.20 88.07 11182628
2016-12-08 88.05 88.85 87.65 88.32 9086715
2016-12-09 88.64 89.00 88.18 89.00 8021683
2016-12-12 90.14 91.50 90.14 90.98 15545409
... ... ... ... ... ...
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
2017-10-18 82.96 83.39 82.54 82.76 6367060
2017-10-19 82.35 83.05 82.33 82.74 7945461
2017-10-20 82.85 83.13 82.62 83.11 9574086
2017-10-23 83.15 83.76 83.04 83.24 9829896
2017-10-24 83.55 83.81 83.31 83.47 7551187
2017-10-25 83.45 83.73 82.95 83.17 9153318
2017-10-26 83.37 83.65 83.11 83.47 9154478
[250 rows x 5 columns]}
In [9]:
price = pd.DataFrame({ tic: data['Close'] for tic, data in data_exchange.items() })
price
Out[9]:
AAPL
AXP
BA
CAT
CSCO
CVX
DD
DIS
GE
GS
...
NKE
PFE
PG
TRV
UNH
UTX
V
VZ
WMT
XOM
Date
2016-10-31
113.54
66.42
142.43
83.46
30.68
104.75
68.79
92.69
29.10
178.24
...
50.18
31.71
86.80
108.18
141.33
102.20
82.51
48.10
70.02
83.32
2016-11-01
111.49
66.25
142.41
82.24
30.48
106.48
68.44
92.39
28.88
178.06
...
49.62
31.07
86.85
106.24
139.43
102.01
81.62
47.66
69.30
83.65
2016-11-02
111.59
65.45
140.75
81.11
30.39
105.39
68.36
91.91
28.49
176.58
...
49.72
30.63
86.74
105.62
138.98
101.54
80.58
46.94
69.45
83.45
2016-11-03
109.83
65.33
140.02
81.27
30.32
105.39
68.50
93.37
28.28
176.21
...
49.73
29.89
86.60
105.72
137.83
101.05
80.65
46.87
69.63
83.66
2016-11-04
108.84
65.51
139.54
82.31
30.19
104.78
68.61
92.45
28.44
175.92
...
49.96
30.00
85.08
104.67
137.71
101.33
80.36
47.08
69.16
83.57
2016-11-07
110.41
67.00
143.03
83.75
30.94
106.85
69.51
94.43
29.31
181.48
...
50.91
30.38
86.56
105.36
141.93
103.05
82.51
47.46
69.78
85.45
2016-11-08
111.06
67.07
142.20
84.68
31.00
107.29
69.26
94.38
29.42
181.92
...
51.08
30.00
87.46
108.01
142.90
103.37
82.88
47.65
69.79
85.31
2016-11-09
110.88
68.74
145.09
91.20
31.36
107.64
70.28
94.64
29.63
192.63
...
51.12
32.12
85.93
106.94
141.90
104.81
83.24
47.86
71.10
86.25
2016-11-10
107.79
70.11
147.69
93.45
31.00
107.79
70.95
94.96
30.41
200.87
...
50.39
33.49
82.96
109.62
146.13
108.41
81.87
46.69
71.39
87.05
2016-11-11
108.43
70.50
148.52
93.01
31.36
106.64
69.21
97.68
30.71
203.94
...
50.77
32.59
83.58
110.28
146.42
108.86
81.88
46.69
71.23
85.67
2016-11-14
105.71
72.42
149.99
94.17
31.37
106.59
69.07
97.92
30.51
209.18
...
50.21
32.38
83.00
112.18
152.28
107.86
78.38
46.18
70.49
85.28
2016-11-15
107.11
72.47
148.11
94.44
31.70
108.96
68.64
97.70
30.75
211.19
...
50.13
32.23
83.62
111.85
152.23
107.68
78.57
47.37
71.42
86.82
2016-11-16
109.99
71.68
146.44
93.35
31.57
108.35
68.88
99.12
30.74
206.26
...
50.68
31.96
83.19
111.35
151.50
106.96
80.08
47.93
71.39
85.75
2016-11-17
109.95
71.78
145.33
92.78
30.05
108.12
69.17
99.37
30.79
209.63
...
51.59
31.73
83.07
111.18
150.77
106.70
81.07
47.84
69.19
85.23
2016-11-18
110.06
71.00
146.35
92.34
30.18
109.20
68.84
98.24
30.67
210.35
...
51.10
31.48
82.00
111.82
149.45
106.50
80.82
48.07
68.54
85.28
2016-11-21
111.73
71.54
147.02
92.90
30.05
110.18
70.07
97.63
30.87
211.08
...
51.28
31.57
82.64
111.84
150.41
106.85
81.69
48.31
69.37
86.49
2016-11-22
111.80
71.72
149.52
93.62
29.89
110.62
70.91
97.71
31.18
211.11
...
51.71
31.33
82.76
112.40
152.26
106.94
79.93
49.49
70.12
86.68
2016-11-23
111.23
72.88
149.74
96.18
29.71
111.00
70.32
98.26
31.34
212.31
...
51.34
31.42
82.68
113.07
153.54
108.11
79.57
50.23
70.83
86.92
2016-11-25
111.79
72.86
150.04
95.81
30.09
111.00
71.00
98.82
31.44
211.38
...
51.52
31.69
83.46
113.45
152.81
108.78
80.13
50.67
71.23
87.12
2016-11-28
111.57
72.13
149.77
94.90
29.92
110.50
70.89
98.97
31.25
210.35
...
51.01
31.54
83.07
113.81
152.11
108.45
79.08
51.12
71.19
86.47
2016-11-29
111.46
71.49
151.64
94.04
29.83
109.34
71.20
99.67
31.05
211.75
...
50.63
31.92
82.89
113.70
157.59
108.84
79.15
50.96
71.37
85.90
2016-11-30
110.52
72.04
150.56
95.56
29.82
111.56
73.61
99.12
30.76
219.29
...
50.07
32.14
82.46
113.35
158.32
107.72
77.32
49.90
70.43
87.30
2016-12-01
109.49
72.53
152.39
96.24
29.45
113.29
73.62
98.94
31.39
226.63
...
50.65
31.46
81.86
115.41
160.94
107.48
75.43
49.87
70.67
87.24
2016-12-02
109.90
71.86
152.25
95.14
29.25
113.00
73.13
98.50
31.34
223.36
...
50.46
31.63
82.40
115.65
160.73
108.22
75.72
49.81
70.88
87.04
2016-12-05
109.11
72.03
152.16
94.45
29.53
113.25
72.89
99.96
31.11
228.55
...
51.85
31.59
82.99
115.87
157.63
107.42
77.31
49.75
69.94
87.48
2016-12-06
109.95
72.31
152.24
95.22
29.33
112.76
72.73
100.66
31.17
231.38
...
50.57
31.56
82.91
116.83
157.32
107.43
77.11
50.36
70.36
87.56
2016-12-07
111.03
74.29
154.14
97.33
29.95
114.44
73.82
101.99
31.60
235.56
...
52.10
31.19
84.18
117.99
159.40
109.68
79.31
51.38
70.60
88.07
2016-12-08
112.12
74.91
155.39
96.27
29.95
115.17
74.68
103.38
31.53
241.45
...
51.55
30.94
83.50
118.38
159.32
108.43
79.28
51.13
70.34
88.32
2016-12-09
113.95
74.77
156.49
95.53
30.06
115.81
74.85
104.86
31.78
241.85
...
51.72
31.70
84.37
119.19
160.12
109.79
79.14
51.49
70.08
89.00
2016-12-12
113.30
73.58
157.16
95.08
30.17
117.15
75.09
104.06
31.86
237.17
...
51.54
32.40
85.13
120.91
159.49
110.39
78.50
51.76
71.67
90.98
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
2017-09-15
159.88
86.99
249.00
121.37
32.44
114.63
NaN
98.52
23.93
225.22
...
53.87
35.36
93.27
120.70
198.18
113.08
105.30
47.86
80.38
80.07
2017-09-18
158.67
87.87
253.08
123.83
32.52
115.19
NaN
98.10
24.46
227.53
...
53.50
35.55
93.15
120.72
198.19
112.77
104.83
48.09
80.00
80.09
2017-09-19
158.73
89.00
252.46
124.74
32.49
116.34
NaN
98.43
24.20
228.91
...
53.33
35.45
94.17
120.58
194.65
113.65
105.41
49.34
80.05
80.22
2017-09-20
156.07
88.43
255.46
124.85
32.60
116.37
NaN
99.21
24.32
229.79
...
53.56
35.99
94.40
121.91
195.75
114.10
104.97
49.48
80.50
80.55
2017-09-21
153.39
88.42
256.04
124.79
32.70
116.47
NaN
98.89
24.75
231.29
...
53.19
35.97
92.64
121.49
195.21
114.50
105.31
48.94
80.01
79.89
2017-09-22
151.89
88.40
256.45
124.43
33.37
117.29
NaN
98.60
24.87
231.03
...
53.24
35.96
92.24
122.04
193.03
115.01
105.56
49.90
79.53
79.92
2017-09-25
150.55
88.21
254.32
124.32
33.72
117.99
NaN
99.57
25.11
230.26
...
53.23
35.51
92.72
122.67
191.75
114.29
103.02
49.90
79.15
80.98
2017-09-26
153.14
88.69
253.70
124.51
33.76
117.52
NaN
98.63
24.93
229.94
...
53.70
35.30
92.65
122.57
192.70
114.72
102.94
49.51
79.39
80.89
2017-09-27
154.23
89.49
255.28
124.52
33.48
117.45
NaN
99.24
24.37
234.76
...
52.67
35.45
90.87
122.59
194.49
117.18
103.89
49.51
79.29
81.43
2017-09-28
153.28
90.14
254.27
125.23
33.35
117.62
NaN
98.05
24.24
235.47
...
52.63
35.60
90.89
122.80
196.10
115.84
104.58
49.41
78.95
82.19
2017-09-29
154.12
90.46
254.21
124.71
33.63
117.50
NaN
98.57
24.18
237.19
...
51.85
35.70
90.98
122.52
195.85
116.08
105.24
49.49
78.14
81.98
2017-10-02
153.81
90.54
255.99
124.72
33.75
117.43
NaN
99.86
24.57
240.65
...
51.87
36.07
91.77
123.32
197.44
117.58
105.44
49.36
78.45
81.63
2017-10-03
154.48
91.43
255.46
125.51
33.85
117.82
NaN
100.79
24.80
241.62
...
51.47
36.14
92.12
123.70
198.63
117.71
105.59
49.85
79.22
81.76
2017-10-04
153.48
91.01
255.76
126.74
33.44
117.58
NaN
100.55
24.48
240.31
...
52.08
35.96
92.42
123.90
200.48
117.63
105.31
49.90
79.09
81.79
2017-10-05
155.39
91.16
258.89
126.40
33.59
118.58
NaN
100.11
24.54
246.06
...
52.18
36.00
92.03
124.44
197.90
118.17
106.24
49.77
79.41
82.02
2017-10-06
155.30
91.55
258.58
126.93
33.75
117.03
NaN
100.07
24.39
246.02
...
52.42
36.05
92.33
125.07
198.06
118.23
106.73
48.81
79.00
81.71
2017-10-09
155.84
91.69
258.39
126.88
33.76
117.71
NaN
99.57
23.43
242.80
...
51.52
36.14
92.12
124.95
196.30
118.63
107.01
49.05
80.53
82.03
2017-10-10
155.90
91.89
260.93
128.19
33.55
118.80
NaN
99.58
23.36
242.60
...
51.53
36.40
91.62
125.94
194.68
118.12
107.31
49.14
84.13
82.26
2017-10-11
156.55
92.44
260.39
127.88
33.59
118.75
NaN
98.90
23.08
241.89
...
51.13
36.34
91.48
126.12
193.93
117.80
107.99
49.21
84.63
82.22
2017-10-12
156.00
91.61
261.91
129.99
33.26
119.14
NaN
96.93
23.05
239.80
...
50.83
36.35
92.15
125.95
192.92
118.82
108.11
48.35
86.10
82.43
2017-10-13
156.99
92.86
260.74
130.71
33.47
119.16
NaN
97.38
22.98
238.53
...
50.98
36.34
93.04
126.67
192.52
118.72
108.66
47.86
86.62
82.41
2017-10-16
159.88
91.96
259.75
131.47
33.54
120.13
NaN
98.13
23.36
242.41
...
51.37
35.98
93.14
128.82
193.20
119.01
108.30
48.09
85.74
82.81
2017-10-17
160.47
91.69
258.62
130.54
33.60
120.22
NaN
98.36
23.19
236.09
...
52.00
36.20
92.80
128.65
203.89
119.36
107.54
48.40
85.98
82.96
2017-10-18
159.76
92.08
260.04
131.29
33.55
118.15
NaN
98.25
23.12
242.03
...
52.30
35.83
92.77
130.02
205.23
119.18
107.80
48.65
86.22
82.76
2017-10-19
155.98
91.90
259.04
131.55
33.75
118.20
NaN
99.01
23.58
239.99
...
52.69
36.24
91.59
133.17
203.25
119.49
107.02
49.21
86.40
82.74
2017-10-20
156.25
92.09
264.75
131.36
34.25
118.64
NaN
99.40
23.83
244.73
...
53.06
36.42
88.25
133.32
207.49
120.93
107.55
49.53
87.44
83.11
2017-10-23
156.17
92.38
262.32
131.68
34.35
118.93
NaN
98.70
22.32
242.13
...
53.66
36.40
87.30
134.45
207.01
120.89
107.53
48.99
88.65
83.24
2017-10-24
157.10
93.86
266.00
138.24
34.58
119.23
NaN
98.29
21.89
244.84
...
53.42
36.27
86.98
133.19
208.15
119.74
108.41
48.94
87.98
83.47
2017-10-25
156.41
93.53
258.42
136.84
34.30
118.44
NaN
97.80
21.50
241.71
...
54.94
36.16
86.86
131.78
207.56
118.99
109.49
48.64
88.48
83.17
2017-10-26
157.41
95.69
259.27
136.94
34.27
118.44
NaN
98.56
21.32
241.72
...
56.81
35.74
87.50
131.94
209.15
119.93
109.80
48.89
88.62
83.47
250 rows × 30 columns
In [10]:
result_corr=price.corr().replace(1,0)
result_corr
Out[10]:
AAPL
AXP
BA
CAT
CSCO
CVX
DD
DIS
GE
GS
...
NKE
PFE
PG
TRV
UNH
UTX
V
VZ
WMT
XOM
AAPL
0.000000
0.812084
0.840925
0.745196
0.557783
-0.222643
0.874111
0.081608
-0.808384
0.099902
...
0.418982
0.623282
0.767258
0.709708
0.869627
0.743952
0.921307
-0.498782
0.796963
-0.824101
AXP
0.812084
0.000000
0.945517
0.919930
0.459522
0.203594
0.899341
-0.129616
-0.852090
0.380277
...
0.355743
0.789974
0.697582
0.778001
0.939796
0.636637
0.909637
-0.238846
0.777941
-0.587705
BA
0.840925
0.945517
0.000000
0.953403
0.394448
0.154817
0.825886
-0.289862
-0.941606
0.162150
...
0.257755
0.732048
0.739201
0.683653
0.953345
0.566810
0.963647
-0.264013
0.866287
-0.652191
CAT
0.745196
0.919930
0.953403
0.000000
0.299744
0.263935
0.730726
-0.398156
-0.913010
0.172000
...
0.090776
0.684740
0.570762
0.645541
0.924275
0.561454
0.908247
-0.241712
0.884296
-0.496654
CSCO
0.557783
0.459522
0.394448
0.299744
0.000000
-0.027932
0.489723
0.343829
-0.304477
0.349687
...
0.359776
0.718889
0.575151
0.357772
0.330307
0.334459
0.469089
-0.167878
0.324448
-0.414262
CVX
-0.222643
0.203594
0.154817
0.263935
-0.027932
0.000000
-0.467611
-0.278768
-0.013144
0.581226
...
-0.329519
0.314428
-0.007864
0.005810
0.048254
-0.354572
-0.034155
0.741431
-0.010869
0.499676
DD
0.874111
0.899341
0.825886
0.730726
0.489723
-0.467611
0.000000
0.485452
-0.665578
0.269210
...
0.708728
0.651428
0.720695
0.860152
0.865327
0.798138
0.842157
-0.477253
0.632431
-0.706187
DIS
0.081608
-0.129616
-0.289862
-0.398156
0.343829
-0.278768
0.485452
0.000000
0.431051
0.396420
...
0.520058
-0.014684
0.040095
0.183703
-0.185547
0.211194
-0.223277
0.027934
-0.335300
-0.057535
GE
-0.808384
-0.852090
-0.941606
-0.913010
-0.304477
-0.013144
-0.665578
0.431051
0.000000
0.075790
...
-0.164812
-0.589623
-0.659892
-0.556930
-0.893697
-0.531311
-0.952104
0.432609
-0.871264
0.696107
GS
0.099902
0.380277
0.162150
0.172000
0.349687
0.581226
0.269210
0.396420
0.075790
0.000000
...
0.290378
0.459959
0.198635
0.444899
0.186730
0.108652
0.052317
0.466370
-0.070033
0.157654
HD
0.908651
0.848172
0.818952
0.791766
0.630705
-0.026678
0.860723
0.071706
-0.743791
0.257269
...
0.286089
0.749641
0.650238
0.748923
0.855794
0.775413
0.872596
-0.407811
0.797442
-0.610811
IBM
-0.559349
-0.493463
-0.673430
-0.677674
0.116892
0.184520
-0.288137
0.553530
0.757256
0.460223
...
0.065626
-0.177208
-0.275767
-0.300083
-0.673769
-0.470539
-0.682546
0.458726
-0.763614
0.480073
INTC
0.211309
0.466391
0.411261
0.512215
0.373521
0.709185
-0.113801
-0.086114
-0.309156
0.482311
...
-0.164615
0.525625
0.196841
0.288908
0.324638
0.090162
0.337783
0.377630
0.384586
0.148579
JNJ
0.870819
0.836557
0.861682
0.796180
0.464078
-0.186835
0.836638
-0.157740
-0.853284
0.014548
...
0.353033
0.679531
0.671020
0.768928
0.892381
0.742637
0.914875
-0.507256
0.862106
-0.692465
JPM
0.697136
0.915028
0.795220
0.760351
0.520994
0.310543
0.812777
0.107333
-0.629366
0.673349
...
0.478939
0.792236
0.613962
0.814274
0.813743
0.580914
0.725404
-0.047573
0.583003
-0.421755
KO
0.861482
0.784454
0.878441
0.841140
0.262843
-0.156370
0.720112
-0.282702
-0.898084
-0.144940
...
0.186690
0.511745
0.625531
0.670861
0.902612
0.698883
0.925098
-0.505459
0.914336
-0.678434
MCD
0.903377
0.874950
0.912254
0.892083
0.319661
-0.125269
0.817884
-0.203660
-0.901475
0.017179
...
0.255143
0.581737
0.611445
0.754162
0.957317
0.794168
0.944485
-0.521673
0.906106
-0.695875
MMM
0.878530
0.893446
0.880638
0.858575
0.461794
-0.088299
0.881307
-0.124938
-0.845896
0.122697
...
0.310692
0.700503
0.613594
0.807695
0.931189
0.810304
0.919875
-0.481420
0.872941
-0.631291
MRK
0.559305
0.456804
0.404983
0.351975
0.600473
-0.137100
0.484405
0.179133
-0.341926
0.265147
...
0.273853
0.532254
0.561012
0.351722
0.401734
0.398363
0.487390
-0.357584
0.310198
-0.521249
MSFT
0.898737
0.920163
0.946962
0.926563
0.396818
0.018795
0.869019
-0.193604
-0.918152
0.111320
...
0.255690
0.662986
0.662013
0.742271
0.962708
0.723170
0.966043
-0.410133
0.900795
-0.651891
NKE
0.418982
0.355743
0.257755
0.090776
0.359776
-0.329519
0.708728
0.520058
-0.164812
0.290378
...
0.000000
0.234780
0.419201
0.498435
0.307018
0.392394
0.282905
-0.241273
0.115927
-0.485172
PFE
0.623282
0.789974
0.732048
0.684740
0.718889
0.314428
0.651428
-0.014684
-0.589623
0.459959
...
0.234780
0.000000
0.658518
0.557601
0.673031
0.382192
0.698405
-0.010394
0.575706
-0.365861
PG
0.767258
0.697582
0.739201
0.570762
0.575151
-0.007864
0.720695
0.040095
-0.659892
0.198635
...
0.419201
0.658518
0.000000
0.495722
0.654355
0.287808
0.764547
-0.172449
0.508458
-0.759115
TRV
0.709708
0.778001
0.683653
0.645541
0.357772
0.005810
0.860152
0.183703
-0.556930
0.444899
...
0.498435
0.557601
0.495722
0.000000
0.783713
0.778718
0.667034
-0.206289
0.659901
-0.422455
UNH
0.869627
0.939796
0.953345
0.924275
0.330307
0.048254
0.865327
-0.185547
-0.893697
0.186730
...
0.307018
0.673031
0.654355
0.783713
0.000000
0.703774
0.937790
-0.347090
0.865489
-0.643338
UTX
0.743952
0.636637
0.566810
0.561454
0.334459
-0.354572
0.798138
0.211194
-0.531311
0.108652
...
0.392394
0.382192
0.287808
0.778718
0.703774
0.000000
0.646142
-0.596152
0.656263
-0.507909
V
0.921307
0.909637
0.963647
0.908247
0.469089
-0.034155
0.842157
-0.223277
-0.952104
0.052317
...
0.282905
0.698405
0.764547
0.667034
0.937790
0.646142
0.000000
-0.434848
0.887435
-0.761464
VZ
-0.498782
-0.238846
-0.264013
-0.241712
-0.167878
0.741431
-0.477253
0.027934
0.432609
0.466370
...
-0.241273
-0.010394
-0.172449
-0.206289
-0.347090
-0.596152
-0.434848
0.000000
-0.390349
0.601657
WMT
0.796963
0.777941
0.866287
0.884296
0.324448
-0.010869
0.632431
-0.335300
-0.871264
-0.070033
...
0.115927
0.575706
0.508458
0.659901
0.865489
0.656263
0.887435
-0.390349
0.000000
-0.541598
XOM
-0.824101
-0.587705
-0.652191
-0.496654
-0.414262
0.499676
-0.706187
-0.057535
0.696107
0.157654
...
-0.485172
-0.365861
-0.759115
-0.422455
-0.643338
-0.507909
-0.761464
0.601657
-0.541598
0.000000
30 rows × 30 columns
In [11]:
# заменяем числа исходя из нужного условия
result=(abs(result_corr)>0.8).astype(int)
result
# альтернативный вариант
# result_corr[abs(result_corr>0)]=1
# result_corr[abs(result_corr<0)]=-1
# result_corr[abs(result_corr==0)]="a"
# result=result_corr
Out[11]:
AAPL
AXP
BA
CAT
CSCO
CVX
DD
DIS
GE
GS
...
NKE
PFE
PG
TRV
UNH
UTX
V
VZ
WMT
XOM
AAPL
0
1
1
0
0
0
1
0
1
0
...
0
0
0
0
1
0
1
0
0
1
AXP
1
0
1
1
0
0
1
0
1
0
...
0
0
0
0
1
0
1
0
0
0
BA
1
1
0
1
0
0
1
0
1
0
...
0
0
0
0
1
0
1
0
1
0
CAT
0
1
1
0
0
0
0
0
1
0
...
0
0
0
0
1
0
1
0
1
0
CSCO
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
CVX
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
DD
1
1
1
0
0
0
0
0
0
0
...
0
0
0
1
1
0
1
0
0
0
DIS
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
GE
1
1
1
1
0
0
0
0
0
0
...
0
0
0
0
1
0
1
0
1
0
GS
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
HD
1
1
1
0
0
0
1
0
0
0
...
0
0
0
0
1
0
1
0
0
0
IBM
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
INTC
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
JNJ
1
1
1
0
0
0
1
0
1
0
...
0
0
0
0
1
0
1
0
1
0
JPM
0
1
0
0
0
0
1
0
0
0
...
0
0
0
1
1
0
0
0
0
0
KO
1
0
1
1
0
0
0
0
1
0
...
0
0
0
0
1
0
1
0
1
0
MCD
1
1
1
1
0
0
1
0
1
0
...
0
0
0
0
1
0
1
0
1
0
MMM
1
1
1
1
0
0
1
0
1
0
...
0
0
0
1
1
1
1
0
1
0
MRK
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
MSFT
1
1
1
1
0
0
1
0
1
0
...
0
0
0
0
1
0
1
0
1
0
NKE
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
PFE
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
PG
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
TRV
0
0
0
0
0
0
1
0
0
0
...
0
0
0
0
0
0
0
0
0
0
UNH
1
1
1
1
0
0
1
0
1
0
...
0
0
0
0
0
0
1
0
1
0
UTX
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
V
1
1
1
1
0
0
1
0
1
0
...
0
0
0
0
1
0
0
0
1
0
VZ
0
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
WMT
0
0
1
1
0
0
0
0
1
0
...
0
0
0
0
1
0
1
0
0
0
XOM
1
0
0
0
0
0
0
0
0
0
...
0
0
0
0
0
0
0
0
0
0
30 rows × 30 columns
In [12]:
import matplotlib.pyplot as plt
import networkx as nx
import numpy as np
A=result.values
G=nx.from_numpy_matrix(A)
mapping=dict(zip(G.nodes(),result.index))
G1=nx.relabel_nodes(G,mapping)
#nx.draw_networkx(G1)
nx.draw_networkx(G1,pos=nx.spring_layout(G1))
plt.show()
In [13]:
clique=list(nx.find_cliques(G1))
print(clique)
max_clique=max(clique,key=len)
print()
print("максимальная ",max_clique)
[['XOM', 'AAPL'], ['VZ'], ['CSCO'], ['JPM', 'DD', 'UNH', 'AXP'], ['JPM', 'DD', 'TRV'], ['MRK'], ['GS'], ['NKE'], ['PFE'], ['PG'], ['DIS'], ['MMM', 'TRV', 'DD'], ['MMM', 'UTX'], ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'JNJ', 'AAPL', 'AXP', 'HD', 'DD'], ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'JNJ', 'AAPL', 'AXP', 'GE'], ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'JNJ', 'AAPL', 'KO', 'HD'], ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'JNJ', 'AAPL', 'KO', 'GE'], ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'JNJ', 'WMT', 'KO', 'GE'], ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'CAT', 'GE', 'AXP'], ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'CAT', 'GE', 'WMT', 'KO'], ['IBM'], ['INTC'], ['CVX']]
максимальная ['MMM', 'MCD', 'BA', 'V', 'UNH', 'MSFT', 'JNJ', 'AAPL', 'AXP', 'HD', 'DD']
In [14]:
pos = nx.fruchterman_reingold_layout(G1,dim=2,k=0.2)
nx.draw_networkx_nodes(G1,pos,node_color='r',alpha=0.4)
nx.draw_networkx_nodes(G1,pos,nodelist=max_clique,node_color='b',alpha=0.5)
nx.draw_networkx_edges(G1,pos,width=1.0,alpha=0.8)
nx.draw_networkx_labels(G1,pos)
plt.show()
In [15]:
names
Out[15]:
Symbol
Company Name
0
DD
E. I. du Pont de Nemours and Company
1
GS
The Goldman Sachs Group, Inc.
2
JNJ
Johnson & Johnson
3
JPM
JPMorgan Chase & Co.
4
VZ
Verizon Communications Inc.
5
IBM
International Business Machines Corporation
6
V
Visa Inc.
7
AXP
American Express Company
8
HD
The Home Depot, Inc.
9
DIS
The Walt Disney Company
10
XOM
Exxon Mobil Corporation
11
KO
The Coca-Cola Company
12
PFE
Pfizer Inc.
13
CSCO
Cisco Systems, Inc.
14
WMT
Wal-Mart Stores, Inc.
15
PG
The Procter & Gamble Company
16
CAT
Caterpillar Inc.
17
TRV
The Travelers Companies, Inc.
18
UTX
United Technologies Corporation
19
MMM
3M Company
20
MCD
McDonald's Corporation
21
BA
The Boeing Company
22
NKE
NIKE, Inc.
23
UNH
UnitedHealth Group Incorporated
24
GE
General Electric Company
25
AAPL
Apple Inc.
26
CVX
Chevron Corporation
27
MRK
Merck & Co., Inc.
28
MSFT
Microsoft Corporation
29
INTC
Intel Corporation
In [16]:
from IPython.display import display
# Имена бумаг в клике
max_clique_name=names.loc[names['Symbol'].isin(max_clique)]
display(max_clique_name)
# Только имена бумаг
print(max_clique_name['Company Name'].values)
Symbol
Company Name
0
DD
E. I. du Pont de Nemours and Company
2
JNJ
Johnson & Johnson
6
V
Visa Inc.
7
AXP
American Express Company
8
HD
The Home Depot, Inc.
19
MMM
3M Company
20
MCD
McDonald's Corporation
21
BA
The Boeing Company
23
UNH
UnitedHealth Group Incorporated
25
AAPL
Apple Inc.
28
MSFT
Microsoft Corporation
['E. I. du Pont de Nemours and Company' 'Johnson & Johnson' 'Visa Inc.'
'American Express Company' 'The Home Depot, Inc.' '3M Company'
"McDonald's Corporation" 'The Boeing Company'
'UnitedHealth Group Incorporated' 'Apple Inc.' 'Microsoft Corporation']
In [17]:
# Имена бумаг вне в клики
no_max_clique_name=names.loc[~names['Symbol'].isin(max_clique)]
no_max_clique_name
Out[17]:
Symbol
Company Name
1
GS
The Goldman Sachs Group, Inc.
3
JPM
JPMorgan Chase & Co.
4
VZ
Verizon Communications Inc.
5
IBM
International Business Machines Corporation
9
DIS
The Walt Disney Company
10
XOM
Exxon Mobil Corporation
11
KO
The Coca-Cola Company
12
PFE
Pfizer Inc.
13
CSCO
Cisco Systems, Inc.
14
WMT
Wal-Mart Stores, Inc.
15
PG
The Procter & Gamble Company
16
CAT
Caterpillar Inc.
17
TRV
The Travelers Companies, Inc.
18
UTX
United Technologies Corporation
22
NKE
NIKE, Inc.
24
GE
General Electric Company
26
CVX
Chevron Corporation
27
MRK
Merck & Co., Inc.
29
INTC
Intel Corporation
In [18]:
pd.DataFrame( max_clique_name['Company Name'].values, columns=['Compamy'] )
Out[18]:
Compamy
0
E. I. du Pont de Nemours and Company
1
Johnson & Johnson
2
Visa Inc.
3
American Express Company
4
The Home Depot, Inc.
5
3M Company
6
McDonald's Corporation
7
The Boeing Company
8
UnitedHealth Group Incorporated
9
Apple Inc.
10
Microsoft Corporation
In [19]:
train[f].dtype=='object'
---------------------------------------------------------------------------
NameError Traceback (most recent call last)
<ipython-input-19-58e20ac17f48> in <module>()
----> 1 train[f].dtype=='object'
NameError: name 'train' is not defined
In [ ]:
Content source: Diyago/Machine-Learning-scripts
Similar notebooks: