obrot_po_godzinach
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.
| 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
- 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 |
|---|---|---|---|
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 , 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'))
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.