Name: SEC 13F-HR Institutional Investment Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

Institutions

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data.institutions

58.92 kB
2,222 rows
2 columns

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

N 13fdata

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data.n_13fdata

63.93 MB
1,713,673 rows
37 columns

CREATE TABLE n_13fdata (
  "cusip" VARCHAR,
  "stock" VARCHAR,
  "cik" BIGINT,
  "institution" VARCHAR,
  "n_2017_09" BIGINT  -- 2017-09,
  "n_2017_08" DOUBLE  -- 2017-08,
  "n_2017_07" DOUBLE  -- 2017-07,
  "n_2017_06" BIGINT  -- 2017-06,
  "n_2017_05" DOUBLE  -- 2017-05,
  "n_2017_04" DOUBLE  -- 2017-04,
  "n_2017_03" BIGINT  -- 2017-03,
  "n_2017_02" DOUBLE  -- 2017-02,
  "n_2017_01" DOUBLE  -- 2017-01,
  "n_2016_12" BIGINT  -- 2016-12,
  "n_2016_11" DOUBLE  -- 2016-11,
  "n_2016_10" DOUBLE  -- 2016-10,
  "n_2016_09" BIGINT  -- 2016-09,
  "n_2016_08" DOUBLE  -- 2016-08,
  "n_2016_07" DOUBLE  -- 2016-07,
  "n_2016_06" BIGINT  -- 2016-06,
  "n_2016_05" DOUBLE  -- 2016-05,
  "n_2016_04" DOUBLE  -- 2016-04,
  "n_2016_03" BIGINT  -- 2016-03,
  "n_2016_02" DOUBLE  -- 2016-02,
  "n_2016_01" DOUBLE  -- 2016-01,
  "n_2015_12" BIGINT  -- 2015-12,
  "n_2015_11" DOUBLE  -- 2015-11,
  "n_2015_10" DOUBLE  -- 2015-10,
  "n_2015_09" BIGINT  -- 2015-09,
  "n_2015_08" DOUBLE  -- 2015-08,
  "n_2015_07" DOUBLE  -- 2015-07,
  "n_2015_06" BIGINT  -- 2015-06,
  "n_2015_05" DOUBLE  -- 2015-05,
  "n_2015_04" DOUBLE  -- 2015-04,
  "n_2015_03" BIGINT  -- 2015-03,
  "n_2015_02" BIGINT  -- 2015-02,
  "n_2015_01" BIGINT  -- 2015-01
);

Stock Names

@kaggle.aneeshpanoli_sec_13fhr_institutional_investment_data.stock_names

1.01 MB
41,244 rows
2 columns

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