S&P 500 2,441.20 17.28
Gold$1,224.80 $5.30
Nasdaq 6,253.81 61.92
Crude Oil $60,490.00      $-1570.00
QUERY Error:SELECT CompName,date,open,high,low,close,volume,adj_close,dividend FROM Historical_Prices_all WHERE (date BETWEEN date_add(current_date(),INTERVAL -10 YEAR) AND current_date()) and (ticker='ROP') ORDER by `date` DESC
Table 'jump_123jump.Historical_Prices_all' doesn't existSearch result for ROP:
USA: (PIH)   1347 Property Insurance Holdings, Inc.
USA: (AMB)   A M B Property Corp
USA: (ARO)   Aeropostale, Inc.
USA: (AEDAX)   AIM European Growth Fund
USA: (EUEYX)   Alpine Cyclical Advantage Property Y
USA: (AWP)   Alpine Global Premier Properties Fund
USA: (AMEN)   AMEN Properties Inc.
USA: (APO)   American Community Properties Trust
USA: (AEPGX)   American Funds EuroPacific Growth Fund A
USA: (ARPI)   American Residential Properties, Inc.
USA: (AMV)   AmeriVest Properties Inc.
USA: (APRS)   Apropos Technology Inc.
USA: (AHH)   Armada Hoffler Properties, Inc.
USA: (AVN)   Avalon Properties, Inc.
USA: (BELM)   Bell Microproducts Inc.
USA: (BLPH)   Bellerophon Therapeutics LLC
USA: (ADRU)   BLDRS Europe 100 ADR Index
USA: (BXP)   Boston Properties, Inc.
USA: (BRE)   BRE Properties, Inc.
USA: (BRX)   Brixmor Property Group Inc.
USA: (BHP)   Broken Hill Proprietary Co Ltd
USA: (BPO)   Brookfield Properties Corporation (USA)
USA: (CPT)   Camden Property Trust
USA: (CPI)   Capital Properties Inc.
USA: (CPTP)   Capital Properties, Inc.
USA: (CBL)   CBL & Associates Properties, Inc.
USA: (CEE)   Central Europe and Russia Fund Inc.
USA: (CEDC)   Central European Distribution Corp
USA: (CETV)   Central European Media Enterprises Ltd.
USA: (CLP)   Colonial Properties Trust
USA: (OFC)   Corporate Office Properties
USA: (CUZ)   Cousins Properties Inc
USA: (CYBE)   CyberOptics Corporation
USA: (DPFDX)   Davlin:Philanthropic
USA: (EIIGX)   E.I.I. Global Property Institutional
USA: (EHP)   Eagle Hospitality Properties Trust Inc
USA: (DEA)   Easterly Government Properties, Inc.
USA: (VEEEX)   Eastern European Equity Fund
USA: (EGP)   EastGroup Properties, Inc.
USA: (EIIPX)   EII Intl Property;Inst
USA: (EPR)   Entertainment Properties Trust
USA: (ENTR)   Entropic Communications, Inc.
USA: (ELS)   Equity Lifestyle Properties
USA: (ESS)   Essex Property Trust, Inc.
USA: (EPIVX)   EuroPac International Value Fund A
USA: (EPIBX)   EuroPac Intl Bond;A
USA: (EKH)   Europe 2001 HOLDRs
USA: (FMP)   Feldman Mall Properties, Inc.
USA: (FIEUX)   Fidelity Europe
USA: (FECAX)   Fidelity Europe Cap Ap
USA: (FSP)   Franklin Street Properties Corp.
USA: (GGP)   General Growth Properties, Inc.
USA: (GPP)   Government Properties Trust, Inc.
USA: (GNI)   Great Northern Iron Ore Properties
USA: (OMAB)   Grupo Aeroportuario del Centro Norte S.A.B. de C.V.
USA: (PAC)   Grupo Aeroportuario Del Pacifico, S.A. de C.V.
USA: (ASR)   Grupo Aeroportuario del Sureste (ADR)
USA: (HIW)   Highwoods Properties, Inc.
USA: (HMG)   HMG/Courtland Properties Inc.
USA: (HME)   Home Properties, Inc.
USA: (HGPI)   Horizon Group Properties Inc.
USA: (HPT)   Hospitality Properties Trust
USA: (HRP)   HRPT Properties Trust
USA: (HPP)   Hudson Pacific Properties, Inc.
USA: (IERAX)   ICON:Europe;A
USA: (ICUCX)   ICON:Europe;C
USA: (ICSEX)   ICON:Europe;S
USA: (IPCC)   Infinity Property and Casualty Corporation
USA: (ESR)   iShares MSCI Emerging Markets Eastern Europe Index Fund
USA: (IEV)   iShares S&P Europe 350 Index
USA: (IVMAX)   Ivy Managed European/Pacific Fund A
USA: (LHO)   Lasalle Hotels Properties
USA: (LRP)   Legacy Healthcare Properties Trust Inc.
USA: (LRY)   Liberty Property Trust
USA: (LTC)   LTC Properties, Inc.
USA: (MPG)   Maguire Properties, Inc.
USA: (MPW)   Medical Properties Trust, Inc.
USA: (MMPI)   Meruelo Maddux Properties, Inc.
USA: (PCS)   MetroPCS Communications, Inc.
USA: (MDF)   Metropolitan Health Network
USA: (MWATX)   Metropolitan West AlphaTrak 500 Fund M
USA: (MPYMX)   Metzler Payden European Emerging Markets Fund
USA: (MEEAX)   MFS European Eqty;A
USA: (MEEBX)   MFS European Eqty;B
USA: (MEECX)   MFS European Eqty;C
USA: (MEEIX)   MFS European Eqty;I
USA: (MSW)   Mission West Properties, Inc.
USA: (RNE)   Morgan Stanley Eastern Europe Fund Inc.
USA: (TEMIX)   Mutual European;A
USA: (TEUBX)   Mutual European;B
USA: (TEURX)   Mutual European;C
USA: (MEURX)   Mutual European;Z
USA: (NNPP)   Nano-Proprietary Inc
USA: (NHP)   Nationwide Health Properties, Inc.
USA: (NRT)   North European Oil Royalty Trust
USA: (NOC)   Northrop Grumman Corporation
USA: (NURMF)   NUR Macroprinters Ltd.
USA: (OLP)   One Liberty Properties, Inc.
USA: (PCE)   Pacific Office Properties Trust Inc.
USA: (PKY)   Parkway Properties, Inc.
USA: (PPS)   Post Properties, Inc.
USA: (PEH)   PowerShares Dynamic Europe
USA: (PEF)   PowerShares FTSE RAFI Europe
USA: (PWD)   PowerShares FTSE RAFI Europe Small-Mid
USA: (UEPIX)   ProFunds:Europe 30;Inv
USA: (UEPSX)   ProFunds:Europe 30;Svc
USA: (PEUGX)   Putnam Europe Equity;A
USA: (PEUBX)   Putnam Europe Equity;B
USA: (PEUMX)   Putnam Europe Equity;M
USA: (PEERX)   Putnam Europe Equity;R
USA: (RPT)   Ramco-Gershenson Property Trus
USA: (RPB)   Republic Property Trust
USA: (RPAI)   Retail Properties of America
USA: (ROP)   Roper Industries, Inc.
USA: (SNH)   Senior Housing Properties Trus
USA: (SPG)   Simon Property Group, Inc.
USA: (SIZ)   Sizeler Property Investors Inc
USA: (GUR)   SPDR S&P Emerging Europe
USA: (HMR.U)   Sports Properties Acquisition Corp.
USA: (STWD)   Starwood Property Trust, Inc.
USA: (STRS)   Stratus Properties, Inc.
USA: (SPH)   Suburban Propane Partners, L.P.
USA: (INN)   Summit Hotel Properties, Inc.
USA: (TREMX)   T. Rowe Price Emerging Europe & Mediterranean Fund
USA: (TRF)   Templeton Russia and East European Fund Inc.
USA: (EEA)   The European Equity Fund Inc.
USA: (TPGI)   Thomas Properties Group, Inc.
USA: (TAPA)   Travelers Property
USA: (TRZ)   Trizec Properties Inc
USA: (EPV)   UltraShort MSCI Europe ProShares
USA: (UMH)   UMH Properties, Inc.
USA: (UPI)   Uroplasty, Inc.
USA: (UBA)   Urstadt Biddle Properties Inc
USA: (UBP)   Urstadt Biddle Properties Inc.
USA: (EUROX)   US Glbl:East European
USA: (VEA)   Vanguard Europe Pacific ETF
USA: (VGK)   Vanguard European Stock ETF
USA: (VPHM)   ViroPharma Incorporate
USA: (FUR)   Winthrop Realty Trus
USA: (DEW)   WisdomTree Europe Equity Income
USA: (DFE)   WisdomTree Europe SmallCap Dividend
USA: (DEB)   WisdomTree Europe Total Dividend
INDIA: (ANSALINFRA) Ansal Properties & Infrastructure Ltd.    (500013)
INDIA: (AUROPHARMA) Aurobindo Pharma Ltd.    (524804)
INDIA: (ESSELPACK) Essel Propack Ltd.    (500135)
INDIA: (EXCELCROP) Excel Crop Care Ltd    (532511)
INDIA: (GARWALLROP) Garware Wall Ropes Ltd.    (509557)
INDIA: () Satra Properties India Ltd    (508996)
INDIA: (STROPTICAL) Sterlite Opitical Technologies Ltd.    (532374)
INDIA: (TNPETRO) Tamilnadu PetroProducts Ltd.    (500777)