STRASMORE/EXPLORE 3,171 QUERIES

libur_wib

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-10-07, from us-stock-market-hours-jakarta-time.

as of series 12×7read in context →
libur_wib — 12 rows by 7 columns, computed from US exchange, SIP and OPRA data.
holiday_dateharitanggal_labelnama_liburstatus_haritutup_wibhari_lagi
2026-11-26Kamis26 November 2026Thanksgivingclosedtutup penuh50
2026-11-27Jumat27 November 2026Thanksgivingearly-close01:00 WIB51
2026-12-24Kamis24 Desember 2026Christmasearly-close01:00 WIB78
2026-12-25Jumat25 Desember 2026Christmasclosedtutup penuh79
2027-01-01Jumat1 Januari 2027New Years Dayclosedtutup penuh86
2027-01-18Senin18 Januari 2027Martin Luther King, Jr. Dayclosedtutup penuh103
2027-02-15Senin15 Februari 2027Washington's Birthdayclosedtutup penuh131
2027-03-26Jumat26 Maret 2027Good Fridayclosedtutup penuh170
2027-05-31Senin31 Mei 2027Memorial Dayclosedtutup penuh236
2027-06-18Jumat18 Juni 2027Juneteenthclosedtutup penuh254
2027-07-05Senin5 Juli 2027Independence Dayclosedtutup penuh271
2027-09-06Senin6 September 2027Labor Dayclosedtutup penuh334
Rows × columns
12 × 7
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for libur_wib, derived from the stored result.
ColumnTypeRangeNotes
holiday_date date 2026-11-26 to 2027-09-06
hari text 3 distinct values (Jumat, Kamis, Senin)
tanggal_label text 12 distinct values
nama_libur text 10 distinct values (Christmas, Good Friday, Independence Day…)
status_hari text 2 distinct values (closed, early-close)
tutup_wib text 2 distinct values (01:00 WIB, tutup penuh)
hari_lagi number 50 to 334

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 holiday_date,
    arrayElement(['Senin', 'Selasa', 'Rabu', 'Kamis', 'Jumat', 'Sabtu', 'Minggu'], toDayOfWeek(date)) AS hari,
    concat(toString(toDayOfMonth(date)), ' ',
           arrayElement(['Januari', 'Februari', 'Maret', 'April', 'Mei', 'Juni',
                         'Juli', 'Agustus', 'September', 'Oktober', 'November', 'Desember'],
                        toMonth(date)), ' ',
           toString(toYear(date)))                                                                  AS tanggal_label,
    any(name)                                                                                       AS nama_libur,
    any(status)                                                                                     AS status_hari,
    any(if(status = 'early-close',
           concat(formatDateTime(toTimeZone(close, 'Asia/Jakarta'), '%H:%i'), ' WIB'),
           'tutup penuh'))                                                                          AS tutup_wib,
    dateDiff('day', today(), date)                                                                  AS hari_lagi
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent