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.
SEC 30-Day Yield vs Distribution Yield
Trailing twelve-month yield and indicated yield, same funds, same dayranking · 2026-08-22 · 6×4Preview: 6 ranked values, largest first. One bond fund, two distribution yields, month by monthseries · 2026-08-22 · 37×4Preview: a 16-point series, ending higher. The market rate backdrop: 3-month and 10-year Treasury yieldsseries · 2026-08-22 · 53×4Preview: a 16-point series, ending higher. Two years of regular distributions: how many, and how variableranking · 2026-08-22 · 6×3Preview: 6 ranked values, largest first.
SCHD vs VOO: Why the Dividend Yields Differ
SCHD and VOO annualized dividend yield: twelve month-ends through July 2026series · 2026-08-22 · 12×5Preview: a 12-point series, ending lower. Quarterly distributions per share: SCHD and VOO, 2025 Q1 through 2026 Q2ranking · 2026-08-22 · 6×3Preview: 6 ranked values, smallest first. Latest dividend yield: index heavyweights beside dividend-screen staplesranking · 2026-08-22 · 12×4Preview: 12 ranked values, largest first. Trailing twelve-month distribution yield: dividend funds beside the S&P 500 trackertable · 2026-08-22 · 7×5
Return of Capital in ETF Distributions
QYLD by calendar year: cash paid, average price, implied ratetable · 2026-08-22 · 5×5 Share price indexed to 100, three covered call ETFs, monthlyseries · 2026-08-22 · 59×4Preview: a 16-point series, ending lower. Trailing year distribution rate, price change, and approximate total returnranking · 2026-08-22 · 7×4Preview: 7 ranked values, largest first. Cash distributions per share, month by monthseries · 2026-08-22 · 59×4Preview: a 16-point series, ending lower.
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.
Monthly Dividend ETFs: Who Actually Pays
Trailing 12 month distribution rate, by fund familyranking · 2026-08-22 · 12×3Preview: 12 ranked values, largest first. Distributions per year: monthly funds beside quarterly benchmarksranking · 2026-08-22 · 12×3Preview: 12 ranked values, largest first. Days from ex dividend date to cash, monthly paying fundsranking · 2026-08-22 · 9×2Preview: 9 ranked values, largest first. Monthly cash per share: an option income fund and a bond fundseries · 2026-08-22 · 24×3Preview: a 16-point series, ending higher.
ETF Relative Strength and Alpha Attribution
Annualized volatility and worst single session, trailing two yearsranking · 2026-08-22 · 10×3Preview: 10 ranked values, largest first. 20-session return versus SPY across a nine-fund ETF universeranking · 2026-08-22 · 9×3Preview: 9 ranked values, largest first. Strongest and weakest sleeve versus SPY, by calendar monthseries · 2026-08-22 · 13×4Preview: a 13-point series, roughly flat. Share of each fund's daily variation explained by SPY, trailing two yearsranking · 2026-08-22 · 9×2Preview: 9 ranked values, largest first.
Covered Call Closed-End Funds vs ETFs
Short-term Treasury yields by month, the reference for fund borrowing costsseries · 2026-08-22 · 36×3Preview: a 16-point series, ending lower. Cash distributions over the trailing year, by declared scheduleranking · 2026-08-22 · 5×2Preview: 5 ranked values, largest first. Monthly cost of a near-the-money call, as a percent of share priceseries · 2026-08-22 · 18×3Preview: a 16-point series, roughly flat.
How Buffer ETFs Work: Caps and Resets
A 15% cap and 9% buffer, seen from three entry pointsranking · 2026-08-12 · 21×4Preview: 16 ranked values, smallest first. SPY calendar-year price return against a 15% cap and 9% bufferranking · 2026-08-12 · 12×3Preview: 12 ranked values, smallest first. Remaining buffer and remaining cap by entry pointranking · 2026-08-12 · 11×3Preview: 11 ranked values, smallest first. Compounding the index against the buffered payoff, net of a 0.79% feeranking · 2026-08-12 · 12×3Preview: 12 ranked values, smallest first.
Contango and Roll Yield in Commodity ETFs
Two listed crude oil funds, calendar year price changeranking · 2026-08-10 · 5×4Preview: 5 ranked values, largest first. Both funds rebased to 100 at the start of the window, month by monthseries · 2026-08-10 · 60×4Preview: a 16-point series, ending higher. The financing leg: 3 month and 1 year Treasury yields by monthseries · 2026-08-10 · 91×4Preview: a 16-point series, ending higher.
How ETF Creation and Redemption Works
Quoted spread against average share volume, US listed ETFsranking · 2026-08-07 · 5×3Preview: 5 ranked values, smallest first. One session of SPY prints, sorted into trade size bucketsranking · 2026-08-07 · 4×4Preview: 4 ranked values, largest first. Quoted spread through the session: large cap fund vs micro cap fundseries · 2026-08-07 · 79×3Preview: a 16-point series, ending lower. Daily range and volume in a high yield bond ETF, month by monthranking · 2026-08-07 · 9×3Preview: 9 ranked values, smallest first.
ETF Premium and Discount to NAV, Explained
How far seven ETFs travel in a regular session, first half of 2026ranking · 2026-08-06 · 7×3Preview: 7 ranked values, largest first. Median session move by month, 2026 first halfseries · 2026-08-06 · 6×4Preview: a 6-point series, roughly flat. Average minute bar range by ET clock time, second quarter 2026series · 2026-08-06 · 26×4Preview: a 16-point series, ending lower. Median move before and after European markets close, first half of 2026ranking · 2026-08-06 · 4×3Preview: 4 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.
Sector Scorecard H1 2026: Winners and Losers
Eight heavily traded chip and memory names: H1 return, quarter split, H1 dollar volumetable · 2026-07-26 · 8×5 Median quoted spread by sector ETF, one representative session (June 29, 2026), regular hoursranking · 2026-07-26 · 11×4Preview: 11 ranked values, smallest first. The eleven sector ETFs: H1 2026 return, Q1 and Q2 split, and H1 dollar volumetable · 2026-07-26 · 11×5 XLE, XLF, and XLK by month: the H1 2026 rotation at month grainseries · 2026-07-26 · 18×3Preview: a 16-point series, ending lower. Five-name baskets per sector: members up vs down, median, best and worst, H1 2026table · 2026-07-26 · 11×9 Sector ETF dollar volume, Q1 vs Q2 2026: every fund traded less in the recovery quarterranking · 2026-07-26 · 11×4Preview: 11 ranked values, largest first.
How Leveraged ETFs Work (and Why They Decay)
Every SOXS reverse split since 2020, and the running consolidation factorseries · 2026-07-15 · 5×3Preview: a 5-point series, ending higher. One semiconductor selloff, four funds: SOXX, USD, SOXL, SOXS on July 13, 2026ranking · 2026-07-15 · 4×2Preview: 4 ranked values, largest first. Growth of $100 in the 1x SOXX vs the 3x SOXL, Jan 2 to Jul 13 2026series · 2026-07-15 · 131×3Preview: a 16-point series, ending higher.
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
$