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

3,022 answered market questions

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

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.
Gold Miner Covered Call ETFs: Yield vs Upside
2026 price return, distributions and total return: miners, wrapper and bulliontable · 2026-10-04 · 4×5 Monthly price move, 2026: GDX vs the covered call wrapper GDXYseries · 2026-10-04 · 10×3Preview: a 10-point series, roughly flat. Monthly at-the-money IV: GDX, GDXJ and SPY over the past yearseries · 2026-10-04 · 13×5Preview: a 13-point series, roughly flat. At-the-money implied volatility: gold miners vs bullion vs the S&P 500table · 2026-10-04 · 4×6
GLD Implied Volatility, Explained
Average implied volatility by delta bucket, trailing twelve monthsranking · 2026-09-23 · 5×3Preview: 5 ranked values, smallest first. 25 delta call minus put implied volatility, in volatility pointsseries · 2026-09-23 · 60×5Preview: a 16-point series, ending lower. Percentile range of daily ATM implied volatility, five year windowranking · 2026-09-23 · 5×3Preview: 5 ranked values, smallest first. Monthly at-the-money 30 day implied volatility: GLD vs SPYseries · 2026-09-23 · 60×4Preview: a 16-point series, roughly flat.
What one Micro Gold (MGC) contract controls at different gold prices

What one Micro Gold (MGC) contract controls at different gold prices

most recentas of table 7×6read in context →
What one Micro Gold (MGC) contract controls at different gold prices — 7 rows by 6 columns, computed from US exchange, SIP and OPRA data.
gold_price_per_ozmgc_notional_usdgc_notional_usdmgc_notional_labelone_pct_move_labelgld_share_equivalent
$3,20032000320000$32,000$320109 GLD shares
$3,60036000360000$36,000$360109 GLD shares
$4,00040000400000$40,000$400109 GLD shares
$4,40044000440000$44,000$440109 GLD shares
$4,80048000480000$48,000$480109 GLD shares
$5,20052000520000$52,000$520109 GLD shares
$5,60056000560000$56,000$560109 GLD shares
the exact SQL behind every number
SELECT
    concat('$', substring(toString(price_per_oz), 1, 1), ',', substring(toString(price_per_oz), 2, 3)) AS gold_price_per_oz,
    price_per_oz * 10                                              AS mgc_notional_usd,
    price_per_oz * 100                                             AS gc_notional_usd,
    concat('$', toString(intDiv(price_per_oz * 10, 1000)), ',000') AS mgc_notional_label,
    concat('$', toString(intDiv(price_per_oz, 10)))                AS one_pct_move_label,
    concat(toString(toUInt16(round(10 / 0.0918))), ' GLD shares')  AS gld_share_equivalent
FROM
(
    SELECT 3200 + (400 * arrayJoin(range(7))) AS price_per_oz
)
ORDER BY price_per_oz
$