create table portfolio
(
	recid	int(10) unsigned not null primary key,
	tkr		varchar(10) not null,
	curdate		date not null,
	lst		numeric(6,2) null,
	eps		numeric(5,2) null,
	pe		numeric(4,2) null,
    ps		numeric(4,2) null,
    pb		numeric(4,2) null,
	ds		numeric(4,2) null,
    yield	numeric(3,2) null,
	vol 	bigint(13) null,
	cap		bigint(15) null
);