STRASMORE/EXPLORE 3,256 QUERIES

wieczor_amzn

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 series 21×4read in context →
wieczor_amzn — 21 rows by 4 columns, computed from US exchange, SIP and OPRA data.
datepo_sesji_pctprzed_sesja_pctmln_akcji_po_sesji
2026-09-011.843.920.47
2026-09-024.221.420.86
2026-09-036.914.331.56
2026-09-043.332.680.79
2026-09-083.912.490.86
2026-09-091.955.920.52
2026-09-102.293.770.43
2026-09-112.533.170.53
2026-09-141.63.090.46
2026-09-152.31.090.69
2026-09-163.661.371.03
2026-09-173.995.990.92
2026-09-1810.622.273.73
2026-09-219.773.833.44
2026-09-223.553.421.21
2026-09-232.772.251.02
2026-09-242.453.420.68
2026-09-255.313.011.48
2026-09-285.141.951.34
2026-09-293.521.460.87
2026-09-306.811.972.13
Rows × columns
21 × 4
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 wieczor_amzn, derived from the stored result.
ColumnTypeRangeNotes
date date 2026-09-01 to 2026-09-30
po_sesji_pct number 1.6 to 10.62 percent
przed_sesja_pct number 1.09 to 5.99 percent
mln_akcji_po_sesji number 0.43 to 3.73

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(sesja)                                                              AS date,
    round(100 * sumIf(volume, min_et >= 960 AND min_et < 1200) / sum(volume), 2) AS po_sesji_pct,
    round(100 * sumIf(volume, min_et >= 240 AND min_et < 570) / sum(volume), 2)  AS przed_sesja_pct,
    round(sumIf(volume, min_et >= 960 AND min_et < 1200) / 1e6, 2)               AS mln_akcji_po_sesji
FROM
(
    SELECT
        toDate(window_start, 'America/New_York')                    AS sesja,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
          + toMinute(toTimeZone(window_start, 'America/New_York'))  AS min_et,
        volume
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AMZN'
      AND window_start >= toDateTime('2026-09-01 04:00:00')
      AND window_start <  toDateTime('2026-10-01 04:00:00')
)
GROUP BY sesja
ORDER BY sesja
⌘/Ctrl + Enter

Work with this data in your AI assistant

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