| 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 |
= |
Date of the data. |
| filter_list |
dxlId |
string(10)* |
= |
DXL unique identifier assigned to every instrument on an exchange level |
|
instrumentName |
string(255) |
|
Security description. |
|
instrumentType |
string(100) |
|
Type of Instrument, Equity or Bond. |
|
intradayDepth |
decimal{14,8} |
|
Intraday Quantity on Loan as a ratio of settled Quantity on Loan from latest available publish. |
|
intradayLenderQuantityOnLoan |
long(0,9000000000000) |
|
Quantity of Intraday loans from Lenders, expressed in shares. |
|
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, expressed in shares. |
|
intradayQuantityOnLoanVsNonCash |
long(0,9000000000000) |
|
Quantity of Intraday Loans vs. Non Cash Collateral, expressed in shares. |
|
intradayQuantityOnLoanVsOpen |
long(0,9000000000000) |
|
Quantity of Intraday Loans with Term type Open, expressed in shares. |
|
intradayQuantityOnLoanVsTerm |
long(0,9000000000000) |
|
Quantity of Intraday Loans vs. Term, expressed in shares. |
|
intradayRecallQuantity |
long(0,9000000000000) |
|
Quantity of Intraday Loans recalled by the Lender, expressed in shares. |
|
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, expressed in shares. |
|
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, expressed in shares. |
|
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 Country code |
|
isoCurrency |
string(3) |
|
ISO Currency code (fixed income only) |
|
liveAvailableQuantity |
long(0,9000000000000) |
|
Indication of overall Quantity of lendable securities not currently on loan/borrowed, on an Intraday basis. Based off settled Available Quantity from the latest available publish, less net Intraday Lender Quantity on Loan (Loans - Returns), expressed in shares.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. |
|
liveAvailableValue |
decimal{16,2} |
|
Indication of overall Value of lendable securities not currently on loan/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) |
|
Indication of overall 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), expressed in shares.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. |
|
liveLenderValueOnLoan |
decimal{16,2} |
|
Indication of overall 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) |
|
Indication of overall 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), expressed in shares.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. |
|
liveShortLoanQuantity |
long(0,9000000000000) |
|
Indication of overall 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), expressed in shares.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. |
|
liveShortLoanValue |
decimal{16,2} |
|
Indication of overall 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} |
|
Indication of overall 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} |
|
Indication of overall 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} |
|
Indication of overall 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, expressed in shares. |
|
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, expressed in shares. Trades can be pending or settled (same day). Representative of intraday demand to borrow securities. |
|
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. |
|
vwaf |
decimal{14,8} |
|
Value weighted average fee for all intraday trades (multiply by 100 for %, 10000 for bps). |
|
vwar |
decimal{14,8} |
|
Value weighted average rebate for all intraday trades (multiply by 100 for %, 10000 for bps). |