STRASMORE/EXPLORE 2,948 QUERIES

post_close_curve

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-02, from canada-after-hours-trading.

as of series 16×4read in context →
post_close_curve — 16 rows by 4 columns, computed from US exchange, SIP and OPRA data.
et_timevolume_millionspct_of_post_closecumulative_pct
16:0011.6154.5154.5
16:150.823.8458.3
16:301.064.9863.3
16:452.1710.1873.5
17:003.415.9889.5
17:151.376.4595.9
17:300.130.696.5
17:450.130.6397.2
18:000.080.3897.5
18:150.060.2797.8
18:300.090.498.2
18:450.060.2698.5
19:000.050.2598.7
19:150.080.499.1
19:300.090.4499.6
19:450.090.44100
Rows × columns
16 × 4
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 post_close_curve, derived from the stored result.
ColumnTypeRangeNotes
et_time text 16 distinct values (16:00, 16:15, 16:30…)
volume_millions number 0.05 to 11.61 count
pct_of_post_close number 0.25 to 54.51 percent
cumulative_pct number 54.5 to 100 percent

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
    et_time,
    round(vol / 1e6, 2)                    AS volume_millions,
    round(100 * vol / sum(vol) OVER (), 2) AS pct_of_post_close,
    round(100 * sum(vol) OVER (ORDER BY et_time ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
              / sum(vol) OVER (), 1)       AS cumulative_pct
FROM
(
    SELECT
        formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 15 minute), '%H:%i') AS et_time,
        sum(toFloat64(volume)) AS vol
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('RY', 'TD', 'BNS', 'BMO', 'ENB', 'TRP', 'CNQ', 'SU', 'CP', 'CNI', 'SHOP', 'MFC', 'AEM')
      AND window_start >= today() - 60
      AND window_start <  today() - 1
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 960
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 1200
    GROUP BY et_time
)
ORDER BY et_time
⌘/Ctrl + Enter

Work with this data in your AI assistant

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

More from this analysiscanada-after-hours-trading
upcoming_us_closures series 12×6 → canada_holiday_sessions series 5×3 → interlisted_after_hours_share ranking 13×3 → The 2s10s spread by month, full history series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → The 5s30s spread month by month, with both legs series 241×4 → See all 2,948 queries →