J-Quants API
Search…
⌃K
📑

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.
  • 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
https://api.jpx-jquants.com/v1
/markets/trades_spec
Get trading by type of investors
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
Python
idToken=<YOUR idToken> && curl https://api.jpx-jquants.com/v1/markets/trades_spec -H "Authorization: Bearer $idToken"
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()