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,
      adj_close float(11,5) unsigned,
      adj_open float(11,5) unsigned,
      adj_high float(11,5) unsigned,
      adj_low float(11,5) unsigned
      );

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