EDHEC Investment Management Datasets

unnamed_0 Unnamed: 0	food Food	beer Beer	smoke Smoke	games Games	books Books	hshld Hshld	clths Clths	hlth Hlth	chems Chems	txtls Txtls	cnstr Cnstr	steel Steel	fabpr FabPr	elceq ElcEq	autos Autos	carry Carry	mines Mines	coal Coal	oil Oil	util Util	telcm Telcm	servs Servs	buseq BusEq	paper Paper	trans Trans	whlsl Whlsl	rtail Rtail	meals Meals	fin Fin	other Other
192607	43	3	16	7	2	8	12	7	17	13	14	45	19	11	39	13	14	8	43	21	5	3	7	6	74	2	33	6	12	4
192608	43	3	16	7	2	8	12	7	17	13	14	45	19	11	39	13	14	8	43	21	5	3	7	6	74	2	33	6	12	4
192609	43	3	16	7	2	8	12	7	17	13	14	45	19	11	39	13	14	8	42	21	5	3	7	6	74	2	33	6	12	4
192610	43	3	16	7	2	8	12	7	17	13	14	45	19	11	39	13	14	8	42	21	5	3	7	6	74	2	33	6	12	4
192611	43	3	16	7	2	8	12	7	17	13	14	45	19	11	39	13	14	8	42	21	5	3	7	6	74	2	33	6	12	4
192612	43	3	16	7	2	8	12	7	17	12	14	45	19	11	39	13	14	8	42	21	5	3	7	6	74	2	33	6	11	4
192701	43	3	16	7	2	8	12	7	17	12	14	45	19	11	39	13	14	8	41	21	5	3	7	6	74	2	33	6	11	4
192702	43	3	15	7	2	8	12	7	17	11	14	45	19	11	39	13	14	8	41	21	5	3	7	6	73	2	33	6	11	4
192703	43	3	15	7	2	8	12	7	17	11	14	45	19	11	39	13	14	8	41	21	5	3	7	6	73	2	33	6	11	4
192704	43	3	15	7	2	8	12	7	17	11	14	45	19	11	39	13	14	8	41	21	4	3	7	6	72	2	33	6	11	4


CREATE TABLE ind30_m_nfirms (
  "unnamed_0" BIGINT,
  "food" BIGINT,
  "beer" BIGINT,
  "smoke" BIGINT,
  "games" BIGINT,
  "books" BIGINT,
  "hshld" BIGINT,
  "clths" BIGINT,
  "hlth" BIGINT,
  "chems" BIGINT,
  "txtls" BIGINT,
  "cnstr" BIGINT,
  "steel" BIGINT,
  "fabpr" BIGINT,
  "elceq" BIGINT,
  "autos" BIGINT,
  "carry" BIGINT,
  "mines" BIGINT,
  "coal" BIGINT,
  "oil" BIGINT,
  "util" BIGINT,
  "telcm" BIGINT,
  "servs" BIGINT,
  "buseq" BIGINT,
  "paper" BIGINT,
  "trans" BIGINT,
  "whlsl" BIGINT,
  "rtail" BIGINT,
  "meals" BIGINT,
  "fin" BIGINT,
  "other" BIGINT
);