create table stocks_daily
(
exchange char(10) NOT NULL,
symbol char(10) NOT NULL,
date datetime NOT NULL,
o real NOT NULL,
h real NOT NULL,
l real NOT NULL,
c real NOT NULL,
volume int NOT NULL,
adjust real NOT NULL
);