SEC 13F-HR Institutional Investment Data

Quarterly institutional filings from 2015 - 2017

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data

Table List

3 tables(61.99 MB)

N 13fdata

Institutions

Stock Names

N 13fdata

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data.n_13fdata

60.96 MB
1713673 rows
37 columns

cusip Cusip	stock Stock	cik Cik	institution Institution	n_2017_08 2017-08	n_2017_05 2017-05	n_2017_02 2017-02	n_2016_11 2016-11	n_2016_08 2016-08	n_2016_06 2016-06	n_2016_05 2016-05	n_2016_02 2016-02
307108	AAC HLDGS INC	1000275	ROYAL BANK OF CANADA \	19	512	512	515	1030	1112	574	538
360206	AAON INC	1000275	ROYAL BANK OF CANADA \	875	85	2	223	11080	5613	5585	4779
361105	AAR CORP	1000275	ROYAL BANK OF CANADA \	17	43	3	41	1500	1634	750	884
375204	ABB LTD	1000275	ROYAL BANK OF CANADA \	1	5003	7	13	162	48	27	21
868109	ACNB CORP	1000275	ROYAL BANK OF CANADA \	1543	1543	1543	1543	3086	3086	1543	1251
957100	ABM INDS INC	1000275	ROYAL BANK OF CANADA \	46	5963	3	269	8600	14821	14798	5750
1055102	AFLAC INC	1000275	ROYAL BANK OF CANADA \	1398	1398	1398	1698	3396	3396	1698	1698
1084102	AGCO CORP	1000275	ROYAL BANK OF CANADA \	268	368	8	50	82	251	60	22720
1228105	AG MTG INVT TR INC	1000275	ROYAL BANK OF CANADA \	18750	18750	18750	18750	6698	97711	18750	78961
1282102	A H BELO CORP	1000275	ROYAL BANK OF CANADA \	13100	13100	13100	25100	50200	50200	25100	25100


CREATE TABLE n_13fdata (
  "cusip" VARCHAR,
  "stock" VARCHAR,
  "cik" BIGINT,
  "institution" VARCHAR,
  "n_2017_09" BIGINT,
  "n_2017_08" DOUBLE,
  "n_2017_07" DOUBLE,
  "n_2017_06" BIGINT,
  "n_2017_05" DOUBLE,
  "n_2017_04" DOUBLE,
  "n_2017_03" BIGINT,
  "n_2017_02" DOUBLE,
  "n_2017_01" DOUBLE,
  "n_2016_12" BIGINT,
  "n_2016_11" DOUBLE,
  "n_2016_10" DOUBLE,
  "n_2016_09" BIGINT,
  "n_2016_08" DOUBLE,
  "n_2016_07" DOUBLE,
  "n_2016_06" BIGINT,
  "n_2016_05" DOUBLE,
  "n_2016_04" DOUBLE,
  "n_2016_03" BIGINT,
  "n_2016_02" DOUBLE,
  "n_2016_01" DOUBLE,
  "n_2015_12" BIGINT,
  "n_2015_11" DOUBLE,
  "n_2015_10" DOUBLE,
  "n_2015_09" BIGINT,
  "n_2015_08" DOUBLE,
  "n_2015_07" DOUBLE,
  "n_2015_06" BIGINT,
  "n_2015_05" DOUBLE,
  "n_2015_04" DOUBLE,
  "n_2015_03" BIGINT,
  "n_2015_02" BIGINT,
  "n_2015_01" BIGINT
);