User Tools

Site Tools


EASA 6.0 MySQL script

This script below establishes the database schema that EASA 6.0 requires.

Here we use temporary database passwords, after running this script please email support@easasoftware.com to obtain the proprietary SQL to update to the actual passwords.

EASA6.0-mysql.sql
CREATE USER '​sa'​@'​localhost'IDENTIFIED BY 'Temp1!+sa';​	 
CREATE USER '​exceluser'​@'​localhost'IDENTIFIED BY '​Temp2!+exceluser';​	 
CREATE USER '​demo'​@'​localhost'IDENTIFIED BY '​Temp3!+demo';​
 
CREATE DATABASE stockdata;
CREATE DATABASE easa;
CREATE DATABASE excel;
CREATE DATABASE excelTesting;
 
GRANT ALL PRIVILEGES ON easa.* TO 'sa'@'localhost';
GRANT ALL PRIVILEGES ON excel.* TO 'exceluser'@'localhost';
GRANT ALL PRIVILEGES ON excelTesting.* TO 'exceluser'@'localhost';
GRANT ALL PRIVILEGES ON stockdata.* TO 'demo'@'localhost';
 
FLUSH PRIVILEGES;
 
USE stockdata;
 
 
DROP TABLE IF EXISTS `exchange`;
CREATE TABLE `exchange` (
  `ID` INT(11) NOT NULL AUTO_INCREMENT,
  `Symbol` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Company` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Industry` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `SPIndex` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Exchange` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Price` DOUBLE DEFAULT NULL,
  `Sector` VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
  `Revenue` DOUBLE DEFAULT NULL,
  PRIMARY KEY (`ID`)
);
 
LOCK TABLES `exchange` WRITE;
/*!40000 ALTER TABLE `exchange` DISABLE KEYS */;
INSERT INTO `exchange` VALUES (1,'GOOG','Google Inc','Internet Information Providers','S&P 500','NASDAQ    ',639.86,'Technology',13431130112),(2,'MITSY','Mitsui & Co Ltd Depository Receipt','Conglomerates','N/A','NASDAQ    ',501.1,'Consumer Services',43304321024),(3,'BIDU','Baidu.com Inc','Internet Information Providers','N/A','NASDAQ    ',324.38,'Technology',158065904),(4,'ISRG','Intuitive Surgical Inc','Medical Appliances & Equipment','N/A','NASDAQ    ',254.25,'Health Care',462876992),(5,'NWLIA','National Western Life Insurance Co','Life Insurance','N/A','NASDAQ    ',246,'Finance',547768000),(6,'FCNCA','First Citizens Bancshares Class A Ord Shs','Regional - Mid-Atlantic Banks','N/A','NASDAQ    ',181.26,'Finance',870745024),(7,'STRA','Strayer Education Inc','Education & Training Services','N/A','NASDAQ    ',177.61,'Consumer Services',290068000),(8,'AAPL','Apple Inc','Personal Computers','S&P 500','NASDAQ    ',169.57,'Technology',22626000896),(9,'WYNN','Wynn Resorts Ltd','Resorts & Casinos','N/A','NASDAQ    ',161,'Consumer Services',2204519936),(10,'ARDNA','Arden Group Inc','Grocery Stores','N/A','NASDAQ    ',159.2,'Consumer Services',485823008),(11,'FWLT','Foster Wheeler Ord Shs','Heavy Construction','N/A','NASDAQ    ',153.84,'Capital Goods',4445787136),(12,'ESGR','Enstar Group Ltd','Property & Casualty Insurance','N/A','NASDAQ    ',146.75,'Finance',93265000),(13,'ANAT','American National Insurance Co','Life Insurance','N/A','NASDAQ    ',145,'Finance',3175904000),(14,'SHLD','Sears Holdings Corp','Department Stores','S&P 500','NASDAQ    ',142.81,'Consumer Services',52169998336),(15,'FSLR','First Solar Inc','Semiconductor - Specialized','N/A','NASDAQ    ',140.65,'N/A',237660992),(16,'LCAPA','Liberty Media Capital Common Series A When Issued Ord Shs','CATV Systems','N/A','NASDAQ    ',128.77,'Consumer Services',1274000000),(17,'LCAPB','Liberty Media Capital Common Series B When Issued Ord Shs','N/A','N/A','NASDAQ    ',128.58,'Consumer Services',0),(18,'DRYS','DryShips Inc','Shipping','N/A','NASDAQ    ',127.97,'N/A',338244992),(19,'CSWC','Capital Southwest Corp','Closed-End Fund - Equity','N/A','NASDAQ    ',125.52,'Finance',6939000),(20,'ATRI','Atrion Corp','Medical Instruments & Supplies','N/A','NASDAQ    ',121.97,'Health Care',86904000),(21,'IDXX','IDEXX Laboratories Inc','Diagnostic Substances','N/A','NASDAQ    ',116.25,'Health Care',827790016),(22,'GRMN','Garmin Ltd','Scientific & Technical Instruments','N/A','NASDAQ    ',115.65,'Technology',2253846016),(23,'DECK','Deckers Outdoor Corp','Textile - Apparel Footwear & Accessories','N/A','NASDAQ    ',114.95,'Consumer Non-Durables',332003008),(24,'RIMM','RESEARCH IN MOTION LIMITED','Diversified Communication Services','N/A','NASDAQ    ',114.9,'Technology',4235034624),(25,'APAGF','Apco Argentina Inc','Independent Oil & Gas','N/A','NASDAQ    ',111.99,'Energy',59314000),(26,'CETV','Central European Media Enterprises Ltd','Broadcasting - TV','N/A','NASDAQ    ',104.69,'Consumer Services',690968000),(27,'ITRI','Itron Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',102.13,'Technology',874148992),(28,'EQIX','Equinix Inc','Telecom Services - Domestic','N/A','NASDAQ    ',99.25,'Consumer Services',330444000),(29,'KTII','K-Tron International Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',99.2,'Capital Goods',173702000),(30,'OYOG','OYO Geospace Corporation','Scientific & Technical Instruments','N/A','NASDAQ    ',96.46,'Technology',136399008),(31,'PCLN','Priceline.Com Ord Shs','Internet Service Providers','N/A','NASDAQ    ',94.49,'Technology',1230807040),(32,'PATR','Patriot Transportation Holdings Inc','Trucking','N/A','NASDAQ    ',94.4,'Transportation',153690000),(33,'MICC','Millicom International Cellular Ord Shs','Diversified Communication Services','N/A','NASDAQ    ',93.88,'N/A',2068318976),(34,'SPWR','SunPower Corp','Scientific & Technical Instruments','N/A','NASDAQ    ',92.99,'Technology',455969984),(35,'AMZN','Amazon.com Inc','Catalog & Mail Order Houses','S&P 500','NASDAQ    ',92.12,'Consumer Services',12193999872),(36,'GLDN','Golden Telecom, Inc','Wireless Communications','N/A','NASDAQ    ',91.99,'Consumer Services',1032916992),(37,'NILE','Blue Nile Inc','Jewelry Stores','N/A','NASDAQ    ',89.77,'Consumer Services',283980000),(38,'MSTR','MicroStrategy Inc','Business Software & Services','N/A','NASDAQ    ',87.38,'Technology',327452992),(39,'HAYN','Haynes International Inc','Steel & Iron','N/A','NASDAQ    ',87.22,'Basic Industries',512971008),(40,'VMSI','Ventana Medical Systems Inc','Medical Instruments & Supplies','N/A','NASDAQ    ',87,'Health Care',261266000),(41,'GFIG','GFI Group Inc','Investment Brokerage - Regional','N/A','NASDAQ    ',86.66,'Finance',842467968),(42,'DHIL','Diamond Hill Investment Group','Investment Brokerage - Regional','N/A','NASDAQ    ',86.36,'Finance',41389000),(43,'CHAP','Chaparral Steel Co','Machine Tools & Accessories','N/A','NASDAQ    ',85.97,'N/A',1722918016),(44,'BIIB','Biogen Idec Inc','Biotechnology','S&P 500','NASDAQ    ',84.75,'Health Care',2900919040),(45,'IVGN','Invitrogen Corp','Biotechnology','N/A','NASDAQ    ',84.23,'Health Care',1271186944),(46,'DNEX','Dionex Corp','Scientific & Technical Instruments','N/A','NASDAQ    ',83.69,'Technology',327284000),(47,'CTSH','Cognizant Technology Solutions Corp','Business Software & Services','N/A','NASDAQ    ',81.66,'Technology',1778736000),(48,'RTRSY','Reuters ADR','Publishing-Periodicals','N/A','NASDAQ    ',81.5,'N/A',5202971136),(49,'LECO','Lincoln Electric Holdings Inc','Small Tools & Accessories','N/A','NASDAQ    ',79.56,'Capital Goods',2136691968),(50,'BUCY','Bucyrus International Inc','Farm & Construction Machinery','N/A','NASDAQ    ',78.93,'Capital Goods',955755008),(51,'ALAB','Alabama National Bancorp','Regional - Southeast Banks','N/A','NASDAQ    ',78.48,'Finance',494552000),(52,'HURN','Huron Consulting Group Inc','Management Services','N/A','NASDAQ    ',78.4,'Finance',435052000),(53,'DWSN','Dawson Geophysical Co','Oil & Gas Equipment & Services','N/A','NASDAQ    ',78.28,'Energy',233716992),(54,'RSTI','Rofin-Sinar Technologies Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',76.92,'Technology',465275008),(55,'KALU','Kaiser Aluminum Corp','Aluminum','N/A','NASDAQ    ',76.91,'Basic Industries',1444800000),(56,'GENZ','Genzyme Corp','Biotechnology','S&P 500','NASDAQ    ',76.9,'Health Care',3479417088),(57,'LEAP','Leap Wireless International Inc','Wireless Communications','N/A','NASDAQ    ',76.85,'Consumer Services',1384788992),(58,'DADE','Dade Behring Holdings Inc','Diagnostic Substances','N/A','NASDAQ    ',76.75,'Health Care',1819000064),(59,'CRDN','Ceradyne Inc','Industrial Equipment & Components','N/A','NASDAQ    ',76.68,'Capital Goods',738326976),(60,'ACGL','Arch Capital Group Ord Shs','Property & Casualty Insurance','N/A','NASDAQ    ',75.5,'Finance',3480194048),(61,'CELG','Celgene Corp','Biotechnology','N/A','NASDAQ    ',74.74,'Health Care',1161115008),(62,'CEPH','Cephalon Inc','Drug Manufacturers - Other','N/A','NASDAQ    ',74.71,'Health Care',1851261056),(63,'SCHN','Schnitzer Steel Industries Inc','Steel & Iron','N/A','NASDAQ    ',74.34,'Basic Industries',2428374016),(64,'EXBD','Corporate Executive Board Co (The)','Management Services','N/A','NASDAQ    ',74.28,'Consumer Services',498113984),(65,'MORN','Morningstar Inc','Asset Management','N/A','NASDAQ    ',73.97,'Finance',373990016),(66,'CHTT','Chattem Inc','Drug Manufacturers - Other','N/A','NASDAQ    ',73.19,'Consumer Non-Durables',387868000),(67,'NIHD','NII Holdings Inc','Wireless Communications','N/A','NASDAQ    ',72.39,'Technology',2785913088),(68,'WPPGY','WPP Group ADR','Advertising Agencies','N/A','NASDAQ    ',72.13,'N/A',12136330240),(69,'CROX','Crocs Inc','Textile - Apparel Footwear & Accessories','N/A','NASDAQ    ',71.95,'Consumer Non-Durables',590524032),(70,'SHPGY','Shire ADR','Drug Manufacturers - Other','N/A','NASDAQ    ',71.79,'Health Care',2049500032),(71,'ALXN','Alexion Pharmaceuticals Inc','Drug Manufacturers - Other','N/A','NASDAQ    ',71.68,'Health Care',16524000),(72,'GPRO','Gen Probe Inc','Research Services','N/A','NASDAQ    ',71.07,'Health Care',385617984),(73,'NTRS','Northern Trust Corp','Regional - Midwest Banks','S&P 500','NASDAQ    ',70.88,'Finance',2489999872),(74,'KYPH','Kyphon Ord Shs','Medical Instruments & Supplies','N/A','NASDAQ    ',70.63,'Health Care',487768000),(75,'GHCI','Genesis HealthCare Corp','N/A','N/A','NASDAQ    ',69.36,'N/A',0),(76,'HOLX','Hologic Inc','Medical Appliances & Equipment','N/A','NASDAQ    ',69.23,'Health Care',689857024),(77,'AMAG','AMAG Pharmaceuticals Inc','Diagnostic Substances','N/A','NASDAQ    ',68.91,'Health Care',2628000),(78,'AMOV','America Movil Class A ADR','N/A','N/A','NASDAQ    ',68.49,'Consumer Services',0),(79,'ZION','Zions Bancorp Ord Shs','Regional - Pacific Banks','S&P 500','NASDAQ    ',68.45,'Finance',3052914944),(80,'COST','Costco Wholesale Corp','Discount, Variety Stores','S&P 500','NASDAQ    ',67.9,'Consumer Services',64400158720),(81,'WSFS','WSFS Financial Corp','Regional - Mid-Atlantic Banks','N/A','NASDAQ    ',67.78,'Finance',186587008),(82,'TECH','Techne Corp','Biotechnology','N/A','NASDAQ    ',67.61,'Health Care',223482000),(83,'VARI','Varian, Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',67.55,'Technology',894560000),(84,'DASTY','Dassault System ADR','Technical & System Software','N/A','NASDAQ    ',67.52,'Technology',1732184064),(85,'CBSS','Compass Bancshares Inc','N/A','N/A','NASDAQ    ',66.83,'N/A',2177379072),(86,'UTHR','United Therapeutics Corp','Drug Manufacturers - Other','N/A','NASDAQ    ',66.63,'Health Care',178223008),(87,'AQNT','aQuantive Inc','N/A','N/A','NASDAQ    ',66.46,'N/A',0),(88,'APOL','Apollo Group Inc','Education & Training Services','S&P 500','NASDAQ    ',66.16,'Consumer Services',2635571968),(89,'MIDD','Middleby Corp','Diversified Machinery','N/A','NASDAQ    ',65.94,'Consumer Durables',420476000),(90,'UHAL','Amerco Ord Shs','Rental & Leasing Services','N/A','NASDAQ    ',65.44,'Consumer Services',2076728064),(91,'WGOV','Woodward Governor Co','Industrial Electrical Equipment','N/A','NASDAQ    ',65.33,'Capital Goods',984483008),(92,'HANS','Hansen Natural Corp','Beverages - Soft Drinks','N/A','NASDAQ    ',65.28,'Consumer Non-Durables',740606976),(93,'MCRS','Micros Systems Inc','Technical & System Software','N/A','NASDAQ    ',65.24,'Technology',785726976),(94,'ALOG','Analogic Corp','Scientific & Technical Instruments','N/A','NASDAQ    ',64.07,'Technology',340782016),(95,'CERN','Cerner Corp','Healthcare Information Services','N/A','NASDAQ    ',63.96,'Technology',1478680960),(96,'GLYT','Genlyte Group Inc','Business Equipment','N/A','NASDAQ    ',63.82,'Capital Goods',1592843008),(97,'COKE','Coca Cola Ord Shs','Beverages - Soft Drinks','N/A','NASDAQ    ',63.79,'Consumer Non-Durables',1439201024),(98,'HSIC','Henry Schein Inc','Medical Equipment Wholesale','N/A','NASDAQ    ',63,'Consumer Services',5468101120),(99,'CPLA','Capella Education Co','Education & Training Services','N/A','NASDAQ    ',62.93,'N/A',201247008),(100,'ASEI','American Science & Engineering Inc','Industrial Equipment & Components','N/A','NASDAQ    ',62.88,'Capital Goods',167775008),(101,'TBSI','TBS International Ltd','Shipping','N/A','NASDAQ    ',62.4,'Transportation',278891008),(102,'VSEC','VSE Corp','Technical Services','N/A','NASDAQ    ',62.09,'Capital Goods',485923008),(103,'ILMN','Illumina Inc','Biotechnology','N/A','NASDAQ    ',61.56,'Health Care',270592000),(104,'ABCO','Advisory Board Co','Research Services','N/A','NASDAQ    ',61.52,'Consumer Services',196742000),(105,'ERTS','Electronic Arts Inc','Multimedia & Graphics Software','S&P 500','NASDAQ    ',61.4,'Technology',3072999936),(106,'PENN','Penn National Gaming Inc','Resorts & Casinos','N/A','NASDAQ    ',61.35,'Consumer Services',2380474112),(107,'DIGE','Digene Corp','N/A','N/A','NASDAQ    ',61.01,'N/A',0),(108,'CSGP','CoStar Group Inc','Internet Information Providers','N/A','NASDAQ    ',60.62,'Consumer Services',175294000),(109,'LUFK','Lufkin Industries Inc','Oil & Gas Equipment & Services','N/A','NASDAQ    ',60.62,'Energy',616998976),(110,'WBMD','WebMD Health Corp','Internet Information Providers','N/A','NASDAQ    ',60.59,'Health Care',298659008),(111,'FLIR','FLIR Systems Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',60.54,'Capital Goods',664769984),(112,'HURC','Hurco Cos Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',60.44,'Capital Goods',181091008),(113,'ASTE','Astec Industries Inc','Farm & Construction Machinery','N/A','NASDAQ    ',60.4,'Basic Industries',775598016),(114,'FMCN','Focus Media Holding Ltd','Advertising Agencies','N/A','NASDAQ    ',60,'Technology',299320000),(115,'LDSH','Ladish Co Inc','Metal Fabrication','N/A','NASDAQ    ',59.54,'Basic Industries',395371008),(116,'ERIE','Erie Indemnity Ord Shs Class A','Property & Casualty Insurance','N/A','NASDAQ    ',59.34,'Finance',1252621952),(117,'AMGN','Amgen Inc','Biotechnology','S&P 500','NASDAQ    ',59.08,'Health Care',14862000128),(118,'NAVG','Navigators Group Inc','Property & Casualty Insurance','N/A','NASDAQ    ',59.03,'Finance',600158016),(119,'BOBJ','Business Objects Depository Receipt','Business Software & Services','N/A','NASDAQ    ',58.99,'Technology',1378577024),(120,'TWIN','Twin Disc Inc','Diversified Machinery','N/A','NASDAQ    ',58.95,'Capital Goods',317200000),(121,'TROW','T Rowe Price Group Inc','Asset Management','S&P 500','NASDAQ    ',58.88,'Finance',2003863040),(122,'WACLY','Wacoal Hldg Depository Receipt','Textile - Apparel Clothing','N/A','NASDAQ    ',58.79,'N/A',1430963968),(123,'ESRX','Express Scripts Inc','Management Services','S&P 500','NASDAQ    ',58.58,'Health Care',17998800896),(124,'ARTC','Arthrocare Corp','Medical Appliances & Equipment','N/A','NASDAQ    ',58.38,'Health Care',287800000),(125,'HUGH','Hughes Communications Inc','Diversified Communication Services','N/A','NASDAQ    ',58,'Consumer Services',910403968),(126,'MLAN','Midland Co','Property & Casualty Insurance','N/A','NASDAQ    ',57.82,'Finance',847852032),(127,'SLGN','Silgan Holdings Inc','Packaging & Containers','N/A','NASDAQ    ',57.56,'Basic Industries',2834808064),(128,'USTR','United Stationers Inc','Wholesale, Other','N/A','NASDAQ    ',57.44,'Consumer Services',4622111744),(129,'CENX','Century Aluminum Co','Aluminum','N/A','NASDAQ    ',57.14,'Basic Industries',1717305984),(130,'CMTL','Comtech Telecommunications Corp','Communication Equipment','N/A','NASDAQ    ',57,'Technology',445684000),(131,'PCAR','Paccar Inc','Trucks & Other Vehicles','S&P 500','NASDAQ    ',56.64,'Capital Goods',16135100416),(132,'ICLR','ICON Plc Depository Receipt','Research Services','N/A','NASDAQ    ',56.48,'Consumer Services',532801984),(133,'STOSY','Santos ADR','Independent Oil & Gas','N/A','NASDAQ    ',56.19,'N/A',2369370112),(134,'VITL','Vital Signs Inc','Medical Instruments & Supplies','N/A','NASDAQ    ',55.96,'Health Care',200646000),(135,'SRCL','Stericycle Inc','Waste Management','N/A','NASDAQ    ',55.88,'Capital Goods',855857984),(136,'AAWW','Atlas Air Worldwide Holdings Inc','Air Services, Other','N/A','NASDAQ    ',55.78,'Transportation',1501752960),(137,'PXSL','Pharmaxis Depository Receipt','Drug Manufacturers - Other','N/A','NASDAQ    ',55.74,'N/A',185230),(138,'MYGN','Myriad Genetics Inc','Diagnostic Substances','N/A','NASDAQ    ',55.71,'Health Care',157126000),(139,'ENSI','Energysouth Inc','Gas Utilities','N/A','NASDAQ    ',55.7,'Energy',131175000),(140,'SINA','SINA Corp','Internet Software & Services','N/A','NASDAQ    ',55.7,'N/A',223552992),(141,'ATPG','ATP Oil & Gas Corporation','Independent Oil & Gas','N/A','NASDAQ    ',55.67,'Energy',544190976),(142,'GMRK','GulfMark Offshore Inc','Oil & Gas Equipment & Services','N/A','NASDAQ    ',55.67,'N/A',284667008),(143,'TONS','Novamerican Steel Inc','Steel & Iron','N/A','NASDAQ    ',55.25,'Basic Industries',795705024),(144,'LAYN','Layne Christensen Co','Heavy Construction','N/A','NASDAQ    ',55.17,'Capital Goods',798364032),(145,'LRCX','Lam Research Corp','Semiconductor Equipment & Materials','N/A','NASDAQ    ',54.97,'Technology',2413652992),(146,'NNDS','NDS GROUP PLC','CATV Systems','N/A','NASDAQ    ',54.7,'Technology',709491968),(147,'ATLS','Atlas America Inc','Oil & Gas Drilling & Exploration','N/A','NASDAQ    ',54.61,'Energy',821817984),(148,'FCBP','First Cmnty Bancp Ord Shs','Regional - Pacific Banks','N/A','NASDAQ    ',54.61,'Finance',347512992),(149,'FISV','Fiserv Inc','Business Software & Services','S&P 500','NASDAQ    ',54.6,'Technology',4652335104),(150,'SIGM','Sigma Designs Inc','Semiconductor - Specialized','N/A','NASDAQ    ',54.58,'Technology',134847008),(151,'LAMR','Lamar Advertising Co','Marketing Services','N/A','NASDAQ    ',54.48,'Consumer Services',1169591040),(152,'REXMY','Rexam Depository Receipt','Packaging & Containers','N/A','NASDAQ    ',54.36,'N/A',6820633088),(153,'HWAY','Healthways Inc','Specialized Health Services','N/A','NASDAQ    ',54.25,'Health Care',560112000),(154,'MAFB','MAF Bancorp Inc','N/A','N/A','NASDAQ    ',54.25,'N/A',586451968),(155,'NDSN','Nordson Corp','Diversified Machinery','N/A','NASDAQ    ',54.23,'Capital Goods',944393024),(156,'CHRW','CH Robinson Worldwide Inc','Air Delivery & Freight Services','N/A','NASDAQ    ',53.99,'Transportation',6855133184),(157,'JOYG','Joy Global Inc','Farm & Construction Machinery','N/A','NASDAQ    ',53.99,'Capital Goods',2500723968),(158,'CHDN','Churchill Downs Inc','Gaming Activities','N/A','NASDAQ    ',53.79,'Consumer Services',376112000),(159,'KLAC','KLA Tencor Corp','Semiconductor Equipment & Materials','S&P 500','NASDAQ    ',53.66,'Technology',2731228928),(160,'CRAI','CRA International Inc','Management Services','N/A','NASDAQ    ',53.4,'Finance',382264000),(161,'ALEX','Alexander & Baldwin Inc','Shipping','N/A','NASDAQ    ',53.28,'Transportation',1639399936),(162,'BOKF','BOK Financial Corp','Regional - Southwest  Banks','N/A','NASDAQ    ',52.97,'Finance',1085665024),(163,'PLMD','PolyMedica Corp','Drug Manufacturers - Other','N/A','NASDAQ    ',52.92,'Health Care',710222976),(164,'VLGEA','Village SuperMkt Ord Shs','Grocery Stores','N/A','NASDAQ    ',52.83,'Consumer Services',1046435008),(165,'SRDX','SurModics, Inc','Diagnostic Substances','N/A','NASDAQ    ',52.45,'Health Care',69437000),(166,'CYTC','Cytyc Corp','Medical Instruments & Supplies','N/A','NASDAQ    ',52.31,'Health Care',675033984),(167,'SYNA','Synaptics Inc','Business Software & Services','N/A','NASDAQ    ',52.1,'Technology',266787008),(168,'PRAA','Portfolio Recovery Associates Inc','Business Services','N/A','NASDAQ    ',52.06,'Finance',205579008),(169,'AIRM','Air Methods Corp','Air Services, Other','N/A','NASDAQ    ',52.04,'Health Care',340188992),(170,'COLM','Columbia Sportswear Co','Textile - Apparel Clothing','N/A','NASDAQ    ',52.01,'Consumer Non-Durables',1324108032),(171,'IBKC','IBERIABANK Corp','Regional - Southeast Banks','N/A','NASDAQ    ',51.98,'Finance',210828000),(172,'INFY','Infosys Technologies Ltd','Technical & System Software','N/A','NASDAQ    ',51.8,'Technology',3633999872),(173,'WFMI','Whole Foods Market Inc','Grocery Stores','S&P 500','NASDAQ    ',51.72,'Consumer Services',6139378176),(174,'COGN','COGNOS INC','Application Software','N/A','NASDAQ    ',51.57,'Technology',1025089344),(175,'PLPC','Preformed Line Products Co','Heavy Construction','N/A','NASDAQ    ',51.55,'Technology',228488000),(176,'ZUMZ','Zumiez Inc','Apparel Stores','N/A','NASDAQ    ',51.55,'Consumer Non-Durables',345400992),(177,'RESP','Respironics Inc','Medical Appliances & Equipment','N/A','NASDAQ    ',51.52,'Health Care',1195035008),(178,'SIAL','Sigma-Aldrich Corp','Specialty Chemicals','S&P 500','NASDAQ    ',51.45,'Basic Industries',1909299968),(179,'EMITF','Elbit Medical Imaging Ltd','Medical Instruments & Supplies','N/A','NASDAQ    ',51.41,'N/A',540944576),(180,'WABC','Westamerica Bancorp','Regional - Pacific Banks','N/A','NASDAQ    ',51.41,'Finance',240884992),(181,'JASO','JA Solar Holdings Co Ltd','Semiconductor - Specialized','N/A','NASDAQ    ',51.34,'N/A',184958096),(182,'ADVS','Advent Software Inc','Application Software','N/A','NASDAQ    ',51.23,'Technology',196432000),(183,'OFIX','Orthofix International NV','Medical Appliances & Equipment','N/A','NASDAQ    ',51.09,'Health Care',439876000),(184,'ADSK','Autodesk Inc','Technical & System Software','S&P 500','NASDAQ    ',51,'Technology',1988700032),(185,'EBIX','Ebix Inc','Business Software & Services','N/A','NASDAQ    ',51,'Technology',35408000),(186,'XNPT','XenoPort Inc','Biotechnology','N/A','NASDAQ    ',50.99,'Health Care',58848000),(187,'VALU','Value Line Inc','Asset Management','N/A','NASDAQ    ',50.79,'Finance',83045000),(188,'CTRP','Ctrip.com','Consumer Services','N/A','NASDAQ    ',50.74,'Consumer Services',127007104),(189,'SIVB','SVB Financial Group','Regional - Pacific Banks','N/A','NASDAQ    ',50.57,'Finance',420800992),(190,'HLND','Hiland Partners LP','Oil & Gas Drilling & Exploration','N/A','NASDAQ    ',50.5,'Energy',241208000),(191,'EXPD','Expeditors International','Air Delivery & Freight Services','N/A','NASDAQ    ',50.22,'Transportation',4849613824),(192,'KCLI','Kansas City Life Insurance Co','Life Insurance','N/A','NASDAQ    ',50.19,'Finance',447531008),(193,'PHRM','Pharmion Corp','Drug Manufacturers - Other','N/A','NASDAQ    ',50.16,'Health Care',250204992),(194,'AVTR','Avatar Holdings Inc','Residential Construction','N/A','NASDAQ    ',50,'Finance',682876032),(195,'CLMT','Calumet Specialty Products Partners LP','Oil & Gas Refining & Marketing','N/A','NASDAQ    ',49.99,'Energy',1586268032),(196,'DRIV','Digital River Inc','Internet Software & Services','N/A','NASDAQ    ',49.96,'Technology',328199008),(197,'BOOM','Dynamic Materials Corp','Industrial Metals & Minerals','N/A','NASDAQ    ',49.9,'Basic Industries',128091000),(198,'RATE','Bankrate Inc','Internet Information Providers','N/A','NASDAQ    ',49.77,'Consumer Services',85703000),(199,'NGPS','NovAtel Inc','Scientific & Technical Instruments','N/A','NASDAQ    ',49.69,'Technology',82281288),(200,'FSCI','Fisher Communications Inc','Broadcasting - TV','N/A','NASDAQ    ',49.43,'Consumer Services',158970000),(201,'SEB','Seaboard Corp','Meat Products','N/A','AMEX      ',1880,'Consumer Non-Durables',2854254080),(202,'NVR','NVR Inc','Residential Construction','N/A','AMEX      ',466.81,'Consumer Durables',5619184128),(203,'WSC','Wesco Financial Corp','Rental & Leasing Services','N/A','AMEX      ',403,'Finance',607865984),(204,'ATF','Equity Income Fund First Exchange','Closed-End Fund - Equity','N/A','AMEX      ',130.39,'N/A',26769000),(205,'USM','United States Cellular Corp','Wireless Communications','N/A','AMEX      ',97.96,'Public Utilities',3696962048),(206,'BIO','Bio Rad Class A Ord Shs','Scientific & Technical Instruments','N/A','AMEX      ',96.68,'Health Care',1309467008),(207,'PRK','Park National Corp','Regional - Midwest Banks','N/A','AMEX      ',90.5,'Finance',364326016),(208,'BTI','Brit Am Tobacco Series A ADR','Cigarettes','N/A','AMEX      ',71.81,'Consumer Non-Durables',19694780416),(209,'TDS','Telephone and Da Ord Shs','Wireless Communications','N/A','AMEX      ',69.15,'Public Utilities',4586144768),(210,'CTO','Consolidated Tomoka Land Co','Real Estate Development','N/A','AMEX      ',68.71,'Finance',40526000),(211,'TDS.S','Telephone and Da Special Ord Shs','N/A','N/A','AMEX      ',66.2,'Consumer Services',0),(212,'PSB','PS Business Parks Series A Ord Shs','REIT - Retail','N/A','AMEX      ',61.8,'Finance',257395008),(213,'LAQ','Latin America Equity Fund Inc','N/A','N/A','AMEX      ',59.8,'N/A',0),(214,'MWP','MarkWest Hydrocarbon Inc','Oil & Gas Equipment & Services','N/A','AMEX      ',59.6,'Energy',697036032),(215,'IMA','Inverness Medical Innovations Inc','Scientific & Technical Instruments','N/A','AMEX      ',58.03,'Health Care',615864000),(216,'AIP','American Israeli Paper Mills Ltd','Paper & Paper Products','N/A','AMEX      ',57.7,'N/A',136204496),(217,'NHC','National HealthCare Corp','Long-Term Care Facilities','N/A','AMEX      ',54.65,'Health Care',581788032),(218,'IMO','IMPERIAL OIL LTD','Oil & Gas Refining & Marketing','N/A','AMEX      ',50.7,'Energy',25198829568),(219,'BKR','Michael Baker Corp','Management Services','N/A','AMEX      ',50.01,'Capital Goods',712510016),(220,'GHM','Graham Corp','Metal Fabrication','N/A','AMEX      ',50,'Capital Goods',71201000),(221,'FTK','Flotek Industries Inc','Specialty Chemicals','N/A','AMEX      ',49.25,'Capital Goods',135348992),
(222,'BTJ','Bolt Technology Corp','Oil & Gas Equipment & Services','N/A','AMEX      ',47.75,'Capital Goods',50464000),(223,'CUB','Cubic Corp','Scientific & Technical Instruments','N/A','AMEX      ',46.46,'Capital Goods',871476992),(224,'MCF','Contango Oil & Gas Co','Independent Oil & Gas','N/A','AMEX      ',44.44,'Energy',18688000),(225,'CEP','Constellation Energy Partners LLC','Oil & Gas Drilling & Exploration','N/A','AMEX      ',42.5,'N/A',40408000),(226,'LNG','Cheniere Energy Inc','Oil & Gas Drilling & Exploration','N/A','AMEX      ',40.2,'Energy',1152000),(227,'TMP','Tompkins Financial Corp','Regional - Northeast Banks','N/A','AMEX      ',39.98,'Finance',127365000),(228,'TSH','Teche Holdings Company','Savings & Loans','N/A','AMEX      ',39.61,'Finance',42234000),(229,'SA','Seabridge Gold Inc','Gold','N/A','AMEX      ',38.73,'Basic Industries',0),(230,'GRC','Gorman-Rupp Co','Diversified Machinery','N/A','AMEX      ',38.3,'Capital Goods',290025984),(231,'BMI','Badger Meter Inc','Scientific & Technical Instruments','N/A','AMEX      ',36.48,'Technology',227748992),(232,'PLX','Protalix BioTherapeutics Inc','Biotechnology','N/A','AMEX      ',36.01,'Consumer Services',0),(233,'DIT','Amcon Distributing Co','Food Wholesale','N/A','AMEX      ',36,'Consumer Services',849180992),(234,'CAC','Camden National Corp','Regional - Northeast Banks','N/A','AMEX      ',34.6,'Finance',109313000),(235,'SAL','Salisbury Bancorp Inc','Savings & Loans','N/A','AMEX      ',32.8,'N/A',25277000),(236,'BHB','Bar Harbor Bankshares','Regional - Northeast Banks','N/A','AMEX      ',32.28,'Finance',49093000),(237,'AE','Adams Resources & Energy Inc','Basic Materials Wholesale','N/A','AMEX      ',31.15,'Energy',2219688960),(238,'ESC','Emeritus Corp','Long-Term Care Facilities','N/A','AMEX      ',30.8,'Health Care',438278016),(239,'MAM','Maine & Maritimes Corp','Electric Utilities','N/A','AMEX      ',30.73,'Public Utilities',37002000),(240,'JST','Jinpan International Ltd','Diversified Electronics','N/A','AMEX      ',30.32,'Capital Goods',87509752),(241,'MLP','Maui Land & Pineapple Co','Processed & Packaged Goods','N/A','AMEX      ',30.04,'Consumer Non-Durables',186036992),(242,'FRS','Frisch\'s Restaurants Inc','Restaurants','N/A','AMEX      ',30,'N/A',289934016),(243,'IOC','Interoil Ord Shs','Oil & Gas Refining & Marketing','N/A','AMEX      ',30,'Energy',552553920),(244,'GGN','Gabelli Global Gold Natural Resources & Income Trust','N/A','N/A','AMEX      ',29.65,'N/A',0),(245,'TA','TravelCenters of America LLC','Auto Parts Stores','N/A','AMEX      ',29.59,'N/A',4983744000),(246,'UTL','Unitil Corp','Diversified Utilities','N/A','AMEX      ',28.85,'Public Utilities',266732000),(247,'CET','Central Securities Corp (United States)','Closed-End Fund - Equity','N/A','AMEX      ',28.81,'N/A',11466000),(248,'GTU','Central Gold Trust','Closed-End Fund - Equity','N/A','AMEX      ',28.65,'N/A',4249000),(249,'RIV','Riviera Holdings Corp','Resorts & Casinos','N/A','AMEX      ',28.02,'Consumer Services',202510000),(250,'ETF','Emerging Markets Telecommunications Fund Inc (The)','N/A','N/A','AMEX      ',27.9,'N/A',0),(251,'ERH','Evergreen Utilities and High Income Fund','N/A','N/A','AMEX      ',27.75,'N/A',0),(252,'AFP','United Capital Corp','Industrial Equipment & Components','N/A','AMEX      ',26.5,'Finance',50844000),(253,'FEN','Energy Income and Growth Fund','Closed-End Fund - Equity','N/A','AMEX      ',26.42,'N/A',0),(254,'UTG','Reaves Utility Income Fund','Closed-End Fund - Equity','N/A','AMEX      ',26.1,'N/A',0),(255,'GEL','Genesis Energy LP','Oil & Gas Pipelines','N/A','AMEX      ',25.65,'N/A',806003968),(256,'STF','Merrill Lynch 9% Strides Linked to Caterpillar 24-09-2009','N/A','N/A','AMEX      ',25.6,'N/A',0),(257,'PHX','Panhandle Oil and Gas Inc','Independent Oil & Gas','N/A','AMEX      ',25.3,'Energy',37199000),(258,'CML','Compellent Technologies Inc','N/A','N/A','AMEX      ',24.87,'N/A',0),(259,'CVF','Castle Convertible Fund','Closed-End Fund - Debt','N/A','AMEX      ',24.85,'N/A',2163000),(260,'RAP','RMR Asia Pacific Real Estate Fund','Closed-End Fund - Equity','N/A','AMEX      ',24.77,'N/A',0),(261,'GOK','Geokinetics Inc','Oil & Gas Equipment & Services','N/A','AMEX      ',24.62,'Energy',324907008),(262,'LXU','LSB Industries Ord Shs','General Building Materials','N/A','AMEX      ',24.48,'Basic Industries',551844992),(263,'APO','American Community Properties Trust','Real Estate Development','N/A','AMEX      ',24.4,'Finance',94885000),(264,'CVR','Chicago Rivet & Machine Co','Auto Manufacturers - Major','N/A','AMEX      ',24.25,'N/A',38449000),(265,'NDD','Neuberger Berman Dividend Advantage Fund Inc','N/A','N/A','AMEX      ',23.89,'N/A',0),(266,'NHR','National Health Realty  Inc','REIT - Healthcare Facilities','N/A','AMEX      ',23.8,'Finance',20090000),(267,'SRQ','DWS RREEF Real Estate Fund','Closed-End Fund - Debt','N/A','AMEX      ',23.74,'N/A',0),(268,'MBR','Mercantile Bp Ord Shs','Regional - Midwest Banks','N/A','AMEX      ',23.65,'Finance',87560000),(269,'SLI','SL Industries Inc','Diversified Electronics','N/A','AMEX      ',23.49,'Technology',195431008),(270,'IIG','Imergent Inc','Internet Software & Services','N/A','AMEX      ',23.44,'Consumer Services',151616992),(271,'JRS','Nuveen Real Estate Income Fund','Closed-End Fund - Debt','N/A','AMEX      ',23.25,'N/A',0),(272,'MSL','Midsouth Bancorp Inc','Regional - Southeast Banks','N/A','AMEX      ',23.25,'Finance',54255000),(273,'ISL','First Israel Fund','N/A','N/A','AMEX      ',23.14,'N/A',0),(274,'ESP','Espey Manufacturing & Electronics Corp','Diversified Electronics','N/A','AMEX      ',23,'Capital Goods',27656000),(275,'UUU','Universal Security Instruments Inc','Electronics Wholesale','N/A','AMEX      ',22.81,'Consumer Services',40741000),(276,'GLU','Gabelli Global Utility & Income Trust','N/A','N/A','AMEX      ',22.7,'N/A',0),(277,'SHM','MS    13.250 03/20/07 MTN MATd','N/A','N/A','AMEX      ',22.49,'N/A',0),(278,'CH','Chile Fund Inc','Closed-End Fund - Foreign','N/A','AMEX      ',22.3,'N/A',4520000),(279,'BCV','Bancroft Fund Ltd','Closed-End Fund - Debt','N/A','AMEX      ',21.74,'N/A',5910000),(280,'ADY','American Dairy Inc','Dairy Products','N/A','AMEX      ',21.5,'N/A',148316992),(281,'SIL','Apex Silver Mines Ltd','Silver','N/A','AMEX      ',21.22,'Basic Industries',24660000),(282,'UNB','Union Bankshares Inc','Regional - Northeast Banks','N/A','AMEX      ',21.15,'Finance',25890000),(283,'GLV','Clough Global Allocation Fund','N/A','N/A','AMEX      ',21.13,'N/A',0),(284,'RVR','White River Capital Inc','Credit Services','N/A','AMEX      ',21,'N/A',58497000),(285,'WLB','Westmoreland Ord Shs','Industrial Metals & Minerals','N/A','AMEX      ',21,'Energy',509564000),(286,'CCF','Chase Corp (United States)','Industrial Equipment & Components','N/A','AMEX      ',20.75,'Basic Industries',124529000),(287,'EML','Eastern Co','Small Tools & Accessories','N/A','AMEX      ',20.6,'Basic Industries',167428000),(288,'GLQ','Clough Global Equity Fund','N/A','N/A','AMEX      ',20.41,'N/A',0),(289,'HTC','Hungarian Telephone and Cable Corp','Diversified Communication Services','N/A','AMEX      ',19.9,'Public Utilities',243026000),(290,'SIF','Sifco Industries','Aerospace/Defense Products & Services','N/A','AMEX      ',19.68,'Basic Industries',85017000),(291,'CQP','Cheniere Energy Partners L P','Oil & Gas Pipelines','N/A','AMEX      ',19.23,'Public Utilities',0),(292,'NG','NOVAGOLD RESOURCES INC','Gold','N/A','AMEX      ',19.1,'Basic Industries',7873106),(293,'BHV','Blackrock Virginia Municipal Bond Trust','N/A','N/A','AMEX      ',19.07,'N/A',0),(294,'DRY','Coinmach Service Units','N/A','N/A','AMEX      ',19,'Consumer Services',0),(295,'NGS','Natural Gas Services Group Inc','Oil & Gas Equipment & Services','N/A','AMEX      ',19,'Energy',68029000),(296,'RHR','RMR Hospitality and Real Estate Fund','N/A','N/A','AMEX      ',19,'N/A',0),(297,'RFR','RMR F.I.R.E. Fund','N/A','N/A','AMEX      ',18.73,'N/A',0),(298,'OTT','Otelco Inc','Diversified Communication Services','N/A','AMEX      ',18.7,'N/A',68806000),(299,'SGB','Southwest Georgia Financial Corp','Regional - Mid-Atlantic Banks','N/A','AMEX      ',18.65,'Finance',16283000),(300,'IAF','Aberdeen Australia Equity Fund Inc','N/A','N/A','AMEX      ',18.64,'N/A',0),(301,'BHO','B&H Ocean Carriers Ltd','Shipping','N/A','AMEX      ',18.5,'N/A',106360000),(302,'BQY','BlackRock S&P Quality Rankings Global Equity Managed Trust','N/A','N/A','AMEX      ',18.43,'N/A',0),(303,'AQQ','American Spectrum Realty Inc','REIT - Retail','N/A','AMEX      ',18,'Finance',29408000),(304,'SRO','DWS RREEF Real Estate Fund II','Closed-End Fund - Debt','N/A','AMEX      ',17.87,'N/A',0),(305,'GLO','Clough Global Opportunities Fund','N/A','N/A','AMEX      ',17.84,'N/A',0),(306,'BLJ','Blackrock New Jersey Municipal Bond Trust','N/A','N/A','AMEX      ',17.8,'N/A',0),(307,'FSP','Franklin Street Properties Corp','REIT - Diversified','N/A','AMEX      ',17.75,'Finance',128962000),(308,'RCH','China Architectural Engineering Inc','General Contractors','N/A','AMEX      ',17.6,'N/A',70773000),(309,'FRH.U','Freedom Acquisition Units','Diversified Investments','N/A','AMEX      ',17.35,'N/A',0),(310,'DLA','Delta Apparel Inc','Textile - Apparel Clothing','N/A','AMEX      ',17.04,'Consumer Non-Durables',312438016),(311,'ACY','Aerocentury Corp','Rental & Leasing Services','N/A','AMEX      ',16.99,'Finance',18028000),(312,'JPK','Morgan Stanley Performance Leveraged Upside Redeemable for C','N/A','N/A','AMEX      ',16.77,'N/A',0),(313,'PMD','Psychemedics Corp','Medical Laboratories & Research','N/A','AMEX      ',16.7,'Health Care',24391000),(314,'DXR','Daxor Corp','Medical Instruments & Supplies','N/A','AMEX      ',16.59,'Consumer Non-Durables',1807000),(315,'UUY','Merrill Lynch Pref Shs Select Utilities Index','N/A','N/A','AMEX      ',16.52,'N/A',0),(316,'EVV','Eaton Vance Limited Duration Income Fund','Closed-End Fund - Debt','N/A','AMEX      ',16.5,'N/A',211076000),(317,'ERC','Evergreen Multi Sector Income Fund','Closed-End Fund - Debt','N/A','AMEX      ',16.28,'N/A',0),(318,'FCM','First Trust/Four Corners Senior Floating Rate Income Fund','N/A','N/A','AMEX      ',16.25,'N/A',0),(319,'NRO','Neuberger Berman Real Estate Securities Income Fund Inc','Closed-End Fund - Debt','N/A','AMEX      ',16.24,'N/A',0),(320,'NMZ','Nuveen Municipal High Income Opportunity Fund','N/A','N/A','AMEX      ',16.19,'N/A',0),(321,'CPD','Caraco Pharmaceutical Laboratories Ltd','Drugs - Generic','N/A','AMEX      ',16.15,'Consumer Non-Durables',127676000),(322,'MEH','Midwest Air Group Inc','Regional Airlines','N/A','AMEX      ',16.15,'Transportation',697177984),(323,'BWL.A','Bowl America Ord Shs','Sporting Activities','N/A','AMEX      ',16.05,'N/A',31975000),(324,'CVP','Centerplate Units','Diversified Investments','N/A','AMEX      ',16.05,'N/A',703088000),(325,'BZM','Blackrock Maryland Municipal Bond Trust','N/A','N/A','AMEX      ',16.04,'N/A',0),(326,'UTK','UTEK Corp','Business Services','N/A','AMEX      ',16,'Technology',36423000),(327,'HEM','HemoSense Inc','Medical Instruments & Supplies','N/A','AMEX      ',15.92,'Health Care',28131000),(328,'BLE','BlackRock Municipal Income Trust II','Closed-End Fund - Debt','N/A','AMEX      ',15.69,'N/A',0),(329,'RZ','Raser Technologies Inc','Industrial Electrical Equipment','N/A','AMEX      ',15.6,'N/A',208000),(330,'CRF','Cornerstone Total Return Fund Inc','N/A','N/A','AMEX      ',15.55,'N/A',0),(331,'FRN','Friendly Ice Cream Corp','N/A','N/A','AMEX      ',15.51,'N/A',528727008),(332,'NXZ','Nuveen Dividend Advantage Municipal Fund 2','Closed-End Fund - Debt','N/A','AMEX      ',15.45,'N/A',0),(333,'VCF','Delaware Investments Colorado Insured Municipal Income Fund','N/A','N/A','AMEX      ',15.4,'N/A',0),(334,'BRN','Barnwell Industries Inc','Independent Oil & Gas','N/A','AMEX      ',15.35,'Energy',45989000),(335,'SVT','Servotronics Inc','Industrial Electrical Equipment','N/A','AMEX      ',15.3,'Capital Goods',27287000),(336,'EIM','Eaton Vance Insured Municipal Bond Fund','Closed-End Fund - Debt','N/A','AMEX      ',15.28,'N/A',0),(337,'BPS','Blackrock Pennsylvania Strategic Municipal Trust Fund','N/A','N/A','AMEX      ',15.25,'N/A',0),(338,'BCL','BlackRock California Municipal Income Trust II','N/A','N/A','AMEX      ',15.21,'N/A',0),(339,'SEA','Star Maritime Acquisition Corp','Diversified Investments','N/A','AMEX      ',15.21,'N/A',0),(340,'VMV','Van Kampen Massachusetts Value Municipal','N/A','N/A','AMEX      ',15.2,'N/A',0),(341,'BCT','Blackrock Broad Investment Grade 2009 TM Trust','N/A','N/A','AMEX      ',15.1,'N/A',0),(342,'AZS','Arizona Star Resource Corp','Gold','N/A','AMEX      ',15.03,'Basic Industries',0),(343,'TF','Thai Capital Fund Inc','N/A','N/A','AMEX      ',15,'N/A',0),(344,'HWK','Hawk Corp','Aerospace/Defense Products & Services','N/A','AMEX      ',14.95,'Capital Goods',222844000),(345,'RMR','RMR Real Estate Fund','N/A','N/A','AMEX      ',14.92,'N/A',0),(346,'EIV','Eaton Vance Insured Municipal Bond Fund II','N/A','N/A','AMEX      ',14.9,'N/A',0),(347,'ACU','Acme United Corp','Office Supplies','N/A','AMEX      ',14.85,'Health Care',58862000),(348,'MAB','Eaton Vance Insured Massachusets Municipal Bond Fund','N/A','N/A','AMEX      ',14.85,'N/A',0),(349,'EMJ','Eaton Vance Insured New Jersey Municipal Bond Fund','N/A','N/A','AMEX      ',14.82,'N/A',0),(350,'BFY','BlackRock New York Municipal Income Trust II','N/A','N/A','AMEX      ',14.74,'N/A',0),(351,'EVM','Eaton Vance Insured California Municipal Bond Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.7,'N/A',0),(352,'MHJ','Man Sang Holdings Inc','Wholesale, Other','N/A','AMEX      ',14.68,'Consumer Services',51716140),(353,'MVG','MAG Silver Corp','Silver','N/A','AMEX      ',14.65,'Basic Industries',0),(354,'RDR','RMR Preferred Dividend Fund','N/A','N/A','AMEX      ',14.65,'N/A',0),(355,'ENX','Eaton Vance Insured New York Municipal Bond Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.6,'N/A',0),(356,'NUJ','Nuveen New Jersey Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14.53,'N/A',0),(357,'EVY','Eaton Vance New York Municipal Income Trust Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.52,'N/A',8166000),(358,'NEA','Nuveen Insured Tax Free Advantage Municipal Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.51,'N/A',0),(359,'NFC','Nuveen Connecticut Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14.51,'N/A',0),(360,'NXK','Nuveen NY Div Advantage Muni Fund Closed Fund','N/A','N/A','AMEX      ',14.49,'N/A',0),(361,'NNB','Nuveen Virginia Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14.47,'N/A',0),(362,'NKR','Nuveen Arizona Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14.35,'N/A',0),(363,'NMB','Nuveen Mass Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14.35,'N/A',0),(364,'NOX','Neuberger Berman Income Opportunity Fund Inc','N/A','N/A','AMEX      ',14.32,'N/A',0),(365,'NYH','Eaton Vance Insured New York Municipal Bond Fund II','N/A','N/A','AMEX      ',14.28,'N/A',0),(366,'MMV','Eaton Vance Massachusetts Municipal Income Trust Fund','N/A','N/A','AMEX      ',14.27,'N/A',0),(367,'MCX','MC Shipping Inc','N/A','N/A','AMEX      ',14.25,'N/A',64268000),(368,'NKX','Nuveen Insured California Tax Free Advantage Municipal Fund','N/A','N/A','AMEX      ',14.23,'N/A',0),(369,'EIA','Eaton Vance Insured California Municipal Bond Fund II','N/A','N/A','AMEX      ',14.21,'N/A',0),(370,'NGB','Nuveen Virginia Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14.13,'N/A',0),(371,'NGX','Nuveen Insured Massachusetts Tax Free Advantage Municipal Fu','N/A','N/A','AMEX      ',14.1,'N/A',0),(372,'NVJ','Nuveen Ohio Dividend Advantage Municipal Fund 3','N/A','N/A','AMEX      ',14.1,'N/A',0),(373,'NKL','Nuveen Insured California Dividend Advantage Municipal Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.07,'N/A',0),(374,'NZF','Nuveen Dividend Advantage Municipal Fund 3','Closed-End Fund - Debt','N/A','AMEX      ',14.02,'N/A',0),(375,'CEV','Eaton Vance California Municipal Income Trust Fund','Closed-End Fund - Debt','N/A','AMEX      ',14.01,'N/A',0),(376,'NKG','Nuveen Georgia Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',14,'N/A',0),(377,'NOM','Nuveen Missouri Premium Income Municipal Fund','N/A','N/A','AMEX      ',14,'N/A',0),(378,'NRK','Nuveen Insured New York Tax Free Advantage Municipal Fund','N/A','N/A','AMEX      ',14,'N/A',0),(379,'NZW','Nuveen Michigan Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',14,'N/A',0),(380,'IF','Indonesia Fund Inc','N/A','N/A','AMEX      ',13.97,'N/A',0),(381,'MIW','Eaton Vance Insured Michigan Municipal Bond Fund','N/A','N/A','AMEX      ',13.95,'N/A',0),(382,'NKO','Nuveen Insured New York Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.95,'N/A',0),(383,'NVG','Nuveen Insured Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.95,'N/A',0),(384,'NZR','Nuveen Maryland Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',13.93,'N/A',0),(385,'NFM','Nuveen Maryland Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.89,'N/A',0),(386,'MYH','MS     9.000 12/20/07 \'07 MTN','N/A','N/A','AMEX      ',13.82,'N/A',0),(387,'NII','Nuveen North Carolina Dividend Advantage Municipal Fund 3','N/A','N/A','AMEX      ',13.81,'N/A',0),(388,'SCB','Community Bankshares Inc (South Carolina)','Regional - Mid-Atlantic Banks','N/A','AMEX      ',13.81,'N/A',38522000),(389,'EVJ','Eaton Vance New Jersey Municipal Income Trust Fund','N/A','N/A','AMEX      ',13.79,'N/A',0),(390,'NVY','Nuveen Pennsylvania Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',13.77,'N/A',0),(391,'NXI','Nuveen Ohio Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.75,'N/A',0),(392,'NBJ','Nuveen Ohio Dividend Advantage Municipal Fund 2','N/A','N/A','AMEX      ',13.74,'N/A',0),(393,'NXJ','Nuveen New Jersey Dividend Advantage Municipal Fund','N/A','N/A','AMEX      ',13.68,'N/A',0),(394,'EIO','Eaton Vance Insured Ohio Municipal Bond Fund','N/A','N/A','AMEX      ',13.66,'N/A',0),(395,'NXE','Nuveen Arizona Dividend Advantage Municipal Fund 3','N/A','N/A','AMEX      ',13.65,'N/A',0),(396,'NVX','Nuveen California Dividend Advantage Muni Fund 2','N/A','N/A','AMEX      ',13.64,'N/A',0),(397,'VMM','Delaware Investments Minnesota Municipal Income Fund II','N/A','N/A','AMEX      ',13.6,'N/A',0),(398,'EIF','Eaton Vance Insured Florida Municipal Bond Fund','N/A','N/A','AMEX      ',13.59,'N/A',0),(399,'JAX','J Alexander\'s Corp','Restaurants','N/A','AMEX      ',13.54,'Consumer Services',140346000),(400,'MZA','BlackRock MuniYield Arizona Fund Inc','N/A','N/A','AMEX      ',13.52,'N/A',0),(401,'BRK.A','Berkshire Hatha Class A Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',127500,'N/A',111856001024),(402,'BRK.B','Berkshire Hatha Class B Ord Shs','N/A','N/A','NYSE      ',4257,'N/A',0),(403,'WPO','Washington Post Co','Publishing-Newspapers','N/A','NYSE      ',808.85,'Consumer Services',4019986944),(404,'CME','CME Group Inc','Business Services','N/A','NYSE      ',629.55,'Finance',1217361024),(405,'WTM','White Mountains Insurance Group Ltd','Property & Casualty Insurance','N/A','NYSE      ',561.95,'Finance',4912200192),(406,'MKL','Markel Corp','Property & Casualty Insurance','N/A','NYSE      ',521.63,'Finance',2563440896),(407,'ALX','Alexander\'s Inc','Property Management','N/A','NYSE      ',413.83,'Finance',207362000),(408,'Y','Alleghany Corp','Property & Casualty Insurance','N/A','NYSE      ',410.54,'Finance',1336125952),(409,'RTP','Rio Tinto ADR','Steel & Iron','N/A','NYSE      ',375.79,'Basic Industries',23899000832),(410,'AW-D','Allied Waste Ind Conv Pref','N/A','N/A','NYSE      ',340.15,'N/A',0),(411,'SGP-B','SGP    6.000 08/13/10 CVT','N/A','N/A','NYSE      ',283.22,'N/A',0),(412,'PTR','Petrochina Depository Receipt','Major Integrated Oil & Gas','N/A','NYSE      ',242.15,'N/A',100520296448),(413,'FFH','Fairfax Finl Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',236.3,'Finance',6381948416),(414,'GS','Goldman Sachs Ord Shs','Investment Brokerage - National','S&P 500','NYSE      ',234.31,'Finance',84560003072),(415,'SQM','Sociedad Quimica y Minera de Chile Rep 10 B Ord Shs ADR','Synthetics','N/A','NYSE      ',202.9,'Basic Industries',1096953984),(416,'CEO','CNOOC ADR representing 100 Class H Shares','Independent Oil & Gas','N/A','NYSE      ',192.34,'N/A',11025370112),(417,'PKX','Posco Depository Receipt','Steel & Iron','N/A','NYSE      ',186.83,'N/A',28143020032),(418,'STU','Student Loan Corp','Credit Services','N/A','NYSE      ',186,'Finance',1596326016),(419,'BLK','Blackrock Inc','Investment Brokerage - Regional','N/A','NYSE      ',183.62,'Finance',3443980032),(420,'SQA.A','Sequa Class A Ord Shs','Aerospace/Defense - Major Diversified','N/A','NYSE      ',170.59,'N/A',2180626944),(421,'FCX-M','FCX    6.750 05/01/10 CVT','N/A','N/A','NYSE      ',169.92,'N/A',0),(422,'SNP','China Petroleum and Chemical (Sinopec) ADR Repstng 100 H Ord','Independent Oil & Gas','N/A','NYSE      ',168.22,'N/A',152426496000),(423,'FLR','Fluor Corp','Heavy Construction','S&P 500','NYSE      ',164.51,'Capital Goods',14860539904),(424,'MA','MasterCard Inc','Business Services','N/A','NYSE      ',163.65,'Finance',3653193984),(425,'ICE','IntercontinentalExchange Inc','Business Services','N/A','NYSE      ',162.26,'Finance',453188000),(426,'IPS','IPSCO INC','N/A','N/A','NYSE      ',159.97,'N/A',0),(427,'DE','Deere & Co','Farm & Construction Machinery','S&P 500','NYSE      ',155.44,'Capital Goods',23058800640),(428,'VNO-A','VNO    6.500 Perp     CVT','N/A','N/A','NYSE      ',154.3,'N/A',0),(429,'ACL','Alcon Inc','Drug Manufacturers - Major','N/A','NYSE      ',149.48,'N/A',5222900224),(430,'PCP','Precision Castparts Corp','Metal Fabrication','N/A','NYSE      ',145.28,'Basic Industries',5908899840),(431,'HCH','Merrill Lynch Canada Canadian Pacific HOLDRs','N/A','N/A','NYSE      ',145,'N/A',0),(432,'UBB','Unibanco Depository Receipt','Foreign Money Center Banks','N/A','NYSE      ',143.32,'N/A',9105775616),(433,'CLB','Core Laboratories NV','Oil & Gas Equipment & Services','N/A','NYSE      ',142.28,'N/A',622452992),(434,'BEN','Franklin Resources Inc','Asset Management','S&P 500','NYSE      ',141.47,'Finance',5873861120),(435,'CMI','Cummins Inc','Diversified Machinery','S&P 500','NYSE      ',140.81,'Capital Goods',12001999872),(436,'MLM','Martin Marietta Materials Inc','General Building Materials','N/A','NYSE      ',140.56,'Basic Industries',2190659072),(437,'LVS','Las Vegas Sands Corp','Resorts & Casinos','N/A','NYSE      ',140.53,'Consumer Services',2430631936),(438,'PCU','Southern Copper Corp','Copper','N/A','NYSE      ',139.68,'Basic Industries',6246980096),(439,'SHG','Shinhan Financial Each Rep 2 Ord Krw5000 ADR','Foreign Regional Banks','N/A','NYSE      ',137.88,'Finance',9684332544),(440,'SI','Sielspon ADR','Telecom Services - Foreign','N/A','NYSE      ',137.18,'Capital Goods',118747496448),(441,'AMG','Affiliated Managers Group Inc','Asset Management','N/A','NYSE      ',136.51,'Finance',1250504960),(442,'WBK','Westpac Banking Depository Receipt','Foreign Money Center Banks','N/A','NYSE      ',135,'N/A',17911900160),(443,'TNH','Terra Nitrogen Co LP','Agricultural Chemicals','N/A','NYSE      ',133.47,'N/A',516086016),(444,'DB','DEUTSCHE BANK','Money Center Banks','N/A','NYSE      ',130.91,'N/A',87451107328),(445,'IEP','Icahn Enterprises Units','Property Management','N/A','NYSE      ',130.9,'N/A',1177981952),(446,'NMX','NYMEX Holdings Inc','Diversified Investments','N/A','NYSE      ',130.89,'N/A',590886976),(447,'CRS','Carpenter Technology Corp','Steel & Iron','N/A','NYSE      ',130.77,'Basic Industries',1944800000),(448,'ESI','ITT Educational Services Inc','Education & Training Services','N/A','NYSE      ',129,'Consumer Services',817032000),(449,'ANZ','Australia and New Zealand Banking ADR Reptg Five Ord Shs','Money Center Banks','N/A','NYSE      ',128.44,'N/A',21723060224),(450,'AZO','AutoZone Inc','Auto Parts Stores','S&P 500','NYSE      ',124.68,'Consumer Durables',6169803776),(451,'ESS','Essex Property Ord Shs','REIT - Residential','N/A','NYSE      ',124.38,'Finance',365756000),(452,'BSC','Bear Stearns Ord Shs','Investment Brokerage - National','S&P 500','NYSE      ',123.16,'Finance',18586949632),(453,'CMG','Chipotle Mexican Grill Ord Shs','Restaurants','N/A','NYSE      ',122.43,'Consumer Services',941420032),(454,'GNI','Great Northern Iron Ore Properties','Steel & Iron','N/A','NYSE      ',122.25,'Basic Industries',18334000),
(455,'DO','Diamond Offshore Drilling Inc','Oil & Gas Drilling & Exploration','N/A','NYSE      ',121.38,'Energy',2349712896),(456,'AVB','AvalonBay Comm Ord Shs','REIT - Residential','N/A','NYSE      ',121.12,'Finance',778568000),(457,'SLG','SL Green Rlty Ord Shs','REIT - Retail','N/A','NYSE      ',121.09,'Finance',861526976),(458,'UNP','Union Pacific Corp','Railroads','S&P 500','NYSE      ',119.82,'Transportation',15840000000),(459,'HDB','HDFC Bank Ltd','Foreign Regional Banks','N/A','NYSE      ',118.68,'N/A',1937944960),(460,'FCX','Freeport McMoRan Copper & Gold Ord Shs','Copper','S&P 500','NYSE      ',118.65,'Basic Industries',11388080128),(461,'IBM','IBM Ord Shs','Diversified Computer Systems','S&P 500','NYSE      ',118.37,'Technology',94674001920),(462,'RIG','Transocean Inc','Oil & Gas Drilling & Exploration','S&P 500','NYSE      ',117.5,'Energy',4973700096),(463,'ENR','Energizer Holdings Inc','Industrial Electrical Equipment','N/A','NYSE      ',116.78,'Consumer Non-Durables',3320199936),(464,'NVO','Novo-Nordisk A/S Depository Receipt','Drug Manufacturers - Other','N/A','NYSE      ',116.78,'Health Care',7694033920),(465,'ETR','Entergy Corp Ord Shs','Electric Utilities','S&P 500','NYSE      ',115.88,'Public Utilities',11199039488),(466,'IX','Orix Corp Depository Receipt','Credit Services','N/A','NYSE      ',114.99,'Finance',9838458880),(467,'SLB','SCHLUMBERGER','Oil & Gas Equipment & Services','S&P 500','NYSE      ',114.84,'Energy',21746589696),(468,'POT','POTASH CORPORATION OF SASKATCHEWAN INC','Nonmetallic Mineral Mining','N/A','NYSE      ',114.41,'Basic Industries',4484199936),(469,'VNO','Vornado Realty Trust Ord Shs','REIT - Retail','S&P 500','NYSE      ',113.99,'Finance',2932239104),(470,'WCG','WellCare Health Plans Inc','Health Care Plans','N/A','NYSE      ',113.73,'Health Care',4758921216),(471,'RE','Everest Re Group Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',113.31,'Finance',4757935104),(472,'ATK','Alliant Techsys Ord Shs','Aerospace/Defense Products & Services','N/A','NYSE      ',112.43,'Capital Goods',3700893952),(473,'LMT','Lockheed Martin Corp','Aerospace/Defense Products & Services','S&P 500','NYSE      ',112.11,'Capital Goods',40370999296),(474,'NC','NACCO Industries Class A Ord Shs','Farm & Construction Machinery','N/A','NYSE      ',111.89,'Capital Goods',3416499968),(475,'X','United States Steel Corp','Metal Fabrication','S&P 500','NYSE      ',111.47,'Basic Industries',15864000512),(476,'CMG.B','Chipotle Mexican Grill Class B Ord Shs','N/A','N/A','NYSE      ',110.5,'N/A',0),(477,'TM','Toyota Motor ADR','Auto Manufacturers - Major','N/A','NYSE      ',110.05,'Consumer Durables',211476398080),(478,'HAN','Hanson ADR','N/A','N/A','NYSE      ',109.65,'N/A',0),(479,'WBD','Wimm-Bill-Dann OAO','Dairy Products','N/A','NYSE      ',109.64,'Consumer Non-Durables',2096292992),(480,'YZC','Yanzhou Coal Mining Level III ADR','Industrial Metals & Minerals','N/A','NYSE      ',109.6,'N/A',1804199040),(481,'BXP','Boston Properties Inc','REIT - Office','S&P 500','NYSE      ',109.57,'Finance',1510947968),(482,'TKG','Telkom ADR','Diversified Communication Services','N/A','NYSE      ',108.5,'N/A',7646410240),(483,'FDX','Fedex Corp','Air Delivery & Freight Services','S&P 500','NYSE      ',107.54,'Transportation',35868000256),(484,'DAI','Daimler AG','Auto Manufacturers - Major','N/A','NYSE      ',107,'N/A',174389198848),(485,'CEA','China East Air Depository Receipt','Major Airlines','N/A','NYSE      ',106.5,'N/A',5267924992),(486,'MTD','Mettler-Toledo International Inc','Scientific & Technical Instruments','N/A','NYSE      ',106.2,'Capital Goods',1677902976),(487,'CM','Canadian Imperial Bank Ord Shs','Money Center Banks','N/A','NYSE      ',106.11,'Finance',15652484096),(488,'LLL','L-3 Communications Holdings Inc','Security & Protection Services','S&P 500','NYSE      ',106,'Technology',13196900352),(489,'CAM','Cameron International Corp','Oil & Gas Equipment & Services','N/A','NYSE      ',105.51,'Energy',4191574016),(490,'VMW','VMware Inc','Business Software & Services','N/A','NYSE      ',105.5,'N/A',973920000),(491,'CLF','Cleveland Cliffs Ord Shs','Steel & Iron','N/A','NYSE      ',104.8,'Basic Industries',2002200064),(492,'SPG','Simon Property Ord Shs','REIT - Retail','S&P 500','NYSE      ',104.75,'Finance',3453839872),(493,'ARE','Alexandria RE Eq Ord Shs','REIT - Industrial','N/A','NYSE      ',104.73,'Finance',371892000),(494,'CHK-D','Chesapeake Enrgy 4.5 Conv Pref','N/A','N/A','NYSE      ',104.25,'N/A',0),(495,'BG','Bunge Ord Shs','Farm Products','N/A','NYSE      ',103.9,'Basic Industries',32752001024),(496,'AMN','Ameron International Corp','General Building Materials','N/A','NYSE      ',103.45,'Capital Goods',592769024),(497,'MTB','M&T Bank Corp','Regional - Northeast Banks','S&P 500','NYSE      ',102.5,'Finance',3503312896),(498,'PRU','Prudential Finl Ord Shs','Life Insurance','S&P 500','NYSE      ',101.11,'Finance',34524999680),(499,'SU','SUNCOR ENERGY INC','Independent Oil & Gas','N/A','NYSE      ',101.1,'Energy',16635029504),(500,'AL','ALCAN INC','Aluminum','N/A','NYSE      ',100.61,'Basic Industries',25013000192),(501,'BHI','Baker Hughes Inc','Oil & Gas Equipment & Services','S&P 500','NYSE      ',99.46,'Energy',9772399616),(502,'ATI','Allegheny Technologies Inc','Industrial Metals & Minerals','S&P 500','NYSE      ',99.31,'Basic Industries',5529200128),(503,'JLL','Jones Lang LaSalle Inc','Property Management','N/A','NYSE      ',98.85,'Finance',2332830976),(504,'LFC','China Life Insurance ADR Rep 15 H Ord','Life Insurance','N/A','NYSE      ',98.64,'N/A',23437600768),(505,'HBC','HSBC ADR','Foreign Money Center Banks','N/A','NYSE      ',98.44,'N/A',75878998016),(506,'APD','Air Products and Chemicals Inc','Chemicals - Major Diversified','S&P 500','NYSE      ',98.15,'Basic Industries',9860200448),(507,'HIG','Hartford Financial Services Group Inc','Property & Casualty Insurance','S&P 500','NYSE      ',97.98,'Finance',29404999680),(508,'DEG','Delhaize Group ADR','Grocery Stores','N/A','NYSE      ',97.75,'N/A',27188369408),(509,'MGM','MGM Mirage','Resorts & Casinos','N/A','NYSE      ',97.25,'Consumer Services',7506931200),(510,'WNG','Washington Group International Inc','Technical Services','N/A','NYSE      ',97.15,'Capital Goods',3468935936),(511,'VMI','Valmont Industries Inc','Metal Fabrication','N/A','NYSE      ',97.09,'Capital Goods',1381804032),(512,'APA','Apache Corp Ord Shs','Independent Oil & Gas','S&P 500','NYSE      ',97.05,'Energy',8693167104),(513,'BA','Boeing Ord Shs','Aerospace/Defense - Major Diversified','S&P 500','NYSE      ',96.5,'Capital Goods',64673001472),(514,'GWW','WW Grainger Inc','Electronics Wholesale','S&P 500','NYSE      ',96,'Capital Goods',6129326080),(515,'DNB','Dun & Bradstreet Corp','Information & Delivery Services','N/A','NYSE      ',95.3,'Consumer Services',1585799936),(516,'ETN','Eaton Corp','Industrial Electrical Equipment','S&P 500','NYSE      ',95.28,'Consumer Durables',12577999872),(517,'SPW','SPX Corp','Appliances','N/A','NYSE      ',95.2,'Consumer Durables',4671600128),(518,'XOM','Exxon Mobil Ord Shs','Major Integrated Oil & Gas','S&P 500','NYSE      ',95.15,'Energy',375193993216),(519,'MMM','3M Co','Conglomerates','S&P 500','NYSE      ',94.73,'Consumer Services',23719000064),(520,'CKH','SEACOR Holdings Inc','Shipping','N/A','NYSE      ',94.69,'Energy',1322760960),(521,'MGA','Magna International Subordinate Voting Ord Shs Class A','Auto Parts','N/A','NYSE      ',94.61,'Consumer Durables',24945999872),(522,'BWA','BorgWarner Inc','Auto Parts','N/A','NYSE      ',94.17,'Consumer Durables',4903600128),(523,'MON','Monsanto Co','Agricultural Chemicals','S&P 500','NYSE      ',94.13,'Basic Industries',8562999808),(524,'VMC','Vulcan Materials Co','General Building Materials','S&P 500','NYSE      ',94.04,'Basic Industries',3311656960),(525,'CHA','China Telecom ADR','Telecom Services - Foreign','N/A','NYSE      ',93.71,'N/A',23531579392),(526,'ITY','Imperial Tobacco Depository Receipt','Tobacco Products, Other','N/A','NYSE      ',93.56,'N/A',23758270464),(527,'CVX','Chevron Ord Shs','Major Integrated Oil & Gas','S&P 500','NYSE      ',92.94,'Energy',206279000064),(528,'TEF','Telefonica ADR rep 3 ord shs','Telecom Services - Foreign','N/A','NYSE      ',92.45,'N/A',78743412736),(529,'CHL','China Mobile ADR','Wireless Communications','N/A','NYSE      ',91.99,'N/A',43255771136),(530,'FRT','Federal Realty Investment Trust Ord Shs','REIT - Retail','N/A','NYSE      ',91.94,'Finance',478244992),(531,'PEG','Public Srvce Ent Ord Shs','Diversified Utilities','S&P 500','NYSE      ',91.44,'Public Utilities',12574000128),(532,'MHS','Medco Health Solutions Inc','Drug Stores','S&P 500','NYSE      ',91.4,'Health Care',43600498688),(533,'CEG','Constellation Energy Group Ord Shs','Electric Utilities','S&P 500','NYSE      ',91.07,'Public Utilities',19922599936),(534,'MAC','Macerich Ord Shs','REIT - Retail','N/A','NYSE      ',91.03,'Finance',863329024),(535,'AB','AllianceBernstein Holding LP','Asset Management','N/A','NYSE      ',90.95,'Finance',4324517888),(536,'GD','General Dynamics Corp','Aerospace/Defense Products & Services','S&P 500','NYSE      ',90.95,'Capital Goods',25474000896),(537,'DEO','Diageo ADR Reptg 4 Ord Shs','Beverages - Wineries & Distillers','N/A','NYSE      ',90.64,'N/A',15222299648),(538,'KYO','Kyocera Corp Depository Receipt','Diversified Electronics','N/A','NYSE      ',90.03,'Technology',11127539712),(539,'DVN','Devon Energy Ord Shs','Independent Oil & Gas','S&P 500','NYSE      ',89.85,'Energy',11130000384),(540,'WHR','Whirlpool Corp','Appliances','S&P 500','NYSE      ',89.81,'Consumer Durables',19040000000),(541,'ED-A','Consolidated Edison 4.65% Series C Cumulative Pref Shs','N/A','N/A','NYSE      ',89.4,'N/A',0),(542,'VE','Vivendi Environ Depository Receipt','Foreign Utilities','N/A','NYSE      ',89.25,'N/A',42634059776),(543,'STN','Station Casinos Inc','Resorts & Casinos','N/A','NYSE      ',89.13,'Consumer Services',1440097024),(544,'XEL-C','Xcel Energy 4.10% Cumulative Pref Shs','N/A','N/A','NYSE      ',89,'N/A',0),(545,'TEX','Terex Corp','Farm & Construction Machinery','N/A','NYSE      ',88.4,'Capital Goods',8288099840),(546,'D','Dominion Resources Inc','Electric Utilities','S&P 500','NYSE      ',88.21,'Public Utilities',16359999488),(547,'HET','Harrah\'s Entertainment Inc','Resorts & Casinos','S&P 500','NYSE      ',88.05,'Consumer Services',10300499968),(548,'AH','Armor Holdings Inc','N/A','N/A','NYSE      ',88,'N/A',0),(549,'EXH','Exterran Holdings Inc','Oil & Gas Equipment & Services','N/A','NYSE      ',87.7,'N/A',1728715008),(550,'BCR','C.R. Bard Inc','Medical Instruments & Supplies','S&P 500','NYSE      ',87.12,'Health Care',2093699968),(551,'HAR','Harman International Industries Inc','Electronic Equipment','S&P 500','NYSE      ',87,'Consumer Services',3551143936),(552,'JEC','Jacobs Engineering Group Inc','Technical Services','N/A','NYSE      ',86.97,'Capital Goods',8173192192),(553,'COP','ConocoPhillips','Major Integrated Oil & Gas','S&P 500','NYSE      ',86.86,'Energy',184383995904),(554,'LM','Legg Mason Inc','Investment Brokerage - Regional','S&P 500','NYSE      ',86.74,'Finance',4511422976),(555,'PBR','Petroleo Brasileiro ADR Reptg 2 Ord Shs','Oil & Gas Drilling & Exploration','N/A','NYSE      ',86.63,'Energy',77790003200),(556,'PE-C','PECO Energy 4.40 Cumulative Pref Shs Series 1','N/A','N/A','NYSE      ',86.5,'N/A',0),(557,'PE-D','PECO Energy 4.68 Cumulative Pref Shs Series 4','N/A','N/A','NYSE      ',86.5,'N/A',0),(558,'TDK','TDK ADR','Diversified Electronics','N/A','NYSE      ',86.29,'Technology',7367119872),(559,'DST','DST Systems Inc','Information & Delivery Services','N/A','NYSE      ',86.12,'Technology',2241600000),(560,'AGE','AG Edwards Inc','N/A','N/A','NYSE      ',85.97,'N/A',3311390976),(561,'BHP','BHP Billiton ADR','Industrial Metals & Minerals','N/A','NYSE      ',85.92,'N/A',39497998336),(562,'SHI','Shanghai Pechem Depository Receipt','Synthetics','N/A','NYSE      ',85.51,'N/A',7089785856),(563,'AXE','Anixter International Inc','Electronics Wholesale','N/A','NYSE      ',85.37,'Technology',5468499968),(564,'CG','Carolina Group Ord Shs','Cigarettes','N/A','NYSE      ',84.83,'Consumer Non-Durables',4016100096),(565,'RDS.A','Royal Dutch Shell ADR Each Repstg Two Class A Ord Shs','Oil & Gas Refining & Marketing','N/A','NYSE      ',84.72,'N/A',318129995776),(566,'RDS.B','Royal Dutch Shel ADR Rep 2 Class B Ord Shs','N/A','N/A','NYSE      ',84.6,'N/A',0),(567,'PX','Praxair Inc','Synthetics','S&P 500','NYSE      ',84.58,'Basic Industries',8728999936),(568,'FO','Fortune Brands Ord Shs','Home Furnishings & Fixtures','S&P 500','NYSE      ',84.46,'Consumer Non-Durables',8798699520),(569,'KB','Kookmin Bank ADR Representing One Ord Shs','Foreign Regional Banks','N/A','NYSE      ',84.3,'Finance',12420310016),(570,'BDX','Becton Dickinson & Co','Medical Instruments & Supplies','S&P 500','NYSE      ',84,'Health Care',6171223040),(571,'BNI','Burlington Northern Santa Fe Corp','Railroads','S&P 500','NYSE      ',84,'Transportation',15308999680),(572,'NYX','NYSE Euronext','Diversified Investments','N/A','NYSE      ',83.82,'Finance',3041441024),(573,'CMS-B','Consumers Energy Series B Pref Shs','N/A','N/A','NYSE      ',83.5,'N/A',0),(574,'OII','Oceaneering International Inc','Oil & Gas Equipment & Services','N/A','NYSE      ',83.5,'Energy',1455671040),(575,'KMT','Kennametal Inc','Machine Tools & Accessories','N/A','NYSE      ',83.48,'Basic Industries',2385492992),(576,'EOG','EOG Resources Inc','Independent Oil & Gas','S&P 500','NYSE      ',83.28,'Energy',3831247104),(577,'ATW','Atwood Oceanics Inc','Oil & Gas Drilling & Exploration','N/A','NYSE      ',83.12,'Energy',363249984),(578,'ZMH','Zimmer Holdings Inc','Medical Appliances & Equipment','S&P 500','NYSE      ',83.12,'Health Care',3674200064),(579,'DHR','Danaher Corp','Conglomerates','S&P 500','NYSE      ',83.11,'Capital Goods',10330229760),(580,'PSA','Public Storage Ord Shs','REIT - Industrial','S&P 500','NYSE      ',83.03,'Finance',1688791040),(581,'SPG-I','Simon Property 6.00% Convertible I Pref Shs','N/A','N/A','NYSE      ',83,'N/A',0),(582,'ANF','Abercrombie & Fitch Co','Apparel Stores','N/A','NYSE      ',82.81,'Consumer Services',3549138944),(583,'MHK','Mohawk Industries Inc','Textile Manufacturing','N/A','NYSE      ',82.53,'Consumer Durables',7763685888),(584,'XEL-E','Xcel Energy Series E Pref Shs','N/A','N/A','NYSE      ',82.5,'N/A',0),(585,'NOV','National Oilwell Varco Inc','Oil & Gas Equipment & Services','S&P 500','NYSE      ',82,'Energy',8407199744),(586,'TGI','Triumph Group Ord Shs','Aerospace/Defense Products & Services','N/A','NYSE      ',81.75,'Capital Goods',1006916992),(587,'UTX','UNITED TECHNOLOGIE','Conglomerates','S&P 500','NYSE      ',81.17,'Capital Goods',51131998208),(588,'TOT','Total Conv Into 1/2 Shs ADR','Major Integrated Oil & Gas','N/A','NYSE      ',81.08,'Energy',182247292928),(589,'BDK','Black & Decker Corp','Small Tools & Accessories','S&P 500','NYSE      ',81.05,'Consumer Durables',6498599936),(590,'ACH','Aluminum Corporation of China ADR Rep 25 Class H Ord Shs','Aluminum','N/A','NYSE      ',81,'N/A',8239104000),(591,'PPL-B','PPL Electric Utilities 4.5% Pref Shs','N/A','N/A','NYSE      ',81,'N/A',0),(592,'PRE','PartnerRe Ord Shs','Property & Casualty Insurance','N/A','NYSE      ',80.93,'Finance',4190654976),(593,'UIC','United Industrial Corp','Aerospace/Defense Products & Services','N/A','NYSE      ',80.75,'Capital Goods',641953024),(594,'RTI','RTI International Metals, Inc (Holding Co)','Industrial Metals & Minerals','N/A','NYSE      ',80.61,'Basic Industries',572246016),(595,'FLS','Flowserve Corp','Diversified Machinery','N/A','NYSE      ',80.48,'Capital Goods',3388423936),(596,'CAT','Caterpillar Ord Shs','Farm & Construction Machinery','S&P 500','NYSE      ',80.1,'Capital Goods',42892001280),(597,'NGG','National Grid ADR','Gas Utilities','N/A','NYSE      ',80.05,'N/A',17861429248),(598,'XL','XL Capital Class A Ord Shs','Property & Casualty Insurance','S&P 500','NYSE      ',80,'Finance',9940746240),(599,'PPG','PPG Industries Inc','Conglomerates','S&P 500','NYSE      ',79.95,'Basic Industries',11665000448),(600,'NOC','Northrop Corp Ord Shs','Aerospace/Defense Products & Services','S&P 500','NYSE      ',79.88,'Capital Goods',30727000064);
/*!40000 ALTER TABLE `exchange` ENABLE KEYS */;
UNLOCK TABLES;
 
 
USE easa;
 
 
DROP TABLE IF EXISTS `tbl_job`;
CREATE TABLE `tbl_job` (
  `JOB_ID` INT(11) NOT NULL AUTO_INCREMENT,
  `PARENT_JOB_ID` INT(11) DEFAULT NULL,
  `PATH` VARCHAR(255) DEFAULT NULL,
  `USERNAME` VARCHAR(45) DEFAULT NULL,
  `MODE` VARCHAR(45) DEFAULT NULL,
  `LDIR` VARCHAR(45) DEFAULT NULL,
  `APPDIR` VARCHAR(255) DEFAULT NULL,
  `JOB_STATUS` VARCHAR(255) DEFAULT NULL,
  `NON_BATCH_SOFTWARE` VARCHAR(45) DEFAULT NULL,
  `DATE_SUBMITTED` datetime DEFAULT NULL,
  `STATE` SMALLINT(6) DEFAULT NULL,
  `SIM_NUM` INT(11) DEFAULT NULL,
  `APP_TITLE` VARCHAR(255) DEFAULT NULL,
  `NOTE` VARCHAR(255) DEFAULT NULL,
  `REMOTE_ID` INT(11) DEFAULT NULL,
  `REMOTE_CS` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`JOB_ID`),
  KEY `FKA5AC7BBC25D6D952` (`PARENT_JOB_ID`),
  CONSTRAINT `FKA5AC7BBC25D6D952` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `tbl_job` (`JOB_ID`)
);
 
USE excel;
 
DROP TABLE IF EXISTS `easaps`;
CREATE TABLE `easaps` (
  `id` BIGINT(20) NOT NULL,
  `easap_name` VARCHAR(255) DEFAULT NULL,
  `easap_uniqueId` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `easap_name` (`easap_name`),
  UNIQUE KEY `easap_uniqueId` (`easap_uniqueId`)
);
 
 
DROP TABLE IF EXISTS `excel_file`;
CREATE TABLE `excel_file` (
  `id` BIGINT(20) NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `save_type` VARCHAR(255) DEFAULT NULL,
  `easap_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FKC85A522452EA222F` (`easap_fk`),
  CONSTRAINT `FKC85A522452EA222F` FOREIGN KEY (`easap_fk`) REFERENCES `easaps` (`id`)
);
 
DROP TABLE IF EXISTS `cases`;
CREATE TABLE `cases` (
  `id` BIGINT(20) NOT NULL,
  `created` datetime DEFAULT NULL,
  `created_by` VARCHAR(255) DEFAULT NULL,
  `pricing_id` VARCHAR(255) DEFAULT NULL,
  `data_file_image` longblob,
  `last_modified` datetime DEFAULT NULL,
  `last_modified_by` VARCHAR(255) DEFAULT NULL,
  `status` VARCHAR(255) DEFAULT NULL,
  `excel_file_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3CEF323277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FK3CEF323277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
);
 
DROP TABLE IF EXISTS `named_range`;
CREATE TABLE `named_range` (
  `name` VARCHAR(255) NOT NULL,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `value` longtext,
  PRIMARY KEY (`excel_file_fk`,`name`),
  KEY `FKB0810C77277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FKB0810C77277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
);
 
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
  `type` INT(11) DEFAULT NULL,
  `value` longtext,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `named_range_fk` VARCHAR(255) NOT NULL,
  `case_fk` BIGINT(20) NOT NULL,
  PRIMARY KEY (`case_fk`,`excel_file_fk`,`named_range_fk`),
  KEY `FK1FE7AA6F969779` (`case_fk`),
  KEY `FK1FE7AA7DAE806` (`excel_file_fk`,`named_range_fk`),
  CONSTRAINT `FK1FE7AA6F969779` FOREIGN KEY (`case_fk`) REFERENCES `cases` (`id`),
  CONSTRAINT `FK1FE7AA7DAE806` FOREIGN KEY (`excel_file_fk`, `named_range_fk`) REFERENCES `named_range` (`excel_file_fk`, `name`)
);
 
 
USE excelTesting;
 
DROP TABLE IF EXISTS `easaps`;
CREATE TABLE `easaps` (
  `id` BIGINT(20) NOT NULL,
  `easap_name` VARCHAR(255) DEFAULT NULL,
  `easap_uniqueId` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  UNIQUE KEY `easap_name` (`easap_name`),
  UNIQUE KEY `easap_uniqueId` (`easap_uniqueId`)
);
 
DROP TABLE IF EXISTS `excel_file`;
CREATE TABLE `excel_file` (
  `id` BIGINT(20) NOT NULL,
  `last_modified` datetime DEFAULT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `save_type` VARCHAR(255) DEFAULT NULL,
  `easap_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `FKC85A522452EA222F` (`easap_fk`),
  CONSTRAINT `FKC85A522452EA222F` FOREIGN KEY (`easap_fk`) REFERENCES `easaps` (`id`)
);
 
DROP TABLE IF EXISTS `cases`;
CREATE TABLE `cases` (
  `id` BIGINT(20) NOT NULL,
  `created` datetime DEFAULT NULL,
  `created_by` VARCHAR(255) DEFAULT NULL,
  `pricing_id` VARCHAR(255) DEFAULT NULL,
  `data_file_image` longblob,
  `last_modified` datetime DEFAULT NULL,
  `last_modified_by` VARCHAR(255) DEFAULT NULL,
  `status` VARCHAR(255) DEFAULT NULL,
  `excel_file_fk` BIGINT(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK3CEF323277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FK3CEF323277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
);
 
DROP TABLE IF EXISTS `named_range`;
CREATE TABLE `named_range` (
  `name` VARCHAR(255) NOT NULL,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `value` longtext,
  PRIMARY KEY (`excel_file_fk`,`name`),
  KEY `FKB0810C77277DA6BE` (`excel_file_fk`),
  CONSTRAINT `FKB0810C77277DA6BE` FOREIGN KEY (`excel_file_fk`) REFERENCES `excel_file` (`id`)
);
 
DROP TABLE IF EXISTS `data`;
CREATE TABLE `data` (
  `type` INT(11) DEFAULT NULL,
  `value` longtext,
  `excel_file_fk` BIGINT(20) NOT NULL,
  `named_range_fk` VARCHAR(255) NOT NULL,
  `case_fk` BIGINT(20) NOT NULL,
  PRIMARY KEY (`case_fk`,`excel_file_fk`,`named_range_fk`),
  KEY `FK1FE7AA6F969779` (`case_fk`),
  KEY `FK1FE7AA7DAE806` (`excel_file_fk`,`named_range_fk`),
  CONSTRAINT `FK1FE7AA6F969779` FOREIGN KEY (`case_fk`) REFERENCES `cases` (`id`),
  CONSTRAINT `FK1FE7AA7DAE806` FOREIGN KEY (`excel_file_fk`, `named_range_fk`) REFERENCES `named_range` (`excel_file_fk`, `name`)
);

Page Tools