Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Get a list of all tickers over 10 year period for Q1500US()

Hi All,

I'm looking to obtain a list of all tickers over a 10 year period in Q1500US() (I'm assuming it doesn't remain static -- someone tell me if I'm wrong). However, when I run my code, I am running into an issue where it says "WARN Logging limit exceeded; some messages discarded".

My code is very basic. I am setting my universe to Q1500US() and running this in pipeline:
context.output = pipeline_output('pipeline')
for equity in context.output.index:
print equity

It seems to work for the first few equities, but it seems that there's a limit to how much I can log to the output console: https://www.quantopian.com/posts/warn-logging-limit-exceeded-some-messages-discarded. Can anyone assist?

Thanks,
L

1 response

Limit content sent to the logging window at around 1000 bytes at a time to stay under one of the logging limits.
That will address one part of your goal.
QTradableStocksUS is the one we need to be working with toward the contest and fund so that's what I used for this example.

        if len(syms) > 1000:  
from quantopian.pipeline  import Pipeline  
from quantopian.algorithm import attach_pipeline, pipeline_output  
from quantopian.pipeline.filters import QTradableStocksUS

def initialize(context):  
    context.done = 0  
    attach_pipeline(Pipeline(screen=QTradableStocksUS()), 'z')

def before_trading_start(context, data):  
    if context.done: return    # just one day for this example

    out = pipeline_output('z')

    syms = ''  
    symbol_names = [s.symbol for s in out.index]  
    for sym in sorted(symbol_names):  
        syms += sym + ' '  
        if len(syms) > 1000:  
            log.info(syms)  
            syms = ''

    context.done = 1

'''
2018-04-17 05:45 before_trading_start:19 INFO A AA AABA AAL AAN AAOI AAON AAPL AAT AAWW AAXN ABAX ABBV ABC ABCB ABEO ABG ABM ABMD ABR ABT ABX ACAD ACC ACCO ACGL ACHC ACHN ACIA ACIW ACLS ACM ACN ACOR ACRS ACXM ADBE ADC ADI ADM ADMS ADNT ADP ADRO ADS ADSK ADSW ADTN AEE AEGN AEIS AEL AEM AEO AEP AER AERI AES AFG AFL AG AGCO AGEN AGI AGII AGIO AGN AGNC AGO AGR AGRO AGX AHH AHL AIG AIMC AIMT AIN AINV AIR AIT AIV AIZ AJG AJRD AKAM AKAO AKBA AKCA AKR AKS AL ALB ALDR ALE ALEX ALG ALGN ALGT ALK ALKS ALL ALLE ALLY ALNY ALRM ALSN ALV ALXN AMAG AMAT AMBA AMBC AMC AMCX AMD AME AMED AMG AMGN AMH AMKR AMN AMP AMSF AMT AMTD AMWD AMZN AN ANAB ANDV ANET ANF ANH ANIK ANIP ANSS AOBC AON AOS APA APAM APC APD APH APLE APOG APPF APPN APRN APTI APTS APTV AR ARCB ARCC ARCH ARCO ARE ARI ARMK ARNA ARNC AROC ARR ARRS ARRY ARW ARWR ASB ASGN ASH ASIX ASMB ASNA ASPS ASTE ATGE ATH ATHN ATI ATKR ATNI ATO ATR ATRA ATRO ATSG ATU ATUS ATVI AUPH AUY AVAV AVB AVGO AVP AVT AVY AWI AWK AWR AXDX AXE AXGN AXL AXP AXS AXTA AY AYI AYR AYX AZO AZPN AZZ B BA BABY BAC BAH BAM BANC  
2018-04-17 05:45 before_trading_start:19 INFO BANR BAP BAS BAX BB BBBY BBT BBY BC BCC BCE BCEI BCO BCOR BCPC BCRX BDC BDN BDX BEAT BECN BEL BEN BERY BFAM BF_B BG BGCP BGG BGS BHE BHF BHGE BHLB BHVN BID BIG BIIB BIO BJRI BK BKD BKE BKH BKNG BKS BKU BL BLD BLDP BLDR BLK BLKB BLL BLMN BLUE BMCH BMI BMO BMRN BMS BMY BNFT BNS BOFI BOH BOJA BOKF BOLD BOOT BOX BPFH BPMC BPOP BPT BR BRC BRKL BRKR BRKS BRK_B BRO BRS BRX BSIG BSX BTE BTG BTU BURL BWA BWXT BXMT BXP BXS BYD BZH C CA CABO CACC CACI CADE CAE CAG CAH CAI CAKE CAL CALM CAMP CAR CARA CARB CARS CASH CASY CAT CATM CATO CATY CB CBAY CBB CBI CBL CBM CBOE CBPO CBPX CBRL CBS CBSH CBT CBU CC CCE CCI CCJ CCK CCL CCMP CCOI CCS CDE CDEV CDK CDNS CDW CE CEF CELG CENT_A CENX CERN CEVA CF CFFN CFG CFR CFX CGNX CHD CHDN CHE CHFC CHGG CHH CHK CHKP CHRS CHRW CHS CHSP CHTR CHUY CI CIEN CIM CINF CIR CIT CJ CKH CL CLB CLDR CLDT CLF CLGX CLH CLI CLNS CLR CLS CLVS CLX CM CMA CMC CMCO CMCS_A CMD CME CMG CMI CMO CMP CMPR CMRE CMS CNA CNC CNCE CNDT CNHI CNI CNK CNMD CNO CNP CNQ CNS CNSL CNX COF COG COHR COHU  
2018-04-17 05:45 before_trading_start:19 INFO COKE COLB COLL COLM COMM CONE CONN COO COP COR CORE CORT COST COT COTV COTY COUP COWN CP CPA CPB CPE CPG CPLA CPRT CPS CPT CR CRAY CRBP CRC CRCM CREE CRI CRL CRM CROX CRS CRSP CRUS CRZO CSCO CSFL CSGP CSGS CSII CSIQ CSL CSOD CSTE CSTM CSX CTAS CTB CTL CTLT CTMX CTRE CTRL CTSH CTXS CUB CUBE CUBI CUTR CUZ CVA CVBF CVCO CVE CVG CVGW CVI CVLT CVNA CVS CVX CW CWH CWST CWT CXO CXP CXW CY CYBR CYH CYS CYTK CZR CZZ D DAL DAN DAR DATA DB DBD DCI DCT DDD DDR DDS DE DEA DECK DEI DENN DEPO DF DFIN DFS DG DGX DHI DHR DIN DIOD DIS DISC_A DISH DK DKS DLB DLR DLTH DLTR DLX DNB DNKN DNOW DNR DO DOC DOOR DORM DOV DOX DPLO DPZ DRE DRH DRI DRQ DRYS DSL DSW DTE DUK DVA DVAX DVMT DVN DXC DXCM DY EA EAT EBAY EBIX EBS EBSB ECA ECHO ECL ECPG ED EDIT EDR EE EEFT EEQ EFII EFSC EFX EGBN EGHT EGN EGO EGOV EGP EGRX EHC EIG EIGI EIX EL ELF ELLI ELS ELY EME EMN EMR ENB ENDP ENLC ENR ENS ENSG ENTA ENTG ENV ENVA EOG EPAM EPAY EPC EPR EPZM EQC EQIX EQR EQT ERF ERI EROS ES ESE ESGR ESIO ESL ESLT ESNT ESPR ESRT ESS ESV ETFC  
2018-04-17 05:45 before_trading_start:19 INFO ETH ETM ETN ETR ETSY ETW EURN EV EVBG EVH EVHC EVR EVRI EVTC EW EWBC EXAS EXC EXEL EXLS EXP EXPD EXPE EXPO EXPR EXR EXTN EXTR EZPW F FAF FANG FAST FAX FB FBC FBHS FBP FCAU FCB FCE_A FCF FCFS FCN FCNC_A FCPT FCX FDC FDP FDS FDX FE FELE FET FEYE FFBC FFIN FFIV FG FGEN FHB FHN FI FIBK FICO FII FIS FISV FIT FITB FIVE FIVN FIX FIZZ FL FLEX FLIR FLO FLOW FLR FLS FLT FLXN FMBI FMC FMI FN FNB FND FNF FNGN FNSR FNV FOE FOLD FORM FOSL FOXF FPRX FR FRAC FRC FRGI FRME FRT FRTA FSIC FSLR FSM FSP FSS FTI FTK FTNT FTR FTS FTV FUL FULT FWON_K FWRD G GAB GATX GBCI GBDC GBT GBX GCI GCO GCP GD GDDY GDI GDOT GDV GE GEF GEO GES GG GGG GHC GHDX GHL GIB GIII GIL GILD GIS GKOS GLNG GLOB GLOG GLPI GLUU GLW GLYC GM GME GMED GMS GNBC GNL GNRC GNTX GOGO GOLF GOOG_L GOOS GOV GPC GPI GPK GPMT GPN GPOR GPRE GPRO GPS GPT GRA GRMN GRPN GRUB GS GSAT GSM GT GTE GTLS GTN GTT GTY GVA GWB GWR GWRE GWW GXP H HA HAE HAFC HAIN HAL HALO HAS HASI HBAN HBHC HBI HBM HCA HCC HCP HCSG HD HDP HDS HE HEES HEI HELE HES HF HFC HFWA HGV  
2018-04-17 05:45 before_trading_start:19 INFO HHC HI HIBB HIG HII HIIQ HIW HK HL HLF HLI HLNE HLT HLX HMHC HMN HMST HMSY HNI HOG HOLI HOLX HOMB HOME HON HOPE HP HPE HPP HPQ HPT HQY HR HRB HRC HRG HRI HRL HRS HRTG HRTX HSC HSIC HSKA HST HSY HT HTA HTGC HTH HTLD HTLF HTZ HUBB HUBG HUBS HUN HURN HXL HYH HZNP HZO IAC IAG IART IBKC IBKR IBM IBOC IBP IBTX ICE ICFI ICHR ICLR ICPT ICUI IDA IDCC IDTI IDXX IEX IFF IGT IIVI ILG ILMN IMAX IMGN IMMU IMO IMPV INCY INDB INFN INFO INGN INGR INN INO INOV INSM INST INSY INT INTC INTU INVA INVH INXN IONS IOSP IOVA IP IPG IPGP IPHI IPHS IPI IPXL IQV IR IRBT IRDM IRM IRT IRTC IRWD ISBC ISCA ISRG IT ITCI ITG ITGR ITRI ITT ITW IVC IVR IVZ JACK JAG JAZZ JBGS JBHT JBL JBLU JBT JCI JCOM JCP JEC JELD JHG JJSF JKHY JLL JNJ JNPR JOE JPM JPS JRVR JWN JW_A K KAI KALA KALU KAMN KAR KBH KBR KEM KERX KEX KEY KEYS KFY KGC KHC KIM KLAC KLIC KLXI KMB KMG KMI KMPR KMT KMX KN KNL KNX KO KOP KORS KOS KR KRA KRC KRG KRNT KRNY KRO KSS KSU KTOS KTWO KURA KW KWR KYN L LABL LAD LADR LAMR LANC LAUR LAZ LB LBRD_K LBTY_K LC LCI  
2018-04-17 05:45 before_trading_start:19 INFO LCII LDOS LEA LECO LEG LEN LEXE_A LFUS LGF_A LGIH LGND LH LHCG LHO LII LITE LIVN LJPC LKQ LKSD LL LLL LLY LM LMAT LMNX LMT LNC LNG LNN LNT LNTH LOGI LOGM LOPE LOW LOXO LPI LPLA LPNT LPSN LPT LPX LQ LRCX LSCC LSI LSTR LSXM_K LTC LTRP_A LTXB LUK LULU LUV LVS LW LXFT LXP LXRX LYB LYV LZB M MA MAA MAC MAG MAIN MAN MANH MANT MAR MAS MASI MATW MATX MB MBFI MBI MBUU MC MCD MCHP MCK MCO MCRN MCY MD MDC MDCA MDCO MDGL MDLZ MDP MDR MDRX MDSO MDT MDU MDXG MED MEDP MEI MELI MEOH MET MFA MFC MGA MGI MGLN MGM MGNX MGP MGPI MHK MHLD MHO MIC MIDD MIK MIME MINI MITL MKC MKL MKSI MKTX MLHR MLI MLM MLNX MMC MMI MMM MMS MMSI MMYT MNK MNR MNRO MNST MNTA MO MOD MOG_A MOH MOS MPC MPW MPWR MRC MRCY MRK MRO MRTN MRTX MRVL MS MSA MSCI MSFT MSG MSGN MSI MSM MSTR MTB MTCH MTD MTDR MTG MTGE MTH MTN MTOR MTRN MTSI MTW MTX MTZ MU MUR MUSA MUX MWA MXIM MXL MYGN MYL MYOK NAD NANO NATI NAV NAVI NBIX NBL NBR NCI NCLH NCMI NCR NCS NDAQ NDSN NE NEA NEE NEM NEOG NEU NEWM NEWR NFG NFLX NFX NG NGD NGHC NGVT NHI NI NJR NKE NKTR  
2018-04-17 05:45 before_trading_start:19 INFO NLSN NLY NMFC NMIH NNI NNN NOC NOMD NOV NOVT NOW NP NPO NR NRG NRZ NSA NSC NSIT NSP NTAP NTB NTCT NTGR NTLA NTNX NTRI NTRS NUAN NUE NUS NUVA NVAX NVCR NVDA NVG NVMI NVR NVRO NWBI NWE NWL NWN NWSA NXST NYCB NYLD NYMT NYRT NYT NZF O OAS OC OCFC OCN OCSL ODFL OEC OFC OFIX OGE OGS OHI OI OII OIS OKE OKTA OLED OLLI OLN OMC OMCL OMER OMF OMI ON ONB ONCE OPB OPK OR ORA ORBC ORC ORCL ORI ORLY OSB OSIS OSK OSTK OSUR OTEX OUT OXM OXY OZRK P PAAS PACW PAG PAH PANW PARR PATK PAYC PAYX PB PBA PBCT PBF PBH PBI PBYI PCAR PCG PCH PCRX PCTY PDCE PDCO PDLI PDM PDS PE PEB PEG PEGA PEGI PEI PEN PENN PEP PETQ PETS PF PFBC PFE PFG PFGC PFPT PFS PG PGNX PGR PGRE PGTI PH PHM PHYS PII PINC PIRS PJC PJT PK PKG PKI PLAB PLAY PLCE PLD PLNT PLT PLUG PLUS PLXS PM PMT PNFP PNM PNR PNW PODD POL POOL POR POST POWI PPBI PPC PPG PPL PRA PRAA PRAH PRGO PRGS PRI PRIM PRLB PRO PRTA PRTK PRTY PRU PSA PSB PSEC PSMT PSTG PSX PTC PTCT PTEN PTLA PUMP PVAC PVG PVH PWR PX PXD PYPL PZZA QCOM QCP QDEL QEP QGEN QLYS QRTE_A QRVO QSII  
2018-04-17 05:45 before_trading_start:19 INFO QSR QTNA QTS QTWO QUAD QUOT QURE R RACE RARE RAVN RBA RBC RCI RCII RCL RDC RDFN RDN RDUS RE REG REGI REGN REI REN RES RETA REVG REXR RF RGA RGEN RGLD RGNX RGR RH RHI RHP RHT RIG RIGL RJF RL RLGY RLI RLJ RMAX RMBS RMD RNG RNR RNST ROCK ROG ROIC ROK ROL ROLL ROP ROST RP RPAI RPD RPM RPT RRC RRD RRGB RRR RS RSG RTEC RTN RTRX RUN RUSH_A RUTH RVNC RWT RXN RY RYAM RYN S SA SABR SAFM SAGE SAH SAIA SAIC SALT SAM SAND SANM SASR SATS SAVE SBAC SBCF SBGI SBH SBLK SBRA SBUX SC SCCO SCHL SCHN SCHW SCI SCL SCS SCVL SD SEAS SEDG SEE SEIC SEM SEMG SERV SF SFBS SFL SFLY SFM SFNC SFS SGEN SGH SGMO SGMS SGRY SGYP SHAK SHEN SHO SHOO SHOP SHW SIG SIGI SINA SIR SIRI SITE SIVB SIX SJI SJM SJR SKT SKX SKYW SLAB SLB SLCA SLF SLG SLGN SLM SM SMCI SMG SMP SMPL SMTC SNA SNAP SNBR SNCR SNDR SNH SNHY SNPS SNR SNV SNX SO SODA SOHU SOI SON SONC SP SPB SPG SPGI SPLK SPN SPPI SPR SPSC SPTN SPWR SPXC SQ SR SRC SRCI SRCL SRE SRG SRI SRNE SRPT SSB SSD SSNC SSP SSRM SSTK SSW SSYS STAG STAR STAY STE STI STL STLD STMP STNG STOR  
2018-04-17 05:45 before_trading_start:19 INFO STRA STT STWD STX STZ SU SUI SUM SUPN SVU SWIR SWK SWKS SWM SWN SWX SXC SXT SYF SYK SYMC SYNA SYNH SYNT SYY T TACO TAHO TAP TARO TBI TBPH TCAP TCBI TCF TCMD TCO TCX TD TDC TDG TDOC TDS TDY TEAM TECD TECH TECK TEL TELL TEN TER TERP TEX TFX TGH TGI TGNA TGT TGTX THC THG THO THRM THS TIF TILE TISI TIVO TJX TK TKR TLRD TMHC TMK TMO TMST TMUS TNC TNET TOL TOWN TPC TPH TPIC TPL TPR TPRE TPX TREE TREX TRGP TRHC TRI TRIP TRMB TRMK TRN TRNO TROW TROX TRP TRQ TRS TRTN TRU TRUE TRUP TRV TSCO TSE TSEM TSG TSLA TSLX TSN TSRO TSS TTC TTD TTEK TTI TTMI TTWO TU TUP TVPT TVTY TWLO TWNK TWO TWOU TWTR TXMD TXN TXRH TXT TYG TYL TYPE UAA UAL UBNT UBS UBSH UBSI UCBI UCTT UDR UE UFPI UFS UGI UHAL UHS UIS ULTA ULTI UMBF UMPQ UNF UNFI UNH UNIT UNM UNP UNT UNVR UPL UPS URBN URGN URI USAT USB USCR USFD USG USNA UTHR UTX UVE UVV V VAC VAR VC VCEL VCRA VECO VEEV VER VET VFC VG VGR VIAB VIAV VIRT VLO VLY VMC VMI VMW VNDA VNO VOYA VRAY VREX VRNS VRNT VRS VRSK VRSN VRTS VRTU VRTX VRX VSAT VSH VSM VST VSTO VTR VVC VVI  
'''