def run(self):
futures = ['TU', 'FV', 'TY', 'US', 'NK', 'NIY', 'ES', 'SP', 'EMD', 'NQ', 'YM', 'AD',\
'BP', 'CD', 'CU1', 'JY', 'MP', 'NE2', 'SF', 'GC', 'SI', 'HG', 'PL', 'PA',\
'LH', 'ZW', 'ZC', 'ZS', 'ZM', 'ZL', 'EBS', 'EBM', 'EBL', 'SXE', 'FDX', \
'SMI', 'SXF', 'CGB', 'FFI', 'FLG', 'AEX', 'KC', 'CT', 'CC', 'SB', 'JTI', \
'JGB', 'JNI', 'SIN', 'SSG', 'HCE', 'HSI', 'ALS', 'YAP', 'MFX', 'KOS', 'VX', \
'JPYUSD', 'CADUSD', 'GBPUSD', 'EURUSD', 'AUDUSD', 'NZDUSD', 'CHFUSD', 'SEKUSD',\
'NOKUSD', 'TRYUSD', 'MXNUSD', 'ZARUSD', 'ILSUSD', 'SGDUSD', 'HKDUSD', 'TWDUSD',\
'INRUSD', 'BRLUSD']
if push_file_to_db(self.input().path, futures):
with open(self.output().path,'w') as f:
f.write("Successfully put CSI data in DB for futures")
def run(self):
futures = ['TU', 'FV', 'TY', 'US', 'NK', 'NIY', 'ES', 'SP', 'EMD', 'NQ', 'YM', 'AD',\
'BP', 'CD', 'CU1', 'JY', 'MP', 'NE2', 'SF', 'GC', 'SI', 'HG', 'PL', 'PA',\
'LH', 'ZW', 'ZC', 'ZS', 'ZM', 'ZL', 'EBS', 'EBM', 'EBL', 'SXE', 'FDX', \
'SMI', 'SXF', 'CGB', 'FFI', 'FLG', 'AEX', 'KC', 'CT', 'CC', 'SB', 'JTI', \
'JGB', 'JNI', 'SIN', 'SSG', 'HCE', 'HSI', 'ALS', 'YAP', 'MFX', 'KOS', 'VX', \
'JPYUSD', 'CADUSD', 'GBPUSD', 'EURUSD', 'AUDUSD', 'NZDUSD', 'CHFUSD', 'SEKUSD',\
'NOKUSD', 'TRYUSD', 'MXNUSD', 'ZARUSD', 'ILSUSD', 'SGDUSD', 'HKDUSD', 'TWDUSD',\
'INRUSD', 'BRLUSD']
if push_file_to_db(self.input().path, futures):
with open(self.output().path, 'w') as f:
f.write("Successfully put CSI data in DB for futures")
def run(self):
usstocks = ['BND', 'BNDX', 'IEMG', 'LQD', 'MUB', 'SHV', 'TIP', 'VBR', 'VEA', 'VIG', 'VNQ',\
'VOE', 'VT', 'VTI', 'VTIP', 'VTV', 'VWO', 'VWOB', 'VXUS']
if push_file_to_db(self.input().path, usstocks):
with open(self.output().path,'w') as f:
f.write("Successfully put CSI data in DB for us-stocks")
def run(self):
findices = ['XMSW','^AXJO','^BSES','^BVSP','^FTSE','^GDAX','^GU15','^MXX',\
'^N500','^N150','^NZ50','^SSMI','^XMSC']
if push_file_to_db(self.input().path, findices):
with open(self.output().path,'w') as f:
f.write("Successfully put CSI data in DB for f-indices")
def run(self):
indices = ['VIX','TCMP','SPX','NYA','COMP']
if push_file_to_db(self.input().path, indices):
with open(self.output().path,'w') as f:
f.write("Successfully put CSI data in DB for indices")
def run(self):
funds = ['AQRIX','AQMIX','QGMIX','SRPFX','ABRZX','VBLTX','VTSMX']
if push_file_to_db(self.input().path, funds):
with open(self.output().path,'w') as f:
f.write("Successfully put CSI data in DB for funds")
def run(self):
usstocks = ['BND', 'BNDX', 'IEMG', 'LQD', 'MUB', 'SHV', 'TIP', 'VBR', 'VEA', 'VIG', 'VNQ',\
'VOE', 'VT', 'VTI', 'VTIP', 'VTV', 'VWO', 'VWOB', 'VXUS']
if push_file_to_db(self.input().path, usstocks):
with open(self.output().path, 'w') as f:
f.write("Successfully put CSI data in DB for us-stocks")
def run(self):
findices = ['XMSW','^AXJO','^BSES','^BVSP','^FTSE','^GDAX','^GU15','^MXX',\
'^N500','^N150','^NZ50','^SSMI','^XMSC']
if push_file_to_db(self.input().path, findices):
with open(self.output().path, 'w') as f:
f.write("Successfully put CSI data in DB for f-indices")
def run(self):
indices = ['VIX', 'TCMP', 'SPX', 'NYA', 'COMP']
if push_file_to_db(self.input().path, indices):
with open(self.output().path, 'w') as f:
f.write("Successfully put CSI data in DB for indices")
def run(self):
funds = ['AQRIX', 'AQMIX', 'QGMIX', 'SRPFX', 'ABRZX', 'VBLTX', 'VTSMX']
if push_file_to_db(self.input().path, funds):
with open(self.output().path, 'w') as f:
f.write("Successfully put CSI data in DB for funds")
