import yfinance as yf
import pandas as pd

# stock_list = pd.read_excel("/home/jhope/Desktop/slm/Rivaldi/RivaAI/rv-space/rv/data/database0201/RLibrairy -Stoxx600_ISIN.xlsx")
# stock_list = pd.read_excel("/home/jhope/Desktop/slm/Rivaldi/RivaAI/rv-space/rv/data/database0201/ISIN Universes US SP500.xlsx")
stock_list = pd.read_excel("/home/tenzin/Desktop/RIvaGet/data/database0201/RLibrairy -Stoxx600_ISIN.xlsx")
#
# stock_list = pd.read_csv('app.csv')
stock_list = stock_list['ISIN'].to_list()
print(stock_list)

#
# stock_list = [x for x in stock_list]
# pure_list = stock_list
# print(len(stock_list))


ls = [' US25470F1049', ' US25470F3029', ' US55354G1004', ' US5949181045', ' US6200763075', ' US55261F1049', ' US57667L1070', ' US5926881054', ' US5951121038', ' BMG667211046', ' US6311031081', ' US6556631025', ' US65339F1012', ' US6516391066', ' US64110L1061', ' US65473P1057', ' US6541061031', ' US6687711084', ' GB00BWFY5505', ' US6668071029', ' US81762P1021', ' US6293775085', ' US6558441084', ' US64110D1046', ' US6658591044', ' US6703461052', ' US67066G1040', ' US62944T1051', ' US6512291062', ' US65249B2088', ' US65249B1098', ' NL0009538784', ' US7561091049', ' US6795801009', ' US68622V1061', ' US6826801036', ' US6819191064', ' US68389X1054', ' US67103H1077', ' US68902V1070', ' US6745991058', ' US92556H2067', ' US70432V1026', ' US7043261079', ' US7127041058', ' US6937181088', ' US42250P1030', ' US7445731067', ' US7075691094', ' US7134481081', ' US7170811035', ' US74251V1026', ' US7427181091', ' US7433151039', ' US7010941042', ' US7458671010', ' US6951561090', ' US7140461093', ' US74340W1036', ' US7181721090', ' US6934751057', ' IE00BLS09M33', ' US7234841010', ' US73278L1052', ' US6935061076', ' US69351T1060', ' US7443201022', ' US74460D1090', ' US7185461040', ' US69370C1009', ' US6936561009', ' US74762E1029', ' US7237871071', ' US70450Y1038', ' US7475251036', ' US74736K1016', ' LR0008862868', ' BMG3223R1088', ' US7588491032', ' US75886F1075', ' US7591EP1005', ' US7703231032', ' US7547301090', ' US7512121010', ' US7611521078', ' US7739031091', ' US7757111049', ' US7766961061', ' US7782961038', ' US7607591002', ' US75513E1010', ' US78410G1040', ' US82669G1040', ' US8552441094', ' US8085131055', ' US83417M1045', ' US81211K1007', ' US8243481061', ' US78486Q1013', ' US8326964058', ' AN8068571086', ' US8330341012', ' US8716071076', ' US8425871071', ' US8288061091', ' US78409V1044', ' US8168511090', ' IE00BFY8C754', ' US8574771031', ' IE00BKVD2N49', ' US21036P1084', ' US8545021011', ' US83088M1027', ' US87165B1035', ' US8636671013', ' US8718291078', ' US00206R1023', ' US60871R2094', ' US8936411003', ' US8793601050', ' US09073M1045', ' CH0102993182', ' US8807701029', ' US89832Q1094', ' US8793691069', ' US87612E1064', ' US8725401090', ' US8835561023', ' US8725901040', ' US8760301072', ' US8962391004', ' US74144T1088', ' US89417E1091', ' US8923561067', ' US88160R1014', ' US9024941034', ' IE00BK9ZQ967', ' US8740541094', ' US90184L1026', ' US8825081040', ' US8832031012', ' US9022521051', ' US9043112062', ' US9043111072', ' US9100471096', ' US9026531049', ' US9139031002', ' US90384S3031', ' US91324P1021', ' US9078181081', ' US9113121068', ' US9113631090', ' US9029733048', ' US92826C8394', ' US9182041080', ' US91913Y1001', ' US9291601097', ' US9290421091', ' US92345Y1064', ' US92343E1029', ' US92532F1003', ' US92276F1003', ' US92556V1061', ' US92343V1044', ' US9297401088', ' US9418481035', ' US9314271084', ' US9581021055', ' US92939U1060', ' US95040Q1040', ' US9497461015', ' US9633201069', ' US94106L1098', ' US9694571004', ' US9311421039', ' US0844231029', ' US96145D1054', ' US9553061055', ' IE00BDB6Q211', ' US9621661043', ' US9831341071', ' US98389B1008', ' US30231G1022', ' US24906P1093', ' US98419M1009', ' US9884981013', ' US98956P1021', ' US9892071054', ' US9897011071']

lsx = [' US25470F1049', ' US25470F3029', ' US55354G1004', ' US5949181045', ' US6200763075', ' US55261F1049']

rs = []

for el in stock_list:
    j = el.replace(' ', '')
    rs.append(j)

print(rs)

save_location = "/home/tenzin/Desktop/RIvaGet/data/databasestox600/"


data = yf.download(stock_list,start="1900-01-01", end="2024-08-10", period="1d", interval="1d")
df = pd.DataFrame(data)
data.index =  pd.to_datetime(data.index).strftime('%Y-%m-%d')
df.drop(['Adj Close'], axis=1, inplace=True)

#3wgv
# df[['PX_OPEN', 'PX_HIGH', 'PX_LOW', 'PX_LAST', 'PX_VOLUME']]
#df2 = df.rename({'PX_OPEN': 'PX_OPEN', 'PX_HIGH': ''PX_HIGH'', 'PX_LOW': 'PX_'PX_LOW'', 'PX_LAST': 'PX_LAST', 'PX_VOLUME': 'PX_VOLUME'}, axis='columns',)
# df_new = df.loc[:, ['PX_OPEN', ''PX_HIGH'', 'PX_'PX_LOW'', 'PX_LAST', 'PX_VOLUME']]
df.columns = pd.MultiIndex.from_tuples([i[::-1] for i in df.columns])
print(df.columns.tolist())

multi = [
('CH0044328745', 'PX_OPEN'), ('IE00B4BNMY34', 'PX_OPEN'), ('IE00B8KQN827', 'PX_OPEN'), ('IE00BFRT3W74', 'PX_OPEN'), ('IE00BLP1HW54', 'PX_OPEN'), ('JE00B783TY65', 'PX_OPEN'), ('JE00BJ1F3079', 'PX_OPEN'), ('PA1436583006', 'PX_OPEN'), ('US0010551028', 'PX_OPEN'), ('US00130H1059', 'PX_OPEN'), ('US0028241000', 'PX_OPEN'), ('US00287Y1091', 'PX_OPEN'), ('US0036541003', 'PX_OPEN'), ('US00507V1098', 'PX_OPEN'), ('US00724F1012', 'PX_OPEN'), ('US00751Y1064', 'PX_OPEN'), ('US0079031078', 'PX_OPEN'), ('US00846U1016', 'PX_OPEN'), ('US0091581068', 'PX_OPEN'), ('US00971T1016', 'PX_OPEN'), ('US0116591092', 'PX_OPEN'), ('US0126531013', 'PX_OPEN'), ('US0152711091', 'PX_OPEN'), ('US0162551016', 'PX_OPEN'), ('US0200021014', 'PX_OPEN'), ('US02079K1079', 'PX_OPEN'), ('US02079K3059', 'PX_OPEN'), ('US0231351067', 'PX_OPEN'), ('US0236081024', 'PX_OPEN'), ('US02376R1023', 'PX_OPEN'), ('US0255371017', 'PX_OPEN'), ('US0258161092', 'PX_OPEN'), ('US0268747849', 'PX_OPEN'), ('US03027X1000', 'PX_OPEN'), ('US0304201033', 'PX_OPEN'), ('US03073E1055', 'PX_OPEN'), ('US03076C1062', 'PX_OPEN'), ('US0311001004', 'PX_OPEN'), ('US0311621009', 'PX_OPEN'), ('US0320951017', 'PX_OPEN'), ('US0326541051', 'PX_OPEN'), ('US03662Q1058', 'PX_OPEN'), ('US0367521038', 'PX_OPEN'), ('US03743Q1085', 'PX_OPEN'), ('US0378331005', 'PX_OPEN'), ('US0382221051', 'PX_OPEN'), ('US0394831020', 'PX_OPEN'), ('US0404131064', 'PX_OPEN'), ('US04621X1081', 'PX_OPEN'), ('US0495601058', 'PX_OPEN'), ('US0527691069', 'PX_OPEN'), ('US0530151036', 'PX_OPEN'), ('US0533321024', 'PX_OPEN'), ('US0534841012', 'PX_OPEN'), ('US0536111091', 'PX_OPEN'), ('US05722G1004', 'PX_OPEN'), ('US0584981064', 'PX_OPEN'), ('US0605051046', 'PX_OPEN'), ('US0640581007', 'PX_OPEN'), ('US0708301041', 'PX_OPEN'), ('US0718131099', 'PX_OPEN'), ('US0758871091', 'PX_OPEN'), ('US0846707026', 'PX_OPEN'), ('US0865161014', 'PX_OPEN'), ('US0905722072', 'PX_OPEN'), ('US09062X1037', 'PX_OPEN'), ('US09247X1019', 'PX_OPEN'), ('US0970231058', 'PX_OPEN'), ('US09857L1089', 'PX_OPEN'), ('US0997241064', 'PX_OPEN'), ('US1011211018', 'PX_OPEN'), ('US1011371077', 'PX_OPEN'), ('US1101221083', 'PX_OPEN'), ('US11133T1034', 'PX_OPEN'), ('US11135F1012', 'PX_OPEN'), ('US1152361010', 'PX_OPEN'), ('US1156372096', 'PX_OPEN'), ('US12503M1080', 'PX_OPEN'), ('US12504L1098', 'PX_OPEN'), ('US12514G1085', 'PX_OPEN'), ('US1252691001', 'PX_OPEN'), ('US12541W2098', 'PX_OPEN'), ('US1255231003', 'PX_OPEN'), ('US12572Q1058', 'PX_OPEN'), ('US1258961002', 'PX_OPEN'), ('US1264081035', 'PX_OPEN'), ('US1266501006', 'PX_OPEN'), ('US1270971039', 'PX_OPEN'), ('US1273871087', 'PX_OPEN'), ('US12769G1004', 'PX_OPEN'), ('US1344291091', 'PX_OPEN'), ('US14040H1059', 'PX_OPEN'), ('US14149Y1082', 'PX_OPEN'), ('US14448C1045', 'PX_OPEN'), ('US1488061029', 'PX_OPEN'), ('US1491231015', 'PX_OPEN'), ('US1508701034', 'PX_OPEN'), ('US15135B1017', 'PX_OPEN'), ('US15189T1079', 'PX_OPEN'), ('US15677J1088', 'PX_OPEN'), ('US1567821046', 'PX_OPEN'), ('US1598641074', 'PX_OPEN'), ('US16119P1084', 'PX_OPEN'), ('US1667641005', 'PX_OPEN'), ('US1696561059', 'PX_OPEN'), ('US1713401024', 'PX_OPEN'), ('US1720621010', 'PX_OPEN'), ('US17275R1023', 'PX_OPEN'), ('US1729081059', 'PX_OPEN'), ('US1729674242', 'PX_OPEN'), ('US1746101054', 'PX_OPEN'), ('US1773761002', 'PX_OPEN'), ('US1890541097', 'PX_OPEN'), ('US1924461023', 'PX_OPEN'), ('US1941621039', 'PX_OPEN'), ('US20030N1019', 'PX_OPEN'), ('US2003401070', 'PX_OPEN'), ('US2058871029', 'PX_OPEN'), ('US20825C1045', 'PX_OPEN'), ('US2091151041', 'PX_OPEN'), ('US21037T1097', 'PX_OPEN'), ('US2166484020', 'PX_OPEN'), ('US2172041061', 'PX_OPEN'), ('US2193501051', 'PX_OPEN'), ('US22052L1044', 'PX_OPEN'), ('US22160K1051', 'PX_OPEN'), ('US22822V1017', 'PX_OPEN'), ('US2310211063', 'PX_OPEN'), ('US23331A1097', 'PX_OPEN'), ('US2333311072', 'PX_OPEN'), ('US23355L1061', 'PX_OPEN'), ('US2358511028', 'PX_OPEN'), ('US2371941053', 'PX_OPEN'), ('US23918K1088', 'PX_OPEN'), ('US2441991054', 'PX_OPEN'), ('US2473617023', 'PX_OPEN'), ('US25179M1036', 'PX_OPEN'), ('US2521311074', 'PX_OPEN'), ('US25278X1090', 'PX_OPEN'), ('US2538681030', 'PX_OPEN'), ('US2546871060', 'PX_OPEN'), ('US2547091080', 'PX_OPEN'), ('US25470M1099', 'PX_OPEN'), ('US2566771059', 'PX_OPEN'), ('US2567461080', 'PX_OPEN'), ('US25746U1097', 'PX_OPEN'), ('US25754A2015', 'PX_OPEN'), ('US2600031080', 'PX_OPEN'), ('US2605571031', 'PX_OPEN'), ('US2644115055', 'PX_OPEN'), ('US26441C2044', 'PX_OPEN'), ('US26614N1028', 'PX_OPEN'), ('US26875P1012', 'PX_OPEN'), ('US2774321002', 'PX_OPEN'), ('US2786421030', 'PX_OPEN'), ('US2788651006', 'PX_OPEN'), ('US2810201077', 'PX_OPEN'), ('US28176E1082', 'PX_OPEN'), ('US2855121099', 'PX_OPEN'), ('US2910111044', 'PX_OPEN'), ('US29355A1079', 'PX_OPEN'), ('US29364G1031', 'PX_OPEN'), ('US29414B1044', 'PX_OPEN'), ('US2944291051', 'PX_OPEN'), ('US29444U7000', 'PX_OPEN'), ('US29476L1070', 'PX_OPEN'), ('US2971781057', 'PX_OPEN'), ('US29786A1060', 'PX_OPEN'), ('US30034W1062', 'PX_OPEN'), ('US30040W1080', 'PX_OPEN'), ('US30161N1019', 'PX_OPEN'), ('US30212P3038', 'PX_OPEN'), ('US3021301094', 'PX_OPEN'), ('US30225T1025', 'PX_OPEN'), ('US3024913036', 'PX_OPEN'), ('US30303M1027', 'PX_OPEN'), ('US3030751057', 'PX_OPEN'), ('US3119001044', 'PX_OPEN'), ('US3137451015', 'PX_OPEN'), ('US31428X1063', 'PX_OPEN'), ('US3156161024', 'PX_OPEN'), ('US31620M1062', 'PX_OPEN'), ('US3167731005', 'PX_OPEN'), ('US33616C1009', 'PX_OPEN'), ('US3377381088', 'PX_OPEN'), ('US3379321074', 'PX_OPEN'), ('US3390411052', 'PX_OPEN'), ('US3453708600', 'PX_OPEN'), ('US34959J1088', 'PX_OPEN'), ('US34964C1062', 'PX_OPEN'),('US00130H1059','PX_HIGH'), ('US0028241000', 'PX_HIGH'), ('US00287Y1091', 'PX_HIGH'), ('US0036541003', 'PX_HIGH'), ('US00507V1098', 'PX_HIGH'), ('US00724F1012', 'PX_HIGH'), ('US00751Y1064', 'PX_HIGH'), ('US0079031078', 'PX_HIGH'), ('US00846U1016', 'PX_HIGH'), ('US0091581068', 'PX_HIGH'), ('US00971T1016', 'PX_HIGH'), ('US0116591092', 'PX_HIGH'), ('US0126531013', 'PX_HIGH'), ('US0152711091', 'PX_HIGH'), ('US0162551016', 'PX_HIGH'), ('US0200021014', 'PX_HIGH'), ('US02079K1079', 'PX_HIGH'), ('US02079K3059', 'PX_HIGH'), ('US0231351067', 'PX_HIGH'), ('US0236081024', 'PX_HIGH'), ('US02376R1023', 'PX_HIGH'), ('US0255371017', 'PX_HIGH'), ('US0258161092', 'PX_HIGH'), ('US0268747849', 'PX_HIGH'), ('US03027X1000', 'PX_HIGH'), ('US0304201033', 'PX_HIGH'), ('US03073E1055', 'PX_HIGH'), ('US03076C1062', 'PX_HIGH'), ('US0311001004', 'PX_HIGH'), ('US0311621009', 'PX_HIGH'), ('US0320951017', 'PX_HIGH'), ('US0326541051', 'PX_HIGH'), ('US03662Q1058', 'PX_HIGH'), ('US0367521038', 'PX_HIGH'), ('US03743Q1085', 'PX_HIGH'), ('US0378331005', 'PX_HIGH'), ('US0382221051', 'PX_HIGH'), ('US0394831020', 'PX_HIGH'), ('US0404131064', 'PX_HIGH'), ('US04621X1081', 'PX_HIGH'), ('US0495601058', 'PX_HIGH'), ('US0527691069', 'PX_HIGH'), ('US0530151036', 'PX_HIGH'), ('US0533321024', 'PX_HIGH'), ('US0534841012', 'PX_HIGH'), ('US0536111091', 'PX_HIGH'), ('US05722G1004', 'PX_HIGH'), ('US0584981064', 'PX_HIGH'), ('US0605051046', 'PX_HIGH'), ('US0640581007', 'PX_HIGH'), ('US0708301041', 'PX_HIGH'), ('US0718131099', 'PX_HIGH'), ('US0758871091', 'PX_HIGH'), ('US0846707026', 'PX_HIGH'), ('US0865161014', 'PX_HIGH'), ('US0905722072', 'PX_HIGH'), ('US09062X1037', 'PX_HIGH'), ('US09247X1019', 'PX_HIGH'), ('US0970231058', 'PX_HIGH'), ('US09857L1089', 'PX_HIGH'), ('US0997241064', 'PX_HIGH'), ('US1011211018', 'PX_HIGH'), ('US1011371077', 'PX_HIGH'), ('US1101221083', 'PX_HIGH'), ('US11133T1034', 'PX_HIGH'), ('US11135F1012', 'PX_HIGH'), ('US1152361010', 'PX_HIGH'), ('US1156372096', 'PX_HIGH'), ('US12503M1080', 'PX_HIGH'), ('US12504L1098', 'PX_HIGH'), ('US12514G1085', 'PX_HIGH'), ('US1252691001', 'PX_HIGH'), ('US12541W2098', 'PX_HIGH'), ('US1255231003', 'PX_HIGH'), ('US12572Q1058', 'PX_HIGH'), ('US1258961002', 'PX_HIGH'), ('US1264081035', 'PX_HIGH'), ('US1266501006', 'PX_HIGH'), ('US1270971039', 'PX_HIGH'), ('US1273871087', 'PX_HIGH'), ('US12769G1004', 'PX_HIGH'), ('US1344291091', 'PX_HIGH'), ('US14040H1059', 'PX_HIGH'), ('US14149Y1082', 'PX_HIGH'), ('US14448C1045', 'PX_HIGH'), ('US1488061029', 'PX_HIGH'), ('US1491231015', 'PX_HIGH'), ('US1508701034', 'PX_HIGH'), ('US15135B1017', 'PX_HIGH'), ('US15189T1079', 'PX_HIGH'), ('US15677J1088', 'PX_HIGH'), ('US1567821046', 'PX_HIGH'), ('US1598641074', 'PX_HIGH'), ('US16119P1084', 'PX_HIGH'), ('US1667641005', 'PX_HIGH'), ('US1696561059', 'PX_HIGH'), ('US1713401024', 'PX_HIGH'), ('US1720621010', 'PX_HIGH'), ('US17275R1023', 'PX_HIGH'), ('US1729081059', 'PX_HIGH'), ('US1729674242', 'PX_HIGH'), ('US1746101054', 'PX_HIGH'), ('US1773761002', 'PX_HIGH'), ('US1890541097', 'PX_HIGH'), ('US1924461023', 'PX_HIGH'), ('US1941621039', 'PX_HIGH'), ('US20030N1019', 'PX_HIGH'), ('US2003401070', 'PX_HIGH'), ('US2058871029', 'PX_HIGH'), ('US20825C1045', 'PX_HIGH'), ('US2091151041', 'PX_HIGH'), ('US21037T1097', 'PX_HIGH'), ('US2166484020', 'PX_HIGH'), ('US2172041061', 'PX_HIGH'), ('US2193501051', 'PX_HIGH'), ('US22052L1044', 'PX_HIGH'), ('US22160K1051', 'PX_HIGH'), ('US22822V1017', 'PX_HIGH'), ('US2310211063', 'PX_HIGH'), ('US23331A1097', 'PX_HIGH'), ('US2333311072', 'PX_HIGH'), ('US23355L1061', 'PX_HIGH'), ('US2358511028', 'PX_HIGH'), ('US2371941053', 'PX_HIGH'), ('US23918K1088', 'PX_HIGH'), ('US2441991054', 'PX_HIGH'), ('US2473617023', 'PX_HIGH'), ('US25179M1036', 'PX_HIGH'), ('US2521311074', 'PX_HIGH'), ('US25278X1090', 'PX_HIGH'), ('US2538681030', 'PX_HIGH'), ('US2546871060', 'PX_HIGH'), ('US2547091080', 'PX_HIGH'), ('US25470M1099', 'PX_HIGH'), ('US2566771059', 'PX_HIGH'), ('US2567461080', 'PX_HIGH'), ('US25746U1097', 'PX_HIGH'), ('US25754A2015', 'PX_HIGH'), ('US2600031080', 'PX_HIGH'), ('US2605571031', 'PX_HIGH'), ('US2644115055', 'PX_HIGH'), ('US26441C2044', 'PX_HIGH'), ('US26614N1028', 'PX_HIGH'), ('US26875P1012', 'PX_HIGH'), ('US2774321002', 'PX_HIGH'), ('US2786421030', 'PX_HIGH'), ('US2788651006', 'PX_HIGH'), ('US2810201077', 'PX_HIGH'), ('US28176E1082', 'PX_HIGH'), ('US2855121099', 'PX_HIGH'), ('US2910111044', 'PX_HIGH'), ('US29355A1079', 'PX_HIGH'), ('US29364G1031', 'PX_HIGH'), ('US29414B1044', 'PX_HIGH'), ('US2944291051', 'PX_HIGH'), ('US29444U7000', 'PX_HIGH'), ('US29476L1070', 'PX_HIGH'), ('US2971781057', 'PX_HIGH'), ('US29786A1060', 'PX_HIGH'), ('US30034W1062', 'PX_HIGH'), ('US30040W1080', 'PX_HIGH'), ('US30161N1019', 'PX_HIGH'), ('US30212P3038', 'PX_HIGH'), ('US3021301094', 'PX_HIGH'), ('US30225T1025', 'PX_HIGH'), ('US3024913036', 'PX_HIGH'), ('US30303M1027', 'PX_HIGH'), ('US3030751057', 'PX_HIGH'), ('US3119001044', 'PX_HIGH'), ('US3137451015', 'PX_HIGH'), ('US31428X1063', 'PX_HIGH'), ('US3156161024', 'PX_HIGH'), ('US31620M1062', 'PX_HIGH'), ('US3167731005', 'PX_HIGH'), ('US33616C1009', 'PX_HIGH'), ('US3377381088', 'PX_HIGH'), ('US3379321074', 'PX_HIGH'), ('US3390411052', 'PX_HIGH'), ('US3453708600', 'PX_HIGH'), ('US34959J1088', 'PX_HIGH'), ('US34964C1062', 'PX_HIGH'), ('US3546131018', 'PX_HIGH'), ('US35671D8570', 'PX_HIGH'), ('US3635761097', 'PX_HIGH'), ('US3703341046', 'PX_HIGH'), ('US37045V1008', 'PX_HIGH'), ('US3724601055', 'PX_HIGH'), ('US3755581036', 'PX_HIGH'), ('US37940X1028', 'PX_HIGH'), ('US37959E1029', 'PX_HIGH'),
('US00287Y1091', 'PX_LOW'), ('US0036541003', 'PX_LOW'), ('US00507V1098', 'PX_LOW'), ('US00724F1012', 'PX_LOW'), ('US00751Y1064', 'PX_LOW'), ('US0079031078', 'PX_LOW'), ('US00846U1016', 'PX_LOW'), ('US0091581068', 'PX_LOW'), ('US00971T1016', 'PX_LOW'), ('US0116591092', 'PX_LOW'), ('US0126531013', 'PX_LOW'), ('US0152711091', 'PX_LOW'), ('US0162551016', 'PX_LOW'), ('US0200021014', 'PX_LOW'), ('US02079K1079', 'PX_LOW'), ('US02079K3059', 'PX_LOW'), ('US0231351067', 'PX_LOW'), ('US0236081024','PX_LOW'), ('US02376R1023', 'PX_LOW'), ('US0255371017','PX_LOW'), ('US0258161092', 'PX_LOW'), ('US0268747849', 'PX_LOW'), ('US03027X1000', 'PX_LOW'), ('US0304201033', 'PX_LOW'), ('US03073E1055', 'PX_LOW'), ('US03076C1062', 'PX_LOW'), ('US0311001004', 'PX_LOW'), ('US0311621009', 'PX_LOW'), ('US0320951017', 'PX_LOW'), ('US0326541051', 'PX_LOW'), ('US03662Q1058', 'PX_LOW'), ('US0367521038', 'PX_LOW'), ('US03743Q1085', 'PX_LOW'), ('US0378331005', 'PX_LOW'), ('US0382221051', 'PX_LOW'), ('US0394831020', 'PX_LOW'), ('US0404131064', 'PX_LOW'), ('US04621X1081', 'PX_LOW'), ('US0495601058', 'PX_LOW'), ('US0527691069', 'PX_LOW'), ('US0530151036', 'PX_LOW'), ('US0533321024', 'PX_LOW'), ('US0534841012', 'PX_LOW'), ('US0536111091', 'PX_LOW'), ('US05722G1004', 'PX_LOW'), ('US0584981064', 'PX_LOW'), ('US0605051046', 'PX_LOW'), ('US0640581007', 'PX_LOW'), ('US0708301041', 'PX_LOW'), ('US0718131099', 'PX_LOW'), ('US0758871091', 'PX_LOW'), ('US0846707026', 'PX_LOW'), ('US0865161014', 'PX_LOW'), ('US0905722072', 'PX_LOW'), ('US09062X1037', 'PX_LOW'), ('US09247X1019', 'PX_LOW'), ('US0970231058', 'PX_LOW'), ('US09857L1089', 'PX_LOW'), ('US0997241064', 'PX_LOW'), ('US1011211018', 'PX_LOW'), ('US1011371077', 'PX_LOW'), ('US1101221083', 'PX_LOW'), ('US11133T1034', 'PX_LOW'), ('US11135F1012', 'PX_LOW'), ('US1152361010', 'PX_LOW'), ('US1156372096', 'PX_LOW'), ('US12503M1080', 'PX_LOW'), ('US12504L1098', 'PX_LOW'), ('US12514G1085', 'PX_LOW'), ('US1252691001', 'PX_LOW'), ('US12541W2098', 'PX_LOW'), ('US1255231003', 'PX_LOW'), ('US12572Q1058', 'PX_LOW'), ('US1258961002', 'PX_LOW'), ('US1264081035', 'PX_LOW'), ('US1266501006', 'PX_LOW'), ('US1270971039', 'PX_LOW'), ('US1273871087', 'PX_LOW'), ('US12769G1004', 'PX_LOW'), ('US1344291091', 'PX_LOW'), ('US14040H1059', 'PX_LOW'), ('US14149Y1082', 'PX_LOW'), ('US14448C1045', 'PX_LOW'), ('US1488061029', 'PX_LOW'), ('US1491231015', 'PX_LOW'), ('US1508701034', 'PX_LOW'), ('US15135B1017', 'PX_LOW'), ('US15189T1079', 'PX_LOW'), ('US15677J1088', 'PX_LOW'), ('US1567821046', 'PX_LOW'), ('US1598641074', 'PX_LOW'), ('US16119P1084', 'PX_LOW'), ('US1667641005', 'PX_LOW'), ('US1696561059', 'PX_LOW'), ('US1713401024', 'PX_LOW'), ('US1720621010', 'PX_LOW'), ('US17275R1023', 'PX_LOW'), ('US1729081059', 'PX_LOW'), ('US1729674242', 'PX_LOW'), ('US1746101054', 'PX_LOW'), ('US1773761002', 'PX_LOW'), ('US1890541097', 'PX_LOW'), ('US1924461023', 'PX_LOW'), ('US1941621039', 'PX_LOW'), ('US20030N1019', 'PX_LOW'), ('US2003401070', 'PX_LOW'), ('US2058871029', 'PX_LOW'), ('US20825C1045', 'PX_LOW'), ('US2091151041', 'PX_LOW'), ('US21037T1097', 'PX_LOW'), ('US2166484020', 'PX_LOW'), ('US2172041061', 'PX_LOW'), ('US2193501051', 'PX_LOW'), ('US22052L1044', 'PX_LOW'), ('US22160K1051', 'PX_LOW'), ('US22822V1017', 'PX_LOW'), ('US2310211063', 'PX_LOW'), ('US23331A1097', 'PX_LOW'), ('US2333311072', 'PX_LOW'), ('US23355L1061', 'PX_LOW'), ('US2358511028', 'PX_LOW'), ('US2371941053', 'PX_LOW'), ('US23918K1088', 'PX_LOW'), ('US2441991054', 'PX_LOW'), ('US2473617023', 'PX_LOW'), ('US25179M1036', 'PX_LOW'), ('US2521311074', 'PX_LOW'), ('US25278X1090', 'PX_LOW'), ('US2538681030', 'PX_LOW'), ('US2546871060', 'PX_LOW'), ('US2547091080', 'PX_LOW'), ('US25470M1099', 'PX_LOW'), ('US2566771059', 'PX_LOW'), ('US2567461080', 'PX_LOW'), ('US25746U1097', 'PX_LOW'), ('US25754A2015', 'PX_LOW'), ('US2600031080', 'PX_LOW'), ('US2605571031', 'PX_LOW'), ('US2644115055', 'PX_LOW'), ('US26441C2044', 'PX_LOW'), ('US26614N1028', 'PX_LOW'), ('US26875P1012', 'PX_LOW'), ('US2774321002', 'PX_LOW'), ('US2786421030', 'PX_LOW'), ('US2788651006', 'PX_LOW'), ('US2810201077', 'PX_LOW'), ('US28176E1082', 'PX_LOW'), ('US2855121099', 'PX_LOW'), ('US2910111044', 'PX_LOW'), ('US29355A1079', 'PX_LOW'), ('US29364G1031', 'PX_LOW'), ('US29414B1044', 'PX_LOW'), ('US2944291051', 'PX_LOW'), ('US29444U7000', 'PX_LOW'), ('US29476L1070', 'PX_LOW'), ('US2971781057', 'PX_LOW'), ('US29786A1060', 'PX_LOW'), ('US30034W1062', 'PX_LOW'), ('US30040W1080', 'PX_LOW'), ('US30161N1019', 'PX_LOW'), ('US30212P3038', 'PX_LOW'), ('US3021301094', 'PX_LOW'), ('US30225T1025', 'PX_LOW'), ('US3024913036', 'PX_LOW'), ('US30303M1027', 'PX_LOW'), ('US3030751057', 'PX_LOW'), ('US3119001044', 'PX_LOW'), ('US3137451015', 'PX_LOW'), ('US31428X1063', 'PX_LOW'), ('US3156161024', 'PX_LOW'), ('US31620M1062', 'PX_LOW'), ('US3167731005', 'PX_LOW'), ('US33616C1009', 'PX_LOW'), ('US3377381088', 'PX_LOW'), ('US3379321074', 'PX_LOW'), ('US3390411052', 'PX_LOW'), ('US3453708600', 'PX_LOW'), ('US34959J1088', 'PX_LOW'), ('US34964C1062', 'PX_LOW'), ('US3546131018', 'PX_LOW'), ('US35671D8570', 'PX_LOW'), ('US3635761097', 'PX_LOW'), ('US3703341046', 'PX_LOW'), ('US37045V1008', 'PX_LOW'), ('US3724601055', 'PX_LOW'), ('US3755581036', 'PX_LOW'), ('US37940X1028', 'PX_LOW'), ('US37959E1029', 'PX_LOW'), ('US38141G1040', 'PX_LOW'), ('US4165151048', 'PX_LOW'), ('US4370761029', 'PX_LOW'), ('US5184391044', 'PX_LOW'), ('US74834L1008', 'PX_LOW'), ('US79466L3024', 'PX_LOW'), ('US8318652091', 'PX_LOW'), ('US98978V1035','PX_LOW'),
('CH0044328745', 'PX_LAST'), ('IE00B4BNMY34', 'PX_LAST'), ('IE00B8KQN827', 'PX_LAST'), ('IE00BFRT3W74', 'PX_LAST'), ('IE00BLP1HW54', 'PX_LAST'), ('JE00B783TY65', 'PX_LAST'), ('JE00BJ1F3079', 'PX_LAST'), ('PA1436583006', 'PX_LAST'), ('US0010551028', 'PX_LAST'), ('US00130H1059', 'PX_LAST'), ('US0028241000', 'PX_LAST'), ('US00287Y1091', 'PX_LAST'), ('US0036541003', 'PX_LAST'), ('US00507V1098', 'PX_LAST'), ('US00724F1012', 'PX_LAST'), ('US00751Y1064', 'PX_LAST'), ('US0079031078', 'PX_LAST'), ('US00846U1016', 'PX_LAST'), ('US0091581068', 'PX_LAST'), ('US00971T1016', 'PX_LAST'), ('US0116591092', 'PX_LAST'), ('US0126531013', 'PX_LAST'), ('US0152711091', 'PX_LAST'), ('US0162551016', 'PX_LAST'), ('US0200021014', 'PX_LAST'), ('US02079K1079', 'PX_LAST'), ('US02079K3059', 'PX_LAST'), ('US0231351067', 'PX_LAST'), ('US0236081024', 'PX_LAST'), ('US02376R1023', 'PX_LAST'), ('US0255371017', 'PX_LAST'), ('US0258161092', 'PX_LAST'), ('US0268747849', 'PX_LAST'), ('US03027X1000', 'PX_LAST'), ('US0304201033', 'PX_LAST'), ('US03073E1055', 'PX_LAST'), ('US03076C1062', 'PX_LAST'), ('US0311001004', 'PX_LAST'), ('US0311621009', 'PX_LAST'), ('US0320951017', 'PX_LAST'), ('US0326541051', 'PX_LAST'), ('US03662Q1058', 'PX_LAST'), ('US0367521038', 'PX_LAST'), ('US03743Q1085', 'PX_LAST'), ('US0378331005', 'PX_LAST'), ('US0382221051', 'PX_LAST'), ('US0394831020', 'PX_LAST'), ('US0404131064', 'PX_LAST'), ('US04621X1081', 'PX_LAST'), ('US0495601058', 'PX_LAST'), ('US0527691069', 'PX_LAST'), ('US0530151036', 'PX_LAST'), ('US0533321024', 'PX_LAST'), ('US0534841012', 'PX_LAST'), ('US0536111091', 'PX_LAST'), ('US05722G1004', 'PX_LAST'), ('US0584981064', 'PX_LAST'), ('US0605051046', 'PX_LAST'), ('US0640581007', 'PX_LAST'), ('US0708301041', 'PX_LAST'), ('US0718131099', 'PX_LAST'), ('US0758871091', 'PX_LAST'), ('US0846707026', 'PX_LAST'), ('US0865161014', 'PX_LAST'), ('US0905722072', 'PX_LAST'), ('US09062X1037', 'PX_LAST'), ('US09247X1019', 'PX_LAST'), ('US0970231058', 'PX_LAST'), ('US09857L1089', 'PX_LAST'), ('US0997241064', 'PX_LAST'), ('US1011211018', 'PX_LAST'), ('US1011371077', 'PX_LAST'), ('US1101221083', 'PX_LAST'), ('US11133T1034', 'PX_LAST'), ('US11135F1012', 'PX_LAST'), ('US1152361010', 'PX_LAST'), ('US1156372096', 'PX_LAST'), ('US12503M1080', 'PX_LAST'), ('US12504L1098', 'PX_LAST'), ('US12514G1085', 'PX_LAST'), ('US1252691001', 'PX_LAST'), ('US12541W2098', 'PX_LAST'), ('US1255231003', 'PX_LAST'), ('US12572Q1058', 'PX_LAST'), ('US1258961002', 'PX_LAST'), ('US1264081035', 'PX_LAST'), ('US1266501006', 'PX_LAST'), ('US1270971039', 'PX_LAST'), ('US1273871087', 'PX_LAST'), ('US12769G1004', 'PX_LAST'), ('US1344291091', 'PX_LAST'), ('US14040H1059', 'PX_LAST'), ('US14149Y1082', 'PX_LAST'), ('US14448C1045', 'PX_LAST'), ('US1488061029', 'PX_LAST'), ('US1491231015', 'PX_LAST'), ('US1508701034', 'PX_LAST'), ('US15135B1017', 'PX_LAST'), ('US15189T1079', 'PX_LAST'), ('US15677J1088', 'PX_LAST'), ('US1567821046', 'PX_LAST'), ('US1598641074', 'PX_LAST'), ('US16119P1084', 'PX_LAST'), ('US1667641005', 'PX_LAST'), ('US1696561059', 'PX_LAST'), ('US1713401024', 'PX_LAST'), ('US1720621010', 'PX_LAST'), ('US17275R1023', 'PX_LAST'), ('US1729081059', 'PX_LAST'), ('US1729674242', 'PX_LAST'), ('US1746101054', 'PX_LAST'), ('US1773761002', 'PX_LAST'), ('US1890541097', 'PX_LAST'), ('US1924461023', 'PX_LAST'), ('US1941621039', 'PX_LAST'), ('US20030N1019', 'PX_LAST'), ('US2003401070', 'PX_LAST'), ('US2058871029', 'PX_LAST'), ('US20825C1045', 'PX_LAST'), ('US2091151041', 'PX_LAST'), ('US21037T1097', 'PX_LAST'), ('US2166484020', 'PX_LAST'), ('US2172041061', 'PX_LAST'), ('US2193501051', 'PX_LAST'), ('US22052L1044', 'PX_LAST'), ('US22160K1051', 'PX_LAST'), ('US22822V1017', 'PX_LAST'), ('US2310211063', 'PX_LAST'), ('US23331A1097', 'PX_LAST'), ('US2333311072', 'PX_LAST'), ('US23355L1061', 'PX_LAST'), ('US2358511028', 'PX_LAST'), ('US2371941053', 'PX_LAST'), ('US23918K1088', 'PX_LAST'), ('US2441991054', 'PX_LAST'), ('US2473617023', 'PX_LAST'), ('US25179M1036', 'PX_LAST'), ('US2521311074', 'PX_LAST'), ('US25278X1090', 'PX_LAST'), ('US2538681030', 'PX_LAST'), ('US2546871060', 'PX_LAST'), ('US2547091080', 'PX_LAST'), ('US25470M1099', 'PX_LAST'), ('US2566771059', 'PX_LAST'), ('US2567461080', 'PX_LAST'), ('US25746U1097', 'PX_LAST'), ('US25754A2015', 'PX_LAST'), ('US2600031080', 'PX_LAST'), ('US2605571031', 'PX_LAST'), ('US2644115055', 'PX_LAST'), ('US26441C2044', 'PX_LAST'), ('US26614N1028', 'PX_LAST'), ('US26875P1012', 'PX_LAST'), ('US2774321002', 'PX_LAST'), ('US2786421030', 'PX_LAST'), ('US2788651006', 'PX_LAST'), ('US2810201077', 'PX_LAST'), ('US28176E1082', 'PX_LAST'), ('US2855121099', 'PX_LAST'), ('US2910111044', 'PX_LAST'), ('US29355A1079', 'PX_LAST'), ('US29364G1031', 'PX_LAST'), ('US29414B1044', 'PX_LAST'), ('US2944291051', 'PX_LAST'), ('US29444U7000', 'PX_LAST'), ('US29476L1070', 'PX_LAST'), ('US2971781057', 'PX_LAST'), ('US29786A1060', 'PX_LAST'), ('US30034W1062', 'PX_LAST'), ('US30040W1080', 'PX_LAST'), ('US30161N1019', 'PX_LAST'), ('US30212P3038', 'PX_LAST'), ('US3021301094', 'PX_LAST'), ('US30225T1025', 'PX_LAST'), ('US3024913036', 'PX_LAST'), ('US30303M1027', 'PX_LAST'), ('US3030751057', 'PX_LAST'), ('US3119001044', 'PX_LAST'), ('US3137451015', 'PX_LAST'), ('US31428X1063', 'PX_LAST'), ('US3156161024', 'PX_LAST'), ('US31620M1062', 'PX_LAST'), ('US3167731005', 'PX_LAST'), ('US33616C1009', 'PX_LAST'), ('US3377381088', 'PX_LAST'), ('US3379321074', 'PX_LAST'), ('US3390411052', 'PX_LAST'), ('US3453708600', 'PX_LAST'), ('US34959J1088', 'PX_LAST'), ('US34964C1062', 'PX_LAST'), ('US3546131018', 'PX_LAST'), ('US35671D8570', 'PX_LAST'), ('US3635761097', 'PX_LAST'), ('US3703341046', 'PX_LAST'), ('US37045V1008', 'PX_LAST'), ('US3724601055', 'PX_LAST'), ('US3755581036', 'PX_LAST'), ('US37940X1028', 'PX_LAST'), ('US37959E1029', 'PX_LAST'), ('US38141G1040', 'PX_LAST'), ('US4165151048', 'PX_LAST'), ('US4370761029', 'PX_LAST'), ('US5184391044', 'PX_LAST'), ('US74834L1008', 'PX_LAST'), ('US79466L3024', 'PX_LAST'), ('US8318652091', 'PX_LAST'), ('US98978V1035', 'PX_LAST'),
('CH0044328745', 'PX_VOLUME'), ('IE00B4BNMY34', 'PX_VOLUME'), ('IE00B8KQN827', 'PX_VOLUME'), ('IE00BFRT3W74', 'PX_VOLUME'), ('IE00BLP1HW54', 'PX_VOLUME'), ('JE00B783TY65', 'PX_VOLUME'), ('JE00BJ1F3079', 'PX_VOLUME'), ('PA1436583006', 'PX_VOLUME'), ('US0010551028', 'PX_VOLUME'), ('US00130H1059', 'PX_VOLUME'), ('US0028241000', 'PX_VOLUME'), ('US00287Y1091', 'PX_VOLUME'), ('US0036541003', 'PX_VOLUME'), ('US00507V1098', 'PX_VOLUME'), ('US00724F1012', 'PX_VOLUME'), ('US00751Y1064', 'PX_VOLUME'), ('US0079031078', 'PX_VOLUME'), ('US00846U1016','PX_VOLUME'), ('US0091581068', 'PX_VOLUME'), ('US00971T1016', 'PX_VOLUME'), ('US0116591092', 'PX_VOLUME'), ('US0126531013', 'PX_VOLUME'), ('US0152711091', 'PX_VOLUME'), ('US0162551016', 'PX_VOLUME'), ('US0200021014', 'PX_VOLUME'), ('US02079K1079', 'PX_VOLUME'), ('US02079K3059', 'PX_VOLUME'), ('US0231351067', 'PX_VOLUME'), ('US0236081024', 'PX_VOLUME'), ('US02376R1023', 'PX_VOLUME'), ('US0255371017', 'PX_VOLUME'), ('US0258161092', 'PX_VOLUME'), ('US0268747849', 'PX_VOLUME'), ('US03027X1000', 'PX_VOLUME'), ('US0304201033', 'PX_VOLUME'), ('US03073E1055', 'PX_VOLUME'), ('US03076C1062', 'PX_VOLUME'), ('US0311001004', 'PX_VOLUME'), ('US0311621009', 'PX_VOLUME'), ('US0320951017', 'PX_VOLUME'), ('US0326541051', 'PX_VOLUME'), ('US03662Q1058', 'PX_VOLUME'), ('US0367521038', 'PX_VOLUME'), ('US03743Q1085', 'PX_VOLUME'), ('US0378331005', 'PX_VOLUME'), ('US0382221051', 'PX_VOLUME'), ('US0394831020', 'PX_VOLUME'), ('US0404131064', 'PX_VOLUME'), ('US04621X1081', 'PX_VOLUME'), ('US0495601058', 'PX_VOLUME'), ('US0527691069', 'PX_VOLUME'), ('US0530151036', 'PX_VOLUME'), ('US0533321024', 'PX_VOLUME'), ('US0534841012', 'PX_VOLUME'), ('US0536111091', 'PX_VOLUME'), ('US05722G1004', 'PX_VOLUME'), ('US0584981064', 'PX_VOLUME'), ('US0605051046', 'PX_VOLUME'), ('US0640581007', 'PX_VOLUME'), ('US0708301041', 'PX_VOLUME'), ('US0718131099', 'PX_VOLUME'), ('US0758871091', 'PX_VOLUME'), ('US0846707026', 'PX_VOLUME'), ('US0865161014', 'PX_VOLUME'), ('US0905722072', 'PX_VOLUME'), ('US09062X1037', 'PX_VOLUME'), ('US09247X1019', 'PX_VOLUME'), ('US0970231058', 'PX_VOLUME'), ('US09857L1089', 'PX_VOLUME'), ('US0997241064', 'PX_VOLUME'), ('US1011211018', 'PX_VOLUME'), ('US1011371077', 'PX_VOLUME'), ('US1101221083', 'PX_VOLUME'), ('US11133T1034', 'PX_VOLUME'), ('US11135F1012', 'PX_VOLUME'), ('US1152361010', 'PX_VOLUME'), ('US1156372096', 'PX_VOLUME'), ('US12503M1080', 'PX_VOLUME'), ('US12504L1098', 'PX_VOLUME'), ('US12514G1085', 'PX_VOLUME'), ('US1252691001', 'PX_VOLUME'), ('US12541W2098', 'PX_VOLUME'), ('US1255231003', 'PX_VOLUME'), ('US12572Q1058', 'PX_VOLUME'), ('US1258961002', 'PX_VOLUME'), ('US1264081035', 'PX_VOLUME'), ('US1266501006', 'PX_VOLUME'), ('US1270971039', 'PX_VOLUME'), ('US1273871087', 'PX_VOLUME'), ('US12769G1004', 'PX_VOLUME'), ('US1344291091', 'PX_VOLUME'), ('US14040H1059', 'PX_VOLUME'), ('US14149Y1082', 'PX_VOLUME'), ('US14448C1045', 'PX_VOLUME'), ('US1488061029', 'PX_VOLUME'), ('US1491231015', 'PX_VOLUME'), ('US1508701034', 'PX_VOLUME'), ('US15135B1017', 'PX_VOLUME'), ('US15189T1079', 'PX_VOLUME'), ('US15677J1088', 'PX_VOLUME'), ('US1567821046', 'PX_VOLUME'), ('US1598641074', 'PX_VOLUME'), ('US16119P1084', 'PX_VOLUME'), ('US1667641005', 'PX_VOLUME'), ('US1696561059', 'PX_VOLUME'), ('US1713401024', 'PX_VOLUME'), ('US1720621010', 'PX_VOLUME'), ('US17275R1023', 'PX_VOLUME'), ('US1729081059', 'PX_VOLUME'), ('US1729674242', 'PX_VOLUME'), ('US1746101054', 'PX_VOLUME'), ('US1773761002', 'PX_VOLUME'), ('US1890541097', 'PX_VOLUME'), ('US1924461023', 'PX_VOLUME'), ('US1941621039', 'PX_VOLUME'), ('US20030N1019', 'PX_VOLUME'), ('US2003401070', 'PX_VOLUME'), ('US2058871029', 'PX_VOLUME'), ('US20825C1045', 'PX_VOLUME'), ('US2091151041', 'PX_VOLUME'), ('US21037T1097', 'PX_VOLUME'), ('US2166484020', 'PX_VOLUME'), ('US2172041061', 'PX_VOLUME'), ('US2193501051', 'PX_VOLUME'), ('US22052L1044', 'PX_VOLUME'), ('US22160K1051', 'PX_VOLUME'), ('US22822V1017', 'PX_VOLUME'), ('US2310211063', 'PX_VOLUME'), ('US23331A1097', 'PX_VOLUME'), ('US2333311072', 'PX_VOLUME'), ('US23355L1061', 'PX_VOLUME'), ('US2358511028', 'PX_VOLUME'), ('US2371941053', 'PX_VOLUME'), ('US23918K1088', 'PX_VOLUME'), ('US2441991054', 'PX_VOLUME'), ('US2473617023', 'PX_VOLUME'), ('US25179M1036', 'PX_VOLUME'), ('US2521311074', 'PX_VOLUME'), ('US25278X1090', 'PX_VOLUME'), ('US2538681030', 'PX_VOLUME'), ('US2546871060', 'PX_VOLUME'), ('US2547091080', 'PX_VOLUME'), ('US25470M1099', 'PX_VOLUME'), ('US2566771059', 'PX_VOLUME'), ('US2567461080', 'PX_VOLUME'), ('US25746U1097', 'PX_VOLUME'), ('US25754A2015', 'PX_VOLUME'), ('US2600031080', 'PX_VOLUME'), ('US2605571031', 'PX_VOLUME'), ('US2644115055', 'PX_VOLUME'), ('US26441C2044', 'PX_VOLUME'), ('US26614N1028', 'PX_VOLUME'), ('US26875P1012', 'PX_VOLUME'), ('US2774321002', 'PX_VOLUME'), ('US2786421030', 'PX_VOLUME'), ('US2788651006', 'PX_VOLUME'), ('US2810201077', 'PX_VOLUME'), ('US28176E1082', 'PX_VOLUME'), ('US2855121099', 'PX_VOLUME'), ('US2910111044', 'PX_VOLUME'), ('US29355A1079', 'PX_VOLUME'), ('US29364G1031', 'PX_VOLUME'), ('US29414B1044', 'PX_VOLUME'), ('US2944291051', 'PX_VOLUME'), ('US29444U7000', 'PX_VOLUME'), ('US29476L1070', 'PX_VOLUME'), ('US2971781057', 'PX_VOLUME'), ('US29786A1060', 'PX_VOLUME'), ('US30034W1062', 'PX_VOLUME'), ('US30040W1080', 'PX_VOLUME'), ('US30161N1019', 'PX_VOLUME'), ('US30212P3038', 'PX_VOLUME'), ('US3021301094', 'PX_VOLUME'), ('US30225T1025', 'PX_VOLUME'), ('US3024913036', 'PX_VOLUME'), ('US30303M1027', 'PX_VOLUME'), ('US3030751057', 'PX_VOLUME'), ('US3119001044', 'PX_VOLUME'), ('US3137451015', 'PX_VOLUME'), ('US31428X1063', 'PX_VOLUME'), ('US3156161024', 'PX_VOLUME'), ('US31620M1062', 'PX_VOLUME'), ('US3167731005', 'PX_VOLUME'), ('US33616C1009', 'PX_VOLUME'), ('US3377381088', 'PX_VOLUME'), ('US3379321074', 'PX_VOLUME'), ('US3390411052', 'PX_VOLUME'), ('US3453708600', 'PX_VOLUME'), ('US34959J1088', 'PX_VOLUME'), ('US34964C1062', 'PX_VOLUME'), ('US3546131018', 'PX_VOLUME'), ('US35671D8570', 'PX_VOLUME'), ('US3635761097', 'PX_VOLUME'), ('US3703341046', 'PX_VOLUME'), ('US37045V1008', 'PX_VOLUME'), ('US3724601055', 'PX_VOLUME'), ('US3755581036', 'PX_VOLUME'), ('US37940X1028', 'PX_VOLUME'), ('US37959E1029', 'PX_VOLUME'), ('US38141G1040', 'PX_VOLUME'), ('US4165151048', 'PX_VOLUME'), ('US4370761029', 'PX_VOLUME'), ('US5184391044', 'PX_VOLUME'), ('US74834L1008', 'PX_VOLUME'), ('US79466L3024', 'PX_VOLUME'), ('US8318652091', 'PX_VOLUME'), ('US98978V1035', 'PX_VOLUME')]
# df.columns = pd.MultiIndex.from_tuples(multi)
# df.columns = pd.MultiIndex.from_tuples([i[::-1] for i in df.columns])
# df.reindex(columns=df.columns.reindex(['PX_OPEN', 'PX_HIGH', 'PX_LOW', 'PX_LAST', 'PX_VOLUME'], level=0)[0])
# df_ordered_multi_cols = pd.DataFrame(df, columns=multi_cols)
d = {'Open': 'PX_OPEN', 'High': 'PX_HIGH', 'Low': 'PX_LOW', 'Close': 'PX_LAST', 'Volume': 'PX_VOLUME'}
df2 = df.rename(columns=d, level=1)
# df2.reindex(columns=df.columns.reindex(['PX_OPEN', ''PX_HIGH'', 'PX_'PX_LOW'', 'PX_LAST', 'PX_VOLUME'], level=0)[0])
print(df2.columns)

# data.index =  pd.to_datetime(data.index).strftime('%d-%m-%Y')
# data.drop(['Adj Close'], axis=1, inplace=True)
# data.columns = pd.MultiIndex.from_tuples([i[::-1] for i in data.columns])
# print(data.columns)
# newdata = data.rename({'PX_OPEN': 'PX_OPEN', 'PX_HIGH': ''PX_HIGH'', 'PX_LOW': 'PX_'PX_LOW'', 'PX_LAST': 'PX_LAST', 'PX_VOLUME': 'PX_VOLUME'})
# newdatas = data.loc[:, ['PX_OPEN', ''PX_HIGH'', 'PX_'PX_LOW'', 'PX_LAST', 'PX_VOLUME']]
# print(newdatas)
#data.drop(['PX_OPEN'], axis=1, inplace=True)
#newdata.drop(['PX_Close'], axis=1,inplace=True)
#newdata  = pd.MultiIndex.from_tuples([i[::-1] for i in data.columns])

for ticker in stock_list:
    try:
        TEMP = df2[ticker].copy(deep=True)
        TEMP = TEMP.dropna()
        TEMP.to_csv(save_location + "/" + f"{ticker}.csv")
    except:
        print("Unable to load data for {}".format(ticker))

#data = yf.download(['TSLA','MSFT'],start="1900-01-01", end="2022-04-30", period="1d", interval="1d")
#data.drop(['Adj Close'], axis=1, inplace=True)
#data.rename(columns={'PX_OPEN': 'PX_OPEN', 'PX_HIGH': ''PX_HIGH'', 'PX_LOW': 'PX_'PX_LOW'', 'PX_LAST': 'PX_LAST', 'PX_VOLUME': 'PX_VOLUME'}, inplace=True)
#print(data.columns)

#data.columns = pd.MultiIndex.from_tuples([i[::-1] for i in data.columns])
#newdate = data.rename(columns={'PX_OPEN': 'PX_OPEN', 'PX_HIGH': ''PX_HIGH'', 'PX_LOW': 'PX_'PX_LOW'', 'PX_LAST': 'PX_LAST', 'PX_VOLUME': 'PX_VOLUME'}, inplace=True)
#newdata = data.rename(columns={'PX_OPEN': 'PX_OPEN', 'PX_HIGH': ''PX_HIGH'', 'PX_LOW': 'PX_'PX_LOW'', 'PX_LAST': 'PX_LAST', 'PX_VOLUME': 'PX_VOLUME', 'Adj Close': 'PX_Close'})

#data.drop(['PX_OPEN'], axis=1, inplace=True)
#newdata.drop(['PX_Close'], axis=1,inplace=True)
#newdata  = pd.MultiIndex.from_tuples([i[::-1] for i in data.columns])

# for ticker in rs:
#     try:
#         TEMP = newdata[ticker].copy(deep=True)
#        # newdata = data.rename(columns={'PX_OPEN': 'PX_OPEN', 'PX_HIGH': ''PX_HIGH'', 'PX_LOW': 'PX_'PX_LOW'', 'PX_LAST': 'PX_LAST', 'PX_VOLUME': 'PX_VOLUME', 'Adj Close': 'PX_Close'})
#         #newdata.drop(['PX_OPEN'], axis=1,inplace=True)
#         TEMP = newdata[ticker].rename(columns={'PX_OPEN': 'PX_OPEN', 'PX_HIGH': ''PX_HIGH'', 'PX_LOW': 'PX_'PX_LOW'', 'PX_LAST': 'PX_LAST', 'PX_VOLUME': 'PX_VOLUME', 'Adj Close': 'PX_Close'})
#         TEMP = TEMP.dropna()
#         TEMP.to_csv(f"{ticker}.csv")
#     except:
#         print("Unable to load data for {}".format(ticker))