📑Market information API

You can information about market.

Weekly Trading by Type of Investors

Trading by Type of Investors data (value) is available since January 2017.

This data is also available via the following site. The data is listed in units of 1000 yen. https://www.jpx.co.jp/english/markets/statistics-equities/investor-type/index.html

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

• 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 September 19, 2022: only the data after revision is provided.

  • Revisions that are announced on or after September 20, 2022: 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.

Get trading by type of investors

GET https://api.jpx-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）

Headers

Name	Type	Description
Authorization*	String	Access Key

200: OK

{
    "trades_spec": [
        {
            "Section":"TSE1st",
            "PublishedDate":"2017-01-13",
            "StartDate":"2017-01-04",
            "EndDate":"2017-01-06",
            "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
        }
    ]
}

400: Bad Request

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

401: Unauthorized

{
    "message": "The incoming token has expired"
}

403: Forbidden

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

Variables	Description	Data type	Examples
Section	Section Name	String	TSEPrime
PublishedDate	Published Date	String	2017-01-13
StartDate	Start Date	String	2017-01-04
EndDate	End Date	String	2017-01-06
ProprietarySales	Proprietary Sales Value	Number	1311271004
ProprietaryPurchases	Proprietary Purchase Value	Number	1453326508
ProprietaryTotal	Proprietary Total Value	Number	2764597512
ProprietaryBalance	Proprietary Balance Value	Number	142055504
BrokerageSales	Brokerage Sales Value	Number	7165529005
BrokeragePurchases	Brokerage Purchase Value	Number	7030019854
BrokerageTotal	Brokerage Total Value	Number	14195548859
BrokerageBalance	Brokerage Balance Value	Number	-135509151
TotalSales	Total Sales Value	Number	8476800009
TotalPurchases	Total Purchase Value	Number	8483346362
TotalTotal	Total Value	Number	16960146371
TotalBalance	Total Balance Value	Number	6546353
IndividualsSales	Individuals Sales Value	Number	1401711615
IndividualsPurchases	Individuals Purchase Value	Number	1161801155
IndividualsTotal	Individuals Total Value	Number	2563512770
IndividualsBalance	Individuals Balance Value	Number	-239910460
ForeignersSales	Foreigners Sales Value	Number	5094891735
ForeignersPurchases	Foreigners Purchase Value	Number	5317151774
ForeignersTotal	Foreigners Total Value	Number	10412043509
ForeignersBalance	Foreigners Balance Value	Number	222260039
SecuritiesCosSales	Securities Companies Sales Value	Number	76381455
SecuritiesCosPurchases	Securities Companies Purchase Value	Number	61700100
SecuritiesCosTotal	Securities Companies Total	Number	138081555
SecuritiesCosBalance	Securities Companies Balance Value	Number	-14681355
InvestmentTrustsSales	Investment Trusts Sales Value	Number	168705109
InvestmentTrustsPurchases	Investment Trusts Purchase Value	Number	124389642
InvestmentTrustsTotal	Investment Trusts Total Value	Number	293094751
InvestmentTrustsBalance	Investment Trusts Balance Value	Number	-44315467
BusinessCosSales	Business Companies Sales Value	Number	71217959
BusinessCosPurchases	Business Companies Purchase Value	Number	63526641
BusinessCosTotal	Business Companies Total Value	Number	134744600
BusinessCosBalance	Business Companies Balance Value	Number	-7691318
OtherCosSales	Other Companies Sales Value	Number	10745152
OtherCosPurchases	Other Companies Purchase Value	Number	15687836
OtherCosTotal	Other Companies Total Value	Number	26432988
OtherCosBalance	Other Companies Balance Value	Number	4942684
InsuranceCosSales	Insurance Companies Sales Value	Number	15926202
InsuranceCosPurchases	Insurance Companies Purchase Value	Number	9831555
InsuranceCosTotal	Insurance Companies Total Value	Number	25757757
InsuranceCosBalance	Insurance Companies Balance Value	Number	-6094647
CityBKsRegionalBKsEtcSales	City Banks Regional Banks Etc Sales Value	Number	10606789
CityBKsRegionalBKsEtcPurchases	City Banks Regional Banks Etc Purchase Value	Number	8843871
CityBKsRegionalBKsEtcTotal	City Banks Regional Banks Etc Total Value	Number	19450660
CityBKsRegionalBKsEtcBalance	City Banks Regional Banks Etc Balance Value	Number	-1762918
TrustBanksSales	Trust Banks Sales Value	Number	292932297
TrustBanksPurchases	Trust Banks Purchase Value	Number	245322795
TrustBanksTotal	Trust Banks Total Value	Number	538255092
TrustBanksBalance	Trust Banks Balance Value	Number	-47609502
OtherFinancialInstitutionsSales	Other Financial Institutions Sales Value	Number	22410692
OtherFinancialInstitutionsPurchases	Other Financial Institutions Purchase Value	Number	21764485
OtherFinancialInstitutionsTotal	Other Financial Institutions Total Value	Number	44175177
OtherFinancialInstitutionsBalance	Other Financial Institutions Balance Value	Number	-646207

Curl

idToken=<YOUR idToken> && curl https://api.jpx-jquants.com/v1/markets/trades_spec -H "Authorization: Bearer $idToken" 

Python

import requests
import json

idToken = "YOUR idToken"
headers = {'Authorization': 'Bearer {}'.format(idToken)}
r = requests.get("https://api.jpx-jquants.com/v1/markets/trades_spec", headers=headers)
r.json()