CREATE TABLE STOCK(SYMBOL VARCHAR(80),COMPANYNAME VARCHAR(80),LASTTRADEPRICE DECIMAL,TRADETIME DATETIME,PREVIOUSCLOSEPRICE DECIMAL,OPENPRICE DECIMAL,ONEYEARTARGETEST DECIMAL,AVGVOLUME DECIMAL,MARKETCAP DECIMAL)