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

3,094 answered market questions

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

Can You Lose More Than You Invest?
The largest US oil tracking fund through April 2020: daily close and session lowseries · 2026-10-05 · 17×3Preview: a 16-point series, ending lower. 2023 run from the first close of the year: year end and peakranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. Deepest overnight gap down per name, 2015 to 2025 (split dates removed)ranking · 2026-10-05 · 6×3Preview: 6 ranked values, largest first. One NVDA option contract, mid January to March 1, 2024: the furthest travellerseries · 2026-10-05 · 33×3Preview: a 16-point series, ending higher.
Buy Limit vs Sell Limit Orders Explained
How often a resting limit was reached, by distance from the prior close (SPY, 2021 to Sep 2026)ranking · 2026-10-05 · 6×3Preview: 6 ranked values, smallest first. A 1% buy limit vs a 1% sell limit: share of SPY sessions reached, by yearranking · 2026-10-05 · 6×3Preview: 6 ranked values, smallest first. The gap a marketable limit crosses: average quoted spread, five names, Sep 15 2026ranking · 2026-10-05 · 5×3Preview: 5 ranked values, largest first. A real quote in motion: Apple's bid and ask by the minute, Sep 15 2026series · 2026-10-05 · 15×4Preview: a 15-point series, ending higher.
Can You Use a Limit Order on a Mutual Fund?
One index ETF's price through a single session, in half-hour ET bucketsseries · 2026-10-04 · 13×3Preview: a 13-point series, ending higher. How far one index ETF travelled inside each recent sessionseries · 2026-10-04 · 30×4Preview: a 16-point series, ending lower. Upcoming market closures that move a fund order's strike dateseries · 2026-10-04 · 12×6Preview: a 12-point series, ending higher. Gap between the last regular-session minute and the official closeranking · 2026-10-04 · 6×4Preview: 6 ranked values, largest first.
Stop Order vs Limit Order: Trigger or Price
AAPL sessions touched at each stop distance, and how many closed back above the open (2024-2025)ranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first. AAPL sessions that opened at least 1.5% below the prior close, 2025series · 2026-10-02 · 16×2Preview: a 16-point series, ending higher. AAPL one minute range and volume by ET clock hour, September 2025ranking · 2026-10-02 · 16×3Preview: 16 ranked values, largest first. Median daily range and sub-open dips across five household names, 2025ranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first.
The largest US oil tracking fund through April 2020: daily close and session low

The largest US oil tracking fund through April 2020: daily close and session low

most recentas of series 17×3read in context →
The largest US oil tracking fund through April 2020: daily close and session low — 17 rows by 3 columns, computed from US exchange, SIP and OPRA data.
dateuso_closeuso_session_low
2020-04-0135.0433.04
2020-04-0240.8836
2020-04-0347.243.52
2020-04-0643.8442.96
2020-04-0740.7239.12
2020-04-0842.9639.52
2020-04-0939.8438.4
2020-04-1339.4438.8
2020-04-1437.2836.24
2020-04-1535.4434.4
2020-04-1634.8833.2
2020-04-1733.6832.8
2020-04-203029.6
2020-04-2122.4818.48
2020-04-2220.0820
2020-04-2321.1220.8
2020-04-2420.5620.08
the exact SQL behind every number 
SELECT
    toString(date)                  AS date,
    round(toFloat64(any(close)), 2) AS uso_close,
    round(toFloat64(any(low)), 2)   AS uso_session_low
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'USO'
  AND date >= '2020-04-01'
  AND date <= '2020-04-24'
GROUP BY date
ORDER BY date
More from this analysisCan You Lose More Than You Invest?
One NVDA option contract, mid January to March 1, 2024: the furthest traveller series 33×3 → 2023 run from the first close of the year: year end and peak ranking 6×3 → Deepest overnight gap down per name, 2015 to 2025 (split dates removed) ranking 6×3 → One fixed short AAPL call strike: requirement as a percent of the share price, April to June 2026 series 62×4 → See all 3,094 queries →
$