tydzien

Name: tydzien
Creator: Strasmore
Published: 2026-10-16
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-10-16, from us-daylight-saving-switch-polish-time.

as of 2026-10-16 series 15×8read in context →

tydzien — 15 rows by 8 columns, computed 2026-10-16 from US exchange, SIP and OPRA data.
date	dzien	pre_market_pl	otwarcie_pl	zamkniecie_pl	po_sesji_pl	roznica_godzin	status_sesji
2026-10-19	poniedziałek	10:00	15:30	22:00	02:00	6	sesja regularna
2026-10-20	wtorek	10:00	15:30	22:00	02:00	6	sesja regularna
2026-10-21	środa	10:00	15:30	22:00	02:00	6	sesja regularna
2026-10-22	czwartek	10:00	15:30	22:00	02:00	6	sesja regularna
2026-10-23	piątek	10:00	15:30	22:00	02:00	6	sesja regularna
2026-10-26	poniedziałek	09:00	14:30	21:00	01:00	5	sesja regularna
2026-10-27	wtorek	09:00	14:30	21:00	01:00	5	sesja regularna
2026-10-28	środa	09:00	14:30	21:00	01:00	5	sesja regularna
2026-10-29	czwartek	09:00	14:30	21:00	01:00	5	sesja regularna
2026-10-30	piątek	09:00	14:30	21:00	01:00	5	sesja regularna
2026-11-02	poniedziałek	10:00	15:30	22:00	02:00	6	sesja regularna
2026-11-03	wtorek	10:00	15:30	22:00	02:00	6	sesja regularna
2026-11-04	środa	10:00	15:30	22:00	02:00	6	sesja regularna
2026-11-05	czwartek	10:00	15:30	22:00	02:00	6	sesja regularna
2026-11-06	piątek	10:00	15:30	22:00	02:00	6	sesja regularna

Rows × columns: 15 × 8
Period covered: 2026-10-19 to 2026-11-06
Computed: 2026-10-16
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 tydzien, derived from the stored result.
Column	Type	Range
`date`	date	2026-10-19 to 2026-11-06
`dzien`	text	5 distinct values (czwartek, piątek, poniedziałek…)
`pre_market_pl`	text	2 distinct values (09:00, 10:00)
`otwarcie_pl`	text	2 distinct values (14:30, 15:30)
`zamkniecie_pl`	text	2 distinct values (21:00, 22:00)
`po_sesji_pl`	text	2 distinct values (01:00, 02:00)
`roznica_godzin`	number	5 to 6
`status_sesji`	text	1 distinct value (sesja regularna)

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-10-16, 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.

WITH
    kalendarz AS
    (
        SELECT toDate('2026-10-19') + arrayJoin(range(19)) AS d
    ),
    zamkniecia AS
    (
        SELECT
            date        AS d,
            any(status) AS status
        FROM global_markets.stocks_market_holidays
        GROUP BY date
    )
SELECT
    toString(k.d)                                                                                   AS date,
    ['poniedziałek', 'wtorek', 'środa', 'czwartek', 'piątek', 'sobota', 'niedziela'][toDayOfWeek(k.d)] AS dzien,
    formatDateTime(toDateTime(concat(toString(k.d), ' 04:00:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS pre_market_pl,
    formatDateTime(toDateTime(concat(toString(k.d), ' 09:30:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS otwarcie_pl,
    formatDateTime(toDateTime(concat(toString(k.d), ' 16:00:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS zamkniecie_pl,
    formatDateTime(toDateTime(concat(toString(k.d), ' 20:00:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS po_sesji_pl,
    toHour(toTimeZone(toDateTime(concat(toString(k.d), ' 09:30:00'), 'America/New_York'), 'Europe/Warsaw'))
        - toHour(toDateTime(concat(toString(k.d), ' 09:30:00'), 'America/New_York'))                AS roznica_godzin,
    if(h.status = '', 'sesja regularna', h.status)                                                  AS status_sesji
FROM kalendarz AS k
LEFT JOIN zamkniecia AS h ON h.d = k.d
WHERE toDayOfWeek(k.d) <= 5
ORDER BY k.d

SQL to run

WITH
    kalendarz AS
    (
        SELECT toDate('2026-10-19') + arrayJoin(range(19)) AS d
    ),
    zamkniecia AS
    (
        SELECT
            date        AS d,
            any(status) AS status
        FROM global_markets.stocks_market_holidays
        GROUP BY date
    )
SELECT
    toString(k.d)                                                                                   AS date,
    ['poniedziałek', 'wtorek', 'środa', 'czwartek', 'piątek', 'sobota', 'niedziela'][toDayOfWeek(k.d)] AS dzien,
    formatDateTime(toDateTime(concat(toString(k.d), ' 04:00:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS pre_market_pl,
    formatDateTime(toDateTime(concat(toString(k.d), ' 09:30:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS otwarcie_pl,
    formatDateTime(toDateTime(concat(toString(k.d), ' 16:00:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS zamkniecie_pl,
    formatDateTime(toDateTime(concat(toString(k.d), ' 20:00:00'), 'America/New_York'), '%H:%i', 'Europe/Warsaw') AS po_sesji_pl,
    toHour(toTimeZone(toDateTime(concat(toString(k.d), ' 09:30:00'), 'America/New_York'), 'Europe/Warsaw'))
        - toHour(toDateTime(concat(toString(k.d), ' 09:30:00'), 'America/New_York'))                AS roznica_godzin,
    if(h.status = '', 'sesja regularna', h.status)                                                  AS status_sesji
FROM kalendarz AS k
LEFT JOIN zamkniecia AS h ON h.d = k.d
WHERE toDayOfWeek(k.d) <= 5
ORDER BY k.d

⌘/Ctrl + Enter

Pracuj z tymi danymi w swoim asystencie AI

Otwiera się gotowy do zapytań, z danymi z tej strony. Za darmo, bez konta.

Claude ChatGPT Gemini Muse Twój własny agent