STRASMORE/EXPLORE 3,214 QUERIES

tehran_volume_clock

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-08, from us-daylight-saving-switch-tehran-time.

as of series 15×3read in context →
tehran_volume_clock — 15 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tehran_timenew_york_timeavg_volume_millions
12:0004:300.06
13:0005:300.06
14:0006:300.2
15:0007:300.29
16:0008:300.51
17:0009:309.06
18:0010:305.73
19:0011:305.91
20:0012:304.93
21:0013:305.58
22:0014:307.42
23:0015:3018.97
00:0016:300.76
01:0017:300.27
02:0018:300.13
Rows × columns
15 × 3
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 tehran_volume_clock, derived from the stored result.
ColumnTypeRangeNotes
tehran_time text 15 distinct values (00:00, 01:00, 02:00…)
new_york_time text 15 distinct values (04:30, 05:30, 06:30…)
avg_volume_millions number 0.06 to 18.97 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
    tehran_time,
    new_york_time,
    avg_volume_millions
FROM
(
    SELECT
        (toHour(toTimeZone(window_start, 'Asia/Tehran')) + 12) % 24            AS hours_from_noon,
        any(formatDateTime(toTimeZone(window_start, 'Asia/Tehran'), '%H:00'))  AS tehran_time,
        any(formatDateTime(toTimeZone(toStartOfHour(toTimeZone(window_start, 'Asia/Tehran')),
                                      'America/New_York'), '%H:%i'))           AS new_york_time,
        round(sum(volume)
              / countDistinct(toDate(toTimeZone(window_start, 'America/New_York')))
              / 1e6, 2)                                                        AS avg_volume_millions
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= toDateTime('2026-06-01 00:00:00', 'UTC')
      AND window_start <  toDateTime('2026-07-01 00:00:00', 'UTC')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 270
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 1170
    GROUP BY hours_from_noon
)
ORDER BY hours_from_noon
⌘/Ctrl + Enter

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

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

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