STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 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-08-22 · 12×3Preview: 12 ranked values, largest first. When Q1 2026 13F reports landed, by week after quarter endranking · 2026-08-22 · 13×2Preview: 13 ranked values, largest first. How long institutional managers take to file a 13F after quarter endseries · 2026-08-22 · 12×4Preview: a 12-point series, roughly flat.
Mutual Fund Frequent Trading Limits Explained
SPY five-minute price marks across one full sessionseries · 2026-08-22 · 78×2Preview: a 16-point series, ending lower. Minutes traded and distinct prices on the same sessionranking · 2026-08-22 · 5×3Preview: 5 ranked values, largest first. How far SPY sat from its own closing print, by time of dayseries · 2026-08-22 · 13×3Preview: a 13-point series, ending lower. Trading sessions inside common calendar-day block windowsranking · 2026-08-22 · 4×2Preview: 4 ranked values, smallest first.
Best Time of Day to Sell a Mutual Fund
Overnight gap versus the session that follows, complete yearsranking · 2026-08-22 · 5×3Preview: 5 ranked values, smallest first. How far SPY trades from its own open and close, by time of dayseries · 2026-08-22 · 13×3Preview: a 13-point series, ending higher. Average one-day move across six widely held funds, since 2021ranking · 2026-08-22 · 6×2Preview: 6 ranked values, smallest first. How big a one-day move usually is, sessions since 2016ranking · 2026-08-22 · 5×2Preview: 5 ranked values, largest 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.
How Mutual Fund NAV Is Calculated: Example
Share of SPY's session volume by half hour, June 2026 averageseries · 2026-08-06 · 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-08-06 · 5×3Preview: 5 ranked values, largest first. One session's price path, SPY every 15 minutes on June 17, 2026series · 2026-08-06 · 27×2Preview: a 16-point series, ending lower. Distance from the 10:00 a.m. ET price to the close, SPY, by monthseries · 2026-08-06 · 12×4Preview: a 12-point series, roughly flat.
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.
When Do Mutual Funds Trade? NAV Pricing at 4 pm
The same 15 sessions, summarized: the close's floor, average, and peakscalar · 2026-07-26 · 1×416.3 SPY volume share of the final 30 minutes and final minute: last 15 sessions through July 10, 2026series · 2026-07-26 · 15×3Preview: a 15-point series, ending lower. Month-end sessions vs all other sessions: SPY close concentration, January–June 2026scalar · 2026-07-26 · 1×76 The spread a fund buyer never pays: median quoted spread, July 10, 2026 regular sessionranking · 2026-07-26 · 3×3Preview: 3 ranked values, smallest first. How much of SPY's day trades at the very end: July 10, 2026 regular sessionscalar · 2026-07-26 · 1×322.5 The print NAV is struck from: AAPL's closing auction cross, July 10, 2026scalar · 2026-07-26 · 1×65.47
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
434740457424
424B2186001918
1447268415536
8-K636706536
NPORT-P518072015
34372724711
D3872436478
13F-HR342409344
SCHEDULE 13G/A339166863
6-K272541330
FWP262251128
D/A2199018982
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
$