In [1]:
import pandas as pd
import numpy as np
df1 = pd.read_csv('companylist.csv')
df2 = pd.read_csv('companylist1.csv')
df3 = pd.read_csv('companylist2.csv')
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/computation/__init__.py:19: UserWarning: The installed version of numexpr 2.4.4 is not supported in pandas and will be not be used
UserWarning)
In [36]:
symbols = np.append(df1.Symbol.values, df2.Symbol.values)
symbols = np.append(symbols, df3.Symbol.values)
In [38]:
symbol1 = '+'.join(df1.Symbol.values).replace(' ','')
symbol1
Out[38]:
'PIH+FLWS+FCCY+SRCE+VNET+TWOU+JOBS+CAFD+EGHT+AVHI+SHLM+AAON+ABAX+ABEO+ABEOW+ABIL+ABMD+AXAS+ACIA+ACTG+ACHC+ACAD+ACST+AXDX+XLRN+ANCX+ARAY+OILD+OILU+VXDN+VXUP+ACRX+ACET+AKAO+ACHN+ACIW+ACRS+ACNB+ACOR+ACTS+ACPW+ATVI+ACTA+ACUR+ACXM+ADMS+ADMP+ADAP+ADUS+AEY+IOTS+ADMA+ADBE+ADTN+ADRO+AAAP+ADES+AEIS+AMD+ADXS+ADXSW+ADVM+MAUI+YPRO+AEGR+AEGN+AGLE+AEHR+AMTX+AEPI+AERI+AVAV+AEZS+AEMD+AFMD+UAVS+AGEN+AGRX+AGYS+AGIO+AGFS+AGFSW+AIMT+AIRM+AIRT+ATSG+AMCN+AIXG+AKAM+AKTX+AKBA+AKER+AKRX+ALRM+ALSK+AMRI+ABDC+ADHD+ALDR+ALDX+ALXN+ALCO+ALGN+ALIM+ALJJ+ALKS+ABTX+ALGT+AIQ+AHGP+ARLP+AHPI+AMOT+ALQA+ALLT+MDRX+AFAM+ALNY+AOSL+GOOG+GOOGL+SMCP+ATEC+ASPS+AIMC+AMAG+AMRN+AMRK+AYA+AMZN+AMBC+AMBCW+AMBA+AMCX+DOX+AMDA+AMED+UHAL+ATAX+AMOV+AAL+AGNC+AGNCB+AGNCP+MTGE+MTGEP+ACSF+ACAS+AETI+AMIC+AMNB+ANAT+APEI+ARII+AMRB+ASEI+AMSWA+AMSC+AMWD+CRMT+ABCB+AMSF+ASRV+ASRVP+ATLO+AMGN+FOLD+AMKR+AMPH+IBUY+AMSG+AMSGP+ASYS+AFSI+AMRS+ADI+ALOG+AVXL+ANCB+ANDA+ANDAR+ANDAU+ANDAW+ANGI+ANGO+ANIP+ANIK+ANSS+ATRS+ANTH+ABAC+APIC+APOG+APOL+AINV+APPF+AAPL+ARCI+APDN+APDNW+AGTC+AMAT+AMCC+AAOI+AREX+APRI+APVOV+APTO+AQMS+AQXP+AUMA+AUMAU+AUMAW+ARDM+ARLZ+PETX+ABUS+ARCW+ABIO+RKDA+ARCB+ACGL+APLP+ACAT+ARDX+ARNA+ARCC+AGII+AGIIL+ARGS+ARIS+ARIA+ARKR+ARMH+ARTX+ARWA+ARWAR+ARWAU+ARWAW+ARQL+ARRY+ARRS+DWAT+AROW+ARWR+ARTNA+ARTW+ASBB+ASNA+ASND+ASCMA+APWC+ASML+AZPN+ASMB+ASFI+ASTE+ATRO+ALOT+ASTC+ASUR+ATAI+ATRA+ATHN+ATHX+AAPC+AAME+ACBI+ACFC+ABY+ATLC+AAWW+AFH+TEAM+ATNI+ATOS+ATRC+ATRI+ATTU+LIFE+AUBN+BOLD+AUDC+AUPH+EARS+ABTL+ADSK+ADP+AVEO+AVXS+AVNW+AVID+AVGR+AVIR+CAR+AWRE+ACLS+AXGN+AXSM+AXTI+BCOM+RILY+BOSC+BEAV+BIDU+BCPC+BWINA+BWINB+BLDP+BANF+BANFP+BKMU+BOCH+BMRC+BKSC+BOTJ+OZRK+BFIN+BWFG+BANR+BZUN+BHAC+BHACR+BHACU+BHACW+BBSI+BSET+BYBK+BV+BBCN+BCBP+BECN+BSF+BBGI+BEBE+BBBY+BGNE+BELFA+BELFB+BLPH+BLCM+BNCL+BNFT+BNTC+BNTCW+BGCP+BGFV+BIND+ORPN+BASI+BIOC+BCRX+BIOD+BDSI+BIIB+BIOL+BLFS+BLRX+BMRN+BVXV+BVXVW+BPTH+BIOS+BBC+BBP+BSTC+BSTG+BSPM+TECH+BEAT+BJRI+BBOX+BDE+BLKB+BBRY+HAWK+BKCC+ADRA+ADRD+ADRE+ADRU+BLMN+BCOR+BLBD+BUFF+BHBK+NILE+BLUE+BKEP+BKEPP+BPMC+ITEQ+BMCH+BNCN+BOBE+BOFI+BOFIL+WIFI+BOJA+BOKF+BOKFL+BNSO+BPFH+BPFHP+BPFHW+EPAY+BLVD+BLVDU+BLVDW+BCLI+BBRG+BDGE+BLIN+BRID+BCOV+AVGO+BSFT+BVSN+BYFC+BWEN+BRCD+BRKL+BRKS+BRKR+BMTC+BLMT+BSQR+BWLD+BLDR+BMLA+BUR+CFFI+CHRW+CA+CCMP+CDNS+CDZI+CACQ+CZR+CSTE+PRSS+CLBS+CLMS+CHY+CHI+CCD+CFGE+CHW+CGO+CSQ+CAMP+CVGW+CFNB+CALA+CALD+CALM+CLMT+ABCD+CAC+CAMT+CSIQ+CGIX+CPHC+CPLA+CBF+CCBG+CPLP+CSWC+CPTA+CLAC+CLACU+CLACW+CFFN+CAPN+CAPNW+CAPR+CPST+CARA+CARB+CBYL+CFNL+CRME+CSII+CATM+CDNA+CECO+CTRE+CKEC+CLBH+CARO+CART+CRZO+TAST+CRTN+CARV+CASM+CACB+CASC+CWST+CASY+CASI+CASS+CATB+CBIO+CPRX+CATY+CATYW+CVCO+CAVM+CBFV+CBOE+CDK+CDW+CECE+CELG+CELGZ+CLDX+CLRB+CLRBW+CLRBZ+CLLS+CBMG+CLSN+CYAD+CEMP+CETX+CSFL+CETV+CFBK+CENT+CENTA+CVCY+CFCB+CENX+CNBKA+CNTY+CPHD+CRNT+CERC+CERCW+CERCZ+CERE+CERN+CERU+CERS+KOOL+CEVA+CFCO+CFCOU+CFCOW+CSBR+CYOU+HOTR+HOTRW+CTHR+GTLS+CHTR+CHFN+CHKP+CHEK+CHEKW+CEMI+CHFC+CCXI+CHMG+CHKE+CHMA+CBNK+PLCE+CMRX+CADC+CALI+CAAS+CBAK+CBPO+CCCL+CCCR+CCRC+JRJC+HGSH+CNIT+CJJD+CLDC+CLDCW+HTHT+CHNR+CREG+CNTF+CXDC+CCIH+CNET+IMOS+CDXC+CHSCL+CHSCM+CHSCN+CHSCO+CHSCP+CHDN+CHUY+CDTX+CIFC+CMCT+CMPR+CINF+CIDM+CTAS+CPHR+CRUS+CSCO+CTRN+CZNC+CZWI+CZFC+CIZN+CTXS+CHCO+CIVB+CIVBP+CDTI+CLNE+CLNT+CLFD+CLRO+CLSD+CLIR+CBLI+CSBK+CLVS+CMFN+CME+CCNE+CISG+CNV+CWAY+COBZ+COKE+CDXS+CVLY+JVA+CCOI+CGNT+CGNX+CTSH+COHR+CHRS+COHU+CLCT+COLL+CIGI+CBAN+CLCD+COLB+COLM+CMCO+CBMX+CBMXW+CMCSA+CBSH+CBSHP+CUBN+CVGI+COMM+CSAL+JCS+ESXB+CYHHZ+CTBI+CWBC+COB+CVLT+CGEN+CPSI+CTG+SCOR+CHCI+CMTL+CNAT+CNCE+CXRX+CCUR+CDOR+CFMS+CNFR+CNMD+CTWS+CNOB+CNXR+CONN+CNSL+CWCO+CPSS+CFRX+CFRXW+CTRV+CTRL+CPAAU+CPRT+COYN+COYNW+CRBP+CORT+BVA+CORE+CORI+CSOD+CRVL+CRVS+COSI+CSGP+COST+CPAH+ICBK+CVTI+COVS+COWN+COWNL+PMTS+CPSH+CRAI+CBRL+BREW+CRAY+CACC+CREE+CRESY+CRTO+CROX+CCRN+XRDC+CRDS+CRWS+CYRX+CYRXW+CSGS+CCLP+CSPI+CSWI+CSX+CTIC+CTIB+CTRP+CUNB+CUI+CPIX+CMLS+CRIS+CUTR+CVBF+CVV+CYAN+CYBR+CYBE+CYCC+CYCCP+CBAY+CYNA+CYNO+CY+CYRN+CONE+CYTK+CTMX+CYTX+CYTXW+CTSO+CYTR+DJCO+DAKT+DAIO+DTLK+DRAM+DWCH+PLAY+DTEA+DWSN+DBVT+DHRM+DFRG+TACO+TACOW+DCTH+DMPI+DGAS+DELT+DELTW+DENN+XRAY+DEPO+DSCI+DERM+DEST+DXLG+DSWL+DTRM+DXCM+DXTR+DHXM+DHIL+FANG+DCIX+DRNA+DFBG+DGII+DMRC+DRAD+DGLY+APPS+DCOM+DMTX+DIOD+DPRX+DISCA+DISCB+DISCK+DISH+DVCR+SAUC+DLHC+DNBF+DLTR+DGICA+DGICB+DMLP+DORM+EAGL+EAGLU+EAGLW+DRWI+DRWIW+DWA+DRYS+DSKX+DSPG+DTSI+DLTH+DNKN+DRRX+DXPE+BOOM+DYSL+DYNT+DVAX+ETFC+EBMT+EGBN+EGLE+EGRX+ELNK+EWBC+EACQ+EACQU+EACQW+EML+EVBS+EVGBC+EVSTC+EVLMC+EBAY+EBAYL+EBIX+ELON+ECHO+SATS+EEI+ECAC+ECACR+ECACU+ESES+EDAP+EDGE+EDGW+EDIT+EDUC+EFUT+EGAN+EGLT+EHTH+EIGR+LOCO+EMITF+ESLT+ERI+ELRC+ESIO+EA+EFII+ELSE+ELEC+ELECU+ELECW+EBIO+RDEN+CAPX+ESBK+ELTK+EMCI+EMCF+EMKR+EMMS+NYNY+ERS+ENTA+ECPG+WIRE+ENDP+ECYT+ELGX+EIGI+WATT+EFOI+ERII+ENOC+ENG+ENPH+ESGR+ENFC+ENTG+ENTL+ETRM+EBTC+EFSC+EGT+ENZY+EPIQ+EPRS+EPZM+PLUS+EQIX+EQFN+EQBK+EAC+ERIC+ERIE+ESCA+ESMC+ESPR+ESSA+EPIX+ESND+ETSY+CLWT+EEFT+ESEA+EVEP+EVK+EVLV+EVOK+EVOL+EXA+EXAS+EXAC+EXEL+EXFO+EXLS+EXPE+EXPD+EXPO+ESRX+EXTR+EYEG+EYEGW+EZPW+FFIV+FB+FCS+FRP+FALC+DAVE+FARM+FFKT+FMNB+FARO+FAST+FATE+FBSS+FBRC+FDML+FNHC+FEIC+FHCO+FENX+GSM+FCSC+FGEN+ONEQ+LION+FDUS+FRGI+FSAM+FSC+FSCFL+FSFR+FITB+FITBI+FNGN+FISI+FNSR+FNJN+FNTC+FNTCU+FNTCW+FEYE+FBNC+FNLC+FRBA+BUSE+FBIZ+FCAP+FCFS+FCNCA+FCLF+FCBC+FCCO+FCFP+FBNK+FDEF+FFBC+FFBCW+FFIN+THFF+FFNW+FFWM+FGBI+INBK+FIBK+FRME+FMBH+FMBI+FNBC+FNFG+FNWB+FSFG+FSLR+FSBK+FAAR+FPA+BICK+FBZ+FCAN+FTCS+FCA+FDT+FDTS+FVC+FV+IFV+FEM+FEMB+FEMS+FTSM+FEP+FEUZ+FGM+FTGC+FTHI+HYLS+FHK+FTAG+FTRI+FPXI+YDIV+SKYY+FJP+FEX+FTC+FTA+FLN+FTLB+LMBS+FMB+FMK+FNX+FNY+FNK+FAD+FAB+MDIV+QABA+QCLN+GRID+CIBR+CARZ+RDVY+FONE+TDIV+QQEW+QQXT+QTEC+AIRR+QINC+RFAP+RFDI+RFEM+RFEU+FTSL+FYX+FYC+FYT+FKO+FCVT+FDIV+FSZ+FTW+TUSA+FKU+FUNC+SVVC+FMER+FSV+FISV+FIVE+FPRX+FVE+FIVN+FLML+FLKS+FLXN+SKOR+LKOR+MBSD+ASET+ESGG+ESG+QLC+FLXS+FLEX+FLIR+FLDM+FFIC+FOMX+FOGO+FONR+FES+FH+FORM+FORTY+FORR+FTNT+FBIO+FWRD+FORD+FWP+FOSL+FMI+FOXF+FRAN+FELE+FRED+RAIL+FEIM+FRPT+FTEO+FTR+FTRPR+FRPH+FSBW+FSBC+FTD+FTEK+FCEL+FORK+FULL+FULLL+FLL+FULT+FNCX+FSNN+FFHL+GK+WILC+GAIA+GLPG+GALT+GALTU+GALTW+GALE+GLMD+GLPI+GPIC+GRMN+GARS+GEMP+GENC+GNCMA+GFN+GFNCP+GFNSL+GENE+GNMK+GNCA+GHDX+GNTX+THRM+GNVC+GTWN+GEOS+GABC+GERN+GEVO+ROCK+GIGM+GIGA+GIII+GILT+GILD+GBCI+GLAD+GLADO+GOOD+GOODM+GOODN+GOODO+GOODP+GAIN+GAINN+GAINO+GAINP+LAND+GLBZ+GBT+ENT+GBLI+GBLIZ+GPAC+GPACU+GPACW+SELF+GSOL+GWRS+KRMA+ACTX+BFIT+LNGR+MILN+QQQC+CATH+SOCL+ALTY+SRET+YLCO+GLBS+GLRI+GLUU+GLYC+GOGO+GLNG+GMLP+GLDC+GDEN+GOGL+GBDC+GTIM+GPRO+GMAN+GRSH+GRSHU+GRSHW+GOV+GOVNI+GPIA+GPIAU+GPIAW+LOPE+GRVY+GBSN+GEC+GLDD+GSBC+GNBC+GRBK+GPP+GPRE+GCBC+GLRE+GRIF+GRFS+GRPN+OMAB+GGAL+GSIT+GSVC+GTXI+GBNK+GFED+GUID+GIFI+GURE+GPOR+GWPH+GWGH+GYRO+HEES+HLG+HNRG+HALL+HALO+HBK+HMPR+HBHC+HBHCL+HNH+HAFC+HNSN+HQCL+HONE+HDNG+HLIT+HRMN+HRMNU+HRMNW+TINY+HBIO+HCAP+HCAPL+HAS+HA+HCOM+HWKN+HWBK+HAYN+HDS+HIIQ+HCSG+HQY+HSTM+HWAY+HTLD+HTLF+HTWR+HTBX+HSII+HELE+HMNY+HMTV+HNNA+HCAC+HCACU+HCACW+HSIC+HTBK+HFWA+HEOP+HCCI+MLHR+HRTX+HSKA+HIBB+HPJ+HIHO+HIMX+HIFS+HSGX+HMNF+HMSY+HOLI+HOLX+HBCP+HOMB+HFBL+HMST+HTBI+CETC+HOFT+HFBC+HBNC+HZNP+HRZN+HDP+HPT+HPTRP+HMHC+HWCC+HOVNP+HBMD+HSNI+HTGM+HUBG+HSON+HDSN+HBAN+HBANO+HBANP+HURC+HURN+HTCH+HCM+HBP+HDRA+HDRAR+HDRAU+HDRAW+HYGS+IDSY+IAC+IKGH+IBKC+IBKCO+IBKCP+ICAD+IEP+ICFI+ICLR+ICON+ICUI+IPWR+INVE+IDRA+IDXX+DSKY+IESC+IROQ+IRG+RXDX+INFO+IIVI+KANG+IKNX+ILMN+ISNS+IMMR+ICCC+IMDZ+IMNP+IMGN+IMMU+IPXL+PI+IMMY+INCR+SAAS+INCY+INDB+IBCP+IBTX+IDSA+INFN+INFI+IPCC+III+IFON+IMKTA+INWK+INNL+INOD+IPHS+IOSP+ISSC+INVA+INGN+ITEK+INOV+INO+NSIT+ISIG+INSM+IIIN+PODD+INSY+NTEC+IART+IDTI+INTC+IQNT+NTLA+IPCI+IPAR+IBKR+ININ+ICPT+ICLD+ICLDW+IDCC+TILE+LINK+IMI+INAP+IBOC+ISCA+IGLD+IIJI+IDXG+XENT+INTX+ISIL+IILG+IVAC+INTL+INTLL+ITCI+IIN+INTU+ISRG+INVT+SNAK+ISTR+ISBC+ITIC+NVIV+IVTY+IONS+IPAS+IPGP+IRMD+IRIX+IRDM+IRDMB+IRBT+IRWD+IRCP+SLQD+TLT+AIA+COMT+IXUS+FALN+IFEU+IFGL+IGF+GNMA+HYXE+JKI+ACWX+ACWI+AAXJ+EWZS+MCHI+ESGD+SCZ+ESGE+EEMA+EEML+EUFN+IEUS+ENZL+QAT+UAE+IBB+SOXX+EMIF+ICLN+WOOD+INDY+ISHG+IGOV+MPCT+ISLE+ISRL+ITI+ITRI+ITRN+ITUS+XXIA+IXYS+IZEA+JJSF+MAYS+JBHT+JCOM+JASO+JKHY+JACK+JXSB+JAGX+JAKK+JMBA+JRVR+JSML+JSMD+JASN+JASNW+JAZZ+JD+JSYN+JSYNR+JSYNU+JSYNW+JBLU+JTPY+JCTCF+JIVE+WYIG+WYIGU+WYIGW+JBSS+JOUT+JNP+JUNO+KTWO+KALU+KMDA+KNDI+KPTI+KBSF+KCAP+KRNY+KELYA+KELYB+KMPH+KFFB+KERX+KEQU+KTEC+KTCC+KFRC+KE+KBAL+KIN+KGJI+KINS+KONE+KIRK+KITE+KTOV+KTOVW+KLAC+KLRE+KLREU+KLREW+KLXI+KONA+KZ+KOPN+KRNT+KOSS+KWEB+KTOS+KLIC+KURA+KVHI+FSTR+LJPC+DRIO+DRIOW+LSBK+LSBG+LBAI+LKFN+LAKE+LRCX+LAMR+LANC+LCA+LCAHU+LCAHW+LNDC+LARK+LMRK+LMRKP+LE+LSTR+LNTH+LTRX+LSCC+LAWS+LAYN+LCNB+LBIX+LGCY+LGCYO+LGCYP+LTXB+DDBI+EDBI+LVHD+UDBI+LMAT+TREE+LXRX+LGIH+LHCG+LBRDA+LBRDK+LBTYA+LBTYB+LBTYK+LILA+LILAK+LVNTA+LVNTB+QVCA+QVCB+BATRA+BATRK+LMCA+LMCK+LSXMA+LSXMB+LSXMK+TAX+LTRPA+LTRPB+LPNT+LCUT+LFVN+LWAY+LGND+LTBR+LPTH+LIME+LLNW+LMNR+LINC+LECO+LIND+LINDW+LLTC+LBIO+LIOX+LPCN+LQDT+LFUS+LIVN+LOB+LIVE+LPSN+LKQ+LMFA+LMFAW+LMIA+LOGI+LOGM+EVAR+CNCR+LONE+LORL+LOXO+LPTN+LPLA+LRAD+LYTS+LULU+LITE+LMNX+LMOS+LUNA+MBTF+MIIIU+MCBC+MFNC+MTSI+MCUR+MGNX+MAGS+MGLN+MPET+MGIC+CALL+MNGA+MGYR+MHLD+MHLDO+MSFG+COOL+MMYT+MBUU+MLVF+MAMS+MANH+LOAN+MNTX+MTEX+MNKD+MANT+MARA+MCHX+MARPS+MRNS+MKTX+MKTO+MRLN+MAR+MBII+MRTN+MMLP+MRVL+MASI+MTCH+MATN+MTLS+MTRX+MAT+MATR+MATW+MFRM+MXIM+MXPT+MXWL+MZOR+MBFI+MBFIP+MCFT+MGRC+MDCA+MFIN+MFINL+MTBC+MTBCP+MNOV+MDSO+MDGS+MDVN+MDWD+MDVX+MDVXW+MEET+MEIP+MPEL+MLNX+MELR+MEMP+MRD+MENT+MTSL+MELI+MBWM+MERC+MBVT+MRCY+EBSB+VIVO+MMSI+MACK+MSLI+MRUS+MLAB+MESO+CASH+MBLX+MEOH+MFRI+MGCD+MGEE+MGPI+MCHP+MU+MICT+MICTW+MSCC+MSFT+MSTR+MVIS+MPB+MTP+MCEP+MBRG+MBCN+MSEX+MSBI+MOFG+MIME+MDXG+MNDO+MB+NERV+MRTX+MIRN+MSON+MIND+MINDP+MITK+MITL+MKSI+MMAC+MINI+MOBL+MOCO+MDSY+MLNK+MBRX+MNTA+MOMO+MCRI+MDLZ+MGI+MPWR+TYPE+MNRO+MRCC+MNST+MSDI+MSDIW+MHGC+MORN+MOSY+MPAA+MDM+MRVC+MSBF+MSG+MTSC+LABL+MFLX+MFSF+MYSZ+MYL+MYOK+MYOS+MYRG+MYGN+NBRV+NAKD+NNDM+NANO+NSTG+NH+NK+NSSC+NDAQ+NTRA+NATH+NAUH+NKSH+FIZZ+NCMI+NCOM+NGHC+NGHCN+NGHCO+NGHCP+NGHCZ+NHLD+NATI+NATL+NRCIA+NRCIB+NSEC+NWLI+NAII+NHTC+NATR+BABY+NAVI+NBTB+NCIT+NKTR+NEOG+NEO+NEON+NEOS+NEOT+NVCN+NEPT+UEPS+NETE+NTAP+NTES+NFLX+NTGR+NLST+NTCT+NTWK+CUR+NBIX+NDRM+NURO+NUROW+NYMT+NYMTO+NYMTP+NLNK+NWS+NWSA+NEWS+NEWT+NEWTL+NEWTZ+NXEO+NXEOU+NXEOW+NXST+NVET+NFEC+EGOV+NICE+NICK+NCBS+NIHD+NVLS+NMIH+NNBR+NDLS+NDSN+NSYS+NTK+NBN+NTIC+NTRS+NTRSP+NFBK+NRIM+NWBI+NWBO+NWBOW+NWPX+NCLH+NWFL+NVFY+NVMI+NVDQ+NOVT+MIFI+NVAX+NVCR+NVGN+NUAN+NMRX+NUTR+NTRI+NUVA+NVTR+QQQX+NVEE+NVEC+NVDA+NXPI+NXTM+NXTD+NXTDW+NYMX+OIIM+OVLY+OASM+OBCI+OPTT+ORIG+OSHC+OCFC+OCRX+OCLR+OFED+OCUL+OCLS+OCLSW+OMEX+ODP+OFS+OHAI+OVBC+OHRP+ODFL+OLBK+ONB+OPOF+OSBC+OSBCP+OLLI+ZEUS+OFLX+OMER+OMCL+ON+OTIV+ONS+ONSIW+ONSIZ+OGXI+OMED+ONTX+ONCS+OHGI+ONVI+OTEX+OPXA+OPXAW+OPGN+OPGNW+OPHT+OPK+OBAS+OCC+OPHC+OPB+ORMP+OSUR+ORBC+ORBK+ORLY+OREX+SEED+OACQ+OACQR+OACQU+OACQW+OESX+ORIT+ORRF+OFIX+OSIS+OSIR+OSN+OTEL+OTIC+OTTR+OUTR+OVAS+OSTK+OXBR+OXBRW+OXFD+OXLC+OXLCN+OXLCO+PFIN+PTSI+PCAR+PACE+PACEU+PACEW+PACB+PCBK+PEIX+PMBC+PPBI+PAAC+PAACR+PAACU+PAACW+PCRX+PACW+PTIE+PAAS+PNRA+PANL+PZZA+FRSH+PBNC+PRTK+PRXL+PCYG+PSTB+PKBK+PRKR+PKOH+PARN+PTNR+PBHC+PATK+PNBK+PATI+PEGI+PDCO+PTEN+PAVMU+PAYX+PCTY+PYDS+PYPL+PBBI+PCCC+PCMI+PCTI+PDCE+PDFS+PDLI+PDVW+SKIS+PGC+PEGA+PCO+PENN+PFLT+PNNT+PWOD+PTXP+PEBO+PEBK+PFBX+PFIS+PBCT+PUB+PRCP+PPHM+PPHMP+PRFT+PFMT+PERF+PERI+PESI+PTX+PERY+PGLC+PETS+PFSW+PGTI+PZRX+PHII+PHIIK+PAHC+PHMD+PLAB+PICO+PIRS+PPC+PME+PNK+PNFP+PPSI+PXLW+PLPM+PLXS+PLUG+PLBC+PSTI+PBSK+PNTR+PCOM+PLCM+POOL+POPE+PLKI+BPOP+BPOPM+BPOPN+PBIB+PTLA+PBPB+PCH+POWL+POWI+PSIX+PDBC+DWLV+DWIN+DWTR+IDLB+PRFZ+PAGG+PSAU+IPKW+LDRI+LALT+PNQI+QQQ+USLB+PSCD+PSCC+PSCE+PSCF+PSCH+PSCI+PSCT+PSCM+PSCU+PRAA+PRAH+PRAN+PFBC+PLPC+PFBI+PINC+LENS+PRGX+PSMT+PBMD+PNRG+PRMW+PRIM+PSET+PY+PRZM+PVTB+PVTBP+PDEX+IPDN+PFIE+PGNX+PRGS+DNAI+PFPT+PRPH+PRQR+BIB+UBIO+TQQQ+ZBIO+SQQQ+BIS+PSEC+PRTO+PTI+PRTA+PWX+PVBC+PROV+PBIP+PSDV+PMD+PTC+PTCT+PULM+PLSE+PCYO+PXS+QADA+QADB+QCRH+QGEN+QIWI+QLIK+QLGC+QLTI+QRVO+QCOM+QSII+QBAK+QLYS+QRHC+QUIK+QDEL+QPAC+QPACU+QPACW+QNST+QUMU+QUNR+QTNT+RRD+RADA+RDCM+ROIA+ROIAK+RSYS+RDUS+RDNT+RDWR+RMBS+RAND+RLOG+GOLD+RNDB+RPD+RPTP+RAVE+RAVN+ROLL+RICK+RCMT+RLOC+RDI+RDIB+RGSE+RELY+RNWK+RP+RETA+UTES+DAX+QYLD+RCON+REPH+RRGB+RRR+RDHL+REGN+RGNX+DFVL+DFVS+DGLD+DLBL+DLBS+DSLV+DTUL+DTUS+DTYL+DTYS+FLAT+GLDI+SLVO+STPP+TAPR+TVIX+TVIZ+UGLD+USLV+VIIX+VIIZ+XIV+ZIV+RGLS+REIS+RELV+RLYP+MARK+RNST+REGI+RNVA+RNVAZ+RCII+RTK+RGEN+RPRX+RBCAA+FRBK+REFR+RESN+REXI+RECN+ROIC+SALE+RTRX+RVNC+RVLT+RWLK+REXX+RFIL+RGCO+RIBT+RIBTW+RELL+RIGL+NAME+RNET+RTTR+RVSB+RLJE+RMGN+ROBO+FUEL+RMTI+RCKY+RMCF+RSTI+ROKA+ROSG+ROST+ROVI+RBPAA+TALL+RGLD+RPXC+RTIX+RBCN+RUSHA+RUSHB+RUTH+RXII+RYAAY+STBA+SANW+SBRA+SBRAP+SABR+SAEX+SAFT+SAGE+SGNT+SAIA+SAJA+SALM+SAL+SAFM+SASR+SGMO+SANM+GCVRZ+SPNS+SRPT+SBFG+SBFGP+SBAC+SCSC+SMIT+SCHN+SCHL+SCLN+SGMS+SQI+SNI+SCYX+SEAC+SBCF+STX+SHIP+SRSC+SHLD+SHLDW+SHOS+SPNE+SGEN+EYES+SCWX+SNFCA+SEIC+SLCT+SCSS+SIR+SELB+SIGI+LEDS+SMLR+SMTC+SENEA+SENEB+SNH+SNHNI+SNHNL+SNMX+SQNM+SQBG+MCRB+SREV+SFBS+SEV+SVBI+SGOC+SMED+SHSP+SHEN+SHLO+SHPG+SCVL+SHBI+SHOR+SFLY+SIFI+SIEB+SIEN+BSRR+SWIR+SIFY+SIGM+SGMA+SGNL+SBNY+SBNYW+SLGN+SILC+SGI+SLAB+SIMO+SPIL+SRAQ+SRAQU+SRAQW+SSRI+SAMG+SFNC+SLP+SINA+SBGI+SINO+SVA+SIRI+SITO+SZMK+SKUL+SKYS+SKLN+MOBI+SPU+SKYW+SWKS+ISM+JSM+OSM+SLM+SLMAP+SLMBP+SMT+SMBK+SWHC+SMSI+SMTX+LNCE+SCKT+SODA+SOHU+SLRC+SUNS+SCTY+SEDG+SONC+SOFO+SONS+SPHS+SORL+SRNE+SOHO+SOHOL+SOHOM+SFBC+SSB+SFST+SMBC+SONA+SBSI+OKSB+SP+SPAN+SBSA+SGRP+SPKE+ONCE+SPAR+SPTN+DWFI+SPPI+ANY+SPEX+SPI+SAVE+SPLK+SPOK+SPWH+SBPH+FUND+SFM+SPSC+SSNC+STAA+STAF+STMP+STLY+SPLS+SBLK+SBLKL+SBUX+STRZA+STRZB+STFC+STBZ+SNC+STDY+GASS+STLD+SMRT+SBOT+STEM+STML+STXS+SRCL+SRCLP+STRL+SHOO+SSFN+SYBT+BANX+SGBK+SSKN+SSYS+STRT+STRS+STRA+STRM+SBBP+STB+SCMP+SUMR+SMMF+SSBI+SMMT+SNBC+SNHY+SEMI+SNSS+STKL+SPWR+RUN+SBCP+SSH+SUNW+SMCI+SPCB+SCON+SGC+SUPN+SPRT+SGRY+SCAI+SRDX+SBBX+SIVB+SIVBO+SYKE+SYMC+SYNC+SYNL+SYNA+SNCR+SNDX+SGYP+SGYPU+SGYPW+ELOS+SNPS+SYNT+SYMX+SYUT+SYPR+SYRS+SYRX+TROW+TTOO+TAIT+TTWO+TLMR+TNDM+TLF+TNGO+TANH+TEDU+TASR+TATT+TAYD+TCPC+AMTD+TEAR+TECD+TCCO+TTGT+TGLS+TGEN+TNAV+TTEC+TLGT+TENX+GLBL+TERP+TRTL+TRTLU+TRTLW+TVIA+TBNK+TSRO+TESO+TSLA+TESS+TSRA+TTEK+TLOG+TTPH+TCBI+TCBIL+TCBIP+TCBIW+TXN+TXRH+TFSL+TGTX+ABCO+ANDE+TBBK+BONT+CG+CAKE+CHEF+TCFC+DSGX+DXYN+ENSG+XONE+FINL+FBMS+FLIC+GT+HABT+HCKT+HAIN+FITS+CUBA+INTG+JYNT+KEYW+KHC+OLD+MDCO+MIK+MIDD+NAVG+SLIM+STKS+ORG+PCLN+PRSC+BITE+RMR+SPNC+ULTI+YORW+NCTY+TBPH+TST+TCRD+THLD+TICC+TTS+TIL+TSBK+TIPT+TITN+TTNP+TIVO+TMUS+TMUSP+TBRA+TKAI+TNXP+TISA+TOPS+TORM+TRCH+TSEM+TWER+CLUB+TOWN+TPIC+TCON+TSCO+TWMC+TACT+TRNS+TBIO+TGA+TTHI+TA+TANNI+TANNL+TANNZ+TZOO+TRVN+TCBK+TRIL+TRS+TRMB+TRIB+TRIP+TSC+TBK+TRNC+TROV+TROVU+TROVW+TRUE+THST+TRUP+TRST+TRMK+TSRI+TTMI+TUBE+TCX+TUES+TOUR+HEAR+TUTI+TUTT+FOX+FOXA+TWIN+TRCB+USCR+PRTS+USEG+GROW+UBNT+UFPT+ULTA+UCTT+RARE+ULBI+ULTR+UTEK+UMBF+UMPQ+UNAM+UNIS+UBSH+UNB+UNXL+QURE+UBCP+UBOH+UBSI+UCBA+UCBI+UCFC+UDF+UBNK+UFCS+UIHC+UNFI+UBFO+USBI+USLM+UTHR+UG+UNTY+OLED+UEIC+UFPI+ULH+USAP+UVSP+UPLD+URRE+URBN+ECOL+USAT+USATP+USAK+USMD+UTMD+UTSI+VALX+VALU+VNDA+BBH+GNRX+PPH+VWOB+VNQI+VGIT+VCIT+VIGI+VYMI+VCLT+VGLT+VMBS+VNR+VNRAP+VNRBP+VNRCP+VONE+VONG+VONV+VTWO+VTWG+VTWV+VTHR+VCSH+VGSH+VTIP+BNDX+VXUS+VRNS+VDSI+VBLT+VASC+VBIV+WOOF+VECO+APPY+VRA+VCYT+VSTM+VCEL+VRNT+VRSN+VRSK+VBTX+VRML+VSAR+VTNR+VRTX+VRTB+VIA+VIAB+VSAT+VIAV+VICL+VICR+CIZ+CEZ+CID+CIL+CFO+CFA+CSF+CDC+CDL+CSB+CSA+VBND+VUSE+VIDI+VDTH+VRAY+VKTX+VKTXW+VBFC+VLGEA+VIP+VNOM+VIRC+VA+VIRT+VRTS+VRTU+VISN+VTGN+VTAE+VTL+VIVE+VVUS+VOD+VLTC+VOXX+VYGR+VSEC+VTVT+VUZI+VWR+WGBS+WBA+WAFD+WAFDW+WASH+WFBI+WSBF+WVE+WAYN+WSTG+WCFB+WDFC+FLAG+WEB+WBMD+WB+WEBK+WEN+WERN+WSBC+WTBA+WSTC+WMAR+WABC+WBB+WSTL+WDC+WFD+WLB+WPRT+WEYS+WHLR+WHLRP+WHLRW+WHF+WHFBL+WFM+WILN+WHLM+WVVI+WVVIP+WLDN+WLFC+WLTW+WIBC+WIN+WINT+WING+WINA+WINS+WTFC+WTFCM+WTFCW+AGND+AGZD+HYND+HYZD+CXSE+EMCG+EMCB+DGRE+DXGE+WETF+DXJS+JGBB+DXKW+GULF+CRDT+DGRW+DGRS+DXPS+UBND+WIX+WMIH+WBKC+WWD+WKHS+WRLD+JMU+WPCS+WPPGY+WMGI+WMGIZ+WSFS+WSFSL+WSCI+WVFC+WYNN+XBIT+XELB+XCRA+XNCR+XBKS+XENE+XGTI+XGTIW+XLNX+XOMA+XPLR+XCOM+XTLB+XNET+MESG+YHOO+YNDX+YIN+YOD+YCB+YRCW+YECO+YY+ZFGN+ZAGG+ZAIS+ZBRA+ZLTQ+ZHNE+Z+ZG+ZN+ZNWAA+ZION+ZIONW+ZIONZ+ZIOP+ZIXI+ZGNX+ZSAN+ZUMZ+ZYNE+ZNGA'
In [32]:
symbol = np.append(df1.Symbol.values, df2.Symbol.values)
symbol = np.append(symbol, df3.Symbol.values)
In [39]:
url = 'http://finance.yahoo.com/d/quotes.csv?s=%s&f=aa2a5bb2b3b4b6cc1c3c6c8dd1d2ee1e7e8e9f6ghjkg1g3g4g5g6ii5j1j3j4j5j6k1' %(symbol1)
In [40]:
url
Out[40]:
'http://finance.yahoo.com/d/quotes.csv?s=PIH+FLWS+FCCY+SRCE+VNET+TWOU+JOBS+CAFD+EGHT+AVHI+SHLM+AAON+ABAX+ABEO+ABEOW+ABIL+ABMD+AXAS+ACIA+ACTG+ACHC+ACAD+ACST+AXDX+XLRN+ANCX+ARAY+OILD+OILU+VXDN+VXUP+ACRX+ACET+AKAO+ACHN+ACIW+ACRS+ACNB+ACOR+ACTS+ACPW+ATVI+ACTA+ACUR+ACXM+ADMS+ADMP+ADAP+ADUS+AEY+IOTS+ADMA+ADBE+ADTN+ADRO+AAAP+ADES+AEIS+AMD+ADXS+ADXSW+ADVM+MAUI+YPRO+AEGR+AEGN+AGLE+AEHR+AMTX+AEPI+AERI+AVAV+AEZS+AEMD+AFMD+UAVS+AGEN+AGRX+AGYS+AGIO+AGFS+AGFSW+AIMT+AIRM+AIRT+ATSG+AMCN+AIXG+AKAM+AKTX+AKBA+AKER+AKRX+ALRM+ALSK+AMRI+ABDC+ADHD+ALDR+ALDX+ALXN+ALCO+ALGN+ALIM+ALJJ+ALKS+ABTX+ALGT+AIQ+AHGP+ARLP+AHPI+AMOT+ALQA+ALLT+MDRX+AFAM+ALNY+AOSL+GOOG+GOOGL+SMCP+ATEC+ASPS+AIMC+AMAG+AMRN+AMRK+AYA+AMZN+AMBC+AMBCW+AMBA+AMCX+DOX+AMDA+AMED+UHAL+ATAX+AMOV+AAL+AGNC+AGNCB+AGNCP+MTGE+MTGEP+ACSF+ACAS+AETI+AMIC+AMNB+ANAT+APEI+ARII+AMRB+ASEI+AMSWA+AMSC+AMWD+CRMT+ABCB+AMSF+ASRV+ASRVP+ATLO+AMGN+FOLD+AMKR+AMPH+IBUY+AMSG+AMSGP+ASYS+AFSI+AMRS+ADI+ALOG+AVXL+ANCB+ANDA+ANDAR+ANDAU+ANDAW+ANGI+ANGO+ANIP+ANIK+ANSS+ATRS+ANTH+ABAC+APIC+APOG+APOL+AINV+APPF+AAPL+ARCI+APDN+APDNW+AGTC+AMAT+AMCC+AAOI+AREX+APRI+APVOV+APTO+AQMS+AQXP+AUMA+AUMAU+AUMAW+ARDM+ARLZ+PETX+ABUS+ARCW+ABIO+RKDA+ARCB+ACGL+APLP+ACAT+ARDX+ARNA+ARCC+AGII+AGIIL+ARGS+ARIS+ARIA+ARKR+ARMH+ARTX+ARWA+ARWAR+ARWAU+ARWAW+ARQL+ARRY+ARRS+DWAT+AROW+ARWR+ARTNA+ARTW+ASBB+ASNA+ASND+ASCMA+APWC+ASML+AZPN+ASMB+ASFI+ASTE+ATRO+ALOT+ASTC+ASUR+ATAI+ATRA+ATHN+ATHX+AAPC+AAME+ACBI+ACFC+ABY+ATLC+AAWW+AFH+TEAM+ATNI+ATOS+ATRC+ATRI+ATTU+LIFE+AUBN+BOLD+AUDC+AUPH+EARS+ABTL+ADSK+ADP+AVEO+AVXS+AVNW+AVID+AVGR+AVIR+CAR+AWRE+ACLS+AXGN+AXSM+AXTI+BCOM+RILY+BOSC+BEAV+BIDU+BCPC+BWINA+BWINB+BLDP+BANF+BANFP+BKMU+BOCH+BMRC+BKSC+BOTJ+OZRK+BFIN+BWFG+BANR+BZUN+BHAC+BHACR+BHACU+BHACW+BBSI+BSET+BYBK+BV+BBCN+BCBP+BECN+BSF+BBGI+BEBE+BBBY+BGNE+BELFA+BELFB+BLPH+BLCM+BNCL+BNFT+BNTC+BNTCW+BGCP+BGFV+BIND+ORPN+BASI+BIOC+BCRX+BIOD+BDSI+BIIB+BIOL+BLFS+BLRX+BMRN+BVXV+BVXVW+BPTH+BIOS+BBC+BBP+BSTC+BSTG+BSPM+TECH+BEAT+BJRI+BBOX+BDE+BLKB+BBRY+HAWK+BKCC+ADRA+ADRD+ADRE+ADRU+BLMN+BCOR+BLBD+BUFF+BHBK+NILE+BLUE+BKEP+BKEPP+BPMC+ITEQ+BMCH+BNCN+BOBE+BOFI+BOFIL+WIFI+BOJA+BOKF+BOKFL+BNSO+BPFH+BPFHP+BPFHW+EPAY+BLVD+BLVDU+BLVDW+BCLI+BBRG+BDGE+BLIN+BRID+BCOV+AVGO+BSFT+BVSN+BYFC+BWEN+BRCD+BRKL+BRKS+BRKR+BMTC+BLMT+BSQR+BWLD+BLDR+BMLA+BUR+CFFI+CHRW+CA+CCMP+CDNS+CDZI+CACQ+CZR+CSTE+PRSS+CLBS+CLMS+CHY+CHI+CCD+CFGE+CHW+CGO+CSQ+CAMP+CVGW+CFNB+CALA+CALD+CALM+CLMT+ABCD+CAC+CAMT+CSIQ+CGIX+CPHC+CPLA+CBF+CCBG+CPLP+CSWC+CPTA+CLAC+CLACU+CLACW+CFFN+CAPN+CAPNW+CAPR+CPST+CARA+CARB+CBYL+CFNL+CRME+CSII+CATM+CDNA+CECO+CTRE+CKEC+CLBH+CARO+CART+CRZO+TAST+CRTN+CARV+CASM+CACB+CASC+CWST+CASY+CASI+CASS+CATB+CBIO+CPRX+CATY+CATYW+CVCO+CAVM+CBFV+CBOE+CDK+CDW+CECE+CELG+CELGZ+CLDX+CLRB+CLRBW+CLRBZ+CLLS+CBMG+CLSN+CYAD+CEMP+CETX+CSFL+CETV+CFBK+CENT+CENTA+CVCY+CFCB+CENX+CNBKA+CNTY+CPHD+CRNT+CERC+CERCW+CERCZ+CERE+CERN+CERU+CERS+KOOL+CEVA+CFCO+CFCOU+CFCOW+CSBR+CYOU+HOTR+HOTRW+CTHR+GTLS+CHTR+CHFN+CHKP+CHEK+CHEKW+CEMI+CHFC+CCXI+CHMG+CHKE+CHMA+CBNK+PLCE+CMRX+CADC+CALI+CAAS+CBAK+CBPO+CCCL+CCCR+CCRC+JRJC+HGSH+CNIT+CJJD+CLDC+CLDCW+HTHT+CHNR+CREG+CNTF+CXDC+CCIH+CNET+IMOS+CDXC+CHSCL+CHSCM+CHSCN+CHSCO+CHSCP+CHDN+CHUY+CDTX+CIFC+CMCT+CMPR+CINF+CIDM+CTAS+CPHR+CRUS+CSCO+CTRN+CZNC+CZWI+CZFC+CIZN+CTXS+CHCO+CIVB+CIVBP+CDTI+CLNE+CLNT+CLFD+CLRO+CLSD+CLIR+CBLI+CSBK+CLVS+CMFN+CME+CCNE+CISG+CNV+CWAY+COBZ+COKE+CDXS+CVLY+JVA+CCOI+CGNT+CGNX+CTSH+COHR+CHRS+COHU+CLCT+COLL+CIGI+CBAN+CLCD+COLB+COLM+CMCO+CBMX+CBMXW+CMCSA+CBSH+CBSHP+CUBN+CVGI+COMM+CSAL+JCS+ESXB+CYHHZ+CTBI+CWBC+COB+CVLT+CGEN+CPSI+CTG+SCOR+CHCI+CMTL+CNAT+CNCE+CXRX+CCUR+CDOR+CFMS+CNFR+CNMD+CTWS+CNOB+CNXR+CONN+CNSL+CWCO+CPSS+CFRX+CFRXW+CTRV+CTRL+CPAAU+CPRT+COYN+COYNW+CRBP+CORT+BVA+CORE+CORI+CSOD+CRVL+CRVS+COSI+CSGP+COST+CPAH+ICBK+CVTI+COVS+COWN+COWNL+PMTS+CPSH+CRAI+CBRL+BREW+CRAY+CACC+CREE+CRESY+CRTO+CROX+CCRN+XRDC+CRDS+CRWS+CYRX+CYRXW+CSGS+CCLP+CSPI+CSWI+CSX+CTIC+CTIB+CTRP+CUNB+CUI+CPIX+CMLS+CRIS+CUTR+CVBF+CVV+CYAN+CYBR+CYBE+CYCC+CYCCP+CBAY+CYNA+CYNO+CY+CYRN+CONE+CYTK+CTMX+CYTX+CYTXW+CTSO+CYTR+DJCO+DAKT+DAIO+DTLK+DRAM+DWCH+PLAY+DTEA+DWSN+DBVT+DHRM+DFRG+TACO+TACOW+DCTH+DMPI+DGAS+DELT+DELTW+DENN+XRAY+DEPO+DSCI+DERM+DEST+DXLG+DSWL+DTRM+DXCM+DXTR+DHXM+DHIL+FANG+DCIX+DRNA+DFBG+DGII+DMRC+DRAD+DGLY+APPS+DCOM+DMTX+DIOD+DPRX+DISCA+DISCB+DISCK+DISH+DVCR+SAUC+DLHC+DNBF+DLTR+DGICA+DGICB+DMLP+DORM+EAGL+EAGLU+EAGLW+DRWI+DRWIW+DWA+DRYS+DSKX+DSPG+DTSI+DLTH+DNKN+DRRX+DXPE+BOOM+DYSL+DYNT+DVAX+ETFC+EBMT+EGBN+EGLE+EGRX+ELNK+EWBC+EACQ+EACQU+EACQW+EML+EVBS+EVGBC+EVSTC+EVLMC+EBAY+EBAYL+EBIX+ELON+ECHO+SATS+EEI+ECAC+ECACR+ECACU+ESES+EDAP+EDGE+EDGW+EDIT+EDUC+EFUT+EGAN+EGLT+EHTH+EIGR+LOCO+EMITF+ESLT+ERI+ELRC+ESIO+EA+EFII+ELSE+ELEC+ELECU+ELECW+EBIO+RDEN+CAPX+ESBK+ELTK+EMCI+EMCF+EMKR+EMMS+NYNY+ERS+ENTA+ECPG+WIRE+ENDP+ECYT+ELGX+EIGI+WATT+EFOI+ERII+ENOC+ENG+ENPH+ESGR+ENFC+ENTG+ENTL+ETRM+EBTC+EFSC+EGT+ENZY+EPIQ+EPRS+EPZM+PLUS+EQIX+EQFN+EQBK+EAC+ERIC+ERIE+ESCA+ESMC+ESPR+ESSA+EPIX+ESND+ETSY+CLWT+EEFT+ESEA+EVEP+EVK+EVLV+EVOK+EVOL+EXA+EXAS+EXAC+EXEL+EXFO+EXLS+EXPE+EXPD+EXPO+ESRX+EXTR+EYEG+EYEGW+EZPW+FFIV+FB+FCS+FRP+FALC+DAVE+FARM+FFKT+FMNB+FARO+FAST+FATE+FBSS+FBRC+FDML+FNHC+FEIC+FHCO+FENX+GSM+FCSC+FGEN+ONEQ+LION+FDUS+FRGI+FSAM+FSC+FSCFL+FSFR+FITB+FITBI+FNGN+FISI+FNSR+FNJN+FNTC+FNTCU+FNTCW+FEYE+FBNC+FNLC+FRBA+BUSE+FBIZ+FCAP+FCFS+FCNCA+FCLF+FCBC+FCCO+FCFP+FBNK+FDEF+FFBC+FFBCW+FFIN+THFF+FFNW+FFWM+FGBI+INBK+FIBK+FRME+FMBH+FMBI+FNBC+FNFG+FNWB+FSFG+FSLR+FSBK+FAAR+FPA+BICK+FBZ+FCAN+FTCS+FCA+FDT+FDTS+FVC+FV+IFV+FEM+FEMB+FEMS+FTSM+FEP+FEUZ+FGM+FTGC+FTHI+HYLS+FHK+FTAG+FTRI+FPXI+YDIV+SKYY+FJP+FEX+FTC+FTA+FLN+FTLB+LMBS+FMB+FMK+FNX+FNY+FNK+FAD+FAB+MDIV+QABA+QCLN+GRID+CIBR+CARZ+RDVY+FONE+TDIV+QQEW+QQXT+QTEC+AIRR+QINC+RFAP+RFDI+RFEM+RFEU+FTSL+FYX+FYC+FYT+FKO+FCVT+FDIV+FSZ+FTW+TUSA+FKU+FUNC+SVVC+FMER+FSV+FISV+FIVE+FPRX+FVE+FIVN+FLML+FLKS+FLXN+SKOR+LKOR+MBSD+ASET+ESGG+ESG+QLC+FLXS+FLEX+FLIR+FLDM+FFIC+FOMX+FOGO+FONR+FES+FH+FORM+FORTY+FORR+FTNT+FBIO+FWRD+FORD+FWP+FOSL+FMI+FOXF+FRAN+FELE+FRED+RAIL+FEIM+FRPT+FTEO+FTR+FTRPR+FRPH+FSBW+FSBC+FTD+FTEK+FCEL+FORK+FULL+FULLL+FLL+FULT+FNCX+FSNN+FFHL+GK+WILC+GAIA+GLPG+GALT+GALTU+GALTW+GALE+GLMD+GLPI+GPIC+GRMN+GARS+GEMP+GENC+GNCMA+GFN+GFNCP+GFNSL+GENE+GNMK+GNCA+GHDX+GNTX+THRM+GNVC+GTWN+GEOS+GABC+GERN+GEVO+ROCK+GIGM+GIGA+GIII+GILT+GILD+GBCI+GLAD+GLADO+GOOD+GOODM+GOODN+GOODO+GOODP+GAIN+GAINN+GAINO+GAINP+LAND+GLBZ+GBT+ENT+GBLI+GBLIZ+GPAC+GPACU+GPACW+SELF+GSOL+GWRS+KRMA+ACTX+BFIT+LNGR+MILN+QQQC+CATH+SOCL+ALTY+SRET+YLCO+GLBS+GLRI+GLUU+GLYC+GOGO+GLNG+GMLP+GLDC+GDEN+GOGL+GBDC+GTIM+GPRO+GMAN+GRSH+GRSHU+GRSHW+GOV+GOVNI+GPIA+GPIAU+GPIAW+LOPE+GRVY+GBSN+GEC+GLDD+GSBC+GNBC+GRBK+GPP+GPRE+GCBC+GLRE+GRIF+GRFS+GRPN+OMAB+GGAL+GSIT+GSVC+GTXI+GBNK+GFED+GUID+GIFI+GURE+GPOR+GWPH+GWGH+GYRO+HEES+HLG+HNRG+HALL+HALO+HBK+HMPR+HBHC+HBHCL+HNH+HAFC+HNSN+HQCL+HONE+HDNG+HLIT+HRMN+HRMNU+HRMNW+TINY+HBIO+HCAP+HCAPL+HAS+HA+HCOM+HWKN+HWBK+HAYN+HDS+HIIQ+HCSG+HQY+HSTM+HWAY+HTLD+HTLF+HTWR+HTBX+HSII+HELE+HMNY+HMTV+HNNA+HCAC+HCACU+HCACW+HSIC+HTBK+HFWA+HEOP+HCCI+MLHR+HRTX+HSKA+HIBB+HPJ+HIHO+HIMX+HIFS+HSGX+HMNF+HMSY+HOLI+HOLX+HBCP+HOMB+HFBL+HMST+HTBI+CETC+HOFT+HFBC+HBNC+HZNP+HRZN+HDP+HPT+HPTRP+HMHC+HWCC+HOVNP+HBMD+HSNI+HTGM+HUBG+HSON+HDSN+HBAN+HBANO+HBANP+HURC+HURN+HTCH+HCM+HBP+HDRA+HDRAR+HDRAU+HDRAW+HYGS+IDSY+IAC+IKGH+IBKC+IBKCO+IBKCP+ICAD+IEP+ICFI+ICLR+ICON+ICUI+IPWR+INVE+IDRA+IDXX+DSKY+IESC+IROQ+IRG+RXDX+INFO+IIVI+KANG+IKNX+ILMN+ISNS+IMMR+ICCC+IMDZ+IMNP+IMGN+IMMU+IPXL+PI+IMMY+INCR+SAAS+INCY+INDB+IBCP+IBTX+IDSA+INFN+INFI+IPCC+III+IFON+IMKTA+INWK+INNL+INOD+IPHS+IOSP+ISSC+INVA+INGN+ITEK+INOV+INO+NSIT+ISIG+INSM+IIIN+PODD+INSY+NTEC+IART+IDTI+INTC+IQNT+NTLA+IPCI+IPAR+IBKR+ININ+ICPT+ICLD+ICLDW+IDCC+TILE+LINK+IMI+INAP+IBOC+ISCA+IGLD+IIJI+IDXG+XENT+INTX+ISIL+IILG+IVAC+INTL+INTLL+ITCI+IIN+INTU+ISRG+INVT+SNAK+ISTR+ISBC+ITIC+NVIV+IVTY+IONS+IPAS+IPGP+IRMD+IRIX+IRDM+IRDMB+IRBT+IRWD+IRCP+SLQD+TLT+AIA+COMT+IXUS+FALN+IFEU+IFGL+IGF+GNMA+HYXE+JKI+ACWX+ACWI+AAXJ+EWZS+MCHI+ESGD+SCZ+ESGE+EEMA+EEML+EUFN+IEUS+ENZL+QAT+UAE+IBB+SOXX+EMIF+ICLN+WOOD+INDY+ISHG+IGOV+MPCT+ISLE+ISRL+ITI+ITRI+ITRN+ITUS+XXIA+IXYS+IZEA+JJSF+MAYS+JBHT+JCOM+JASO+JKHY+JACK+JXSB+JAGX+JAKK+JMBA+JRVR+JSML+JSMD+JASN+JASNW+JAZZ+JD+JSYN+JSYNR+JSYNU+JSYNW+JBLU+JTPY+JCTCF+JIVE+WYIG+WYIGU+WYIGW+JBSS+JOUT+JNP+JUNO+KTWO+KALU+KMDA+KNDI+KPTI+KBSF+KCAP+KRNY+KELYA+KELYB+KMPH+KFFB+KERX+KEQU+KTEC+KTCC+KFRC+KE+KBAL+KIN+KGJI+KINS+KONE+KIRK+KITE+KTOV+KTOVW+KLAC+KLRE+KLREU+KLREW+KLXI+KONA+KZ+KOPN+KRNT+KOSS+KWEB+KTOS+KLIC+KURA+KVHI+FSTR+LJPC+DRIO+DRIOW+LSBK+LSBG+LBAI+LKFN+LAKE+LRCX+LAMR+LANC+LCA+LCAHU+LCAHW+LNDC+LARK+LMRK+LMRKP+LE+LSTR+LNTH+LTRX+LSCC+LAWS+LAYN+LCNB+LBIX+LGCY+LGCYO+LGCYP+LTXB+DDBI+EDBI+LVHD+UDBI+LMAT+TREE+LXRX+LGIH+LHCG+LBRDA+LBRDK+LBTYA+LBTYB+LBTYK+LILA+LILAK+LVNTA+LVNTB+QVCA+QVCB+BATRA+BATRK+LMCA+LMCK+LSXMA+LSXMB+LSXMK+TAX+LTRPA+LTRPB+LPNT+LCUT+LFVN+LWAY+LGND+LTBR+LPTH+LIME+LLNW+LMNR+LINC+LECO+LIND+LINDW+LLTC+LBIO+LIOX+LPCN+LQDT+LFUS+LIVN+LOB+LIVE+LPSN+LKQ+LMFA+LMFAW+LMIA+LOGI+LOGM+EVAR+CNCR+LONE+LORL+LOXO+LPTN+LPLA+LRAD+LYTS+LULU+LITE+LMNX+LMOS+LUNA+MBTF+MIIIU+MCBC+MFNC+MTSI+MCUR+MGNX+MAGS+MGLN+MPET+MGIC+CALL+MNGA+MGYR+MHLD+MHLDO+MSFG+COOL+MMYT+MBUU+MLVF+MAMS+MANH+LOAN+MNTX+MTEX+MNKD+MANT+MARA+MCHX+MARPS+MRNS+MKTX+MKTO+MRLN+MAR+MBII+MRTN+MMLP+MRVL+MASI+MTCH+MATN+MTLS+MTRX+MAT+MATR+MATW+MFRM+MXIM+MXPT+MXWL+MZOR+MBFI+MBFIP+MCFT+MGRC+MDCA+MFIN+MFINL+MTBC+MTBCP+MNOV+MDSO+MDGS+MDVN+MDWD+MDVX+MDVXW+MEET+MEIP+MPEL+MLNX+MELR+MEMP+MRD+MENT+MTSL+MELI+MBWM+MERC+MBVT+MRCY+EBSB+VIVO+MMSI+MACK+MSLI+MRUS+MLAB+MESO+CASH+MBLX+MEOH+MFRI+MGCD+MGEE+MGPI+MCHP+MU+MICT+MICTW+MSCC+MSFT+MSTR+MVIS+MPB+MTP+MCEP+MBRG+MBCN+MSEX+MSBI+MOFG+MIME+MDXG+MNDO+MB+NERV+MRTX+MIRN+MSON+MIND+MINDP+MITK+MITL+MKSI+MMAC+MINI+MOBL+MOCO+MDSY+MLNK+MBRX+MNTA+MOMO+MCRI+MDLZ+MGI+MPWR+TYPE+MNRO+MRCC+MNST+MSDI+MSDIW+MHGC+MORN+MOSY+MPAA+MDM+MRVC+MSBF+MSG+MTSC+LABL+MFLX+MFSF+MYSZ+MYL+MYOK+MYOS+MYRG+MYGN+NBRV+NAKD+NNDM+NANO+NSTG+NH+NK+NSSC+NDAQ+NTRA+NATH+NAUH+NKSH+FIZZ+NCMI+NCOM+NGHC+NGHCN+NGHCO+NGHCP+NGHCZ+NHLD+NATI+NATL+NRCIA+NRCIB+NSEC+NWLI+NAII+NHTC+NATR+BABY+NAVI+NBTB+NCIT+NKTR+NEOG+NEO+NEON+NEOS+NEOT+NVCN+NEPT+UEPS+NETE+NTAP+NTES+NFLX+NTGR+NLST+NTCT+NTWK+CUR+NBIX+NDRM+NURO+NUROW+NYMT+NYMTO+NYMTP+NLNK+NWS+NWSA+NEWS+NEWT+NEWTL+NEWTZ+NXEO+NXEOU+NXEOW+NXST+NVET+NFEC+EGOV+NICE+NICK+NCBS+NIHD+NVLS+NMIH+NNBR+NDLS+NDSN+NSYS+NTK+NBN+NTIC+NTRS+NTRSP+NFBK+NRIM+NWBI+NWBO+NWBOW+NWPX+NCLH+NWFL+NVFY+NVMI+NVDQ+NOVT+MIFI+NVAX+NVCR+NVGN+NUAN+NMRX+NUTR+NTRI+NUVA+NVTR+QQQX+NVEE+NVEC+NVDA+NXPI+NXTM+NXTD+NXTDW+NYMX+OIIM+OVLY+OASM+OBCI+OPTT+ORIG+OSHC+OCFC+OCRX+OCLR+OFED+OCUL+OCLS+OCLSW+OMEX+ODP+OFS+OHAI+OVBC+OHRP+ODFL+OLBK+ONB+OPOF+OSBC+OSBCP+OLLI+ZEUS+OFLX+OMER+OMCL+ON+OTIV+ONS+ONSIW+ONSIZ+OGXI+OMED+ONTX+ONCS+OHGI+ONVI+OTEX+OPXA+OPXAW+OPGN+OPGNW+OPHT+OPK+OBAS+OCC+OPHC+OPB+ORMP+OSUR+ORBC+ORBK+ORLY+OREX+SEED+OACQ+OACQR+OACQU+OACQW+OESX+ORIT+ORRF+OFIX+OSIS+OSIR+OSN+OTEL+OTIC+OTTR+OUTR+OVAS+OSTK+OXBR+OXBRW+OXFD+OXLC+OXLCN+OXLCO+PFIN+PTSI+PCAR+PACE+PACEU+PACEW+PACB+PCBK+PEIX+PMBC+PPBI+PAAC+PAACR+PAACU+PAACW+PCRX+PACW+PTIE+PAAS+PNRA+PANL+PZZA+FRSH+PBNC+PRTK+PRXL+PCYG+PSTB+PKBK+PRKR+PKOH+PARN+PTNR+PBHC+PATK+PNBK+PATI+PEGI+PDCO+PTEN+PAVMU+PAYX+PCTY+PYDS+PYPL+PBBI+PCCC+PCMI+PCTI+PDCE+PDFS+PDLI+PDVW+SKIS+PGC+PEGA+PCO+PENN+PFLT+PNNT+PWOD+PTXP+PEBO+PEBK+PFBX+PFIS+PBCT+PUB+PRCP+PPHM+PPHMP+PRFT+PFMT+PERF+PERI+PESI+PTX+PERY+PGLC+PETS+PFSW+PGTI+PZRX+PHII+PHIIK+PAHC+PHMD+PLAB+PICO+PIRS+PPC+PME+PNK+PNFP+PPSI+PXLW+PLPM+PLXS+PLUG+PLBC+PSTI+PBSK+PNTR+PCOM+PLCM+POOL+POPE+PLKI+BPOP+BPOPM+BPOPN+PBIB+PTLA+PBPB+PCH+POWL+POWI+PSIX+PDBC+DWLV+DWIN+DWTR+IDLB+PRFZ+PAGG+PSAU+IPKW+LDRI+LALT+PNQI+QQQ+USLB+PSCD+PSCC+PSCE+PSCF+PSCH+PSCI+PSCT+PSCM+PSCU+PRAA+PRAH+PRAN+PFBC+PLPC+PFBI+PINC+LENS+PRGX+PSMT+PBMD+PNRG+PRMW+PRIM+PSET+PY+PRZM+PVTB+PVTBP+PDEX+IPDN+PFIE+PGNX+PRGS+DNAI+PFPT+PRPH+PRQR+BIB+UBIO+TQQQ+ZBIO+SQQQ+BIS+PSEC+PRTO+PTI+PRTA+PWX+PVBC+PROV+PBIP+PSDV+PMD+PTC+PTCT+PULM+PLSE+PCYO+PXS+QADA+QADB+QCRH+QGEN+QIWI+QLIK+QLGC+QLTI+QRVO+QCOM+QSII+QBAK+QLYS+QRHC+QUIK+QDEL+QPAC+QPACU+QPACW+QNST+QUMU+QUNR+QTNT+RRD+RADA+RDCM+ROIA+ROIAK+RSYS+RDUS+RDNT+RDWR+RMBS+RAND+RLOG+GOLD+RNDB+RPD+RPTP+RAVE+RAVN+ROLL+RICK+RCMT+RLOC+RDI+RDIB+RGSE+RELY+RNWK+RP+RETA+UTES+DAX+QYLD+RCON+REPH+RRGB+RRR+RDHL+REGN+RGNX+DFVL+DFVS+DGLD+DLBL+DLBS+DSLV+DTUL+DTUS+DTYL+DTYS+FLAT+GLDI+SLVO+STPP+TAPR+TVIX+TVIZ+UGLD+USLV+VIIX+VIIZ+XIV+ZIV+RGLS+REIS+RELV+RLYP+MARK+RNST+REGI+RNVA+RNVAZ+RCII+RTK+RGEN+RPRX+RBCAA+FRBK+REFR+RESN+REXI+RECN+ROIC+SALE+RTRX+RVNC+RVLT+RWLK+REXX+RFIL+RGCO+RIBT+RIBTW+RELL+RIGL+NAME+RNET+RTTR+RVSB+RLJE+RMGN+ROBO+FUEL+RMTI+RCKY+RMCF+RSTI+ROKA+ROSG+ROST+ROVI+RBPAA+TALL+RGLD+RPXC+RTIX+RBCN+RUSHA+RUSHB+RUTH+RXII+RYAAY+STBA+SANW+SBRA+SBRAP+SABR+SAEX+SAFT+SAGE+SGNT+SAIA+SAJA+SALM+SAL+SAFM+SASR+SGMO+SANM+GCVRZ+SPNS+SRPT+SBFG+SBFGP+SBAC+SCSC+SMIT+SCHN+SCHL+SCLN+SGMS+SQI+SNI+SCYX+SEAC+SBCF+STX+SHIP+SRSC+SHLD+SHLDW+SHOS+SPNE+SGEN+EYES+SCWX+SNFCA+SEIC+SLCT+SCSS+SIR+SELB+SIGI+LEDS+SMLR+SMTC+SENEA+SENEB+SNH+SNHNI+SNHNL+SNMX+SQNM+SQBG+MCRB+SREV+SFBS+SEV+SVBI+SGOC+SMED+SHSP+SHEN+SHLO+SHPG+SCVL+SHBI+SHOR+SFLY+SIFI+SIEB+SIEN+BSRR+SWIR+SIFY+SIGM+SGMA+SGNL+SBNY+SBNYW+SLGN+SILC+SGI+SLAB+SIMO+SPIL+SRAQ+SRAQU+SRAQW+SSRI+SAMG+SFNC+SLP+SINA+SBGI+SINO+SVA+SIRI+SITO+SZMK+SKUL+SKYS+SKLN+MOBI+SPU+SKYW+SWKS+ISM+JSM+OSM+SLM+SLMAP+SLMBP+SMT+SMBK+SWHC+SMSI+SMTX+LNCE+SCKT+SODA+SOHU+SLRC+SUNS+SCTY+SEDG+SONC+SOFO+SONS+SPHS+SORL+SRNE+SOHO+SOHOL+SOHOM+SFBC+SSB+SFST+SMBC+SONA+SBSI+OKSB+SP+SPAN+SBSA+SGRP+SPKE+ONCE+SPAR+SPTN+DWFI+SPPI+ANY+SPEX+SPI+SAVE+SPLK+SPOK+SPWH+SBPH+FUND+SFM+SPSC+SSNC+STAA+STAF+STMP+STLY+SPLS+SBLK+SBLKL+SBUX+STRZA+STRZB+STFC+STBZ+SNC+STDY+GASS+STLD+SMRT+SBOT+STEM+STML+STXS+SRCL+SRCLP+STRL+SHOO+SSFN+SYBT+BANX+SGBK+SSKN+SSYS+STRT+STRS+STRA+STRM+SBBP+STB+SCMP+SUMR+SMMF+SSBI+SMMT+SNBC+SNHY+SEMI+SNSS+STKL+SPWR+RUN+SBCP+SSH+SUNW+SMCI+SPCB+SCON+SGC+SUPN+SPRT+SGRY+SCAI+SRDX+SBBX+SIVB+SIVBO+SYKE+SYMC+SYNC+SYNL+SYNA+SNCR+SNDX+SGYP+SGYPU+SGYPW+ELOS+SNPS+SYNT+SYMX+SYUT+SYPR+SYRS+SYRX+TROW+TTOO+TAIT+TTWO+TLMR+TNDM+TLF+TNGO+TANH+TEDU+TASR+TATT+TAYD+TCPC+AMTD+TEAR+TECD+TCCO+TTGT+TGLS+TGEN+TNAV+TTEC+TLGT+TENX+GLBL+TERP+TRTL+TRTLU+TRTLW+TVIA+TBNK+TSRO+TESO+TSLA+TESS+TSRA+TTEK+TLOG+TTPH+TCBI+TCBIL+TCBIP+TCBIW+TXN+TXRH+TFSL+TGTX+ABCO+ANDE+TBBK+BONT+CG+CAKE+CHEF+TCFC+DSGX+DXYN+ENSG+XONE+FINL+FBMS+FLIC+GT+HABT+HCKT+HAIN+FITS+CUBA+INTG+JYNT+KEYW+KHC+OLD+MDCO+MIK+MIDD+NAVG+SLIM+STKS+ORG+PCLN+PRSC+BITE+RMR+SPNC+ULTI+YORW+NCTY+TBPH+TST+TCRD+THLD+TICC+TTS+TIL+TSBK+TIPT+TITN+TTNP+TIVO+TMUS+TMUSP+TBRA+TKAI+TNXP+TISA+TOPS+TORM+TRCH+TSEM+TWER+CLUB+TOWN+TPIC+TCON+TSCO+TWMC+TACT+TRNS+TBIO+TGA+TTHI+TA+TANNI+TANNL+TANNZ+TZOO+TRVN+TCBK+TRIL+TRS+TRMB+TRIB+TRIP+TSC+TBK+TRNC+TROV+TROVU+TROVW+TRUE+THST+TRUP+TRST+TRMK+TSRI+TTMI+TUBE+TCX+TUES+TOUR+HEAR+TUTI+TUTT+FOX+FOXA+TWIN+TRCB+USCR+PRTS+USEG+GROW+UBNT+UFPT+ULTA+UCTT+RARE+ULBI+ULTR+UTEK+UMBF+UMPQ+UNAM+UNIS+UBSH+UNB+UNXL+QURE+UBCP+UBOH+UBSI+UCBA+UCBI+UCFC+UDF+UBNK+UFCS+UIHC+UNFI+UBFO+USBI+USLM+UTHR+UG+UNTY+OLED+UEIC+UFPI+ULH+USAP+UVSP+UPLD+URRE+URBN+ECOL+USAT+USATP+USAK+USMD+UTMD+UTSI+VALX+VALU+VNDA+BBH+GNRX+PPH+VWOB+VNQI+VGIT+VCIT+VIGI+VYMI+VCLT+VGLT+VMBS+VNR+VNRAP+VNRBP+VNRCP+VONE+VONG+VONV+VTWO+VTWG+VTWV+VTHR+VCSH+VGSH+VTIP+BNDX+VXUS+VRNS+VDSI+VBLT+VASC+VBIV+WOOF+VECO+APPY+VRA+VCYT+VSTM+VCEL+VRNT+VRSN+VRSK+VBTX+VRML+VSAR+VTNR+VRTX+VRTB+VIA+VIAB+VSAT+VIAV+VICL+VICR+CIZ+CEZ+CID+CIL+CFO+CFA+CSF+CDC+CDL+CSB+CSA+VBND+VUSE+VIDI+VDTH+VRAY+VKTX+VKTXW+VBFC+VLGEA+VIP+VNOM+VIRC+VA+VIRT+VRTS+VRTU+VISN+VTGN+VTAE+VTL+VIVE+VVUS+VOD+VLTC+VOXX+VYGR+VSEC+VTVT+VUZI+VWR+WGBS+WBA+WAFD+WAFDW+WASH+WFBI+WSBF+WVE+WAYN+WSTG+WCFB+WDFC+FLAG+WEB+WBMD+WB+WEBK+WEN+WERN+WSBC+WTBA+WSTC+WMAR+WABC+WBB+WSTL+WDC+WFD+WLB+WPRT+WEYS+WHLR+WHLRP+WHLRW+WHF+WHFBL+WFM+WILN+WHLM+WVVI+WVVIP+WLDN+WLFC+WLTW+WIBC+WIN+WINT+WING+WINA+WINS+WTFC+WTFCM+WTFCW+AGND+AGZD+HYND+HYZD+CXSE+EMCG+EMCB+DGRE+DXGE+WETF+DXJS+JGBB+DXKW+GULF+CRDT+DGRW+DGRS+DXPS+UBND+WIX+WMIH+WBKC+WWD+WKHS+WRLD+JMU+WPCS+WPPGY+WMGI+WMGIZ+WSFS+WSFSL+WSCI+WVFC+WYNN+XBIT+XELB+XCRA+XNCR+XBKS+XENE+XGTI+XGTIW+XLNX+XOMA+XPLR+XCOM+XTLB+XNET+MESG+YHOO+YNDX+YIN+YOD+YCB+YRCW+YECO+YY+ZFGN+ZAGG+ZAIS+ZBRA+ZLTQ+ZHNE+Z+ZG+ZN+ZNWAA+ZION+ZIONW+ZIONZ+ZIOP+ZIXI+ZGNX+ZSAN+ZUMZ+ZYNE+ZNGA&f=aa2a5bb2b3b4b6cc1c3c6c8dd1d2ee1e7e8e9f6ghjkg1g3g4g5g6ii5j1j3j4j5j6k1'
In [42]:
pd.read_csv(url, header = 0)
In [45]:
symbol1 = '+'.join(df1.Symbol.values[:100]).replace(' ','')
url = 'http://finance.yahoo.com/d/quotes.csv?s=%s&f=aa2a5bb2b3b4b6cc1c3c6c8dd1d2ee1e7e8e9f6ghjkg1g3g4g5g6ii5j1j3j4j5j6k1' %(symbol1)
df_stock = pd.read_csv(url, header = None)
In [61]:
symbol1 = '+'.join(df1.Symbol.values[3000:4000]).replace(' ','')
url = 'http://finance.yahoo.com/d/quotes.csv?s=%s&f=aa2a5bb2b3b4b6cc1c3c6c8dd1d2ee1e7e8e9f6ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k3k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t6t7t8vv1v7ww1w4xy' %(symbol1)
df_stock = pd.read_csv(url, header = None)
In [66]:
name = [u' Ask ',
u' Average Daily Volume ',
u' Ask Size ',
u' Bid ',
u' Ask (Real-time) ',
u' Bid (Real-time) ',
u' Book Value ',
u' Bid Size ',
u' Change & Percent Change ',
u' Change ',
u' Commission ',
u' Change (Real-time) ',
u' After Hours Change (Real-time) ',
u' Dividend/Share ',
u' Last Trade Date ',
u' Trade Date ',
u' Earnings/Share ',
u' Error Indication (returned for symbol changed / invalid) ',
u' EPS Estimate Current Year ',
u' EPS Estimate Next Year ',
u' EPS Estimate Next Quarter ',
u' Float Shares ',
u' Day\u2019s Low ',
u' Day\u2019s High ',
u' 52-week Low ',
u' 52-week High ',
u' Holdings Gain Percent ',
u' Annualized Gain ',
u' Holdings Gain ',
u' Holdings Gain Percent (Real-time) ',
u' Holdings Gain (Real-time) ',
u' More Info ',
u' Order Book (Real-time) ',
u' Market Capitalization ',
u' Market Cap (Real-time) ',
u' EBITDA ',
u' Change From 52-week Low ',
u' Percent Change From 52-week Low ',
u' Last Trade (Real-time) With Time ',
u' Change Percent (Real-time) ',
u' Last Trade Size ',
u' Change From 52-week High ',
u' Percebt Change From 52-week High ',
u' Last Trade (With Time) ',
u' Last Trade (Price Only) ',
u' High Limit ',
u' Low Limit ',
u' Day\u2019s Range ',
u' Day\u2019s Range (Real-time) ',
u' 50-day Moving Average ',
u' 200-day Moving Average ',
u' Change From 200-day Moving Average ',
u' Percent Change From 200-day Moving Average ',
u' Change From 50-day Moving Average ',
u' Percent Change From 50-day Moving Average ',
u' Name ',
u' Notes ',
u' Open ',
u' Previous Close ',
u' Price Paid ',
u' Change in Percent ',
u' Price/Sales ',
u' Price/Book ',
u' Ex-Dividend Date ',
u' P/E Ratio ',
u' Dividend Pay Date ',
u' P/E Ratio (Real-time) ',
u' PEG Ratio ',
u' Price/EPS Estimate Current Year ',
u' Price/EPS Estimate Next Year ',
u' Symbol ',
u' Shares Owned ',
u' Short Ratio ',
u' Last Trade Time ',
u' Trade Links ',
u' Ticker Trend ',
u' 1 yr Target Price ',
u' Volume ',
u' Holdings Value ',
u' Holdings Value (Real-time) ',
u' 52-week Range ',
u' Day\u2019s Value Change ',
u' Day\u2019s Value Change (Real-time) ',
u' Stock Exchange ',
u' Dividend Yield ']
In [63]:
df_stock
Out[63]:
Ask
Average Daily Volume
Ask Size
Bid
Ask (Real-time)
Bid (Real-time)
Book Value
Bid Size
Change & Percent Change
Change
...
Ticker Trend
1 yr Target Price
Volume
Holdings Value
Holdings Value (Real-time)
52-week Range
Day’s Value Change
Day’s Value Change (Real-time)
Stock Exchange
Dividend Yield
0
5.51
27021.0
400.0
5.48
NaN
NaN
-6.740
800.0
-0.10 - -1.79%
-0.1000
...
NaN
19.25
19040
NaN
NaN
4.84 - 10.35
NaN
NaN
NGM
NaN
1
9.04
443033.0
3700.0
8.71
NaN
NaN
0.780
300.0
+0.88 - +10.92%
0.8800
...
NaN
10.00
2772675
NaN
NaN
3.61 - 9.30
NaN
NaN
NCM
NaN
2
30.26
888406.0
100.0
NaN
NaN
NaN
10.800
NaN
-0.36 - -1.18%
-0.3600
...
NaN
30.90
547780
NaN
NaN
21.56 - 30.72
NaN
NaN
NMS
NaN
3
0.98
323968.0
100.0
0.87
NaN
NaN
0.483
3500.0
+0.064 - +7.115%
0.0640
...
NaN
1.75
490454
NaN
NaN
0.460 - 3.470
NaN
NaN
NCM
NaN
4
81.61
5008880.0
200.0
81.22
NaN
NaN
28.550
200.0
+0.22 - +0.27%
0.2200
...
NaN
92.95
3352828
NaN
NaN
71.50 - 97.30
NaN
NaN
NMS
1.84
5
25.26
454356.0
400.0
24.78
NaN
NaN
21.750
400.0
-0.01 - -0.04%
-0.0100
...
NaN
24.60
243700
NaN
NaN
19.11 - 26.34
NaN
NaN
NMS
2.24
6
8.52
305.0
200.0
7.51
NaN
NaN
0.000
200.0
+0.00 - +0.00%
0.0000
...
NaN
NaN
27
NaN
NaN
4.19 - 9.05
NaN
NaN
NMS
NaN
7
NaN
49657.0
NaN
35.65
NaN
NaN
22.400
500.0
-0.04 - -0.10%
-0.0400
...
NaN
40.67
15554
NaN
NaN
34.59 - 41.35
NaN
NaN
NMS
3.66
8
22.99
42854.0
200.0
22.97
NaN
NaN
15.370
200.0
+0.00 - +0.00%
0.0000
...
NaN
24.00
25974
NaN
NaN
16.91 - 24.28
NaN
NaN
NCM
1.04
9
15.75
55900.0
10800.0
15.74
NaN
NaN
13.740
400.0
-0.01 - -0.06%
-0.0100
...
NaN
15.50
70610
NaN
NaN
12.38 - 15.95
NaN
NaN
NMS
2.03
10
NaN
72497.0
NaN
17.01
NaN
NaN
6.800
500.0
-1.50 - -7.11%
-1.5000
...
NaN
28.50
58396
NaN
NaN
8.95 - 27.18
NaN
NaN
NGM
NaN
11
13.45
1414.0
600.0
12.71
NaN
NaN
14.810
600.0
+0.00 - +0.00%
0.0000
...
NaN
NaN
203
NaN
NaN
11.69 - 13.52
NaN
NaN
NGM
2.76
12
20.00
5471.0
400.0
17.05
NaN
NaN
8.460
100.0
+0.19 - +1.04%
0.1900
...
NaN
19.00
6791
NaN
NaN
11.71 - 19.98
NaN
NaN
NGM
3.72
13
8.60
11822.0
2000.0
8.55
NaN
NaN
0.000
1000.0
+0.07 - +0.82%
0.0700
...
NaN
NaN
1001
NaN
NaN
7.12 - 9.00
NaN
NaN
NCM
2.34
14
NaN
103232.0
NaN
108.01
NaN
NaN
10.570
100.0
-2.23 - -1.88%
-2.2300
...
NaN
103.00
96553
NaN
NaN
80.86 - 125.00
NaN
NaN
NMS
1.42
15
33.66
1479.0
200.0
33.55
NaN
NaN
0.000
200.0
+0.00 - +0.00%
0.0000
...
NaN
NaN
0
NaN
NaN
26.73 - 33.70
NaN
NaN
NIM
NaN
16
18.54
439790.0
2500.0
18.53
NaN
NaN
4.690
3100.0
+0.04 - +0.22%
0.0400
...
NaN
24.44
238657
NaN
NaN
15.71 - 26.04
NaN
NaN
NMS
NaN
17
NaN
735689.0
NaN
34.44
NaN
NaN
5.970
100.0
+0.44 - +0.72%
0.4400
...
NaN
69.13
293522
NaN
NaN
37.57 - 67.55
NaN
NaN
NMS
NaN
18
32.59
1238610.0
400.0
32.16
NaN
NaN
3.020
100.0
-1.02 - -3.06%
-1.0200
...
NaN
25.32
1546294
NaN
NaN
8.78 - 34.21
NaN
NaN
NMS
NaN
19
NaN
3651.0
NaN
19.27
NaN
NaN
23.060
700.0
+0.00 - +0.00%
0.0000
...
NaN
NaN
0
NaN
NaN
18.05 - 21.00
NaN
NaN
NCM
0.79
20
10.20
3649740.0
3000.0
9.90
NaN
NaN
2.730
100.0
+0.12 - +1.20%
0.1200
...
NaN
11.62
2857608
NaN
NaN
8.43 - 11.38
NaN
NaN
NMS
2.40
21
27.31
884684.0
500.0
NaN
NaN
NaN
13.370
NaN
-0.88 - -3.48%
-0.8800
...
NaN
24.21
1505378
NaN
NaN
20.91 - 29.34
NaN
NaN
NMS
0.95
22
NaN
115084.0
NaN
30.92
NaN
NaN
30.310
200.0
-0.27 - -0.87%
-0.2700
...
NaN
33.00
56928
NaN
NaN
26.93 - 34.32
NaN
NaN
NMS
3.08
23
18.92
16522.0
200.0
18.90
NaN
NaN
9.740
1700.0
-0.09 - -0.47%
-0.0900
...
NaN
19.00
4482
NaN
NaN
16.04 - 21.09
NaN
NaN
NMS
3.58
24
22.30
238586.0
300.0
22.28
NaN
NaN
-6.500
1000.0
+0.16 - +0.72%
0.1600
...
NaN
24.13
81317
NaN
NaN
17.26 - 29.09
NaN
NaN
NMS
4.07
25
10.00
30316.0
100.0
8.00
NaN
NaN
11.700
100.0
-0.08 - -0.91%
-0.0800
...
NaN
11.00
14217
NaN
NaN
7.65 - 10.39
NaN
NaN
NMS
NaN
26
46.77
142837.0
400.0
46.73
NaN
NaN
21.780
2700.0
-1.25 - -2.61%
-1.2500
...
NaN
44.00
125579
NaN
NaN
40.52 - 52.18
NaN
NaN
NMS
3.25
27
19.63
3202.0
300.0
19.46
NaN
NaN
20.550
600.0
-0.0038 - -0.0195%
-0.0038
...
NaN
NaN
400
NaN
NaN
17.2000 - 20.2600
NaN
NaN
NCM
NaN
28
0.70
64760.0
2200.0
0.63
NaN
NaN
1.095
100.0
-0.0035 - -0.5000%
-0.0035
...
NaN
2.00
15201
NaN
NaN
0.6600 - 1.5100
NaN
NaN
NMS
NaN
29
52.40
6431520.0
300.0
51.83
NaN
NaN
41.240
300.0
-0.33 - -0.63%
-0.3300
...
NaN
58.94
2944319
NaN
NaN
34.99 - 88.46
NaN
NaN
NMS
3.82
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
104
5.80
140175.0
100.0
5.18
NaN
NaN
6.540
1000.0
+0.03 - +0.56%
0.0300
...
NaN
12.00
86873
NaN
NaN
5.02 - 9.87
NaN
NaN
NMS
NaN
105
24.78
510597.0
500.0
24.77
NaN
NaN
7.160
200.0
+0.00 - +0.00%
0.0000
...
NaN
25.00
38459
NaN
NaN
17.51 - 26.63
NaN
NaN
NGM
NaN
106
38.29
12497200.0
1500.0
38.17
NaN
NaN
29.910
100.0
-1.06 - -2.69%
-1.0600
...
NaN
41.95
41814378
NaN
NaN
26.15 - 39.42
NaN
NaN
NMS
NaN
107
21.98
2629570.0
100.0
20.80
NaN
NaN
7.240
5000.0
-0.21 - -0.99%
-0.2100
...
NaN
20.87
1656529
NaN
NaN
9.94 - 23.20
NaN
NaN
NMS
NaN
108
16.60
124923.0
100.0
13.25
NaN
NaN
1.570
500.0
-1.15 - -7.77%
-1.1500
...
NaN
17.97
65169
NaN
NaN
10.92 - 16.48
NaN
NaN
NMS
NaN
109
1.74
51436.0
300.0
1.31
NaN
NaN
0.630
500.0
+0.02 - +1.27%
0.0200
...
NaN
5.00
6003
NaN
NaN
1.22 - 2.49
NaN
NaN
NCM
NaN
110
37.42
43894.0
400.0
37.21
NaN
NaN
24.370
200.0
-0.03 - -0.08%
-0.0300
...
NaN
38.52
4525
NaN
NaN
27.44 - 38.51
NaN
NaN
NCM
1.28
111
10.30
607127.0
1600.0
9.55
NaN
NaN
-12.100
300.0
-0.16 - -1.61%
-0.1600
...
NaN
17.33
445467
NaN
NaN
6.25 - 21.37
NaN
NaN
NMS
0.00
112
7.00
30967.0
1000.0
2.50
NaN
NaN
6.080
1000.0
-0.12 - -4.08%
-0.1200
...
NaN
NaN
31199
NaN
NaN
1.46 - 6.05
NaN
NaN
NCM
NaN
113
40.49
1148970.0
200.0
40.10
NaN
NaN
9.520
700.0
+0.75 - +1.90%
0.7500
...
NaN
51.75
1068218
NaN
NaN
31.07 - 65.53
NaN
NaN
NMS
NaN
114
3.17
682875.0
3000.0
2.91
NaN
NaN
5.660
1000.0
+0.17 - +5.76%
0.1700
...
NaN
4.50
1000108
NaN
NaN
2.90 - 47.98
NaN
NaN
NMS
NaN
115
6.67
940395.0
2700.0
6.00
NaN
NaN
4.580
1000.0
-0.33 - -4.80%
-0.3300
...
NaN
10.70
985293
NaN
NaN
4.71 - 12.74
NaN
NaN
NMS
NaN
116
3.50
524981.0
300.0
3.17
NaN
NaN
3.070
100.0
-0.39 - -10.48%
-0.3900
...
NaN
NaN
446882
NaN
NaN
1.32 - 12.73
NaN
NaN
NCM
NaN
117
67.95
832503.0
200.0
51.25
NaN
NaN
16.810
100.0
+0.47 - +0.92%
0.4700
...
NaN
73.57
487836
NaN
NaN
46.13 - 110.46
NaN
NaN
NMS
NaN
118
36.19
715348.0
100.0
23.12
NaN
NaN
2.930
200.0
+0.38 - +1.17%
0.3800
...
NaN
37.22
733911
NaN
NaN
18.41 - 38.49
NaN
NaN
NMS
NaN
119
1.17
49816.0
8800.0
0.82
NaN
NaN
0.970
100.0
+0.04 - +3.54%
0.0400
...
NaN
3.00
15090
NaN
NaN
0.91 - 2.05
NaN
NaN
NCM
NaN
120
37.70
1613530.0
500.0
37.10
NaN
NaN
14.900
100.0
-0.39 - -1.03%
-0.3900
...
NaN
33.00
991587
NaN
NaN
15.36 - 38.75
NaN
NaN
NMS
NaN
121
38.84
826711.0
1000.0
25.11
NaN
NaN
14.900
100.0
-0.41 - -1.06%
-0.4100
...
NaN
32.07
205702
NaN
NaN
16.45 - 39.11
NaN
NaN
NMS
NaN
122
1.46
50316.0
4000.0
NaN
NaN
NaN
0.210
NaN
-0.04 - -2.78%
-0.0400
...
NaN
NaN
59248
NaN
NaN
1.32 - 2.09
NaN
NaN
NGM
NaN
123
199999.00
NaN
200.0
0.01
NaN
NaN
0.000
100.0
+0.00 - +0.00%
0.0000
...
NaN
NaN
0
NaN
NaN
NaN
NaN
NaN
NGM
NaN
124
NaN
3372920.0
NaN
4.00
NaN
NaN
33.230
100.0
-0.01 - -0.04%
-0.0100
...
NaN
30.08
2371492
NaN
NaN
19.65 - 31.64
NaN
NaN
NMS
0.91
125
2.64
16703.0
100.0
2.50
NaN
NaN
0.000
1000.0
+0.0034 - +0.1344%
0.0034
...
NaN
NaN
4551
NaN
NaN
1.2700 - 5.2100
NaN
NaN
NMS
NaN
126
2.23
NaN
1000.0
0.77
NaN
NaN
0.000
1000.0
+0.00 - +0.00%
0.0000
...
NaN
NaN
0
NaN
NaN
NaN
NaN
NaN
NMS
NaN
127
4.78
2590220.0
1700.0
4.60
NaN
NaN
0.600
1000.0
+0.17 - +3.79%
0.1700
...
NaN
13.00
1567162
NaN
NaN
4.45 - 14.93
NaN
NaN
NCM
NaN
128
4.28
206192.0
1000.0
3.89
NaN
NaN
0.970
600.0
+0.05 - +1.20%
0.0500
...
NaN
5.42
97390
NaN
NaN
3.23 - 5.78
NaN
NaN
NMS
0.00
129
12.50
143943.0
100.0
7.00
NaN
NaN
7.020
500.0
+0.06 - +0.70%
0.0600
...
NaN
18.25
266002
NaN
NaN
7.33 - 21.03
NaN
NaN
NGM
NaN
130
1.74
21902.0
100.0
NaN
NaN
NaN
1.570
NaN
+0.35 - +25.00%
0.3500
...
NaN
7.00
134767
NaN
NaN
1.03 - 9.20
NaN
NaN
NCM
NaN
131
25.06
488436.0
400.0
NaN
NaN
NaN
11.420
NaN
+0.17 - +1.05%
0.1700
...
NaN
14.30
356155
NaN
NaN
11.53 - 26.73
NaN
NaN
NMS
NaN
132
8.67
184913.0
4500.0
7.00
NaN
NaN
3.930
2000.0
-0.14 - -1.91%
-0.1400
...
NaN
32.60
67617
NaN
NaN
4.64 - 43.00
NaN
NaN
NGM
NaN
133
2.86
12078000.0
500.0
2.74
NaN
NaN
1.920
300.0
-0.03 - -1.05%
-0.0300
...
NaN
2.91
13730296
NaN
NaN
1.78 - 2.89
NaN
NaN
NMS
NaN
134 rows × 85 columns
In [60]:
3163/1000
Out[60]:
3
In [122]:
stock_list = []
for i in xrange(len(symbols)/1000+1):
symbol_n = '+'.join(symbols[i*1000:(i+1)*1000]).replace(' ','')
url = 'http://finance.yahoo.com/d/quotes.csv?s=%s&f=aa2a5bb2b3b4b6cc1c3c6c8dd1d2ee1e7e8e9f6ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k3k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t6t7t8vv1v7ww1w4xy' %(symbol_n)
df_stock = pd.read_csv(url, header = None)
df_stock.columns = new_name
stock_list.append(df_stock)
---------------------------------------------------------------------------
URLError Traceback (most recent call last)
<ipython-input-122-fbb4916602d0> in <module>()
3 symbol_n = '+'.join(symbols[i*1000:(i+1)*1000]).replace(' ','')
4 url = 'http://finance.yahoo.com/d/quotes.csv?s=%s&f=aa2a5bb2b3b4b6cc1c3c6c8dd1d2ee1e7e8e9f6ghjkg1g3g4g5g6ii5j1j3j4j5j6k1k2k3k4k5ll1l2l3mm2m3m4m5m6m7m8nn4opp1p2p5p6qrr1r2r5r6r7ss1s7t1t6t7t8vv1v7ww1w4xy' %(symbol_n)
----> 5 df_stock = pd.read_csv(url, header = None)
6 df_stock.columns = new_name
7 stock_list.append(df_stock)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/io/parsers.pyc in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skip_footer, doublequote, delim_whitespace, as_recarray, compact_ints, use_unsigned, low_memory, buffer_lines, memory_map, float_precision)
527 skip_blank_lines=skip_blank_lines)
528
--> 529 return _read(filepath_or_buffer, kwds)
530
531 parser_f.__name__ = name
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/io/parsers.pyc in _read(filepath_or_buffer, kwds)
279 filepath_or_buffer, _, compression = get_filepath_or_buffer(
280 filepath_or_buffer, encoding,
--> 281 compression=kwds.get('compression', None))
282 kwds['compression'] = (inferred_compression if compression == 'infer'
283 else compression)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/io/common.pyc in get_filepath_or_buffer(filepath_or_buffer, encoding, compression)
275
276 if _is_url(filepath_or_buffer):
--> 277 req = _urlopen(str(filepath_or_buffer))
278 if compression == 'infer':
279 content_encoding = req.headers.get('Content-Encoding', None)
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in urlopen(url, data, timeout, cafile, capath, cadefault, context)
152 else:
153 opener = _opener
--> 154 return opener.open(url, data, timeout)
155
156 def install_opener(opener):
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in open(self, fullurl, data, timeout)
429 req = meth(req)
430
--> 431 response = self._open(req, data)
432
433 # post-process response
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in _open(self, req, data)
447 protocol = req.get_type()
448 result = self._call_chain(self.handle_open, protocol, protocol +
--> 449 '_open', req)
450 if result:
451 return result
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in _call_chain(self, chain, kind, meth_name, *args)
407 func = getattr(handler, meth_name)
408
--> 409 result = func(*args)
410 if result is not None:
411 return result
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in http_open(self, req)
1225
1226 def http_open(self, req):
-> 1227 return self.do_open(httplib.HTTPConnection, req)
1228
1229 http_request = AbstractHTTPHandler.do_request_
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in do_open(self, http_class, req, **http_conn_args)
1195 except socket.error, err: # XXX what error?
1196 h.close()
-> 1197 raise URLError(err)
1198 else:
1199 try:
URLError: <urlopen error [Errno 8] nodename nor servname provided, or not known>
In [125]:
df_stock = pd.read_csv(url, header = None)
---------------------------------------------------------------------------
URLError Traceback (most recent call last)
<ipython-input-125-bafae2e41d84> in <module>()
----> 1 df_stock = pd.read_csv(url, header = None)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/io/parsers.pyc in parser_f(filepath_or_buffer, sep, delimiter, header, names, index_col, usecols, squeeze, prefix, mangle_dupe_cols, dtype, engine, converters, true_values, false_values, skipinitialspace, skiprows, skipfooter, nrows, na_values, keep_default_na, na_filter, verbose, skip_blank_lines, parse_dates, infer_datetime_format, keep_date_col, date_parser, dayfirst, iterator, chunksize, compression, thousands, decimal, lineterminator, quotechar, quoting, escapechar, comment, encoding, dialect, tupleize_cols, error_bad_lines, warn_bad_lines, skip_footer, doublequote, delim_whitespace, as_recarray, compact_ints, use_unsigned, low_memory, buffer_lines, memory_map, float_precision)
527 skip_blank_lines=skip_blank_lines)
528
--> 529 return _read(filepath_or_buffer, kwds)
530
531 parser_f.__name__ = name
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/io/parsers.pyc in _read(filepath_or_buffer, kwds)
279 filepath_or_buffer, _, compression = get_filepath_or_buffer(
280 filepath_or_buffer, encoding,
--> 281 compression=kwds.get('compression', None))
282 kwds['compression'] = (inferred_compression if compression == 'infer'
283 else compression)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/io/common.pyc in get_filepath_or_buffer(filepath_or_buffer, encoding, compression)
275
276 if _is_url(filepath_or_buffer):
--> 277 req = _urlopen(str(filepath_or_buffer))
278 if compression == 'infer':
279 content_encoding = req.headers.get('Content-Encoding', None)
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in urlopen(url, data, timeout, cafile, capath, cadefault, context)
152 else:
153 opener = _opener
--> 154 return opener.open(url, data, timeout)
155
156 def install_opener(opener):
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in open(self, fullurl, data, timeout)
429 req = meth(req)
430
--> 431 response = self._open(req, data)
432
433 # post-process response
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in _open(self, req, data)
447 protocol = req.get_type()
448 result = self._call_chain(self.handle_open, protocol, protocol +
--> 449 '_open', req)
450 if result:
451 return result
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in _call_chain(self, chain, kind, meth_name, *args)
407 func = getattr(handler, meth_name)
408
--> 409 result = func(*args)
410 if result is not None:
411 return result
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in http_open(self, req)
1225
1226 def http_open(self, req):
-> 1227 return self.do_open(httplib.HTTPConnection, req)
1228
1229 http_request = AbstractHTTPHandler.do_request_
/Users/zoesh/anaconda/lib/python2.7/urllib2.pyc in do_open(self, http_class, req, **http_conn_args)
1195 except socket.error, err: # XXX what error?
1196 h.close()
-> 1197 raise URLError(err)
1198 else:
1199 try:
URLError: <urlopen error [Errno 8] nodename nor servname provided, or not known>
In [84]:
df_stocks = pd.concat(stock_list, ignore_index=True)
In [108]:
df_stock.to_csv('test')
In [87]:
import datetime
In [129]:
new_name = []
for n in name:
n = n.encode('ascii', 'ignore').strip()
new_name.append(n)
In [120]:
df_stock.columns = new_name
print new_name
csv_name = date + '_all_stocks_info'
df_stocks.to_csv(csv_name)
[' Ask ', ' Average Daily Volume ', ' Ask Size ', ' Bid ', ' Ask (Real-time) ', ' Bid (Real-time) ', ' Book Value ', ' Bid Size ', ' Change & Percent Change ', ' Change ', ' Commission ', ' Change (Real-time) ', ' After Hours Change (Real-time) ', ' Dividend/Share ', ' Last Trade Date ', ' Trade Date ', ' Earnings/Share ', ' Error Indication (returned for symbol changed / invalid) ', ' EPS Estimate Current Year ', ' EPS Estimate Next Year ', ' EPS Estimate Next Quarter ', ' Float Shares ', ' Days Low ', ' Days High ', ' 52-week Low ', ' 52-week High ', ' Holdings Gain Percent ', ' Annualized Gain ', ' Holdings Gain ', ' Holdings Gain Percent (Real-time) ', ' Holdings Gain (Real-time) ', ' More Info ', ' Order Book (Real-time) ', ' Market Capitalization ', ' Market Cap (Real-time) ', ' EBITDA ', ' Change From 52-week Low ', ' Percent Change From 52-week Low ', ' Last Trade (Real-time) With Time ', ' Change Percent (Real-time) ', ' Last Trade Size ', ' Change From 52-week High ', ' Percebt Change From 52-week High ', ' Last Trade (With Time) ', ' Last Trade (Price Only) ', ' High Limit ', ' Low Limit ', ' Days Range ', ' Days Range (Real-time) ', ' 50-day Moving Average ', ' 200-day Moving Average ', ' Change From 200-day Moving Average ', ' Percent Change From 200-day Moving Average ', ' Change From 50-day Moving Average ', ' Percent Change From 50-day Moving Average ', ' Name ', ' Notes ', ' Open ', ' Previous Close ', ' Price Paid ', ' Change in Percent ', ' Price/Sales ', ' Price/Book ', ' Ex-Dividend Date ', ' P/E Ratio ', ' Dividend Pay Date ', ' P/E Ratio (Real-time) ', ' PEG Ratio ', ' Price/EPS Estimate Current Year ', ' Price/EPS Estimate Next Year ', ' Symbol ', ' Shares Owned ', ' Short Ratio ', ' Last Trade Time ', ' Trade Links ', ' Ticker Trend ', ' 1 yr Target Price ', ' Volume ', ' Holdings Value ', ' Holdings Value (Real-time) ', ' 52-week Range ', ' Days Value Change ', ' Days Value Change (Real-time) ', ' Stock Exchange ', ' Dividend Yield ']
---------------------------------------------------------------------------
UnicodeEncodeError Traceback (most recent call last)
<ipython-input-120-4c168cad9761> in <module>()
2 print new_name
3 csv_name = date + '_all_stocks_info'
----> 4 df_stocks.to_csv(csv_name)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/frame.pyc in to_csv(self, path_or_buf, sep, na_rep, float_format, columns, header, index, index_label, mode, encoding, compression, quoting, quotechar, line_terminator, chunksize, tupleize_cols, date_format, doublequote, escapechar, decimal, **kwds)
1341 doublequote=doublequote,
1342 escapechar=escapechar, decimal=decimal)
-> 1343 formatter.save()
1344
1345 if path_or_buf is None:
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in save(self)
1548
1549 else:
-> 1550 self._save()
1551
1552 finally:
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in _save(self)
1635 def _save(self):
1636
-> 1637 self._save_header()
1638
1639 nrows = len(self.data_index)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in _save_header(self)
1631
1632 # write out the index label line
-> 1633 writer.writerow(encoded_labels)
1634
1635 def _save(self):
UnicodeEncodeError: 'ascii' codec can't encode character u'\u2019' in position 4: ordinal not in range(128)
In [131]:
df_stock.columns = new_name
In [133]:
df_stock.columns
Out[133]:
Index([u'Ask', u'Average Daily Volume', u'Ask Size', u'Bid',
u'Ask (Real-time)', u'Bid (Real-time)', u'Book Value', u'Bid Size',
u'Change & Percent Change', u'Change', u'Commission',
u'Change (Real-time)', u'After Hours Change (Real-time)',
u'Dividend/Share', u'Last Trade Date', u'Trade Date', u'Earnings/Share',
u'Error Indication (returned for symbol changed / invalid)',
u'EPS Estimate Current Year', u'EPS Estimate Next Year',
u'EPS Estimate Next Quarter', u'Float Shares', u'Days Low',
u'Days High', u'52-week Low', u'52-week High', u'Holdings Gain Percent',
u'Annualized Gain', u'Holdings Gain',
u'Holdings Gain Percent (Real-time)', u'Holdings Gain (Real-time)',
u'More Info', u'Order Book (Real-time)', u'Market Capitalization',
u'Market Cap (Real-time)', u'EBITDA', u'Change From 52-week Low',
u'Percent Change From 52-week Low', u'Last Trade (Real-time) With Time',
u'Change Percent (Real-time)', u'Last Trade Size',
u'Change From 52-week High', u'Percebt Change From 52-week High',
u'Last Trade (With Time)', u'Last Trade (Price Only)', u'High Limit',
u'Low Limit', u'Days Range', u'Days Range (Real-time)',
u'50-day Moving Average', u'200-day Moving Average',
u'Change From 200-day Moving Average',
u'Percent Change From 200-day Moving Average',
u'Change From 50-day Moving Average',
u'Percent Change From 50-day Moving Average', u'Name', u'Notes',
u'Open', u'Previous Close', u'Price Paid', u'Change in Percent',
u'Price/Sales', u'Price/Book', u'Ex-Dividend Date', u'P/E Ratio',
u'Dividend Pay Date', u'P/E Ratio (Real-time)', u'PEG Ratio',
u'Price/EPS Estimate Current Year', u'Price/EPS Estimate Next Year',
u'Symbol', u'Shares Owned', u'Short Ratio', u'Last Trade Time',
u'Trade Links', u'Ticker Trend', u'1 yr Target Price', u'Volume',
u'Holdings Value', u'Holdings Value (Real-time)', u'52-week Range',
u'Days Value Change', u'Days Value Change (Real-time)',
u'Stock Exchange', u'Dividend Yield'],
dtype='object')
In [97]:
date = str(datetime.datetime.today().date())
csv_name = date + '_all_stocks_info'
df_stocks.to_csv(csv_name)
---------------------------------------------------------------------------
UnicodeEncodeError Traceback (most recent call last)
<ipython-input-97-0c5a189d8a1f> in <module>()
1 date = str(datetime.datetime.today().date())
2 csv_name = date + '_all_stocks_info'
----> 3 df_stocks.to_csv(csv_name)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/frame.pyc in to_csv(self, path_or_buf, sep, na_rep, float_format, columns, header, index, index_label, mode, encoding, compression, quoting, quotechar, line_terminator, chunksize, tupleize_cols, date_format, doublequote, escapechar, decimal, **kwds)
1341 doublequote=doublequote,
1342 escapechar=escapechar, decimal=decimal)
-> 1343 formatter.save()
1344
1345 if path_or_buf is None:
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in save(self)
1548
1549 else:
-> 1550 self._save()
1551
1552 finally:
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in _save(self)
1635 def _save(self):
1636
-> 1637 self._save_header()
1638
1639 nrows = len(self.data_index)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in _save_header(self)
1631
1632 # write out the index label line
-> 1633 writer.writerow(encoded_labels)
1634
1635 def _save(self):
UnicodeEncodeError: 'ascii' codec can't encode character u'\u2019' in position 4: ordinal not in range(128)
In [102]:
df_stocks.to_csv(csv_name)
---------------------------------------------------------------------------
UnicodeEncodeError Traceback (most recent call last)
<ipython-input-102-1074583b1451> in <module>()
----> 1 df_stocks.to_csv(csv_name)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/frame.pyc in to_csv(self, path_or_buf, sep, na_rep, float_format, columns, header, index, index_label, mode, encoding, compression, quoting, quotechar, line_terminator, chunksize, tupleize_cols, date_format, doublequote, escapechar, decimal, **kwds)
1341 doublequote=doublequote,
1342 escapechar=escapechar, decimal=decimal)
-> 1343 formatter.save()
1344
1345 if path_or_buf is None:
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in save(self)
1548
1549 else:
-> 1550 self._save()
1551
1552 finally:
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in _save(self)
1635 def _save(self):
1636
-> 1637 self._save_header()
1638
1639 nrows = len(self.data_index)
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/format.pyc in _save_header(self)
1631
1632 # write out the index label line
-> 1633 writer.writerow(encoded_labels)
1634
1635 def _save(self):
UnicodeEncodeError: 'ascii' codec can't encode character u'\u2019' in position 4: ordinal not in range(128)
In [103]:
df_stocks.encode('ascii', 'ignore')
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
<ipython-input-103-ec894c35dd89> in <module>()
----> 1 df_stocks.encode('ascii', 'ignore')
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/core/generic.pyc in __getattr__(self, name)
2667 if name in self._info_axis:
2668 return self[name]
-> 2669 return object.__getattribute__(self, name)
2670
2671 def __setattr__(self, name, value):
AttributeError: 'DataFrame' object has no attribute 'encode'
In [124]:
df_stocks.to_pickle(csv_name)
In [130]:
new_name
Out[130]:
['Ask',
'Average Daily Volume',
'Ask Size',
'Bid',
'Ask (Real-time)',
'Bid (Real-time)',
'Book Value',
'Bid Size',
'Change & Percent Change',
'Change',
'Commission',
'Change (Real-time)',
'After Hours Change (Real-time)',
'Dividend/Share',
'Last Trade Date',
'Trade Date',
'Earnings/Share',
'Error Indication (returned for symbol changed / invalid)',
'EPS Estimate Current Year',
'EPS Estimate Next Year',
'EPS Estimate Next Quarter',
'Float Shares',
'Days Low',
'Days High',
'52-week Low',
'52-week High',
'Holdings Gain Percent',
'Annualized Gain',
'Holdings Gain',
'Holdings Gain Percent (Real-time)',
'Holdings Gain (Real-time)',
'More Info',
'Order Book (Real-time)',
'Market Capitalization',
'Market Cap (Real-time)',
'EBITDA',
'Change From 52-week Low',
'Percent Change From 52-week Low',
'Last Trade (Real-time) With Time',
'Change Percent (Real-time)',
'Last Trade Size',
'Change From 52-week High',
'Percebt Change From 52-week High',
'Last Trade (With Time)',
'Last Trade (Price Only)',
'High Limit',
'Low Limit',
'Days Range',
'Days Range (Real-time)',
'50-day Moving Average',
'200-day Moving Average',
'Change From 200-day Moving Average',
'Percent Change From 200-day Moving Average',
'Change From 50-day Moving Average',
'Percent Change From 50-day Moving Average',
'Name',
'Notes',
'Open',
'Previous Close',
'Price Paid',
'Change in Percent',
'Price/Sales',
'Price/Book',
'Ex-Dividend Date',
'P/E Ratio',
'Dividend Pay Date',
'P/E Ratio (Real-time)',
'PEG Ratio',
'Price/EPS Estimate Current Year',
'Price/EPS Estimate Next Year',
'Symbol',
'Shares Owned',
'Short Ratio',
'Last Trade Time',
'Trade Links',
'Ticker Trend',
'1 yr Target Price',
'Volume',
'Holdings Value',
'Holdings Value (Real-time)',
'52-week Range',
'Days Value Change',
'Days Value Change (Real-time)',
'Stock Exchange',
'Dividend Yield']
In [134]:
import pandas.io.data as web
/Users/zoesh/anaconda/lib/python2.7/site-packages/pandas/io/data.py:35: FutureWarning:
The pandas.io.data module is moved to a separate package (pandas-datareader) and will be removed from pandas in a future version.
After installing the pandas-datareader package (https://github.com/pydata/pandas-datareader), you can change the import ``from pandas.io import data, wb`` to ``from pandas_datareader import data, wb``.
FutureWarning)
In [135]:
symbol = 'ABEO'
In [137]:
from datetime import date, datetime, timedelta
from collections import defaultdict
start = datetime(2010, 1, 1)
end = date.today()
web.DataReader(symbol, 'yahoo', start, end)
Out[137]:
Open
High
Low
Close
Volume
Adj Close
Date
2010-01-04
3.15
3.29
3.10
3.20
400
159.999996
2010-01-05
3.20
3.25
3.10
3.25
400
162.499996
2010-01-06
3.15
3.18
3.10
3.18
700
158.999996
2010-01-07
3.12
3.25
3.05
3.25
800
162.499996
2010-01-08
3.28
3.29
3.22
3.29
600
164.499996
2010-01-11
3.29
3.29
3.00
3.11
400
155.499981
2010-01-12
3.15
3.29
3.10
3.29
400
164.499996
2010-01-13
3.26
3.30
3.15
3.25
100
162.499996
2010-01-14
3.01
3.27
3.01
3.25
200
162.499996
2010-01-15
3.25
3.27
3.15
3.27
200
163.499996
2010-01-19
3.27
3.27
3.05
3.10
800
154.999997
2010-01-20
3.05
3.10
2.96
3.00
1800
149.999997
2010-01-21
3.05
3.05
2.90
2.95
800
147.499997
2010-01-22
2.99
3.00
2.80
2.84
3300
141.999997
2010-01-25
2.89
2.89
2.70
2.80
600
139.999997
2010-01-26
2.70
2.75
2.66
2.75
1200
137.499997
2010-01-27
2.70
2.78
2.70
2.75
1000
137.499997
2010-01-28
2.78
2.85
2.60
2.85
300
142.499997
2010-01-29
2.80
2.80
2.70
2.79
100
139.499997
2010-02-01
2.80
2.80
2.75
2.79
200
139.499997
2010-02-02
2.75
2.81
2.60
2.75
500
137.499997
2010-02-03
2.70
2.79
2.65
2.79
400
139.499997
2010-02-04
2.80
2.80
2.65
2.78
200
138.999997
2010-02-05
2.70
2.75
2.65
2.75
400
137.499997
2010-02-08
2.77
2.85
2.75
2.75
400
137.499997
2010-02-09
2.75
2.75
2.70
2.75
300
137.499997
2010-02-10
2.70
2.71
2.66
2.70
500
134.999997
2010-02-11
2.70
2.75
2.66
2.75
400
137.499997
2010-02-12
2.70
2.75
2.70
2.75
400
137.499997
2010-02-16
2.70
2.75
2.50
2.75
700
137.499997
...
...
...
...
...
...
...
2016-06-14
2.96
3.10
2.88
2.96
69600
2.960000
2016-06-15
2.95
3.05
2.89
2.90
97900
2.900000
2016-06-16
2.87
2.88
2.77
2.85
79100
2.850000
2016-06-17
2.88
2.95
2.83
2.89
73100
2.890000
2016-06-20
2.92
2.94
2.78
2.80
64000
2.800000
2016-06-21
2.78
2.86
2.58
2.76
69100
2.760000
2016-06-22
2.74
2.78
2.50
2.68
40800
2.680000
2016-06-23
2.76
2.76
2.60
2.71
70500
2.710000
2016-06-24
2.57
2.67
2.46
2.56
908200
2.560000
2016-06-27
2.47
2.65
2.34
2.44
62300
2.440000
2016-06-28
2.44
2.60
2.36
2.43
46800
2.430000
2016-06-29
2.43
2.44
2.33
2.37
51900
2.370000
2016-06-30
2.39
2.42
2.32
2.36
66500
2.360000
2016-07-01
2.36
2.45
2.36
2.43
49500
2.430000
2016-07-05
2.43
2.45
2.31
2.42
40400
2.420000
2016-07-06
2.42
2.44
2.32
2.34
23900
2.340000
2016-07-07
2.34
2.44
2.32
2.32
19900
2.320000
2016-07-08
2.35
2.40
2.35
2.37
33500
2.370000
2016-07-11
2.39
2.45
2.36
2.37
52400
2.370000
2016-07-12
2.37
2.49
2.37
2.44
78100
2.440000
2016-07-13
2.45
2.50
2.35
2.43
58200
2.430000
2016-07-14
2.44
2.44
2.31
2.37
116400
2.370000
2016-07-15
2.33
2.45
2.33
2.42
52900
2.420000
2016-07-18
2.45
2.48
2.36
2.41
50000
2.410000
2016-07-19
2.38
2.56
2.38
2.41
184500
2.410000
2016-07-20
2.44
2.51
2.41
2.48
47900
2.480000
2016-07-21
2.51
2.61
2.45
2.48
42100
2.480000
2016-07-22
2.47
2.56
2.46
2.50
68000
2.500000
2016-07-25
2.52
2.75
2.47
2.55
54500
2.550000
2016-07-26
2.55
2.60
2.53
2.54
49100
2.540000
1652 rows × 6 columns
In [141]:
td_seq = defaultdict()
alert_list = defaultdict()
c = web.DataReader(symbol, 'yahoo', start, end)
setup = c.iloc[-1]['Close'] - c.iloc[-1-4]['Close']
buy_setup = True
buy_counter = 1
sell_counter = -1
if setup < 0:
'''buy setup'''
buy_setup = True
elif setup > 0:
'''sell setup'''
buy_setup = False
for i in xrange(1,(len(c))):
if buy_setup:
buy = c.iloc[-1-i]['Close'] - c.iloc[-5-i]['Close']
# buy = c.ix[str(end-timedelta(days = i))]['Close'] - c.ix[str(end-timedelta(days = 4 + i))]['Close']
if buy < 0:
buy_counter += 1
if buy_counter > 9:
buy_counter = 1
print symbol, ' fail to reverse to buy'
alert_list[symbol] = buy_counter
td_seq[symbol] = buy_counter
if buy_counter == 9:
if ((c.iloc[-1]['Low'] <= c.iloc[-3]['Low']) and (c.iloc[-1]['Low'] <= c.iloc[-4]['Low'])) or \
((c.iloc[-2]['Low'] <= c.iloc[-3]['Low']) and (c.iloc[-2]['Low'] <= c.iloc[-4]['Low'])):
alert_list[symbol] = 'perfect buy'
else:
alert_list[symbol] = buy_counter
td_seq[symbol] = buy_counter
else:
if (alert_list[symbol] == 'perfect buy') and (buy_counter == 9):
print symbol, 'perfect buy'
elif buy_counter == 8:
if ((c.iloc[-2]['Low'] <= c.iloc[-3]['Low']) and (c.iloc[-2]['Low'] <= c.iloc[-4]['Low'])):
alert_list[symbol] = 'prepare perfect buy'
print symbol, 'prepare perfect buy'
td_seq[symbol] = buy_counter
break
else:
sell = c.iloc[-1-i]['Close'] - c.iloc[-5-i]['Close']
# sell = c.ix[str(end-timedelta(days = i))]['Close'] - c.ix[str(end-timedelta(days = 4 + i))]['Close']
if sell > 0:
sell_counter -= 1
if sell_counter < -9:
sell_counter = -1
print symbol, ' fail to reverse to sell'
alert_list[symbol] = sell_counter
td_seq[symbol] = sell_counter
if sell_counter == -9:
if ((c.iloc[-1]['High'] > c.iloc[-3]['High']) and (c.iloc[-1]['High'] > c.iloc[-4]['High'])) or \
((c.iloc[-2]['High'] > c.iloc[-3]['High']) and (c.iloc[-2]['High'] > c.iloc[-4]['High'])):
alert_list[symbol] = 'perfect sell'
alert_list[symbol] = sell_counter
td_seq[symbol] = sell_counter
else:
if (alert_list[symbol] == 'perfect sell') and (sell_counter == -9):
print symbol, 'perfect sell'
elif sell_counter == -8:
if ((c.iloc[-2]['High'] > c.iloc[-3]['High']) and (c.iloc[-2]['High'] > c.iloc[-4]['High'])):
alert_list[symbol] = 'prepare perfect sell'
print symbol, 'prepare perfect sell'
td_seq[symbol] = sell_counter
break
---------------------------------------------------------------------------
KeyError Traceback (most recent call last)
<ipython-input-141-ba972a14ec28> in <module>()
54 td_seq[symbol] = sell_counter
55 else:
---> 56 if (alert_list[symbol] == 'perfect sell') and (sell_counter == -9):
57 print symbol, 'perfect sell'
58 elif sell_counter == -8:
KeyError: 'ABEO'
In [148]:
if 'ABEO' in alert_list:
print True
else: print 'ha'
True
In [147]:
alert_list['ABEO'] = 'perfect sell'
In [ ]:
mmm 12/12/14 4/29/15 4/17/15 down HS
Content source: kennethcc2005/yahoo_finance_stocks
Similar notebooks: