STRASMORE/EXPLORE 3,293 QUERIES

etf_units

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-10-16, from dow-jones-nasdaq-share-price-for-indian-investors.

as of series 50×4read in context →
etf_units — 50 rows by 4 columns, computed from US exchange, SIP and OPRA data.
dateas_of_labeldia_close_usdqqq_close_usd
2026-08-077 Aug 2026539.62723.03
2026-08-1010 Aug 2026538.99720.87
2026-08-1111 Aug 2026537.28718.45
2026-08-1212 Aug 2026537.15723.7
2026-08-1313 Aug 2026537.91732.07
2026-08-1414 Aug 2026536.8731.07
2026-08-1717 Aug 2026534.19729.87
2026-08-1818 Aug 2026532.91717.51
2026-08-1919 Aug 2026534.27716.08
2026-08-2020 Aug 2026527.51710.93
2026-08-2121 Aug 2026532.22713.44
2026-08-2424 Aug 2026533.65706.32
2026-08-2525 Aug 2026535.24710.72
2026-08-2626 Aug 2026534.23711.37
2026-08-2727 Aug 2026535.22721.11
2026-08-2828 Aug 2026535.06716.43
2026-08-3131 Aug 2026531.57716.76
2026-09-011 Sep 2026527.75707.64
2026-09-022 Sep 2026530.62709.24
2026-09-033 Sep 2026536.93717.67
2026-09-044 Sep 2026534.08718.96
2026-09-088 Sep 2026528.03718.36
2026-09-099 Sep 2026524.07716.31
2026-09-1010 Sep 2026520.75708.69
2026-09-1111 Sep 2026525.79714.88
2026-09-1414 Sep 2026524.49709.18
2026-09-1515 Sep 2026521.23704.54
2026-09-1616 Sep 2026515.22704.72
2026-09-1717 Sep 2026518.35716.92
2026-09-1818 Sep 2026515.88721.45
2026-09-2121 Sep 2026519.78741.47
2026-09-2222 Sep 2026518747.46
2026-09-2323 Sep 2026514.3741.21
2026-09-2424 Sep 2026512.68741.1
2026-09-2525 Sep 2026517.49744.5
2026-09-2828 Sep 2026514.02736.53
2026-09-2929 Sep 2026512.88737.93
2026-09-3030 Sep 2026508.55739.77
2026-10-011 Oct 2026508.62742.03
2026-10-022 Oct 2026511.1749.58
2026-10-055 Oct 2026512.11756.2
2026-10-066 Oct 2026514.56759.66
2026-10-077 Oct 2026511.02757.73
2026-10-088 Oct 2026511.65747.58
2026-10-099 Oct 2026516.11751.27
2026-10-1212 Oct 2026517.91746.04
2026-10-1313 Oct 2026516.21743.57
2026-10-1414 Oct 2026515.63728.95
2026-10-1515 Oct 2026521.18728
2026-10-1616 Oct 2026521.16727.6
Rows × columns
50 × 4
Period covered
to
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for etf_units, derived from the stored result.
ColumnTypeRangeNotes
date date 2026-08-07 to 2026-10-16
as_of_label text 50 distinct values (1 Oct 2026, 1 Sep 2026, 10 Aug 2026…)
dia_close_usd number 508.55 to 539.62 US dollars
qqq_close_usd number 704.54 to 759.66 US dollars

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
    date,
    concat(toString(toDayOfMonth(date)), ' ', formatDateTime(date, '%b %Y')) AS as_of_label,
    round(toFloat64(anyIf(close, ticker = 'DIA')), 2)                        AS dia_close_usd,
    round(toFloat64(anyIf(close, ticker = 'QQQ')), 2)                        AS qqq_close_usd
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('DIA', 'QQQ')
  AND date >= today() - 70
GROUP BY date
HAVING countIf(ticker = 'DIA') > 0
   AND countIf(ticker = 'QQQ') > 0
ORDER BY date
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent