bahagian_sesi

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

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

bahagian_sesi — 3 rows by 3 columns, computed 2026-09-30 from US exchange, SIP and OPRA data.
segmen	peratus_volum	peratus_dagangan
Pramarket	3.25	4.49
Sesi biasa	89.58	92.87
Selepas waktu	7.17	2.64

Rows × columns: 3 × 3
Computed: 2026-09-30
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 bahagian_sesi, derived from the stored result.
Column	Type	Range
`segmen`	text	3 distinct values (Pramarket, Selepas waktu, Sesi biasa)
`peratus_volum`	number	3.25 to 89.58
`peratus_dagangan`	number	2.64 to 92.87

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-30, 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
    s.segmen                                       AS segmen,
    round(100 * s.volum / t.jumlah_volum, 2)       AS peratus_volum,
    round(100 * s.dagangan / t.jumlah_dagangan, 2) AS peratus_dagangan
FROM
(
    SELECT
        multiIf(et_minit < 570, 'Pramarket', et_minit < 960, 'Sesi biasa', 'Selepas waktu') AS segmen,
        min(et_minit)  AS mula,
        sum(volume)    AS volum,
        sum(dagangan)  AS dagangan
    FROM
    (
        SELECT
            volume,
            transactions AS dagangan,
            toHour(toTimeZone(window_start, 'America/New_York')) * 60
                + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minit
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'TSLA')
          AND window_start >= '2026-08-17 00:00:00'
          AND window_start <  '2026-09-26 00:00:00'
    )
    WHERE et_minit >= 240 AND et_minit < 1200
    GROUP BY segmen
) AS s
CROSS JOIN
(
    SELECT
        sum(volume)       AS jumlah_volum,
        sum(transactions) AS jumlah_dagangan
    FROM
    (
        SELECT
            volume,
            transactions,
            toHour(toTimeZone(window_start, 'America/New_York')) * 60
                + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minit
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'TSLA')
          AND window_start >= '2026-08-17 00:00:00'
          AND window_start <  '2026-09-26 00:00:00'
    )
    WHERE et_minit >= 240 AND et_minit < 1200
) AS t
ORDER BY s.mula

SQL to run

SELECT
    s.segmen                                       AS segmen,
    round(100 * s.volum / t.jumlah_volum, 2)       AS peratus_volum,
    round(100 * s.dagangan / t.jumlah_dagangan, 2) AS peratus_dagangan
FROM
(
    SELECT
        multiIf(et_minit < 570, 'Pramarket', et_minit < 960, 'Sesi biasa', 'Selepas waktu') AS segmen,
        min(et_minit)  AS mula,
        sum(volume)    AS volum,
        sum(dagangan)  AS dagangan
    FROM
    (
        SELECT
            volume,
            transactions AS dagangan,
            toHour(toTimeZone(window_start, 'America/New_York')) * 60
                + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minit
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'TSLA')
          AND window_start >= '2026-08-17 00:00:00'
          AND window_start <  '2026-09-26 00:00:00'
    )
    WHERE et_minit >= 240 AND et_minit < 1200
    GROUP BY segmen
) AS s
CROSS JOIN
(
    SELECT
        sum(volume)       AS jumlah_volum,
        sum(transactions) AS jumlah_dagangan
    FROM
    (
        SELECT
            volume,
            transactions,
            toHour(toTimeZone(window_start, 'America/New_York')) * 60
                + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minit
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'TSLA')
          AND window_start >= '2026-08-17 00:00:00'
          AND window_start <  '2026-09-26 00:00:00'
    )
    WHERE et_minit >= 240 AND et_minit < 1200
) AS t
ORDER BY s.mula

⌘/Ctrl + Enter

Work with this data in your AI assistant

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

Claude ChatGPT Gemini Muse Your own agent