Can You Use a Limit Order on a Mutual Fund?
One index ETF's price through a single session, in half-hour ET bucketsseries ·
2026-11-07 · 13×3
How far one index ETF travelled inside each recent sessionseries ·
2026-11-07 · 31×4
Upcoming market closures that move a fund order's strike dateseries ·
2026-11-07 · 12×6
Gap between the last regular-session minute and the official closeranking ·
2026-11-07 · 6×4
Buying Before or After a Stock Split
Forward and reverse splits by year, US listed companiesranking ·
2026-11-07 · 10×3
Recent forward splits at large US companies, by effective sessionranking ·
2026-11-07 · 12×4
Most-used forward split multipliers, last ten yearsranking ·
2026-11-07 · 10×3
AAPL across its 2020 four for one split: split-adjusted closes and volumeseries ·
2026-11-07 · 10×4
Stock Order Types Explained: The Core Four
AAPL average quoted spread by ET clock time, Sep 16 2026series ·
2026-10-08 · 64×3
Average quoted spread across six household names, one mid-morning hourranking ·
2026-10-08 · 6×3
How often a buy limit under the prior close was reached (AAPL, one year of sessions)ranking ·
2026-10-08 · 6×2
Overnight gap between one close and the next open, year to Sep 2026ranking ·
2026-10-08 · 6×4
Can You Lose More Than You Invest?
The largest US oil tracking fund through April 2020: daily close and session lowseries ·
2026-10-05 · 17×3
2023 run from the first close of the year: year end and peakranking ·
2026-10-05 · 6×3
Deepest overnight gap down per name, 2015 to 2025 (split dates removed)ranking ·
2026-10-05 · 6×3
One NVDA option contract, mid January to March 1, 2024: the furthest travellerseries ·
2026-10-05 · 33×3
Buy Limit vs Sell Limit Orders Explained
How often a resting limit was reached, by distance from the prior close (SPY, 2021 to Sep 2026)ranking ·
2026-10-05 · 6×3
A 1% buy limit vs a 1% sell limit: share of SPY sessions reached, by yearranking ·
2026-10-05 · 6×3
The gap a marketable limit crosses: average quoted spread, five names, Sep 15 2026ranking ·
2026-10-05 · 5×3
A real quote in motion: Apple's bid and ask by the minute, Sep 15 2026series ·
2026-10-05 · 15×4
Stop Order vs Limit Order: Trigger or Price
AAPL sessions touched at each stop distance, and how many closed back above the open (2024-2025)ranking ·
2026-10-02 · 5×3
AAPL sessions that opened at least 1.5% below the prior close, 2025series ·
2026-10-02 · 16×2
AAPL one minute range and volume by ET clock hour, September 2025ranking ·
2026-10-02 · 16×3
Median daily range and sub-open dips across five household names, 2025ranking ·
2026-10-02 · 5×3
One index ETF's price through a single session, in half-hour ET buckets
One index ETF's price through a single session, in half-hour ET buckets
| et_time | etf_price | asof_label |
|---|---|---|
| 09:30 | 766.06 | Nov 4 |
| 10:00 | 767.39 | Nov 4 |
| 10:30 | 766.18 | Nov 4 |
| 11:00 | 765.28 | Nov 4 |
| 11:30 | 766.89 | Nov 4 |
| 12:00 | 767.84 | Nov 4 |
| 12:30 | 768.35 | Nov 4 |
| 13:00 | 768.58 | Nov 4 |
| 13:30 | 767.71 | Nov 4 |
| 14:00 | 768.16 | Nov 4 |
| 14:30 | 767.69 | Nov 4 |
| 15:00 | 767.57 | Nov 4 |
| 15:30 | 767.34 | Nov 4 |
the exact SQL behind every number
WITH
(
SELECT max(toDate(toTimeZone(window_start, 'America/New_York')))
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND window_start >= today() - 20
AND window_start < today() - 2
) AS charted_session
SELECT
formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
round(avg(toFloat64(close)), 2) AS etf_price,
min(formatDateTime(toTimeZone(window_start, 'America/New_York'), '%b %e')) AS asof_label
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'SPY'
AND toDate(toTimeZone(window_start, 'America/New_York')) = charted_session
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
+ toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
GROUP BY et_time
ORDER BY et_time
More from this analysisCan You Use a Limit Order on a Mutual Fund?
How far one index ETF travelled inside each recent session
series 31×4
→
Upcoming market closures that move a fund order's strike date
series 12×6
→
Gap between the last regular-session minute and the official close
ranking 6×4
→
AAPL average quoted spread by ET clock time, Sep 16 2026
series 64×3
→
See all 3,293 queries →