--- title: "Data sample: Excel, CSV & JSON | Markets Open" date: "2026-10-24" data_version: "2026.10.22-rc.1" ui_version: "1.13.79" canonical: "https://marketsopen.today/data/sample" status: null status_reason: null source_published_at: null last_verified_at: null generated_at: "2026-11-12T08:25:20Z" --- # Data sample: Excel, CSV & JSON | Markets Open Skip to content (#content) markets open .today (/) Today (/)Calendar (/holidays/2026)API & data (/data) Support (https://buy.stripe.com/8x2fZ9crrdgb9kAdQffrW00) EN 中文 (/zh/data/sample) MARKETS OPEN PRO · DATA SAMPLE Less sorting. Ready-to-use files. A sample of the data pack included in Markets Open Pro (/account/buy): the same free calendar facts, consolidated into Excel, CSV and JSON. FREE Free lookup Check calendars and night-session dates Use public APIs and downloads Combine and format files yourself MARKETS OPEN PRO Ready-to-use pack Consolidated annual multi-market workbook Six sheets, including coverage and sources Full CSV / JSON ZIP Download Excel sample (/samples/marketsopen-data-pack-sample.xlsx)See report preview ↓ (#sample-report) Sample download needs no login. Report preview Snapshot year 2026 · Status-check date 2026-10-09 Generated from sample data; shows what you can do with the pack. 2026-10-01 SHFE Confirmed closed 2026-10-09 SHFE.au Civil night session 21:00–02:30 (+1 day) · Trading date 2026-10-12 2026-12-31 SHFE.au Next trading date Not yet confirmed Actual full snapshot: 13 market/channel scopes · 4,745 calendar rows · 32,120 session rows. Times: Asia/Shanghai. What the standard package contains Public sample: 15 calendar rows, 10 session rows, 3 coverage rows and 4 sources. Selected rows only, not the full annual pack. Calendars · CSV (/samples/marketsopen-data-pack-calendars-sample.csv)Sessions · CSV (/samples/marketsopen-data-pack-sessions-sample.csv)Complete sample · JSON (/samples/marketsopen-data-pack-sample.json) XLSX One workbook, six sheets Start, Calendars, Sessions, Coverage, Sources and Fields. Filter dates and products; check coverage and source links in the same file. ZIP · CSV / JSON Full fields, ready to join calendars.csv · product-sessions.csv · coverage.csv · sources.csv · pack.json · dictionary.json · README.txt · manifest.json · marketsopen-data-pack.xlsx The manifest records file hashes. The dictionary explains every column, null values and CSV encoding. Source documents are linked, not reproduced. The complete generated 2026 snapshot has 13 market/channel scopes, 4,745 calendar rows, 32,120 product-session rows and 18 sources. These are counts from this snapshot, not a guarantee of future-year coverage. Full-pack scopes: BSE, CFFEX, CZCE, DCE, GFEX, HKEX, INE, NB, SB, SGE, SHFE, SSE, SZSE. Public sample scopes: SHFE, SSE, HKEX. Preview actual rows A few columns are shown below. Downloads retain the complete field set. All times are local to the row’s time zone. Calendar sample · 15 selected records Date | Market | status | is_trading_day | civil_evening_has | Evening trading date | 2026-09-30 | HKEX | open | true | false | null | 2026-10-01 | HKEX | closed | false | false | null | 2026-10-09 | HKEX | open | true | false | null | 2026-10-12 | HKEX | open | true | false | null | 2026-12-31 | HKEX | half_day | true | false | null | 2026-09-30 | SHFE | open | true | false | null | 2026-10-01 | SHFE | closed | false | false | null | 2026-10-09 | SHFE | open | true | true | 2026-10-12 | 2026-10-12 | SHFE | open | true | true | 2026-10-13 | 2026-12-31 | SHFE | open | true | null | null | 2026-09-30 | SSE | open | true | false | null | 2026-10-01 | SSE | closed | false | false | null | 2026-10-09 | SSE | open | true | false | null | 2026-10-12 | SSE | open | true | false | null | 2026-12-31 | SSE | open | true | false | null | Product sessions · SHFE.au and SHFE.cu · Asia/Shanghai Date | Product | Day sessions | Civil evening | Trading date | Incoming evening date | 2026-09-30 | SHFE.au | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | false | null | 2026-09-29 | 2026-10-01 | SHFE.au | [] | false | null | null | 2026-10-09 | SHFE.au | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | 21:00–02:30 (+1 day) | 2026-10-12 | 2026-10-08 | 2026-10-12 | SHFE.au | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | 21:00–02:30 (+1 day) | 2026-10-13 | 2026-10-09 | 2026-12-31 | SHFE.au | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | null | null | 2026-12-30 | 2026-09-30 | SHFE.cu | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | false | null | 2026-09-29 | 2026-10-01 | SHFE.cu | [] | false | null | null | 2026-10-09 | SHFE.cu | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | 21:00–01:00 (+1 day) | 2026-10-12 | 2026-10-08 | 2026-10-12 | SHFE.cu | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | 21:00–01:00 (+1 day) | 2026-10-13 | 2026-10-09 | 2026-12-31 | SHFE.cu | [["09:00","10:15"],["10:30","11:30"],["13:30","15:00"]] | null | null | 2026-12-30 | How to read these rows Civil evening and trading date SHFE.au on 2026-10-09 has an evening session assigned to 2026-10-12. The 2026-10-12 row identifies 2026-10-09 as its incoming evening. These columns answer different questions. Unknown is different from false On 2026-10-01, is_trading_day=false is an explicit closure and day_sessions=[] means closed. On 2026-12-31, civil_evening_has=null with reason=next_trading_date_unverified: next-year attribution is unconfirmed. It must not be treated as false. null means unknown or unavailable; false is an explicit negative; not_applicable means the question does not apply. Coverage and sources you can inspect The coverage rows below retain annual counters for the selected scopes. They do not count the public sample subset. Consult the coverage table before using a scope or year. Annual coverage for sampled scopes Scope | Calendar rows | Known | Unknown | Product rows | HKEX | 365 | 365 | 0 | 0 | SHFE | 365 | 365 | 0 | 7300 | SSE | 365 | 365 | 0 | 0 | The Stock Exchange of Hong Kong Limited · Hong Kong Securities Market Holiday Schedule for Year 2026 — CT/075/25 (https://www.hkex.com.hk/-/media/HKEX-Market/Services/Circulars-and-Notices/Participant-and-Members-Circulars/SEHK/2025/ce_SEHK_CT_075_2025.pdf) hkex.2026 · official · source checked 2026-10-22 Shanghai Futures Exchange · 2026 exchange holiday calendar (https://www.shfe.com.cn/services/calenderandholidays/holiday/) shfe.2026 · official · source checked 2026-10-22 Shanghai Futures Exchange · Trading hours by product (SHFE and INE) (https://www.shfe.com.cn/services/calenderandholidays/tradinghours/) shfe.hours · official · source checked 2026-10-22 Shanghai Stock Exchange · 2026 holiday arrangements — SSE [2025] 45 (https://www.sse.com.cn/disclosure/announcement/general/c/c_20251222_10802507.shtml) sse.2026 · official · source checked 2026-10-22 Version and data scope as_of 2026-10-09 · data_version 2026.10.22-rc.1 · Pack schema mo-data-pack/1 as_of is the validity-check date for the current engine snapshot. It does not reconstruct what was known on that date. CSV and JSON preserve all sample fields and provenance; Excel uses selected columns for readability. Limitations and license The standard pack includes actual retained version exports. No live feed, SLA, custom service, monthly fresh-data guarantee or historical point-in-time reconstruction is included. Snapshot counts are not a guarantee of future-year coverage. Data is CC BY 4.0: retain attribution and data_version. Official source documents have their own rights. Included in Markets Open Pro Core facts stay free. See Markets Open Pro → (/account/buy) marketsopen.today Trading-day calendars Weekly email: China futures rule changes and next week’s market calendar. Subscribe free — The China Commodity Desk (https://brucewang688.substack.com/subscribe?utm_source=marketsopen&utm_medium=site&utm_campaign=footer-subscribe) Sources (/data#sources)About (/about)Methodology (/methodology)llms.txt (/llms.txt)FuturesClock ↗ (https://futuresclock.com/en/)Support (/about#support) The structured record