STRASMORE/EXPLORE 3,293 QUERIES

price_trace

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-24, from gis-dividend-for-japanese-investors.

as of series 53×5read in context →
price_trace — 53 rows by 5 columns, computed from US exchange, SIP and OPRA data.
weekas_ofclose_usdweek_high_usdweek_low_usd
2025-10-202025/10/2447.4148.0647.27
2025-10-272025/10/3146.6148.5246.21
2025-11-032025/11/0746.8847.3245.8
2025-11-102025/11/1447.4148.0946.04
2025-11-172025/11/2148.3349.0946.71
2025-11-242025/11/2847.3548.346.66
2025-12-012025/12/0545.9347.4945.6
2025-12-082025/12/1246.6946.8845.15
2025-12-152025/12/1947.8649.2446.65
2025-12-222025/12/2647.0547.7246.45
2025-12-292026/01/0245.7247.3145.6
2026-01-052026/01/0944.645.5642.78
2026-01-122026/01/1644.5145.7943.34
2026-01-192026/01/2344.5644.8843.42
2026-01-262026/01/3046.2646.2844.01
2026-02-022026/02/0647.8749.2945.12
2026-02-092026/02/1348.3449.5947.03
2026-02-162026/02/2044.6246.7143.72
2026-02-232026/02/2745.234643.92
2026-03-022026/03/0644.2945.5943.06
2026-03-092026/03/1339.3844.339.29
2026-03-162026/03/2037.0139.9237.01
2026-03-232026/03/2736.4537.6535.64
2026-03-302026/04/0237.4237.5536.32
2026-04-062026/04/1035.5937.9335.43
2026-04-132026/04/1735.535.8834.04
2026-04-202026/04/2434.9735.6534.7
2026-04-272026/05/0134.7235.8634.12
2026-05-042026/05/0834.6835.9433.58
2026-05-112026/05/1532.9934.932.91
2026-05-182026/05/2233.6934.6232.64
2026-05-252026/05/2933.8134.3633.15
2026-06-012026/06/0533.1534.1631.75
2026-06-082026/06/1234.5134.5232.57
2026-06-152026/06/1833.423533.06
2026-06-222026/06/2636.0136.4533.32
2026-06-292026/07/0237.5738.2534.8
2026-07-062026/07/1036.2237.7735.26
2026-07-132026/07/1737.9739.5635.77
2026-07-202026/07/2436.0337.9635.53
2026-07-272026/07/3135.7538.5235.72
2026-08-032026/08/0736.8937.1335.39
2026-08-102026/08/1439.239.3536.4
2026-08-172026/08/2139.9740.137.68
2026-08-242026/08/2841.5541.6739.27
2026-08-312026/09/0438.2942.238.28
2026-09-072026/09/1135.8538.6535.61
2026-09-142026/09/1836.3237.2935.87
2026-09-212026/09/2533.6436.5333.6
2026-09-282026/10/0232.0134.0931.18
2026-10-052026/10/0932.2932.731.3
2026-10-122026/10/1633.1334.1531.68
2026-10-192026/10/2334.3935.2532.36
Rows × columns
53 × 5
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 price_trace, derived from the stored result.
ColumnTypeRangeNotes
week date 2025-10-20 to 2026-10-19
as_of text 53 distinct values (2025/10/24, 2025/10/31, 2025/11/07…)
close_usd number 32.01 to 48.34 US dollars
week_high_usd number 32.7 to 49.59 US dollars
week_low_usd number 31.18 to 47.27 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
    toString(toStartOfWeek(date, 1))            AS week,
    formatDateTime(max(date), '%Y/%m/%d')       AS as_of,
    round(toFloat64(argMax(close, date)), 2)    AS close_usd,
    round(toFloat64(max(high)), 2)              AS week_high_usd,
    round(toFloat64(min(low)), 2)               AS week_low_usd
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'GIS'
  AND date >= today() - 365
GROUP BY week
ORDER BY week
⌘/Ctrl + Enter

このデータをAIアシスタントで使う

このページのデータで、すぐにクエリできる状態で開きます。無料、アカウント不要。