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

इस डेटा के साथ अपने AI असिस्टेंट में काम करें

इस पेज के डेटा के साथ, क्वेरी के लिए तैयार खुलता है। मुफ़्त, बिना अकाउंट।

Claude ChatGPT Gemini Muse आपका अपना एजेंट