jp_holiday_sessions
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-30, from does-the-us-market-close-for-japanese-holidays.
| session_date | session_label | tokyo_closure | spy_volume_millions | spy_move_pct |
|---|---|---|---|---|
| 2026-01-02 | Fri Jan 2 | New Year exchange closure | 89.4 | -0.37 |
| 2026-01-12 | Mon Jan 12 | Coming of Age Day | 64 | 0.65 |
| 2026-02-11 | Wed Feb 11 | National Foundation Day | 76.4 | -0.64 |
| 2026-02-23 | Mon Feb 23 | Emperor’s Birthday | 90.6 | -0.79 |
| 2026-03-20 | Fri Mar 20 | Vernal Equinox Day | 165.6 | -1.21 |
| 2026-04-29 | Wed Apr 29 | Showa Day | 41.9 | 0.08 |
| 2026-05-04 | Mon May 4 | Greenery Day | 51.9 | -0.29 |
| 2026-05-05 | Tue May 5 | Children’s Day | 36.9 | 0.28 |
| 2026-05-06 | Wed May 6 | Substitute holiday (Constitution Memorial Day) | 53.3 | 0.78 |
| 2026-07-20 | Mon Jul 20 | Marine Day | 50.4 | -0.67 |
| 2026-08-11 | Tue Aug 11 | Mountain Day | 36.7 | -0.51 |
| 2026-09-21 | Mon Sep 21 | Respect for the Aged Day | 50.5 | 0.95 |
| 2026-09-23 | Wed Sep 23 | Autumnal Equinox Day | 54.9 | -0.64 |
- Rows × columns
- 13 × 5
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
session_date |
date | 2026-01-02 to 2026-09-23 | |
session_label |
text | 13 distinct values (Fri Jan 2, Fri Mar 20, Mon Feb 23…) | |
tokyo_closure |
text | 13 distinct values | |
spy_volume_millions |
number | 36.7 to 165.6 | count |
spy_move_pct |
number | -1.21 to 0.95 | percent |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
SELECT
toString(date) AS session_date,
formatDateTime(date, '%a %b %e') AS session_label,
transform(
toString(date),
['2026-01-02','2026-01-12','2026-02-11','2026-02-23','2026-03-20',
'2026-04-29','2026-05-04','2026-05-05','2026-05-06','2026-07-20',
'2026-08-11','2026-09-21','2026-09-23'],
['New Year exchange closure','Coming of Age Day','National Foundation Day',
'Emperor’s Birthday','Vernal Equinox Day','Showa Day','Greenery Day',
'Children’s Day','Substitute holiday (Constitution Memorial Day)','Marine Day',
'Mountain Day','Respect for the Aged Day','Autumnal Equinox Day'],
'Tokyo closure'
) AS tokyo_closure,
round(toFloat64(volume) / 1e6, 1) AS spy_volume_millions,
round((toFloat64(close) / toFloat64(open) - 1) * 100, 2) AS spy_move_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'SPY'
AND date IN (
'2026-01-02','2026-01-12','2026-02-11','2026-02-23','2026-03-20',
'2026-04-29','2026-05-04','2026-05-05','2026-05-06','2026-07-20',
'2026-08-11','2026-09-21','2026-09-23'
)
ORDER BY date
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.