dxyz_vs_nav
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-20, from how-pre-ipo-shares-trade.
| session_date | session_label | close | nav_june_30_2026 | vs_nav_pct | volume_millions |
|---|---|---|---|---|---|
| 2026-08-28 | Aug 28, 2026 | 34.74 | 34.3 | 1.3 | 1.47 |
| 2026-08-31 | Aug 31, 2026 | 32.13 | 34.3 | -6.3 | 1.68 |
| 2026-09-01 | Sep 1, 2026 | 31.6 | 34.3 | -7.9 | 1.12 |
| 2026-09-02 | Sep 2, 2026 | 32.7 | 34.3 | -4.7 | 0.68 |
| 2026-09-03 | Sep 3, 2026 | 32.25 | 34.3 | -6 | 0.72 |
| 2026-09-04 | Sep 4, 2026 | 32.7 | 34.3 | -4.7 | 0.73 |
| 2026-09-08 | Sep 8, 2026 | 34.24 | 34.3 | -0.2 | 1.38 |
| 2026-09-09 | Sep 9, 2026 | 32.6 | 34.3 | -5 | 0.92 |
| 2026-09-10 | Sep 10, 2026 | 32.05 | 34.3 | -6.6 | 0.65 |
| 2026-09-11 | Sep 11, 2026 | 32.11 | 34.3 | -6.4 | 0.53 |
| 2026-09-14 | Sep 14, 2026 | 31.57 | 34.3 | -8 | 0.85 |
| 2026-09-15 | Sep 15, 2026 | 30.26 | 34.3 | -11.8 | 0.65 |
| 2026-09-16 | Sep 16, 2026 | 30.75 | 34.3 | -10.3 | 0.69 |
| 2026-09-17 | Sep 17, 2026 | 31.15 | 34.3 | -9.2 | 0.59 |
| 2026-09-18 | Sep 18, 2026 | 31.31 | 34.3 | -8.7 | 1.08 |
- Rows × columns
- 15 × 6
- 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 |
|---|---|---|---|
session_date |
date | 2026-08-28 to 2026-09-18 | |
session_label |
text | 15 distinct values (Aug 28, 2026, Aug 31, 2026, Sep 1, 2026…) | |
close |
number | 30.26 to 34.74 | US dollars |
nav_june_30_2026 |
number | every row is 34.3 | US dollars |
vs_nav_pct |
number | -11.8 to 1.3 | percent |
volume_millions |
number | 0.53 to 1.68 | 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(toDate(date)) AS session_date,
concat(formatDateTime(toDate(date), '%b'), ' ',
toString(toDayOfMonth(toDate(date))), ', ',
toString(toYear(toDate(date)))) AS session_label,
round(toFloat64(close), 2) AS close,
34.30 AS nav_june_30_2026,
round((toFloat64(close) / 34.30 - 1) * 100, 1) AS vs_nav_pct,
round(toFloat64(volume) / 1e6, 2) AS volume_millions
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'DXYZ'
AND date >= '2026-08-28'
ORDER BY session_date