sikukuu_eat

Name: sikukuu_eat
Creator: Strasmore
Published: 2026-09-26
License: https://www.strasmore.com/terms/

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-26, from us-stock-market-hours-east-africa-time.

as of 2026-09-26 table 12×6read in context →

sikukuu_eat — 12 rows by 6 columns, computed 2026-09-26 from US exchange, SIP and OPRA data.
tarehe	siku	sikukuu	hali	kufunga_eat	siku_zilizosalia
26 Novemba 2026	Alhamisi	Thanksgiving	Imefungwa kabisa		61
27 Novemba 2026	Ijumaa	Thanksgiving	Inafunga mapema	21:00	62
24 Desemba 2026	Alhamisi	Christmas	Inafunga mapema	21:00	89
25 Desemba 2026	Ijumaa	Christmas	Imefungwa kabisa		90
1 Januari 2027	Ijumaa	New Years Day	Imefungwa kabisa		97
18 Januari 2027	Jumatatu	Martin Luther King, Jr. Day	Imefungwa kabisa		114
15 Februari 2027	Jumatatu	Washington's Birthday	Imefungwa kabisa		142
26 Machi 2027	Ijumaa	Good Friday	Imefungwa kabisa		181
31 Mei 2027	Jumatatu	Memorial Day	Imefungwa kabisa		247
18 Juni 2027	Ijumaa	Juneteenth	Imefungwa kabisa		265
5 Julai 2027	Jumatatu	Independence Day	Imefungwa kabisa		282
6 Septemba 2027	Jumatatu	Labor Day	Imefungwa kabisa		345

Rows × columns: 12 × 6
Computed: 2026-09-26
Completeness: Some fields are partly empty — see the columns below
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 sikukuu_eat, derived from the stored result.
Column	Type	Range	Notes
`tarehe`	text	12 distinct values
`siku`	text	3 distinct values (Alhamisi, Ijumaa, Jumatatu)
`sikukuu`	text	10 distinct values (Christmas, Good Friday, Independence Day…)
`hali`	text	2 distinct values (Imefungwa kabisa, Inafunga mapema)
`kufunga_eat`	text	1 distinct value (21:00)	2 of 12 rows populated
`siku_zilizosalia`	number	61 to 345

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 2026-09-26, 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
    concat(toString(toDayOfMonth(date)), ' ',
           ['Januari','Februari','Machi','Aprili','Mei','Juni','Julai','Agosti','Septemba','Oktoba','Novemba','Desemba'][toMonth(date)],
           ' ', toString(toYear(date)))                                  AS tarehe,
    ['Jumatatu','Jumanne','Jumatano','Alhamisi','Ijumaa','Jumamosi','Jumapili'][toDayOfWeek(date)] AS siku,
    any(name)                                                            AS sikukuu,
    if(any(status) = 'early-close', 'Inafunga mapema', 'Imefungwa kabisa') AS hali,
    any(if(status = 'early-close',
           formatDateTime(toTimeZone(close, 'Africa/Nairobi'), '%H:%i'),
           ''))                                                          AS kufunga_eat,
    dateDiff('day', today(), date)                                       AS siku_zilizosalia
FROM global_markets.stocks_market_holidays
WHERE date >= today()
GROUP BY date
ORDER BY date

SQL to run

⌘/Ctrl + Enter

Fanya kazi na data hii kwenye msaidizi wako wa AI

Hufunguka tayari kuuliza, na data ya ukurasa huu. Bure, bila akaunti.

Claude ChatGPT Gemini Muse Wakala wako mwenyewe