EDHEC Investment Management Datasets

unnamed_0 Unnamed: 0	agric Agric	food Food	beer Beer	smoke Smoke	toys Toys	fun Fun	books Books	hshld Hshld	clths Clths	medeq MedEq	drugs Drugs	chems Chems	txtls Txtls	bldmt BldMt	cnstr Cnstr	steel Steel	mach Mach	elceq ElcEq	autos Autos	aero Aero	ships Ships	mines Mines	coal Coal	oil Oil	util Util	telcm Telcm	bussv BusSv	hardw Hardw	chips Chips	labeq LabEq	boxes Boxes	trans Trans	whlsl Whlsl	rtail Rtail	meals Meals	banks Banks	insur Insur	rlest RlEst	fin Fin	other Other
192607	3	40	3	16	1	6	1	8	12	2	5	17	13	13	1	45	19	11	39	1	12	14	8	43	21	5	6	4	2	1	6	72	2	33	6	3	3	2	4	4
192608	3	40	3	16	1	6	1	8	12	2	5	17	13	13	1	45	19	11	39	1	12	14	8	43	21	5	6	4	2	1	6	72	2	33	6	3	3	2	4	4
192609	3	40	3	16	1	6	1	8	12	2	5	17	13	13	1	45	19	11	39	1	12	14	8	42	21	5	6	4	2	1	6	72	2	33	6	3	3	2	4	4
192610	3	40	3	16	1	6	1	8	12	2	5	17	13	13	1	45	19	11	39	1	12	14	8	42	21	5	6	4	2	1	6	72	2	33	6	3	3	2	4	4
192611	3	40	3	16	1	6	1	8	12	2	5	17	13	13	1	45	19	11	39	1	12	14	8	42	21	5	6	4	2	1	6	72	2	33	6	3	3	2	4	4
192612	3	40	3	16	1	6	1	8	12	2	5	17	12	13	1	45	19	11	39	1	12	14	8	42	21	5	6	4	2	1	6	72	2	33	6	2	3	2	4	4
192701	3	40	3	16	1	6	1	8	12	2	5	17	12	13	1	45	19	11	39	1	12	14	8	41	21	5	6	4	2	1	6	72	2	33	6	2	3	2	4	4
192702	3	40	3	15	1	6	1	8	12	2	5	17	11	13	1	45	19	11	39	1	12	14	8	41	21	5	6	4	2	1	6	71	2	33	6	2	3	2	4	4
192703	3	40	3	15	1	6	1	8	12	2	5	17	11	13	1	45	19	11	39	1	12	14	8	41	21	5	6	4	2	1	6	71	2	33	6	2	3	2	4	4
192704	3	40	3	15	1	6	1	8	12	2	5	17	11	13	1	45	19	11	39	1	12	14	8	41	21	4	6	4	2	1	6	70	2	33	6	2	3	2	4	4


CREATE TABLE ind49_m_nfirms (
  "unnamed_0" BIGINT,
  "agric" BIGINT,
  "food" BIGINT,
  "soda" BIGINT,
  "beer" BIGINT,
  "smoke" BIGINT,
  "toys" BIGINT,
  "fun" BIGINT,
  "books" BIGINT,
  "hshld" BIGINT,
  "clths" BIGINT,
  "hlth" BIGINT,
  "medeq" BIGINT,
  "drugs" BIGINT,
  "chems" BIGINT,
  "rubbr" BIGINT,
  "txtls" BIGINT,
  "bldmt" BIGINT,
  "cnstr" BIGINT,
  "steel" BIGINT,
  "fabpr" BIGINT,
  "mach" BIGINT,
  "elceq" BIGINT,
  "autos" BIGINT,
  "aero" BIGINT,
  "ships" BIGINT,
  "guns" BIGINT,
  "gold" BIGINT,
  "mines" BIGINT,
  "coal" BIGINT,
  "oil" BIGINT,
  "util" BIGINT,
  "telcm" BIGINT,
  "persv" BIGINT,
  "bussv" BIGINT,
  "hardw" BIGINT,
  "softw" BIGINT,
  "chips" BIGINT,
  "labeq" BIGINT,
  "paper" BIGINT,
  "boxes" BIGINT,
  "trans" BIGINT,
  "whlsl" BIGINT,
  "rtail" BIGINT,
  "meals" BIGINT,
  "banks" BIGINT,
  "insur" BIGINT,
  "rlest" BIGINT,
  "fin" BIGINT,
  "other" BIGINT
);