daily_volume_reset
Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-09-24, from why-open-interest-updates-once-a-day.
| date | date_label | volume_thousands | contracts_with_volume |
|---|---|---|---|
| 2026-06-01 | Jun 1 | 558.8 | 1620 |
| 2026-06-02 | Jun 2 | 1132.8 | 1714 |
| 2026-06-03 | Jun 3 | 759.4 | 1579 |
| 2026-06-04 | Jun 4 | 626.7 | 1575 |
| 2026-06-05 | Jun 5 | 687.9 | 1667 |
| 2026-06-08 | Jun 8 | 1179.8 | 1860 |
| 2026-06-09 | Jun 9 | 1698.8 | 1858 |
| 2026-06-10 | Jun 10 | 806.7 | 1567 |
| 2026-06-11 | Jun 11 | 918.8 | 1473 |
| 2026-06-12 | Jun 12 | 514 | 1448 |
| 2026-06-15 | Jun 15 | 544.4 | 1481 |
| 2026-06-16 | Jun 16 | 877.2 | 1429 |
| 2026-06-17 | Jun 17 | 664.6 | 1424 |
| 2026-06-18 | Jun 18 | 438.3 | 1282 |
| 2026-06-22 | Jun 22 | 449.9 | 1374 |
| 2026-06-23 | Jun 23 | 813.4 | 1375 |
| 2026-06-24 | Jun 24 | 441.8 | 1315 |
| 2026-06-25 | Jun 25 | 1878.8 | 1906 |
| 2026-06-26 | Jun 26 | 724.4 | 1557 |
| 2026-06-29 | Jun 29 | 506.9 | 1326 |
| 2026-06-30 | Jun 30 | 1019.7 | 1429 |
- Rows × columns
- 21 × 4
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
date |
date | 2026-06-01 to 2026-06-30 | |
date_label |
text | 21 distinct values (Jun 1, Jun 10, Jun 11…) | |
volume_thousands |
number | 438.3 to 1,878.8 | count |
contracts_with_volume |
number | 1,282 to 1,906 | count |
Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.
Run it yourself
This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.
SELECT
toString(date) AS date,
formatDateTime(toDate(date), '%b %e') AS date_label,
round(sum(volume) / 1000, 1) AS volume_thousands,
countDistinct(ticker) AS contracts_with_volume
FROM global_markets.options_greeks
WHERE underlying_symbol = 'AAPL'
AND date >= '2026-06-01'
AND date <= '2026-06-30'
AND volume > 0
GROUP BY date
ORDER BY date
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.