---
name: jpx-tse-listed-issues-ingestion
description: "How to get JPX List of TSE-listed Issues data into a pandas DataFrame and Parquet: access, the request, the format, limits, quirks and terms."
---

# Load the JPX list of TSE-listed issues into pandas and Parquet

Source entry: https://signal-lab-jet.vercel.app/datasets/jpx-tse-listed-issues
Provider: https://www.jpx.co.jp/english/markets/statistics-equities/misc/01.html
Checked against the provider's documentation: 2026-11-05

## Access
- No account or key; direct Excel download.
- English file data_e.xlsx and Japanese twin data_j.xlsx on the List of TSE-listed Issues page.

## Request
```bash
curl -o data_e.xlsx 'https://www.jpx.co.jp/english/markets/statistics-equities/misc/tvdivq0000001vg2-att/data_e.xlsx'
```

## Format
Excel (.xlsx, about 260 KB), one sheet, one row per issue: Effective Date, Local Code, Name (English), Section/Products, 33 Sector(Code), 33 Sector(name), 17 Sector(Code), 17 Sector(name), Size Code (New Index Series), Size (New Index Series). Non-stock rows use "-" in the sector and size columns.

## Load into pandas and Parquet
Needs Python 3 with requests, pandas and pyarrow.
```python
"""JPX List of TSE-listed Issues (monthly Excel, English) -> pandas -> Parquet. No key."""
import io
import requests
import pandas as pd

URL = "https://www.jpx.co.jp/english/markets/statistics-equities/misc/tvdivq0000001vg2-att/data_e.xlsx"
r = requests.get(URL, timeout=60)
r.raise_for_status()
df = pd.read_excel(io.BytesIO(r.content), dtype=str)
df.to_parquet("jpx_tse_listed_issues.parquet", index=False)
print(len(df), "issues; effective", df["Effective Date"].iloc[0], ";", df["Section/Products"].value_counts().index[0])
```
Run by us on 2026-11-05 (python 3.13 | pandas | pyarrow | requests (box probe)). Result: 4444 issues; effective 20261031 ; Prime Market (Domestic)

## Limits
- One snapshot a month (as of the previous month-end), updated at about 9:00 a.m. JST on the 3rd business day; only the latest file is posted.
- No download limit stated.

## Quirks
- Read all columns as text: sector and size columns mix numbers and "-".
- Reference data only, no prices; for prices see the J-Quants API (separate terms).

## Terms and attribution
- JPX website terms prohibit collecting data or secondary use of site information for commercial purposes without JPX permission or a paid contract.
- The list is an outline for information, not a solicitation for investment; JPX does not assure its completeness.
- Terms page: https://www.jpx.co.jp/english/term-of-use/index.html

## Sources
- https://www.jpx.co.jp/english/markets/statistics-equities/misc/01.html: "Updated at approximately 9:00 a.m. on the 3rd business day of each month"
- https://www.jpx.co.jp/english/term-of-use/index.html: "The collection of data or secondary use of information from this website for commercial purposes is strictly prohibited, unless JPX has granted prior permission or authorized such use under a paid contract."

## Help improve this skill
Missing a source, or see something to improve? Call the MCP tool suggest_source or feedback (or POST /api/suggest or /api/feedback). Reviewed ideas: https://signal-lab-jet.vercel.app/agent-suggestions

Information for educational purposes only. Free tiers, limits and licenses belong to the providers and may change; check the provider's own terms before using the data.