STRASMORE/EXPLORE 3,127 QUERIES

nowruz_tape

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-06, from does-the-us-market-close-for-iranian-holidays.

as of series 9×4read in context →
nowruz_tape — 9 rows by 4 columns, computed from US exchange, SIP and OPRA data.
session_dateus_weekdayspy_closedaily_range_pct
2026-03-23دوشنبه655.381.33
2026-03-24سه‌شنبه653.181.1
2026-03-25چهارشنبه656.821.02
2026-03-26پنج‌شنبه645.091.56
2026-03-27جمعه634.091.51
2026-03-30دوشنبه631.971.76
2026-03-31سه‌شنبه650.342.13
2026-04-01چهارشنبه655.240.85
2026-04-02پنج‌شنبه655.832.03
Rows × columns
9 × 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 nowruz_tape, derived from the stored result.
ColumnTypeRangeNotes
session_date date 2026-03-23 to 2026-04-02
us_weekday text 5 distinct values (جمعه, دوشنبه, سه‌شنبه…)
spy_close number 631.97 to 656.82 US dollars
daily_range_pct number 0.85 to 2.13 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
    toString(date) AS session_date,
    transform(toDayOfWeek(date), [1, 2, 3, 4, 5, 6, 7],
              ['دوشنبه', 'سه‌شنبه', 'چهارشنبه', 'پنج‌شنبه', 'جمعه', 'شنبه', 'یک‌شنبه'], '') AS us_weekday,
    round(toFloat64(max(close)), 2) AS spy_close,
    round(100 * (toFloat64(max(high)) - toFloat64(min(low))) / toFloat64(min(low)), 2) AS daily_range_pct
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'SPY'
  AND date >= toDate('2026-03-21')
  AND date <= toDate('2026-04-02')
GROUP BY date
ORDER BY date
⌘/Ctrl + Enter

با این داده‌ها در دستیار هوش مصنوعی خود کار کنید

آماده‌ی پرس‌وجو باز می‌شود، با داده‌های همین صفحه. رایگان، بدون حساب.

Claude ChatGPT Gemini Muse عامل خودتان