CREATE TABLE `STOCKS` (
  `SYMBOL` varchar(6) NOT NULL,
  `DATE` bigint(8) NOT NULL,
  `OPEN` double(6,2) NOT NULL,
  `HIGH` double(6,2) NOT NULL,
  `LOW` double(6,2) NOT NULL,
  `CLOSE` double(6,2) NOT NULL,
  `VOLUME` bigint(12) NOT NULL,
  UNIQUE KEY `SYMBOL` (`SYMBOL`,`DATE`)
)