STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

What Is Form N-PORT? Fund Holdings Filing
Most-filed EDGAR form types over the trailing yearranking · 2026-10-04 · 12×3Preview: 12 ranked values, largest first. When Q1 2026 13F reports landed, by week after quarter endranking · 2026-10-04 · 13×2Preview: 13 ranked values, largest first. How long institutional managers take to file a 13F after quarter endseries · 2026-10-04 · 13×4Preview: a 13-point series, roughly flat.
Mutual Fund Order Cutoff Times by Broker
Upcoming US market closures and early closesseries · 2026-10-04 · 12×7Preview: a 12-point series, ending higher. Full sessions versus shortened sessions over the trailing yearranking · 2026-10-04 · 2×2Preview: 2 ranked values, largest first. Shortened sessions on the SPY tape since January 2024series · 2026-10-04 · 6×5Preview: a 6-point series, roughly flat.
Mutual Fund Frequent Trading Limits Explained
SPY five-minute price marks across one full sessionseries · 2026-10-04 · 78×2Preview: a 16-point series, ending lower. Minutes traded and distinct prices on the same sessionranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. How far SPY sat from its own closing print, by time of dayseries · 2026-10-04 · 13×3Preview: a 13-point series, ending lower. Trading sessions inside common calendar-day block windowsranking · 2026-10-04 · 4×2Preview: 4 ranked values, smallest first.
Mutual Fund Forward Pricing Rule Explained
Upcoming exchange closures, the days a fund NAV is skipped or shortenedseries · 2026-10-04 · 12×5Preview: a 12-point series, ending higher. Shares a $10,000 order buys at the screen NAV versus the struck NAV, ten sharpest sessionsranking · 2026-10-04 · 10×4Preview: 10 ranked values, largest first. How far one closing value lands from the last (SPY daily closes, 2023 onward)ranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Average distance from each ET clock mark to the closing print (SPY, trailing months)series · 2026-10-04 · 13×3Preview: a 13-point series, roughly flat.
Mutual Fund Exchange vs Selling and Rebuying
How many calendar days one trading session sits from the nextranking · 2026-10-04 · 4×3Preview: 4 ranked values, largest first. Upcoming US market holidays and early closesseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Average SPY volume per minute over the final half hour of the sessionseries · 2026-10-04 · 30×2Preview: a 16-point series, ending higher.
Mutual Fund Cutoffs on Early-Close Days
Minute bars and volume per session: early closes against full sessions, Nov-Dec 2025ranking · 2026-10-04 · 2×4Preview: 2 ranked values, smallest first. SPY volume by half hour: a 1:00 p.m. half day against an ordinary Fridayseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Upcoming 1:00 p.m. early closes, with the hour before each oneseries · 2026-10-04 · 2×6Preview: a 2-point series, ending higher. Every upcoming closure, tagged full closure or early closeseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher.
How Often Mutual Funds Change Holdings
Days from quarter end to 13F filing date, by reporting quarterseries · 2026-10-04 · 9×4Preview: a 9-point series, ending lower. Price change since the last quarter-end snapshot dateranking · 2026-10-04 · 6×4Preview: 6 ranked values, smallest first. How old each quarter-end holdings snapshot is todayseries · 2026-10-04 · 7×4Preview: a 7-point series, ending lower. Splits and new listings per month across the US marketseries · 2026-10-04 · 14×3Preview: a 14-point series, ending lower.
ETF vs Mutual Fund Settlement: Two Clocks
SPY by half hour clock bucket, pinned session of Sep 15, 2026series · 2026-10-04 · 13×2Preview: a 13-point series, ending lower. Upcoming trade dates and the day their cash settlesseries · 2026-10-04 · 15×6Preview: a 15-point series, ending higher. Closures and early closes still ahead on the exchange calendarseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. How far the 11:00 a.m. print sat from the closing print, Sep 15, 2026ranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. Calendar days from trade date to settlement, by weekdayseries · 2026-10-04 · 5×4Preview: a 5-point series, ending higher.
Do Mutual Funds Trade on Market Holidays?
Scheduled early closes ahead, with the exchange close timeseries · 2026-10-04 · 2×4Preview: a 2-point series, ending higher. Upcoming US market closures and shortened sessionsseries · 2026-10-04 · 12×4Preview: a 12-point series, ending higher. Short regular sessions on the SPY tape since January 2024ranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. 2026 sessions that reopened more than three calendar days laterseries · 2026-10-04 · 7×3Preview: a 7-point series, roughly flat.
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-10-04 · 13×3Preview: a 13-point series, ending higher. How far one index ETF travelled inside each recent sessionseries · 2026-10-04 · 30×4Preview: a 16-point series, ending lower. Upcoming market closures that move a fund order's strike dateseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Gap between the last regular-session minute and the official closeranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first.
Can You Cancel a Mutual Fund Order? 4 pm Cutoff
Upcoming sessions where the standard 4 p.m. cutoff does not applyseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher.
Best Time of Day to Sell a Mutual Fund
Overnight gap versus the session that follows, complete yearsranking · 2026-10-04 · 5×3Preview: 5 ranked values, smallest first. How far SPY trades from its own open and close, by time of dayseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. Average one-day move across six widely held funds, since 2021ranking · 2026-10-04 · 6×2Preview: 6 ranked values, smallest first. How big a one-day move usually is, sessions since 2016ranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first.
When Do Mutual Funds Trade? NAV Pricing at 4 pm
The same 15 sessions, summarized: the close's floor, average, and peakscalar · 2026-09-28 · 1×417.7 SPY volume share of the final 30 minutes and final minute: last 15 sessions through July 10, 2026series · 2026-09-28 · 15×3Preview: a 15-point series, ending lower. Month-end sessions vs all other sessions: SPY close concentration, January–June 2026scalar · 2026-09-28 · 1×76 The spread a fund buyer never pays: median quoted spread, July 10, 2026 regular sessionranking · 2026-09-28 · 3×3Preview: 3 ranked values, smallest first. How much of SPY's day trades at the very end: July 10, 2026 regular sessionscalar · 2026-09-28 · 1×324.6 The print NAV is struck from: AAPL's closing auction cross, July 10, 2026scalar · 2026-09-28 · 1×65.47
How Mutual Fund NAV Is Calculated: Example
Share of SPY's session volume by half hour, June 2026 averageseries · 2026-09-28 · 13×2Preview: a 13-point series, ending higher. Average move from the 11:30 a.m. ET European close to the 4:00 p.m. close, Q2 2026ranking · 2026-09-28 · 5×3Preview: 5 ranked values, largest first. One session's price path, SPY every 15 minutes on June 17, 2026series · 2026-09-28 · 27×2Preview: a 16-point series, ending lower. Distance from the 10:00 a.m. ET price to the close, SPY, by monthseries · 2026-09-28 · 12×4Preview: a 12-point series, roughly flat.
Can You Day Trade an Index Fund? ETFs vs Funds
VOO: last traded price in each 30-minute bucket of the most recent complete session (ET, extended hours included)series · 2026-09-26 · 32×2Preview: a 16-point series, ending higher. Typical quoted spread on the three largest S&P 500 ETFs, trailing five daysranking · 2026-09-26 · 3×3Preview: 3 ranked values, smallest first.
Do Mutual Funds Trade in the Primary Market?
Where an average session's share volume lands on the clock, September 1 to 15, 2026series · 2026-09-22 · 64×2Preview: a 16-point series, roughly flat. Average trades per session across six exchange-listed funds, August 2026ranking · 2026-09-22 · 6×2Preview: 6 ranked values, largest first. One session of prices in an exchange-listed fund, 30-minute ET bucketsseries · 2026-09-22 · 32×4Preview: a 16-point series, ending higher. How far one exchange-listed fund's price travels within a session, August 2026series · 2026-09-22 · 21×4Preview: a 16-point series, ending lower.
The 7-5-3-1 Rule in Mutual Funds, Tested
The eight weakest seven-year windows on SPY, dividends counted as cashtable · 2026-09-17 · 8×6 A flat 500-a-month SIP against the same plan stepped up 10% a year, contributions onlytable · 2026-09-17 · 10×5 Rolling seven-year returns on SPY, one window per start monthseries · 2026-09-17 · 193×5Preview: a 16-point series, ending higher. Where the seven-year windows landed: SPY windows by return band, dividends countedranking · 2026-09-17 · 5×3Preview: 5 ranked values, smallest first.
International Fund NAV: Fair Value Pricing
The overnight and New York halves of the day, year by yearranking · 2026-08-10 · 6×3Preview: 6 ranked values, smallest first. Foreign listings during New York hours, sorted by the US large cap moveranking · 2026-08-10 · 5×4Preview: 5 ranked values, smallest first. Average move by New York half hour, two foreign listingsseries · 2026-08-10 · 25×3Preview: a 16-point series, ending lower. Where the daily move lands: overnight gap versus the New York sessionranking · 2026-08-10 · 6×3Preview: 6 ranked values, largest first.
Mutual Funds vs ETFs: What Actually Differs
Quoted bid-ask spread by fund: venue quotes, 11:00 to 13:59 ET, July 22, 2026ranking · 2026-08-02 · 7×4Preview: 7 ranked values, smallest first. The first active ETF share class: DFMC weekly closes since its March 2026 listingseries · 2026-08-02 · 20×4Preview: a 16-point series, ending lower. How far the price travels inside a day: seven ETFs, July 2026 sessionsranking · 2026-08-02 · 7×4Preview: 7 ranked values, largest first. One session, many prices: VOO in half-hour marks, Wednesday July 22, 2026series · 2026-08-02 · 32×3Preview: a 16-point series, roughly flat.
Selling Mutual Funds at a Loss: How Basis Works
Daily tracking difference against SPY: broad US equity funds, first half of 2026ranking · 2026-08-01 · 4×3Preview: 4 ranked values, smallest first. The same monthly lots ranked by per share result at the December 2022 priceranking · 2026-08-01 · 18×3Preview: 16 ranked values, largest first. Distribution cadence: index and income funds, twelve months to June 30, 2026ranking · 2026-08-01 · 9×4Preview: 9 ranked values, largest first. A monthly buyer's lot prices and running average cost: VTI, July 2021 to December 2022series · 2026-08-01 · 18×4Preview: a 16-point series, ending lower.
When Do Mutual Fund Trades Settle?
Short end vs long end of the Treasury curve: monthly averages, July 2024 to June 2026series · 2026-08-01 · 24×4Preview: a 16-point series, ending lower. Trading sessions vs calendar days, twelve months through June 2026series · 2026-08-01 · 12×4Preview: a 12-point series, ending lower. How far the S&P 500 tracker moved open to close: sessions by size band, July 2025 to June 2026ranking · 2026-08-01 · 5×3Preview: 5 ranked values, largest first. Longest breaks between US trading sessions, January to late July 2026ranking · 2026-08-01 · 10×2Preview: 10 ranked values, largest first.
The 8-4-3 Rule for Mutual Funds, Explained
An illustrative $10,000 SPY stake from year end 2005, marked at each year endranking · 2026-07-31 · 21×3Preview: 16 ranked values, smallest first. Annualized SPY price growth over rolling eight-year windows, by starting year endranking · 2026-07-31 · 14×3Preview: 14 ranked values, smallest first. SPY calendar-year price change vs the 12% assumption, 2006-2025ranking · 2026-07-31 · 20×3Preview: 16 ranked values, smallest first.
Most-filed EDGAR form types over the trailing year

Most-filed EDGAR form types over the trailing year

most recentas of ranking 12×3read in context →
Most-filed EDGAR form types over the trailing year — 12 rows by 3 columns, computed from US exchange, SIP and OPRA data.
form_typefilingsfilers
434595657565
424B2190520892
1447202715485
8-K633476554
NPORT-P530902015
34399624733
D3935737128
13F-HR343009368
SCHEDULE 13G/A338506863
6-K273291336
FWP263481096
D/A2268519546
the exact SQL behind every number
SELECT
    form_type,
    count()            AS filings,
    countDistinct(cik) AS filers
FROM global_markets.stocks_sec_edgar_index
WHERE filing_date >= today() - 365
  AND filing_date <= today()
GROUP BY form_type
ORDER BY filings DESC
LIMIT 12
$