usd_windows
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-11-01, from msft-stock-price-in-twd.
| label | basis_start | start_close_usd | latest_close_usd | usd_return_pct |
|---|---|---|---|---|
| 1 年 | 2025 年 11 月 | 517.03 | 521.91 | 0.94 |
| 3 年 | 2023 年 11 月 | 348.32 | 521.91 | 49.84 |
| 5 年 | 2021 年 11 月 | 333.13 | 521.91 | 56.67 |
- Rows × columns
- 3 × 5
- 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 |
|---|---|---|---|
label |
text | 3 distinct values (1 年, 3 年, 5 年) | |
basis_start |
text | 3 distinct values (2021 年 11 月, 2023 年 11 月, 2025 年 11 月) | |
start_close_usd |
number | 333.13 to 517.03 | US dollars |
latest_close_usd |
number | every row is 521.91 | US dollars |
usd_return_pct |
number | 0.94 to 56.67 | percent |
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
concat(toString(intDiv(lookback_days, 365)), ' 年') AS label,
concat(toString(toYear(min(date))), ' 年 ', toString(toMonth(min(date))), ' 月') AS basis_start,
round(argMin(toFloat64(close), date), 2) AS start_close_usd,
round(argMax(toFloat64(close), date), 2) AS latest_close_usd,
round(100 * (argMax(toFloat64(close), date) / argMin(toFloat64(close), date) - 1), 2) AS usd_return_pct
FROM global_markets.stocks_daily_aggs
ARRAY JOIN [365, 1095, 1825] AS lookback_days
WHERE ticker = 'MSFT'
AND date >= today() - 1825
AND date >= today() - lookback_days
GROUP BY lookback_days
ORDER BY lookback_days
在你的 AI 助理中使用這些資料
開啟即可查詢，已帶入本頁資料。免費，無需帳號。