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 (stock trading value) can be obtained. This data is also available via the following site. The data is set in units of 1000 yen. https://www.jpx.co.jp/english/markets/statistics-equities/investor-type/index.html

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. 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 parameter "section", please refer to the following page.

pageSection name

Get trading by type of investors

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

Either "code" or "from/to" can be specified.

"*" 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.

Headers

Name	Type	Description
Authorization*	String	Access Key

200: OK

{
    "trades_spec": [
        {
            "PublishedDate":"2017-01-13",
            "StartDate":"2017-01-04",
            "EndDate":"2017-01-06",
            "Section":"TSE1st",
            "ProprietarySales":1311271004,
            "ProprietaryPurchases":1453326508,
            "ProprietaryTotal":2764597512,
            "ProprietaryBalance":142055504,
            "BrokerageSales":7165529005,
            "BrokeragePurchases":7030019854,
            "BrokerageTotal":14195548859,
            "BrokerageBalance":-135509151,
            "TotalSales":8476800009,
            "TotalPurchases":8483346362,
            "TotalTotal":16960146371,
            "TotalBalance":6546353,
            "IndividualsSales":1401711615,
            "IndividualsPurchases":1161801155,
            "IndividualsTotal":2563512770,
            "IndividualsBalance":-239910460,
            "ForeignersSales":5094891735,
            "ForeignersPurchases":5317151774,
            "ForeignersTotal":10412043509,
            "ForeignersBalance":222260039,
            "SecuritiesCosSales":76381455,
            "SecuritiesCosPurchases":61700100,
            "SecuritiesCosTotal":138081555,
            "SecuritiesCosBalance":-14681355,
            "InvestmentTrustsSales":168705109,
            "InvestmentTrustsPurchases":124389642,
            "InvestmentTrustsTotal":293094751,
            "InvestmentTrustsBalance":-44315467,
            "BusinessCosSales":71217959,
            "BusinessCosPurchases":63526641,
            "BusinessCosTotal":134744600,
            "BusinessCosBalance":-7691318,
            "OtherCosSales":10745152,
            "OtherCosPurchases":15687836,
            "OtherCosTotal":26432988,
            "OtherCosBalance":4942684,
            "InsuranceCosSales":15926202,
            "InsuranceCosPurchases":9831555,
            "InsuranceCosTotal":25757757,
            "InsuranceCosBalance":-6094647,
            "CityBKsRegionalBKsEtcSales":10606789,
            "CityBKsRegionalBKsEtcPurchases":8843871,
            "CityBKsRegionalBKsEtcTotal":19450660,
            "CityBKsRegionalBKsEtcBalance":-1762918,
            "TrustBanksSales":292932297,
            "TrustBanksPurchases":245322795,
            "TrustBanksTotal":538255092,
            "TrustBanksBalance":-47609502,
            "OtherFinancialInstitutionsSales":22410692,
            "OtherFinancialInstitutionsPurchases":21764485,
            "OtherFinancialInstitutionsTotal":44175177,
            "OtherFinancialInstitutionsBalance":-646207
        }
    ],
    "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

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
ProprietarySales	Proprietary Sales Value	Number
ProprietaryPurchases	Proprietary Purchase Value	Number
ProprietaryTotal	Proprietary Total Value	Number
ProprietaryBalance	Proprietary Balance Value	Number
BrokerageSales	Brokerage Sales Value	Number
BrokeragePurchases	Brokerage Purchase Value	Number
BrokerageTotal	Brokerage Total Value	Number
BrokerageBalance	Brokerage Balance Value	Number
TotalSales	Total Sales Value	Number
TotalPurchases	Total Purchase Value	Number
TotalTotal	Total Value	Number
TotalBalance	Total Balance Value	Number
IndividualsSales	Individuals Sales Value	Number
IndividualsPurchases	Individuals Purchase Value	Number
IndividualsTotal	Individuals Total Value	Number
IndividualsBalance	Individuals Balance Value	Number
ForeignersSales	Foreigners Sales Value	Number
ForeignersPurchases	Foreigners Purchase Value	Number
ForeignersTotal	Foreigners Total Value	Number
ForeignersBalance	Foreigners Balance Value	Number
SecuritiesCosSales	Securities Companies Sales Value	Number
SecuritiesCosPurchases	Securities Companies Purchase Value	Number
SecuritiesCosTotal	Securities Companies Total	Number
SecuritiesCosBalance	Securities Companies Balance Value	Number
InvestmentTrustsSales	Investment Trusts Sales Value	Number
InvestmentTrustsPurchases	Investment Trusts Purchase Value	Number
InvestmentTrustsTotal	Investment Trusts Total Value	Number
InvestmentTrustsBalance	Investment Trusts Balance Value	Number
BusinessCosSales	Business Companies Sales Value	Number
BusinessCosPurchases	Business Companies Purchase Value	Number
BusinessCosTotal	Business Companies Total Value	Number
BusinessCosBalance	Business Companies Balance Value	Number
OtherCosSales	Other Companies Sales Value	Number
OtherCosPurchases	Other Companies Purchase Value	Number
OtherCosTotal	Other Companies Total Value	Number
OtherCosBalance	Other Companies Balance Value	Number
InsuranceCosSales	Insurance Companies Sales Value	Number
InsuranceCosPurchases	Insurance Companies Purchase Value	Number
InsuranceCosTotal	Insurance Companies Total Value	Number
InsuranceCosBalance	Insurance Companies Balance Value	Number
CityBKsRegionalBKsEtcSales	City Banks Regional Banks Etc Sales Value	Number
CityBKsRegionalBKsEtcPurchases	City Banks Regional Banks Etc Purchase Value	Number
CityBKsRegionalBKsEtcTotal	City Banks Regional Banks Etc Total Value	Number
CityBKsRegionalBKsEtcBalance	City Banks Regional Banks Etc Balance Value	Number
TrustBanksSales	Trust Banks Sales Value	Number
TrustBanksPurchases	Trust Banks Purchase Value	Number
TrustBanksTotal	Trust Banks Total Value	Number
TrustBanksBalance	Trust Banks Balance Value	Number
OtherFinancialInstitutionsSales	Other Financial Institutions Sales Value	Number
OtherFinancialInstitutionsPurchases	Other Financial Institutions Purchase Value	Number
OtherFinancialInstitutionsTotal	Other Financial Institutions Total Value	Number
OtherFinancialInstitutionsBalance	Other Financial Institutions Balance Value	Number

Sample Code

Curl

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

Python

import requests
import json

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