Trading by Type of Investors (/markets/trades_spec)

Trading by type of investors (stock trading value) can be obtained.

Overview

Trading by type of investors can be obtained. This data is also available via the following site. https://www.jpx.co.jp/english/markets/statistics-equities/investor-type/index.html

For the interrelationships of each data, please refer as below.

Attention

• In accordance with the market classification review conducted on April 4, 2022, statistical data that are based on market classifications have been The statistical data that are based on the revised market segments have been changed to the new market segments and are presented here.

• When the data of trading by type of investors is revised, that is, value of the past data is modified, the data is provided by this API as follows.

  • Revisions that are announced on or before April 3, 2023: only the data after revision is provided.

  • Revisions that are announced on or after April 3, 2023: both the data before revision and after revision are provided. When a revision occurs, a record is added with the same Section, StartDate and EndDate. In such a case, data with the newer PublishedDate represents the revised data while the data with the older PublishedDate can be identified as the pre-correction data.

Parameter and Response

In your request message, either "section" or "from/to" can be specified. It is possible to set a flag "is_value", and if it is true, you can obtain data for the amount; if false, you can obtain data for the number of shares. Combination of parameter in the request and results are as below.

Section	From /To	Results
		Trading data of a specific section for the specified period.
		All trading data of a specific section.
		Trading data of all sections for the specified period.
		All trading data of all sections for all available period.

For the flag "is_value", please refer to the table below.

If the flag "is_value" is not set, the response will be in amount based.

is_value	Results
true	Data in units of amount(Units of 1,000 yen)
false	Data in units of shares(Units of 1,000 shares)

For the parameter "section", please refer to the following page.

pageSection name

Get trading by type of investors

GET https://api.jquants-pro.com/v1/markets/trades_spec

Either "code" or "from/to" can be specified. It is possible to set a flag for the amount(is_value), and if it is true, you can obtain data for the amount; if false, you can obtain data for the number of shares.

"*" Required.

Query Parameters

Name	Type	Description
section	String	section name （e.g. TSEPrime）
from	String	starting point of data period （e.g. 20210901 or 2021-09-01）
to	String	end point of data period （e.g. 20210907 or 2021-09-07）
pagination_key	String	The primary key of the first item that this operation will evaluate. Use the value that was returned for pagination_key in the previous operation.
is_value	String	a flag for the amount （true or false）

Headers

Name	Type	Description
Authorization*	String	Access Key

200: OK

{
    "trades_spec": [
        {
            "PublishedDate": "2020-01-08",
            "StartDate": "2019-12-23",
            "EndDate": "2019-12-27",
            "Section": "TSE1st",
            "ProprietarySalesValue": 1008801247.0,
            "ProprietaryPurchasesValue": 1110285326.0,
            "ProprietaryTotalValue": 2119086573.0,
            "ProprietaryBalanceValue": 101484079.0,
            "BrokerageSalesValue": 6300413556.0,
            "BrokeragePurchasesValue": 6207917380.0,
            "BrokerageTotalValue": 12508330936.0,
            "BrokerageBalanceValue": -92496176.0,
            "TotalSalesValue": 7309214803.0,
            "TotalPurchasesValue": 7318202706.0,
            "TotalTotalValue": 14627417509.0,
            "TotalBalanceValue": 8987903.0,
            "IndividualsSalesValue": 1664637841.0,
            "IndividualsPurchasesValue": 1577133528.0,
            "IndividualsTotalValue": 3241771369.0,
            "IndividualsBalanceValue": -87504313.0,
            "ForeignersSalesValue": 4011051173.0,
            "ForeignersPurchasesValue": 4140884154.0,
            "ForeignersTotalValue": 8151935327.0,
            "ForeignersBalanceValue": 129832981.0,
            "SecuritiesCosSalesValue": 61112633.0,
            "SecuritiesCosPurchasesValue": 61692637.0,
            "SecuritiesCosTotalValue": 122805270.0,
            "SecuritiesCosBalanceValue": 580004.0,
            "InvestmentTrustsSalesValue": 174855913.0,
            "InvestmentTrustsPurchasesValue": 106079133.0,
            "InvestmentTrustsTotalValue": 280935046.0,
            "InvestmentTrustsBalanceValue": -68776780.0,
            "BusinessCosSalesValue": 90791248.0,
            "BusinessCosPurchasesValue": 79495157.0,
            "BusinessCosTotalValue": 170286405.0,
            "BusinessCosBalanceValue": -11296091.0,
            "OtherCosSalesValue": 13768054.0,
            "OtherCosPurchasesValue": 59548767.0,
            "OtherCosTotalValue": 73316821.0,
            "OtherCosBalanceValue": 45780713.0,
            "InsuranceCosSalesValue": 13157376.0,
            "InsuranceCosPurchasesValue": 3313814.0,
            "InsuranceCosTotalValue": 16471190.0,
            "InsuranceCosBalanceValue": -9843562.0,
            "CityBKsRegionalBKsEtcSalesValue": 25480516.0,
            "CityBKsRegionalBKsEtcPurchasesValue": 5964700.0,
            "CityBKsRegionalBKsEtcTotalValue": 31445216.0,
            "CityBKsRegionalBKsEtcBalanceValue": -19515816.0,
            "TrustBanksSalesValue": 234270831.0,
            "TrustBanksPurchasesValue": 161116278.0,
            "TrustBanksTotalValue": 395387109.0,
            "TrustBanksBalanceValue": -73154553.0,
            "OtherFinancialInstitutionsSalesValue": 11287971.0,
            "OtherFinancialInstitutionsPurchasesValue": 12689212.0,
            "OtherFinancialInstitutionsTotalValue": 23977183.0,
            "OtherFinancialInstitutionsBalanceValue": 1401241.0,
            "IndividualCashSalesValue": 1826541.0,
            "IndividualCashPurchasesValue": 2578741.0,
	    "IndividualMarginSalesValue": 4401241.0,
	    "IndividualMarginPurchasesValue": 6401241.0,
	    "ProprietaryCashSalesValue": 401241.0,
	    "ProprietaryCashPurchasesValue": 901241.0,
	    "ProprietaryMarginSalesValue": 2241.0,
	    "ProprietaryMarginPurchasesValue": 44241.0,
	    "ForeignInstitutionsSalesValue": 557841.0,
	    "ForeignInstitutionsPurchasesValue": 98341.0,
	    "ForeignIndividualsSalesValue": 23541.0,
            "ForeignIndividualsPurchasesValue": 33471.0
        }
    ],
    "pagination_key": "value1.value2."
}

400: Bad Request

{
    "message": "<Error Message>"
}

401: Unauthorized

{
    "message": "The incoming token is invalid or expired."
}

403: Forbidden

{
    "message": "Missing Authentication Token. The method or resources may not be supported."
}

500: Internal Server Error

{
    "message": "Unexpected error. Please try again later."
}

413: Payload Too Large

{
    "message": "Response data is too large. Specify parameters to reduce the acquired data range."
}

Data Item

Number of shares

Variable	Description	Data type	Remark
PublishedDate	Published Date	String	YY-MM-DD
StartDate	Start Date	String	YY-MM-DD
EndDate	End Date	String	YY-MM-DD
Section	Section Name	String	See Section name
ProprietarySalesVolume	Proprietary Sales Volume	Number
ProprietaryPurchasesVolume	Proprietary Purchases Volume	Number
ProprietaryTotalVolume	Proprietary Total Volume	Number
ProprietaryBalanceVolume	Proprietary Balance Volume	Number	※
BrokerageSalesVolume	Brokerage Sales Volume	Number
BrokeragePurchasesVolume	Brokerage Purchases Volume	Number
BrokerageTotalVolume	Brokerage Total Volume	Number
BrokerageBalanceVolume	Brokerage Balance Volume	Number	※
TotalSalesVolume	Total Sales Volume	Number
TotalPurchasesVolume	Total Purchases Volume	Number
TotalTotalVolume	Total Total Volume	Number
TotalBalanceVolume	Total Balance Volume	Number	※
IndividualsSalesVolume	Individuals Sales Volume	Number
IndividualsPurchasesVolume	Individuals Purchases Volume	Number
IndividualsTotalVolume	Individuals Total Volume	Number
IndividualsBalanceVolume	Individuals Balance Volume	Number	※
ForeignersSalesVolume	Foreigners Sales Volume	Number
ForeignersPurchasesVolume	Foreigners Purchases Volume	Number
ForeignersTotalVolume	Foreigners Total Volume	Number
ForeignersBalanceVolume	Foreigners Balance Volume	Number	※
SecuritiesCosSalesVolume	Securities Cos Sales Volume	Number
SecuritiesCosPurchasesVolume	Securities Cos Purchases Volume	Number
SecuritiesCosTotalVolume	Securities Cos Total Volume	Number
SecuritiesCosBalanceVolume	Securities Cos Balance Volume	Number	※
InvestmentTrustsSalesVolume	Investment Trusts Sales Volume	Number
InvestmentTrustsPurchasesVolume	Investment Trusts Purchases Volume	Number
InvestmentTrustsTotalVolume	Investment Trusts Total Volume	Number
InvestmentTrustsBalanceVolume	Investment Trusts Balance Volume	Number	※
BusinessCosSalesVolume	Business Cos Sales Volume	Number
BusinessCosPurchasesVolume	Business Cos Purchases Volume	Number
BusinessCosTotalVolume	Business Cos Total Volume	Number
BusinessCosBalanceVolume	Business Cos Balance Volume	Number	※
OtherCosSalesVolume	Other Cos Sales Volume	Number
OtherCosPurchasesVolume	Other Cos Purchases Volume	Number
OtherCosTotalVolume	Other Cos Total Volume	Number
OtherCosBalanceVolume	Other Cos Balance Volume	Number	※
InsuranceCosSalesVolume	Insurance Cos Sales Volume	Number
InsuranceCosPurchasesVolume	Insurance Cos Purchases Volume	Number
InsuranceCosTotalVolume	Insurance Cos Total Volume	Number
InsuranceCosBalanceVolume	Insurance Cos Balance Volume	Number	※
CityBKsRegionalBKsEtcSalesVolume	City Banks Regional Banks Etc Sales Volume	Number
CityBKsRegionalBKsEtcPurchasesVolume	City Banks Regional Banks Etc Purchases Volume	Number
CityBKsRegionalBKsEtcTotalVolume	City Banks Regional Banks Etc Total Volume	Number
CityBKsRegionalBKsEtcBalanceVolume	City Banks Regional Banks Etc Balance Volume	Number	※
TrustBanksSalesVolume	Trust Banks Sales Volume	Number
TrustBanksPurchasesVolume	Trust Banks Purchases Volume	Number
TrustBanksTotalVolume	Trust Banks Total Volume	Number
TrustBanksBalanceVolume	Trust Banks Balance Volume	Number	※
OtherFinancialInstitutionsSalesVolume	Other Financial Institutions Sales Volume	Number
OtherFinancialInstitutionsPurchasesVolume	Other Financial Institutions Purchases Volume	Number
OtherFinancialInstitutionsTotalVolume	Other Financial Institutions Total Volume	Number
OtherFinancialInstitutionsBalanceVolume	Other Financial Institutions Balance Volume	Number	※
IndividualCashSalesVolume	Individual Cash Sales Volume	Number
IndividualCashPurchasesVolume	Individual Cash Purchases Volume	Number
IndividualMarginSalesVolume	Individual Margin Sales Volume	Number
IndividualMarginPurchasesVolume	Individual Margin Purchases Volume	Number
ProprietaryCashSalesVolume	Proprietary Cash Sales Volume	Number
ProprietaryCashPurchasesVolume	Proprietary Cash Purchases Volume	Number
ProprietaryMarginSalesVolume	Proprietary Margin Sales Volume	Number
ProprietaryMarginPurchasesVolume	Proprietary Margin Purchases Volume	Number
ForeignInstitutionsSalesVolume	Foreign Institutions Sales Volume	Number
ForeignInstitutionsPurchasesVolume	Foreign Institutions Purchases Volume	Number
ForeignIndividualsSalesVolume	Foreign Individuals Sales Volume	Number
ForeignIndividualsPurchasesVolume	Foreign Individuals Purchases Volume	Number

Amount

Variable	Description	Data type	Remark
PublishedDate	Published Date	String	YY-MM-DD
StartDate	Star tDate	String	YY-MM-DD
EndDate	End Date	String	YY-MM-DD
Section	Section Name	String	See Section name
ProprietarySalesValue	Proprietary Sales Value	Number
ProprietaryPurchasesValue	Proprietary Purchases Value	Number
ProprietaryTotalValue	Proprietary Total Value	Number
ProprietaryBalanceValue	Proprietary Balance Value	Number	※
BrokerageSalesValue	Brokerage Sales Value	Number
BrokeragePurchasesValue	Brokerage Purchases Value	Number
BrokerageTotalValue	Brokerage Total Value	Number
BrokerageBalanceValue	Brokerage Balance Value	Number	※
TotalSalesValue	Total Sales Value	Number
TotalPurchasesValue	Total Purchases Value	Number
TotalTotalValue	Total Total Value	Number
TotalBalanceValue	Total Balance Value	Number	※
IndividualsSalesValue	Individuals Sales Value	Number
IndividualsPurchasesValue	Individuals Purchases Value	Number
IndividualsTotalValue	Individuals Total Value	Number
IndividualsBalanceValue	Individuals Balance Value	Number	※
ForeignersSalesValue	Foreigners Sales Value	Number
ForeignersPurchasesValue	Foreigners Purchases Value	Number
ForeignersTotalValue	Foreigners Total Value	Number
ForeignersBalanceValue	Foreigners Balance Value	Number	※
SecuritiesCosSalesValue	Securities Cos Sales Value	Number
SecuritiesCosPurchasesValue	Securities Cos Purchases Value	Number
SecuritiesCosTotalValue	Securities Cos Total Value	Number
SecuritiesCosBalanceValue	Securities Cos Balance Value	Number	※
InvestmentTrustsSalesValue	Investment Trusts Sales Value	Number
InvestmentTrustsPurchasesValue	Investment Trusts Purchases Value	Number
InvestmentTrustsTotalValue	Investment Trusts Total Value	Number
InvestmentTrustsBalanceValue	Investment Trusts Balance Value	Number	※
BusinessCosSalesValue	Business Cos Sales Value	Number
BusinessCosPurchasesValue	Business Cos Purchases Value	Number
BusinessCosTotalValue	Business Cos Total Value	Number
BusinessCosBalanceValue	Business Cos Balance Value	Number	※
OtherCosSalesValue	Other Cos Sales Value	Number
OtherCosPurchasesValue	Other Cos Purchases Value	Number
OtherCosTotalValue	Other Cos Total Value	Number
OtherCosBalanceValue	Other Cos Balance Value	Number	※
InsuranceCosSalesValue	Insurance Cos Sales Value	Number
InsuranceCosPurchasesValue	Insurance Cos Purchases Value	Number
InsuranceCosTotalValue	Insurance Cos Total Value	Number
InsuranceCosBalanceValue	Insurance Cos Balance Value	Number	※
CityBKsRegionalBKsEtcSalesValue	City BKs Regional BKs Etc Sales Value	Number
CityBKsRegionalBKsEtcPurchasesValue	City BKs Regional BKs Etc Purchases Value	Number
CityBKsRegionalBKsEtcTotalValue	City BKs Regional BKs Etc Total Value	Number
CityBKsRegionalBKsEtcBalanceValue	City BKs Regional BKs Etc Balance Value	Number	※
TrustBanksSalesValue	Trust Banks Sales Value	Number
TrustBanksPurchasesValue	Trust Banks Purchases Value	Number
TrustBanksTotalValue	Trust Banks Total Value	Number
TrustBanksBalanceValue	Trust Banks Balance Value	Number	※
OtherFinancialInstitutionsSalesValue	Other Financial Institutions Sales Value	Number
OtherFinancialInstitutionsPurchasesValue	Other Financial Institutions Purchases Value	Number
OtherFinancialInstitutionsTotalValue	Other Financial Institutions Total Value	Number
OtherFinancialInstitutionsBalanceValue	Other Financial Institutions Balance Value	Number	※
IndividualCashSalesValue	Individual Cash Sales Value	Number
IndividualCashPurchasesValue	Individual Cash Purchases Value	Number
IndividualMarginSalesValue	Individual Margin Sales Value	Number
IndividualMarginPurchasesValue	Individual Margin Purchases Value	Number
ProprietaryCashSalesValue	Proprietary Cash Sales Value	Number
ProprietaryCashPurchasesValue	Proprietary Cash Purchases Value	Number
ProprietaryMarginSalesValue	Proprietary Margin Sales Value	Number
ProprietaryMarginPurchasesValue	Proprietary Margin Purchases Value	Number
ForeignInstitutionsSalesValue	Foreign Institutions Sales Value	Number
ForeignInstitutionsPurchasesValue	Foreign Institutions Purchases Value	Number
ForeignIndividualsSalesValue	Foreign Individuals Sales Value	Number
ForeignIndividualsPurchasesValue	Foreign Individuals Purchases Value	Number

※ Difference represents the amount of 'purchases-sell,' indicating whether there were more sell orders or purchases orders. If there is no sign, it indicates a surplus of buy orders, while a '-' sign indicates a surplus of sell orders.

Sample Code

Curl

idToken=<YOUR idToken> && curl https://api.jquants-pro.com/v1/markets/trades_spec?section=TSEPrime&from=20230324&to=20230403&is_value=true -H "Authorization: Bearer $idToken" 

Python

import requests
import json

idToken = "YOUR idToken"
headers = {'Authorization': 'Bearer {}'.format(idToken)}
r = requests.get("https://api.jquants-pro.com/v1/markets/trades_spec?section=TSEPrime&from=20230324&to=20230403&is_value=true", headers=headers)
r.json()