| key |
id |
string(100)* |
= |
The id field uniquely identifies the entity record. |
| timeline |
fileTimeStamp |
dateTime* |
=< >= |
Date and time of the data. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the price is calculated. |
| filter_list |
bbTicker |
string(100) |
= |
Bloomberg ticker. For equities, it combines Bloomberg's exchange ticker symbol with the Bloomberg exchange code. For fixed income, it combines Bloomberg's ticker symbol for the issuer with the coupon rate and the maturity date. |
| filter_list |
bbgId |
string(100) |
= |
Bloomberg Global Identifier, a unique, randomly-generated 12-digit identifer. |
| filter_list |
ciqTradingItemId |
long(0,2147483647) |
= |
Unique identifier created by S&P Global Market Intelligence to identify a trading item. |
| filter_list |
cusip |
string(9) |
= |
Committee on Uniform Security Identification Procedures identifier owned by American Bankers Association. This field requires a CUSIP license. Note: CINS (CUSIP International Numbering System) is not supported. |
| filter_list |
dataDate |
date |
= |
The date on which the reported data is effective. |
| filter_list |
dxlId |
string(10)* |
= |
DXL unique identifier assigned to every instrument on an exchange level. |
|
instrumentName |
string(255) |
|
The official name of the financial instrument. |
|
instrumentType |
string(100) |
|
Type of instrument, equity or bond. |
|
intradayDepth |
decimal{22,8} |
|
Intraday quantity on loan as a ratio of settled quantity on loan from latest available publish. |
|
intradayIndicativeFee |
decimal{14,8} |
|
The intraday indicative fee shows the expected borrow cost for a hedge fund, in 'fee' terms, throughout the day. This is a derived rate using S&P's proprietary analytics and data set. The calculation uses both contributed borrow costs between agent lenders and prime brokers on an intraday basis, as well as contributed rates from the hedge fund participants to produce an indication of the intraday market rate. It should not be assumed that the intraday indicative rate is the actual rate a prime broker will quote or charge, but rather an intraday indication of the standard market cost. Requires data contribution. Data will be blank for 'Standard' file version. (Magnitude: Actuals) |
|
intradayIndicativeFeeDelta |
decimal{14,8} |
|
Change in intraday indicative fee, compared to previous dataset date's settled indicative fee. Intraday indicative fee delta = intraday day indicative fee - previous day settled indicative fee. Requires data contribution. Data will be blank for 'Standard' file version. (Magnitude: Actuals) |
|
intradayIndicativeRebate |
decimal{14,8} |
|
The intraday indicative rebate shows the expected borrow cost for a hedge fund, in 'rebate' terms, throughout the day. This is a derived rate using S&P's proprietary analytics and data set. The calculation uses both contributed borrow costs between agent lenders and prime brokers on an intraday basis, as well as contributed rates from the hedge fund participants to produce an indication of the intraday market rate. It should not be assumed that the intraday indicative rate is the actual rate a prime broker will quote or charge, but rather an intraday indication of the standard market cost. Requires data contribution. Data will be blank for 'Standard' file version. |
|
intradayIndicativeRebateDelta |
decimal{14,8} |
|
Change in intraday indicative fee, compared to previous dataset date's settled indicative fee. Intraday indicative fee delta = intraday day indicative fee - previous day settled indicative fee. Requires data contribution. Data will be blank for 'Standard' file version. |
|
intradayLenderQuantityOnLoan |
long(0,9000000000000) |
|
Quantity of intraday loans from lenders. (Magnitude: Actuals) |
|
intradayLenderValueOnLoan |
decimal{14,2} |
|
Value of intraday loans from lenders, expressed in USD. |
|
intradayLoanCount |
long(0,9000000000000) |
|
Count of intraday loans. |
|
intradayQuantityOnLoanVsCash |
long(0,9000000000000) |
|
Quantity of intraday loans vs. cash collateral. (Magnitude: Actuals) |
|
intradayQuantityOnLoanVsNonCash |
long(0,9000000000000) |
|
Quantity of intraday loans vs. non cash collateral. (Magnitude: Actuals) |
|
intradayQuantityOnLoanVsOpen |
long(0,9000000000000) |
|
Quantity of intraday loans with term type open. (Magnitude: Actuals) |
|
intradayQuantityOnLoanVsTerm |
long(0,9000000000000) |
|
Quantity of intraday loans vs. term. (Magnitude: Actuals) |
|
intradayRecallQuantity |
long(0,9000000000000) |
|
Quantity of intraday loans recalled by the lender. (Magnitude: Actuals) |
|
intradayRecallValue |
decimal{14,2} |
|
Value of intraday loans recalled by the lender, expressed in USD. |
|
intradayRerateQuantityOnLoan |
long(0,9000000000000) |
|
Quantity of intraday loans flagged as a rerated transaction. (Magnitude: Actuals) |
|
intradayRerateValueOnLoan |
decimal{14,2} |
|
Value of intraday loans flagged as a rerated transaction, expressed in USD |
|
intradayReturnCount |
long(0,9000000000000) |
|
Count of intraday returns. |
|
intradayShortLoanQuantity |
long(0,9000000000000) |
|
Intraday quantity on loan with loans not related to directional short selling removed. (Magnitude: Actuals) |
|
intradayShortLoanValue |
decimal{14,2} |
|
Intraday value on loan with loans not related to directional short selling removed, expressed in USD. |
|
intradayValueOnLoanVsCash |
decimal{14,2} |
|
Value of intraday loans vs. cash collateral, expressed in USD. |
|
intradayValueOnLoanVsNonCash |
decimal{14,2} |
|
Value of intraday loans vs. non cash collateral, expressed in USD. |
|
intradayValueOnLoanVsOpen |
decimal{14,2} |
|
Value of intraday loans with term type open, expressed in USD. |
|
intradayValueOnLoanVsTerm |
decimal{14,2} |
|
Value of intraday loans vs. term, expressed in USD. |
| filter_list |
isin |
string(12) |
= |
International Securities Identification Number. An international code that identifies a securities issue. |
|
isoCountry |
string(2) |
|
ISO-3166 alpha -2 country code. |
|
isoCurrency |
string(3) |
|
ISO-4217 currency code (fixed income only). |
|
liveAvailableQuantity |
long(0,9000000000000) |
|
Estimated quantity of lendable securities not currently on loan or borrowed, on an intraday basis. Based off settled available quantity from the latest available publish, less net intraday lender quantity on loan (loans - returns). Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a live quantity. (Magnitude: Actuals) |
|
liveAvailableValue |
decimal{16,2} |
|
Estimated value of lendable securities not currently on loan or borrowed, on an intraday basis. Based off settled available value from the latest available publish, less net intraday lender value on loan (loans - returns), expressed in USD. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a live value. |
|
liveLenderQuantityOnLoan |
long(0,9000000000000) |
|
Estimated loans from lenders, on an intraday basis, based off settled lender quantity on loan from the latest available publish, plus net intraday lender quantity on loan (loans - returns). Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a live quantity. (Magnitude: Actuals) |
|
liveLenderValueOnLoan |
decimal{16,2} |
|
Estimated loans from lenders, on an intraday basis, based off settled lender value on loan from the latest available publish, plus net intraday lender value on loan (loans - returns), expressed in USD. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a live value. |
|
liveQuantityOnLoan |
long(0,9000000000000) |
|
Estimated quantity on loan, on an intraday basis, based off settled quantity on loan from the latest available publish, plus net intraday quantity on loan (loans - returns). Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a live quantity. (Magnitude: Actuals) |
|
liveShortLoanQuantity |
long(0,9000000000000) |
|
Estimated short loan quantity, on an intraday basis, based off settled short loan quantity from the latest available publish, plus net intraday short loan quantity (loans - returns). Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a live quantity. (Magnitude: Actuals) |
|
liveShortLoanValue |
decimal{16,2} |
|
Estimated short loan value, on an intraday basis, based off settled short loan value from the latest available publish, plus net intraday short loan value (loans - returns), expressed in USD. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a live value. |
|
liveUtilization |
decimal{14,8} |
|
Estimated utilization, on an intraday basis, based off settled lender value on loan from the latest available publish plus net intraday lender value on loan (loans - returns), divided by settled lendable value from the latest available publish. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a live value. |
|
liveUtilizationByQuantity |
decimal{14,8} |
|
Estimated utilization, on an intraday basis, based off settled lender quantity on loan from the latest available publish plus net intraday lender quantity on loan (loans - returns), divided by settled lendable quantity from the previous dataset date. Please note, this metric is designed to be an indication, and might not always be a precise quantity. Results will show as blanks in instances where S&P Global is not able to reliably inform a live quantity. |
|
liveValueOnLoan |
decimal{16,2} |
|
Estimated value on loan, on an intraday basis, based off settled value on loan from the latest available publish, plus net intraday value on loan (loans - returns), expressed in USD. Please note, this metric is designed to be an indication, and might not always be a precise value. Results will show as blanks in instances where S&P Global is not able to reliably inform a live value. |
|
marketArea |
string(255) |
|
Market classification of security defining the country or currency of trading, security type. |
|
pcIntradayLoansStartT |
decimal{14,8} |
|
Percentage of all intraday loans where start date is equal to trade date. |
|
pcIntradayLoansStartT1 |
decimal{14,8} |
|
Percentage of all intraday loans where start date is equal to trade date +1. |
|
pcIntradayLoansStartT2 |
decimal{14,8} |
|
Percentage of all intraday loans where start date is equal to trade date +2. |
|
pcIntradayReturnsToStartT |
decimal{14,8} |
|
Percentage of all intraday returns where start date is equal to trade date. |
|
pcIntradayReturnsToStartT1 |
decimal{14,8} |
|
Percentage of all intraday returns where start date is equal to trade date +1. |
|
pcIntradayReturnsToStartT2 |
decimal{14,8} |
|
Percentage of all intraday returns where start date is equal to trade date +2. |
|
quick |
string(20) |
|
Security Identification Code Conference; instrument identifier used in Japan. |
|
region |
string(100) |
|
Group that defines a set of instruments. |
|
returnQuantity |
long(0,9000000000000) |
|
Quantity of shares returned to lenders from intraday transactions. (Magnitude: Actuals) |
|
returnValue |
decimal{14,2} |
|
Value of shares returned to lenders from intraday transactions, expressed in USD. |
| filter_list |
sedol |
string(7) |
= |
Stock Exchange Daily Official List identifier assigned by the London Stock Exchange, requires SEDOL license. |
|
timeSeriesId |
long(0,2147483647) |
|
Integer representation of the data date. |
|
tradeQuantity |
long(0,9000000000000) |
|
Quantity of shares on loan received from intraday transactions. Trades can be pending or settled (same day). Representative of intraday demand to borrow securities. (Magnitude: Actuals) |
|
tradeValue |
decimal{14,2} |
|
Value of shares on loan received from intraday transactions, expressed in USD. Trades can be pending or settled (same day). Representative of intraday demand to borrow securities. |