From a 500-row sample across 25 columns.
local_total_cost_amountinvestment_type_namelocal_unrealized_gain_loss+22local_total_cost_amountinvestment_type_namelocal_unrealized_gain_loss+22| local_currency_code | trade_country_name | security_name | interest_rate | original_face | shares_par_value | base_market_value | base_total_cost | base_unrealized_gain_loss | base_accrued_interest | local_market_value | local_total_cost_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| INR | INDIA | INDIAN RUPEE | 0 | 0 | 3142032 | 45518.55 | 45518.55 | 0 | 0 | 3142032 | 3142032 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
local_currency_code | text | This column sets forth the currency code of the country in which the security or financial instrument originates | 0% | USD0JPY |
trade_country_name | text | This column lists the country from which the security or financial instrument originates | 0% | UNITED STATES OF AMERICA…0JAPAN |
security_name | text | This column sets forth the name of the security or financial instrument. In the case of stock and corporate bonds, this will be the company name or bond name. In the case of currency holdings, this will be the name of the currency. In the case of investment funds, it will be the name of the company operating the investment fund. | 0% | 0US TREASURY N/BSTATE STREET BANK + TRUS… |
security_description | text |
GET /api/datasets/fypi-ruxh GET /api/datasets/fypi-ruxh/quality GET /api/datasets/fypi-ruxh/related GET /api/columns?dataset=fypi-ruxh
local_total_cost_amountinvestment_type_namelocal_unrealized_gain_losslocal_total_cost_amountinvestment_type_namelocal_unrealized_gain_loss+22| EUR | INTERNATIONAL | NETFLIX INC | 3.875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| JPY | JAPAN | UACJ CORP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| JPY | JAPAN | EN JAPAN INC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| AUD | AUSTRALIA | WESTERN AREAS LTD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| SEK | SWEDEN | FORTNOX AB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| JPY | JAPAN | NIPPON CARBON CO LTD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| JPY | JAPAN | GODO STEEL LTD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| JPY | JAPAN | NGK INSULATORS LTD | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EUR | FRANCE | HAULOTTE GROUP | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Showing 12 of 25 columns. All of them are listed below.
| This column provides a basic description of the security or financial investment, if any. |
| 1% |
0COMMON STOCKCOMMON STOCK USD.01 |
maturity_date | datetime | This column sets forth the maturity date of the investment, if any. | 17% | 1899-12-31T00:00:00.0002030-12-31T00:00:00.0002028-01-15T00:00:00.000 |
interest_rate | float | This column sets for the interest rate paid on the investment, if any. | 0% | 0.0000043.5 |
original_face | integer | This column sets for the original face value of the investment instrument, if any | 0% | 01000000500000 |
shares_par_value | integer | In the case of fixed income investments (such as bonds), this column sets forth the “par value,” or face value, of the investment instrument; in the case of stock and other financial instruments, this column sets forth the number of shares or units held | 0% | 0200000100000 |
base_market_value | float | This column sets forth the average market value of the investment as of the date set forth in the Period End Date column | 0% | 0.000.010.02 |
base_total_cost | float | This column sets forth the total cost basis of the investment | 0% | 0200000.00125000.00 |
base_unrealized_gain_loss | float | This column sets forth the unrealized gain or loss in value of the investment since acquisition | 0% | 0.00-0.01-0.02 |
base_accrued_interest | float | This column sets forth the amount of interest that has accrued on a fixed income investment since acquisition | 0% | 0.00958.331375.00 |
local_market_value | float | This column sets forth the average value of the investment in the investment’s local market as of the date set forth in the Period End Date column | 0% | 00.010.02 |
local_total_cost_amount | float | This column sets forth the total cost basis of the investment in the investment’s local market | 0% | 0200000.00125000.00 |
local_unrealized_gain_loss | float | This column sets forth the unrealized gain or loss in value of the investment since acquisition in the investment’s local market | 0% | 0-0.01-0.02 |
local_accrued_interest | float | This column sets forth the amount of interest that has accrued on a fixed income investment since acquisition in the investment’s local market | 0% | 0.00958.331375.00 |
period_end_date | datetime | This column sets forth the end date of the fiscal year | 0% | 1899-12-31T00:00:00.0002019-06-30T00:00:00.0002020-06-30T00:00:00.000of 11 |
asset_class | categorical | This column sets forth the investment category into which the investment falls (equity, fixed income, cash or cash equivalent) | 0% | EQUITY1899-12-31T00:00:00.000FIXED INCOMEof 5 |
investment_type_name | text | This column sets forth the name of the type of investment | 0% | COMMON STOCK1899-12-31T00:00:00.000CORPORATE BONDS |
major_industry_name | text | This column sets forth the major industry in which the investment falls | 0% | 1899-12-31T00:00:00.000CORPORATEINDUSTRIALS |
minor_industry_name | text | This column sets forth the minor industry in which the investment falls | 0% | 1899-12-31T00:00:00.000INDUSTRIALBANKS |
moody_s_quality_rating | text | This column sets forth the rating that has been assigned to the investment by Moody's, where a rating is available | 19% | 1899-12-31T00:00:00.000NA0 |
s_and_p_quality_rating | text | This column sets forth the rating that has been assigned to the investment by S&P, where a rating is available | 19% | 1899-12-31T00:00:00.000NA0 |
direct_group_trust_holding | categorical | Indicates a Direct or Group Trust Holding | 0% | Group TrustDirectof 2 |
data_as_of | datetime | — | 11% | 2021-01-21T00:00:00.0002020-01-30T00:00:00.0002023-01-25T00:00:00.000of 7 |