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

Can You Opt Out of Share Lending?
Share of reported AAPL volume marked short, by sessionseries · 2026-10-05 · 64×3Preview: a 16-point series, roughly flat. Cash per share a substitute payment would have replaced, trailing yearranking · 2026-10-05 · 7×4Preview: 7 ranked values, largest first. How crowded is the short side? Days to cover across the whole reporting universeranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. Reported short interest and days to cover across seven large capsranking · 2026-10-05 · 7×4Preview: 7 ranked values, smallest first.
Why Index Options Are Taxed 60/40: Section 1256
Average daily options volume: Section 1256 names against equity optionsranking · 2026-10-04 · 4×3Preview: 4 ranked values, largest first. Share of contract volume by days to expiry, SPX and SPYranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first.
What Happens When an ETF Closes
How the tape behaved into the final sessionranking · 2026-10-04 · 5×3Preview: 5 ranked values, smallest first. How long retired listings had traded before their last sessionranking · 2026-10-04 · 5×3Preview: 5 ranked values, smallest first. Listings that printed their final daily bar, by yearranking · 2026-10-04 · 11×2Preview: 11 ranked values, smallest first. Final trading days by month, rolling three yearsseries · 2026-10-04 · 33×3Preview: a 16-point series, ending lower.
The $100,000 Rule for Stock Options (ISOs)
What $100,000 of grant-date value covered, by grant year (MSFT)ranking · 2026-10-04 · 11×3Preview: 11 ranked values, smallest first. Form 4 lines coded M (derivative exercise), by monthseries · 2026-10-04 · 24×3Preview: a 16-point series, ending higher. Shares that $100,000 of grant-date value covers, by share priceranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first.
Substitute Payments and Your 1099
One quarterly dividend on 1,000 shares, at a qualified rate versus an ordinary ratetable · 2026-10-04 · 8×6 Calendar days from ex-dividend date to payable date, most recent dividendranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. Days to cover at each short interest settlement, AAPL against KOtable · 2026-10-04 · 35×3 Share of reported volume marked short, trailing four monthsranking · 2026-10-04 · 8×3Preview: 8 ranked values, largest first.
SPY ETF Price in Korean Won: KRW per Share
SPY closing price in US dollars, month by monthseries · 2026-10-04 · 15×3Preview: a 15-point series, ending higher. When the US session lands on the Korean clock: June against January 2026ranking · 2026-10-04 · 16×3Preview: 16 ranked values, largest first. One share of SPY in Korean won, across input exchange ratesranking · 2026-10-04 · 7×2Preview: 7 ranked values, smallest first. What a broker's FX spread adds to the won cost of one shareranking · 2026-10-04 · 5×3Preview: 5 ranked values, smallest first. A won budget against whole shares and fractional sharesranking · 2026-10-04 · 5×4Preview: 5 ranked values, smallest first.
SPX vs SPY Options: Which One to Trade
SPY option volume by days to expiry, trailing six weeksranking · 2026-10-04 · 5×3Preview: 5 ranked values, largest first. Time value left in deep in-the-money SPY calls, against the dividend at stakeranking · 2026-10-04 · 15×4Preview: 15 ranked values, smallest first. How close SPY closes to the nearest whole-dollar strike on monthly expirationsseries · 2026-10-04 · 12×4Preview: a 12-point series, roughly flat. What one contract controls: SPX, SPY and XSPranking · 2026-10-04 · 3×4Preview: 3 ranked values, largest first.
Qualified Dividend Holding Period: 61 Days
Every 121-day window around a Coca-Cola ex-dividend dateseries · 2026-10-04 · 14×6Preview: a 14-point series, ending higher. How long after the ex-date the cash actually arrivesranking · 2026-10-04 · 10×3Preview: 10 ranked values, largest first. Days between consecutive ex-dividend dates, against the 121-day windowranking · 2026-10-04 · 6×3Preview: 6 ranked values, smallest first.
Micro Gold Futures vs GLD: Size, Tax, Cost
What one Micro Gold (MGC) contract controls at different gold pricestable · 2026-10-04 · 7×6 GLD's trailing year, and the gold notional inside one MGCseries · 2026-10-04 · 13×7Preview: a 13-point series, ending higher. GLD overnight gaps against intraday moves, by yearranking · 2026-10-04 · 10×4Preview: 10 ranked values, smallest first. GLD sponsor fee on a stake matching one MGC, by years heldranking · 2026-10-04 · 10×3Preview: 10 ranked values, smallest first.
Dividends vs Buybacks: Shareholder Yield
Dividend yield, buyback yield and total shareholder yieldranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. AAPL diluted share count, every reported quarter since 2021series · 2026-10-04 · 20×3Preview: a 16-point series, ending lower. The exact quarters behind each buyback yieldtable · 2026-10-04 · 8×5 Share of net income already committed to the dividendranking · 2026-10-04 · 8×2Preview: 8 ranked values, largest first.
How Are Event Contracts Taxed? 60/40 or Not
Illustrative at a 37% ordinary rate: tax on a $10,000 gain, and the deductible part of a $10,000 loss with no offsetting gainsranking · 2026-10-02 · 3×3Preview: 3 ranked values, smallest first.
When Covered Calls Trigger the Straddle Rules
KO ex dividend dates and the 121 day qualified dividend windowseries · 2026-09-26 · 12×5Preview: a 12-point series, ending higher.
Why stocks drop on the ex-dividend date
KO: dividend per share against the realised opening drop, every ex-date 2021 to 2025series · 2026-08-14 · 20×4Preview: a 16-point series, roughly flat. Opening drop per dollar of dividend paid, ex-dates 2021 to 2025ranking · 2026-08-14 · 10×4Preview: 10 ranked values, largest first. Pooled opening drop per dollar paid, by calendar yearranking · 2026-08-14 · 5×3Preview: 5 ranked values, largest first. Quarterly dividend against ordinary overnight moves, 2021 to 2025ranking · 2026-08-14 · 10×4Preview: 10 ranked values, smallest first.
Wash Sale Rule and Options: The 61-Day Window
How many trading sessions fit inside a 61 day wash sale windowseries · 2026-08-13 · 30×4Preview: a 16-point series, roughly flat. One full 61 day wash sale window on the tape: AAPL, Dec 1 2025 through Jan 30 2026series · 2026-08-13 · 42×3Preview: a 16-point series, ending lower. Average call and put delta by strike distance, AAPL, 20 to 45 days to expiry, June 2026ranking · 2026-08-13 · 5×4Preview: 5 ranked values, largest first. Every December session and how far its wash sale window reaches into the new yearseries · 2026-08-13 · 22×4Preview: a 16-point series, ending higher.
Cost Basis Methods: FIFO vs Specific ID
Cheapest to dearest monthly lot in 2024, five household tickersranking · 2026-08-09 · 5×3Preview: 5 ranked values, largest first. Twelve monthly AAPL lots, first regular session of each month of 2024series · 2026-08-09 · 12×3Preview: a 12-point series, ending higher. Realized gain per share on each 2024 lot, sold at the same June 2025 priceseries · 2026-08-09 · 12×3Preview: a 12-point series, ending lower.
Share of reported AAPL volume marked short, by session

Share of reported AAPL volume marked short, by session

most recentas of series 64×3read in context →
Share of reported AAPL volume marked short, by session — 64 rows by 3 columns, computed from US exchange, SIP and OPRA data.
datesession_labelshort_volume_pct
2026-06-08Jun 846.5
2026-06-09Jun 934.7
2026-06-10Jun 1043.4
2026-06-11Jun 1152.4
2026-06-12Jun 1250.6
2026-06-15Jun 1541
2026-06-17Jun 1754.4
2026-06-18Jun 1843.3
2026-06-22Jun 2248.4
2026-06-24Jun 2441.6
2026-06-25Jun 2537
2026-06-26Jun 2638.9
2026-06-30Jun 3044.2
2026-07-01Jul 138.1
2026-07-02Jul 246.5
2026-07-06Jul 645.7
2026-07-08Jul 851.4
2026-07-09Jul 952.9
2026-07-10Jul 1048.8
2026-07-14Jul 1451.2
2026-07-15Jul 1553.7
2026-07-16Jul 1657.5
2026-07-20Jul 2045.2
2026-07-21Jul 2149.8
2026-07-22Jul 2243.8
2026-07-24Jul 2447.2
2026-07-27Jul 2740.3
2026-07-28Jul 2850.3
2026-07-30Jul 3047.9
2026-07-31Jul 3152.6
2026-08-03Aug 345.9
2026-08-04Aug 447.6
2026-08-05Aug 552.1
2026-08-07Aug 741.6
2026-08-10Aug 1042.4
2026-08-11Aug 1135.9
2026-08-13Aug 1335.9
2026-08-14Aug 1432.9
2026-08-17Aug 1737.5
2026-08-19Aug 1939.6
2026-08-20Aug 2039.3
2026-08-21Aug 2150.4
2026-08-25Aug 2558.5
2026-08-26Aug 2651.8
2026-08-27Aug 2756.7
2026-08-31Aug 3151.5
2026-09-01Sep 151.6
2026-09-02Sep 245.5
2026-09-03Sep 348.3
2026-09-08Sep 859.6
2026-09-09Sep 963.3
2026-09-10Sep 1058.9
2026-09-14Sep 1446.3
2026-09-15Sep 1540.1
2026-09-16Sep 1649.2
2026-09-18Sep 1854.6
2026-09-21Sep 2144.7
2026-09-22Sep 2256.8
2026-09-24Sep 2449.2
2026-09-25Sep 2558.3
2026-09-28Sep 2848.8
2026-09-30Sep 3041
2026-10-01Oct 156.7
2026-10-02Oct 254.1
the exact SQL behind every number
SELECT
    date,
    formatDateTime(date, '%b %e')                         AS session_label,
    round(100 * max(short_volume) / max(total_volume), 1) AS short_volume_pct
FROM global_markets.stocks_short_volume
WHERE ticker = 'AAPL'
  AND date >= today() - 120
  AND total_volume > 0
GROUP BY date
ORDER BY date
$