STRASMORE/EXPLORE 2,830 QUERIES

saham_luar_sesi

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 ranking 6×3read in context →
saham_luar_sesi — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickerperatus_pramarketperatus_selepas_waktu
SPY2.5613.67
NVDA4.097.44
MSFT3.795.37
AAPL2.555.01
KO0.755.51
TSLA2.72.26
Rows × columns
6 × 3
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 saham_luar_sesi, derived from the stored result.
ColumnTypeRangeNotes
ticker text 6 distinct values (AAPL, KO, MSFT…)
peratus_pramarket number 0.75 to 4.09
peratus_selepas_waktu number 2.26 to 13.67

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
    ticker,
    round(100 * sumIf(volume, et_minit < 570) / sum(volume), 2)   AS peratus_pramarket,
    round(100 * sumIf(volume, et_minit >= 960) / sum(volume), 2)  AS peratus_selepas_waktu
FROM
(
    SELECT
        ticker,
        volume,
        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 ticker
ORDER BY peratus_pramarket + peratus_selepas_waktu DESC
⌘/Ctrl + Enter

Gunakan data ini dalam pembantu AI anda

Dibuka sedia untuk ditanya, dengan data halaman ini. Percuma, tanpa akaun.