API  /  Kafka Streaming
API Docs Kafka Streaming Protobuf OpenAPI YAML
Message

Form13F_HR

An institution's quarterly 13F holdings report, summarised per security type (shares, funds, options, warrants, preferred stock and debt). Published for every 13F filing (13F-HR, 13F-NT, 13F-CTR and their amendments); the enriched per-institution summary is published separately as ThirteenFAlert.

fields33 topicsec-filings
▶Proto definition.proto 
message Form13F_HR {
  string accession_no = 1;
  string cik = 2;
  string company = 3;
  string formtype = 4;
  int64 total_holdings = 5;
  int64 unique_holdings = 6;
  int64 total_value = 7;
  string report_period_end_date = 8;
  bool is_amendment = 9;
  int64 amendment_no = 10;
  string amendment_type = 11;
  string filing_date = 12;
  string file_number = 13;
  int64 share_value = 14;
  int64 share_holdings_cnt = 15;
  int64 fund_value = 16;
  int64 fund_holdings_cnt = 17;
  int64 warrant_value = 18;
  int64 warrant_holdings_cnt = 19;
  int64 call_value = 20;
  int64 call_holdings_cnt = 21;
  int64 put_value = 22;
  int64 put_holdings_cnt = 23;
  int64 pfd_value = 24;
  int64 pfd_holdings_cnt = 25;
  int64 debt_value = 26;
  int64 debt_holdings_cnt = 27;
  int64 agg_total_value = 28;
  int64 agg_total_holdings = 29;
  int64 agg_unique_holdings = 30;
  int64 agg_total_holdings_cnt = 31;
  double buy_value = 32;
  double sell_value = 33;
}
Fields
accession_no string 1
the filing's accession no
cik string 2
the CIK of the filing institution
company string 3
the name of the filing institution
formtype string 4
the SEC form type (e.g. 13F-HR, 13F-HR/A, 13F-NT)
total_holdings int64 5
total number of holdings reported in the filing
unique_holdings int64 6
count of distinct security tickers held
total_value int64 7
total dollar value across all reported holdings
report_period_end_date string 8
the end date of the quarter the holdings are reported for
is_amendment bool 9
whether this filing amends a previously filed 13F
amendment_no int64 10
the amendment number, if this is an amendment
amendment_type string 11
the type of amendment (e.g. NEW HOLDINGS, RESTATEMENT)
filing_date string 12
the date the filing was published to the SEC on
file_number string 13
the SEC file number assigned to the filer
share_value int64 14
total dollar value of equity share holdings
share_holdings_cnt int64 15
total share count across equity share holdings
fund_value int64 16
total dollar value of fund (mutual/ETF) holdings
fund_holdings_cnt int64 17
total share count across fund holdings
warrant_value int64 18
total dollar value of warrant holdings
warrant_holdings_cnt int64 19
total share count across warrant holdings
call_value int64 20
total dollar value of call option holdings
call_holdings_cnt int64 21
total share count across call option holdings
put_value int64 22
total dollar value of put option holdings
put_holdings_cnt int64 23
total share count across put option holdings
pfd_value int64 24
total dollar value of preferred stock holdings
pfd_holdings_cnt int64 25
total share count across preferred stock holdings
debt_value int64 26
total dollar value of debt holdings
debt_holdings_cnt int64 27
total share count across debt holdings
agg_total_value int64 28
aggregate dollar value of all holdings for the report period (incl. amendments)
agg_total_holdings int64 29
aggregate count of distinct positions for the report period (incl. amendments)
agg_unique_holdings int64 30
aggregate count of distinct tickers for the report period (incl. amendments)
agg_total_holdings_cnt int64 31
aggregate share count across all holdings for the report period (incl. amendments)
buy_value double 32
total buy value for the report period (incl. amendments)
sell_value double 33
total sell value for the report period (incl. amendments)