| key |
id |
string(250)* |
= |
The id field uniquely identifies the entity record. |
|
aggregatedParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The Aggregated Par Held represents the total par value held grouped by the count of funds or companies as holders within specific industries or sectors based on GICS classification at a given calendar quarter end date in USD. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the ParHeld is reported. |
|
buyCount |
long(-2147483648,2147483647) |
|
The Buy Count represents the total number of distinct transactions where investors have purchased a specific security categorized by GICS industry or sector classification. It provides insight into the frequency of buying activity across different sectors and helps assess sector-specific investment trends for a specific Calendar Quarter End Date. |
|
buyInCount |
long(-2147483648,2147483647) |
|
The Buy In Count indicates the total number of distinct holders who have newly acquired positions in a specific security based on GICS industry or sector classification. This count highlights the number of new or additional investors entering different sectors for a specific Calendar Quarter End Date. |
|
buyInParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The Buy In Par Held represents the total par value of securities newly acquired by distinct investors for a specific security based on GICS industry or sector classification. This metric highlights the aggregate value of new or additional investments entering different sectors for a specific Calendar Quarter End Date in USD. |
|
buyParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The Buy Par Held represents the total par value of securities purchased by investors for a specific security categorized by GICS industry or sector classification. It provides insight into the aggregate value of buying activity across different sectors and helps assess sector-specific investment trends for a specific Calendar Quarter End Date in USD. |
|
dateEndedStandard |
date |
|
The Date Ended Standard refers to the standardized format used to indicate the Quarter End Date. It provides a uniform method for documenting when an event or timeframe officially concludes. This standardization ensures accuracy and consistency across records and systems. |
|
holdersCount |
long(-2147483648,2147483647) |
|
The Holders Count represents the total number of distinct holders across various industries or sectors based on GICS classification for a given security for a specific Calendar Quarter End Date. It offers insight into the distribution of investors across different industry sectors. This count is important for assessing sectoral investor diversity. |
|
isDeleted |
boolean |
|
Indicates whether the row is (logically) deleted or not. |
|
isFirmLevelAggregate |
boolean |
|
The "Is Firm Level Aggregate" value represents whether the aggregate calculations from the table were done for firm owners. When it is true its counterpart field value "Is Fund Level Aggregate" will be false. |
|
isFundLevelAggregate |
boolean |
|
The "Is Fund Level Aggregate" value represents whether the aggregate calculations from the table were done for fund owners. When it is true its counterpart field "Is Firm Level Aggregate" will be false. |
|
keyCiqIndustryTree |
long(-32768,32767) |
|
The Key CIQ Industry Tree classifies industries based on the CIQ Industry Tree structure. It provides insights into industry activity trends for a specific Calendar Quarter End Date. The corresponding primary industry and sector are provided in primaryIndustryGics and primarySectorGics fields of the entity. |
|
lastModifiedDateTime |
dateTime* |
|
Last modification date and time of a physical row in UTC timezone. |
|
latestFlag |
boolean |
|
The Latest Flag determines whether the aggregate calculations from the table were made based on the latest available active portfolio only in which case the value will be true. If the calculations were made based on historical portfolios the value will be false. |
|
primaryIndustryGics |
string(250) |
|
The Primary Industry GICS classifies the primary industry for holders based on the GICS system. It offers an overview of holder positions within various industries for a specific Calendar Quarter End Date. |
|
primarySectorGics |
string(250) |
|
The Primary Sector GICS classifies the primary sector for holders based on GICS. It offers an overview of holder positions within various sectors for a specific Calendar Quarter End Date. |
|
sellCount |
long(-2147483648,2147483647) |
|
The Sell Count represents the total number of distinct transactions where investors have sold a specific security categorized by GICS industry or sector classification. It reflects the frequency of selling activity across various sectors and helps understand divestment trends for a specific Calendar Quarter End Date. |
|
sellOutCount |
long(-2147483648,2147483647) |
|
The Sell Out Count signifies the total number of distinct holders who have completely sold their holdings of a specific security categorized by GICS industry or sector classification. This count provides insight into the number of investors exiting their positions across different sectors for a specific Calendar Quarter End Date. |
|
sellOutParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The Sell Out Par Held represents the total par value of securities that distinct holders have completely sold for a specific security categorized by GICS industry or sector classification. This metric provides insight into the aggregate value of securities exited across different sectors for a specific Calendar Quarter End Date in USD. |
|
sellParHeld |
long(-9223372036854775807,9223372036854775806) |
|
The Sell Par Held represents the total par value of securities sold by investors for a specific security categorized by GICS industry or sector classification. It reflects the aggregate value of selling activity across various sectors and helps understand the magnitude of divestments for a specific Calendar Quarter End Date in USD. |