obrot_po_godzinach

Name: obrot_po_godzinach
Creator: Strasmore
Published: 2026-10-09
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-09, from us-premarket-and-after-hours-polish-time.

as of 2026-10-09 ranking 16×3read in context →

obrot_po_godzinach — 16 rows by 3 columns, computed 2026-10-09 from US exchange, SIP and OPRA data.
godzina_pl	udzial_pct	mln_akcji_na_sesje
10:00 PL / 04:00 ET	0.3	0.12
11:00 PL / 05:00 ET	0.09	0.03
12:00 PL / 06:00 ET	0.12	0.05
13:00 PL / 07:00 ET	0.48	0.18
14:00 PL / 08:00 ET	0.62	0.24
15:00 PL / 09:00 ET	16.3	6.18
16:00 PL / 10:00 ET	15.96	6.05
17:00 PL / 11:00 ET	12.41	4.71
18:00 PL / 12:00 ET	9.94	3.77
19:00 PL / 13:00 ET	8.83	3.35
20:00 PL / 14:00 ET	9.38	3.56
21:00 PL / 15:00 ET	19.99	7.58
22:00 PL / 16:00 ET	4.71	1.79
23:00 PL / 17:00 ET	0.57	0.22
00:00 PL / 18:00 ET	0.17	0.06
01:00 PL / 19:00 ET	0.11	0.04

Rows × columns: 16 × 3
Computed: 2026-10-09
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 obrot_po_godzinach, derived from the stored result.
Column	Type	Range	Notes
`godzina_pl`	text	16 distinct values
`udzial_pct`	number	0.09 to 19.99	percent
`mln_akcji_na_sesje`	number	0.03 to 7.58

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-09, 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(
        argMax(formatDateTime(window_start, '%H:00', 'Europe/Warsaw'), window_start),
        ' PL / ',
        argMax(formatDateTime(window_start, '%H:00', 'America/New_York'), window_start),
        ' ET'
    )                                                             AS godzina_pl,
    round(100 * sum(volume) / (
        SELECT sum(volume)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'AAPL'
          AND window_start >= today() - 120
          AND window_start <  today() - 1
    ), 2)                                                         AS udzial_pct,
    round(sum(volume)
          / countDistinct(toDate(window_start, 'America/New_York'))
          / 1e6, 2)                                               AS mln_akcji_na_sesje
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'AAPL'
  AND window_start >= today() - 120
  AND window_start <  today() - 1
GROUP BY toHour(toTimeZone(window_start, 'America/New_York'))
ORDER BY toHour(toTimeZone(window_start, 'America/New_York'))

SQL to run

SELECT
    concat(
        argMax(formatDateTime(window_start, '%H:00', 'Europe/Warsaw'), window_start),
        ' PL / ',
        argMax(formatDateTime(window_start, '%H:00', 'America/New_York'), window_start),
        ' ET'
    )                                                             AS godzina_pl,
    round(100 * sum(volume) / (
        SELECT sum(volume)
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker = 'AAPL'
          AND window_start >= today() - 120
          AND window_start <  today() - 1
    ), 2)                                                         AS udzial_pct,
    round(sum(volume)
          / countDistinct(toDate(window_start, 'America/New_York'))
          / 1e6, 2)                                               AS mln_akcji_na_sesje
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'AAPL'
  AND window_start >= today() - 120
  AND window_start <  today() - 1
GROUP BY toHour(toTimeZone(window_start, 'America/New_York'))
ORDER BY toHour(toTimeZone(window_start, 'America/New_York'))

⌘/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