Katelynn's Report

Katelynn's Report

(US Market)

Help










Font Size:

IVC holding

The data portal provides longitudinal view of the holding share values at industry and sector levels by each investment company (IVC). The share values are summarized from calibrated share value in 13F report. The holding at per security level is available through 13F Holding table.


ivcidshlds: IVC industry level holding

IVC industry level holding tracks the IVC holding share values in more than 100 industrial categories that was generated according to industry classification of NAICS (North American Industry Classification System). The industrial category of each security was actively maintained by us to promptly reflect any changes, either caused by changes in the security issuer's business or changes in classification standard. The table is constructed as shown below

CREATE TABLE `ivcidshlds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`idscode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`value` int(11) NOT NULL,
`chg` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_ivcidshlds_on_cik_and_period_and_idscode` (`cik`,`period`,`idscode`),
KEY `index_ivcidshlds_on_cik` (`cik`),
KEY `index_ivcidshlds_on_period` (`period`),
KEY `index_ivcidshlds_on_idscode` (`idscode`)
) ENGINE=InnoDB AUTO_INCREMENT=15319080 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

cik: Central index key of the investment company.

period: The reporting period. There are four periods each year (Mar 31st, Jun 30th, Sep 30th, Dec 31st).

idscode: The internal industry classification code, which can be mapped to NAICS code and industry name through idscode2naics table.

value: Calibrated holding share values in 1000 US dollars.


IVC sector level holding

IVC sector level holding tracks the IVC holding share values in 12 major sectors generated according to NAICS. The table is constructed as shown below

CREATE TABLE `ivcsechlds` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`cik` int(11) NOT NULL,
`period` date NOT NULL,
`seccode` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`value` int(11) NOT NULL,
`chg` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `index_ivcsechlds_on_cik_and_period_and_seccode` (`cik`,`period`,`seccode`),
KEY `index_ivcsechlds_on_cik` (`cik`),
KEY `index_ivcsechlds_on_period` (`period`),
KEY `index_ivcsechlds_on_seccode` (`seccode`)
) ENGINE=InnoDB AUTO_INCREMENT=3487865 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Field definition

cik: Central index key of the investment company.

period: The reporting period. There are four periods each year (Mar 31st, Jun 30th, Sep 30th, Dec 31st).

seccode: The internal sector classification code, which can be mapped to sector name through seccode2sectors table.

value: Calibrated holding share values in 1000 US dollars.