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

2,401 answered market questions

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

XOM Dividend: Yield, History & Ex-Dates
XOM dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-09-19 · 1×71.03 XOM recent dividend payments: ex-dividend date and per-share amountseries · 2026-09-19 · 10×2Preview: a 10-point series, ending lower. XOM total dividends paid per year (regular dividends)ranking · 2026-09-19 · 7×2Preview: 7 ranked values, smallest first.
WMT Dividend: Yield, History & Ex-Dates
WMT dividend snapshot: latest payout, annual rate, yield, and next ex-datescalar · 2026-09-19 · 1×70.248 WMT recent dividend payments: ex-dividend date and per-share amountseries · 2026-09-19 · 10×2Preview: a 10-point series, ending lower. WMT total dividends paid per year (regular dividends)ranking · 2026-09-19 · 7×2Preview: 7 ranked values, largest first.
Why VIX Options Don't Track the VIX
SPY near-the-money implied volatility by distance to expirationranking · 2026-09-19 · 6×3Preview: 6 ranked values, smallest first. How far the long tenor travels on days the front end jumpsranking · 2026-09-19 · 5×4Preview: 5 ranked values, smallest first. Near-dated versus long-dated SPY implied volatility, session by sessionseries · 2026-09-19 · 80×3Preview: a 16-point series, ending lower. The near-to-far implied volatility gap across liquid namesranking · 2026-09-19 · 6×4Preview: 6 ranked values, largest first.
Why Ticker Symbols Break Your Dataset
When each symbol last printed a daily barranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. New listings landing on a symbol that already had historyranking · 2026-09-19 · 11×3Preview: 11 ranked values, smallest first. Which share-class spellings actually carry historyranking · 2026-09-19 · 4×4Preview: 4 ranked values, smallest first. Trading sessions per year under FB and METAranking · 2026-09-19 · 15×3Preview: 15 ranked values, smallest first.
Why Stocks Halt: Limit Up-Limit Down Bands
Where listed symbols sit by price, and which band rule governs each zoneranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-09-19 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-09-19 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-09-19 · 8×4Preview: 8 ranked values, largest first.
Why Are Spreads Wider at the Open? Real Data
Window guard: the UTC session filter maps to a 9:30 a.m. ET start on both ends of the rolling windowscalar · 2026-09-19 · 1×2570 Share of quote updates at the one-cent minimum spread, by half hour (regular hours, ET)series · 2026-09-19 · 13×4Preview: a 13-point series, ending higher. Median spread each half hour, as a multiple of each name's tightest bucket (regular hours, ET)series · 2026-09-19 · 13×4Preview: a 13-point series, ending lower. Session by session: how often, and by how much, the open ran wider than middaytable · 2026-09-19 · 3×6 Median quoted spread by phase of the trading day, in basis points (ET clock)ranking · 2026-09-19 · 5×4Preview: 5 ranked values, largest first. The opening premium priced: median and 90th-percentile spread at the open (9:30-10:00 ET) vs. midday (12:00-14:00 ET)table · 2026-09-19 · 3×12 MU: median quoted spread by half hour on July 7, 2026 (ET, regular hours)series · 2026-09-19 · 13×5Preview: a 13-point series, ending lower. MU into July 7, 2026: prior regular-session close, opening print, overnight gapscalar · 2026-09-19 · 1×3984.31
Why Short Interest Data Is Always Two Weeks Old
The pipeline lag in one row: plus the bulk backfill these figures deliberately excludescalar · 2026-09-19 · 1×612 Every incrementally-delivered settlement: measured on one date, on file days laterseries · 2026-09-19 · 12×3Preview: a 12-point series, ending lower. GME, winter 2020-21: each short interest print and the price move before it went public (as-traded prices)table · 2026-09-19 · 6×5 GME days to cover: as reported in the file, and recomputed on the volume that traded while the print was pendingscalar · 2026-09-19 · 1×857 The current state of the cycle: the newest print on file, and the one still in the pipelinescalar · 2026-09-19 · 1×622,567 The blind window: what five stocks did between the settlement date and the day its short interest was publishedtable · 2026-09-19 · 5×6
Why Odd Lots Don't Set the NBBO
Round lot size for a basket of familiar tickers, from the latest closeranking · 2026-09-19 · 9×3Preview: 9 ranked values, largest first. Listed names averaging above $250 a share, by monthseries · 2026-09-19 · 24×2Preview: a 16-point series, ending lower. How many listed names sit in each round lot tierranking · 2026-09-19 · 3×3Preview: 3 ranked values, largest first. AAPL trade sizes on the 27 April 2026 sessionranking · 2026-09-19 · 4×3Preview: 4 ranked values, largest first.
Why Index Options Are Taxed 60/40: Section 1256
Average daily options volume: Section 1256 names against equity optionsranking · 2026-09-19 · 4×3Preview: 4 ranked values, largest first. Share of contract volume by days to expiry, SPX and SPYranking · 2026-09-19 · 5×3Preview: 5 ranked values, largest first.
Who Sets the Ex-Dividend Date? Not the Board
One-time distributions by size: where the ex-date landsranking · 2026-09-19 · 4×4Preview: 4 ranked values, largest first. Regular dividends: ex-date before the record date, or on itseries · 2026-09-19 · 44×5Preview: a 16-point series, ending higher. Board declaration to ex-date to payment, eight household payersranking · 2026-09-19 · 8×4Preview: 8 ranked values, largest first. Ex-date alignment by payout cadence, since T+1 took effectranking · 2026-09-19 · 6×4Preview: 6 ranked values, largest first.
Which Stocks Have Weekly Options? How to Tell
Optionable underlyings by expiration pattern, trailing five weeksranking · 2026-09-19 · 4×2Preview: 4 ranked values, largest first. Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdaysranking · 2026-09-19 · 25×4Preview: 16 ranked values, largest first. Underlyings with a traded expiration on each weekday, trailing five weeksranking · 2026-09-19 · 6×2Preview: 6 ranked values, smallest first. AAPL expirations within 130 days, as of Monday Aug 24, 2026series · 2026-09-19 · 12×5Preview: a 12-point series, ending higher.
Which Stocks Have Daily Options?
Monday, Wednesday, Friday expirations: distinct option roots carrying an expiry on each weekdayseries · 2026-09-19 · 5×3Preview: a 5-point series, ending higher. Daily options vs weekly options: upcoming expiration dates for six household tickersranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. SPY's expiration on every trading day: each near-term SPY expiry date, its weekday and volumeseries · 2026-09-19 · 12×4Preview: a 12-point series, ending lower. Which tickers carry the most upcoming expirations: option roots by distinct expiration dates in the next six weeksranking · 2026-09-19 · 20×3Preview: 16 ranked values, largest first.
Where to Park Idle Cash
The pickup for extending: extra yield over the 1-month bill, in basis pointsseries · 2026-09-19 · 125×3Preview: a 16-point series, ending higher. The short end over the last 180 days: 1-month, 3-month and 1-year bill yieldsseries · 2026-09-19 · 125×5Preview: a 16-point series, ending higher. The current Treasury yield curve: what every maturity pays right nowranking · 2026-09-19 · 7×2Preview: 7 ranked values, smallest first.
When Special Dividends Adjust Options
Time value left in KO calls as they move deeper in the moneyranking · 2026-09-19 · 5×4Preview: 5 ranked values, largest first. One time distributions by size, measured against the ex date closing priceranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. How big each kind of cash distribution is, as a share of the stock priceranking · 2026-09-19 · 5×4Preview: 5 ranked values, largest first. One time cash distributions per calendar year, and their share of all payoutsranking · 2026-09-19 · 9×3Preview: 9 ranked values, largest first.
When Is Short Interest Released?
The short interest release schedule: recent FINRA settlement dates and names reportedseries · 2026-09-19 · 16×2Preview: a 16-point series, ending lower. Measured publication lag: settlement date vs the day the file first arrived hereseries · 2026-09-19 · 12×3Preview: a 12-point series, ending lower. The publication lag in one row: fastest, median and slowest across incrementally-delivered settlementsscalar · 2026-09-19 · 1×412 Day-of-month and the gap between consecutive settlement dates: the twice-monthly cadenceseries · 2026-09-19 · 16×3Preview: a 16-point series, ending higher. The current state of the release cycle: the newest print on file and the settlement still pendingscalar · 2026-09-19 · 1×631
When Short Options Get Assigned Early
Time value left in AAPL contracts by depth in the moneytable · 2026-09-19 · 5×5 AAPL calls 1 to 5 percent in the money, by days left to expiryranking · 2026-09-19 · 6×4Preview: 6 ranked values, smallest first. Latest cash dividend per share, and what it is worth against the stockseries · 2026-09-19 · 6×4Preview: a 6-point series, ending lower. Put versus call implied volatility, near the money, 20 to 45 days outranking · 2026-09-19 · 5×4Preview: 5 ranked values, smallest first.
When Do Options Start Trading After an IPO?
How long-dated a new chain gets in its first twelve weeksranking · 2026-09-19 · 12×3Preview: 12 ranked values, smallest first. Trading sessions from first equity print to first listed option printranking · 2026-09-19 · 12×4Preview: 12 ranked values, smallest first. How quickly the forty largest new listings got a traded option chainranking · 2026-09-19 · 20×3Preview: 16 ranked values, smallest first. How a new option chain widens: strikes and expirations tradedranking · 2026-09-19 · 12×3Preview: 12 ranked values, smallest first.
What Time Do Options Start Trading?
SPY option volume, minute by minute into the 9:30 openseries · 2026-09-19 · 46×3Preview: a 16-point series, ending higher. US option contract volume by Eastern-time half hourseries · 2026-09-19 · 21×3Preview: a 16-point series, ending higher. Scheduled open and close on every upcoming half dayseries · 2026-09-19 · 2×6Preview: a 2-point series, roughly flat.
What Replaced the PDT Rule? Intraday Margin
What 100 shares, one contract's deliverable, cost at the end of August 2026ranking · 2026-09-19 · 6×4Preview: 6 ranked values, largest first. Intraday high-to-low range as a share of the open, August 2026ranking · 2026-09-19 · 6×3Preview: 6 ranked values, largest first. The five widest AAPL sessions of August 2026 for the same $5,000 accountranking · 2026-09-19 · 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-19 · 21×3Preview: a 16-point series, ending lower.
What Real-Time Market Data Actually Costs
Where AAPL shares printed across venues, June 16 2026ranking · 2026-09-19 · 12×2Preview: 12 ranked values, largest first. US symbols that traded each month over the past yearseries · 2026-09-19 · 12×3Preview: a 12-point series, ending higher. AAPL quote updates by ET clock hour, June 16 2026ranking · 2026-09-19 · 16×3Preview: 16 ranked values, largest first. One ETF's daily record, year by yearranking · 2026-09-19 · 15×3Preview: 15 ranked values, largest first.
What It Costs to Trade a Stock, Measured
The one-cent floor: share price, percent of quotes exactly one cent wide, and what a penny costs in bpstable · 2026-09-19 · 5×6 NVDA vs SOXS: median quoted spread over the window, with the smallest single-session gapscalar · 2026-09-19 · 1×50.91 NVDA vs SOXS: median quoted spread by session (bps of the midpoint)series · 2026-09-19 · 5×4Preview: a 5-point series, ending lower. The cost-to-trade ladder: median quoted spread in bps of the midpoint, regular hours, recent completed sessionstable · 2026-09-19 · 12×5
What Is VIX1D? The 1-Day Volatility Index
Implied daily move (IV / 16) against realized daily movement, SPY by monthseries · 2026-09-19 · 13×5Preview: a 13-point series, ending lower. SPY option volume by expiration through one session, June 17 2026series · 2026-09-19 · 14×4Preview: a 14-point series, ending lower. SPY near-the-money implied volatility by days to expiryranking · 2026-09-19 · 8×2Preview: 8 ranked values, largest first. SPY absolute daily move, median and 90th percentile by yearranking · 2026-09-19 · 8×4Preview: 8 ranked values, smallest first.
What Is the NBBO? National Best Bid and Offer
NBBO updates per session: four heavily traded names vs. two thin small capsseries · 2026-09-19 · 6×5Preview: a 6-point series, ending lower. Exchange stamp to SIP stamp: the consolidation step, in microsecondsranking · 2026-09-19 · 4×3Preview: 4 ranked values, smallest first. The smallest size the NBBO will show: six names across the price tiersranking · 2026-09-19 · 6×4Preview: 6 ranked values, smallest first. KO: ten consecutive NBBO updates from 1:30 p.m. ET on a recent sessionseries · 2026-09-19 · 10×7Preview: a 10-point series, roughly flat. GME, 2024-05-14: NBBO updates and trades per minute across a five-minute LULD pauseseries · 2026-09-19 · 15×3Preview: a 15-point series, roughly flat. AAPL: average NBBO updates per minute by half-hour bucket (ET, 4 a.m. to 8 p.m.)series · 2026-09-19 · 32×3Preview: a 16-point series, roughly flat.
What Is the 3m10y Spread? The Fed's Yield Curve
3-month and 10-year yields with both spreads, last 90 daysseries · 2026-09-19 · 62×6Preview: a 16-point series, ending higher. 3m10y and 2s10s spreads, monthly averages over twenty yearsseries · 2026-09-19 · 241×4Preview: a 16-point series, ending higher. Every 3m10y inversion since 1985, on monthly averagesseries · 2026-09-19 · 9×6Preview: a 9-point series, roughly flat. Three tenors through the 2022 hiking cycle, monthly averagesseries · 2026-09-19 · 42×5Preview: a 16-point series, ending higher. 2s10s versus 3m10y in three inversion windows, daily closestable · 2026-09-19 · 3×9
page 1 of 25
nke_weekly

nke_weekly

as of series 53×4read in context →
nke_weekly — 53 rows by 4 columns, computed from US exchange, SIP and OPRA data.
weekweekly_closehigh_52w_closebelow_high_pct
2025-09-1570.8974.574.9
2025-09-2269.3174.577.1
2025-09-2971.9374.573.5
2025-10-0665.2274.5712.5
2025-10-1367.3774.579.7
2025-10-2069.1174.577.3
2025-10-2764.5974.5713.4
2025-11-0361.0974.5718.1
2025-11-1064.1774.5713.9
2025-11-1762.874.5715.8
2025-11-2464.6374.5713.3
2025-12-0165.8674.5711.7
2025-12-0867.4774.579.5
2025-12-1558.7174.5721.3
2025-12-2260.9374.5718.3
2025-12-2963.2874.5715.1
2026-01-0565.9274.5711.6
2026-01-1264.3874.5713.7
2026-01-1965.0474.5712.8
2026-01-2661.8174.5717.1
2026-02-0263.9274.5714.3
2026-02-0963.1374.5715.3
2026-02-1665.474.5712.3
2026-02-2362.1874.5716.6
2026-03-0257.0174.5723.5
2026-03-0953.9874.5727.6
2026-03-1652.3774.5729.8
2026-03-2351.3774.5731.1
2026-03-3044.1974.5740.7
2026-04-0642.6274.5742.8
2026-04-1346.0374.5738.3
2026-04-2044.6974.5740.1
2026-04-2744.474.5740.5
2026-05-0444.1474.5740.8
2026-05-1141.8874.5743.8
2026-05-1844.6774.5740.1
2026-05-2546.2374.5738
2026-06-0142.9874.5742.4
2026-06-0844.9374.5739.7
2026-06-1545.274.5739.4
2026-06-2240.7574.5745.4
2026-06-2944.0974.5740.9
2026-07-0644.3774.5740.5
2026-07-1343.7674.5741.3
2026-07-2041.774.5744.1
2026-07-2741.7174.5744.1
2026-08-0341.774.5744.1
2026-08-1040.7374.5745.4
2026-08-1740.7674.5745.3
2026-08-2439.674.5746.9
2026-08-3138.474.5748.5
2026-09-0736.874.5750.7
2026-09-1435.5174.5752.4
the exact SQL behind every number
SELECT
    week,
    weekly_close,
    round(max(week_high_close) OVER (), 2)                                 AS high_52w_close,
    round((1 - weekly_close / max(week_high_close) OVER ()) * 100, 1)      AS below_high_pct
FROM
(
    SELECT
        toString(toStartOfWeek(date, 1))            AS week,
        round(toFloat64(argMax(close, date)), 2)    AS weekly_close,
        toFloat64(max(close))                       AS week_high_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'NKE'
      AND date >= today() - 371
      AND date <  today()
    GROUP BY week
)
ORDER BY week
$