create table symbol_table (
      symbol varchar(10),
      name varchar(80),
      location varchar(25)
      );

create table hp1d (
      sym varchar(10),
      pdatetime date,
      open float(11,5) unsigned,
      high float(11,5) unsigned,
      low float(11,5) unsigned,
      close float(11,5) unsigned,
      volume int(10) unsigned,
      adjclose float(11,5) unsigned,
      adjopen float(11,5) unsigned,
      adjhigh float(11,5) unsigned,
      adjlow float(11,5) unsigned
      );

alter table hp1d add primary key (sym, pdatetime);