STRASMORE/EXPLORE 3,127 QUERIES

weekday_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 ranking 5×4read in context →
weekday_tape — 5 rows by 4 columns, computed from US exchange, SIP and OPRA data.
labelobserved_countavg_volume_millionsavg_range_pct
دوشنبه5261.90.89
سه‌شنبه5766.40.92
چهارشنبه57660.94
پنج‌شنبه5470.51.06
جمعه5473.91.01
Rows × columns
5 × 4
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 weekday_tape, derived from the stored result.
ColumnTypeRangeNotes
label text 5 distinct values (جمعه, دوشنبه, سه‌شنبه…)
observed_count number 52 to 57 count
avg_volume_millions number 61.9 to 73.9 count
avg_range_pct number 0.89 to 1.06 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
    transform(toDayOfWeek(d), [1, 2, 3, 4, 5],
              ['دوشنبه', 'سه‌شنبه', 'چهارشنبه', 'پنج‌شنبه', 'جمعه'], 'سایر') AS label,
    toUInt32(count())                                                       AS observed_count,
    round(avg(day_volume) / 1e6, 1)                                         AS avg_volume_millions,
    round(avg(range_pct), 2)                                                AS avg_range_pct
FROM
(
    SELECT
        date                                                                     AS d,
        max(volume)                                                              AS day_volume,
        100 * (toFloat64(max(high)) - toFloat64(min(low))) / toFloat64(min(low)) AS range_pct
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= today() - 400
      AND date <  today() - 2
      AND toDayOfWeek(date) <= 5
    GROUP BY date
)
GROUP BY label, toDayOfWeek(d)
ORDER BY toDayOfWeek(d)
⌘/Ctrl + Enter

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

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

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