In Progress

GeniusCoder Stock Project

java program format is

java stockReader [directory of csv files]

File format


Inside [url removed, login to view] the first line is

AACC 9-Jan-09 5.41 5.41 4.97 4.97 55400

you will write into stockSymbols

Market = NASDAQ

Symbol = AACC

if NASDAQ + AACC exists you will not write it. there is a unique key (Market,Symbol)

get the StockId

then write the Date, Open, High, Low, Close, Volume to dailyStockPrices

Table format is

create table stockSymbols


StockId int auto_increment primary key,

Market text not null,

Symbol text not null


create table dailyStockPrices


StockId int not null,

StockDate date not null,

StockOpen decimal(20,2) not null,

StockHigh decimal(20,2) not null,

StockLow decimal(20,2) not null,

StockClose decimal(20,2) not null,

StockVolume int not null


Skills: Java, JSP

About the Employer:
( 197 reviews ) Hacienda Heights, United States

Project ID: #700045

Awarded to:



$150 USD in 3 days
(17 Reviews)