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

2,236 answered market questions

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

What Replaced the PDT Rule? Intraday Margin
What 100 shares, one contract's deliverable, cost at the end of August 2026ranking · 2026-09-14 · 6×4Preview: 6 ranked values, largest first. Intraday high-to-low range as a share of the open, August 2026ranking · 2026-09-14 · 6×3Preview: 6 ranked values, largest first. The five widest AAPL sessions of August 2026 for the same $5,000 accountranking · 2026-09-14 · 5×3Preview: 5 ranked values, largest first. A $5,000 account holding $20,000 of AAPL from the open: loss and deficit at each session low, August 2026series · 2026-09-14 · 21×3Preview: a 16-point series, ending lower.
What 100 shares, one contract's deliverable, cost at the end of August 2026

What 100 shares, one contract's deliverable, cost at the end of August 2026

most recentas of ranking 6×4read in context →
What 100 shares, one contract's deliverable, cost at the end of August 2026 — 6 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickerpriced_onone_contract_deliverable_usdmaintenance_at_25pct_usd
SPYAug 317670519176
MSFTAug 315072912682
AMDAug 314707211768
TSLAAug 31367959199
AAPLAug 31316857921
NVDAAug 31220785520
the exact SQL behind every number
SELECT
    ticker,
    formatDateTime(max(date), '%b %e')                          AS priced_on,
    toInt64(round(toFloat64(argMax(close, date)) * 100, 0))     AS one_contract_deliverable_usd,
    toInt64(round(toFloat64(argMax(close, date)) * 25, 0))      AS maintenance_at_25pct_usd
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'TSLA', 'AMD', 'SPY')
  AND date >= '2026-08-24'
  AND date <  '2026-09-01'
GROUP BY ticker
ORDER BY one_contract_deliverable_usd DESC
$