Dataset: SEC 13F-HR Institutional Investment Data

About this Dataset

SEC 13F-HR Institutional Investment Data

Context

The dataset consists of quarterly filings of institutions scraped from the SEC EDGAR database.

Content

The Insititutions.csv contains the names of institutions and their unique ids.
The stock_names.csv contains the names of companies and their unique ids.

13Fdata.csv Includes three years of quarterly filings from 2015 - 2017 for all the institutions in the SEC database.

Acknowledgements

Data courtesy: SEC

Inspiration

Interesting questions to ask:
Can you pick the most promising securities to invest in based on how institutions are trading it?
How about some cool dataviz?

Tables

N 13fdata

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data.n_13fdata

60.96 MB
1713673 rows
37 columns


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
);

Institutions

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data.institutions

57.54 KB
2222 rows
2 columns


CREATE TABLE institutions (
  "cik" BIGINT,
  "name" VARCHAR
);

Stock Names

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data.stock_names

990.17 KB
41244 rows
2 columns


CREATE TABLE stock_names (
  "cuisp" VARCHAR,
  "name" VARCHAR
);