STRASMORE/EXPLORE 3,256 QUERIES

ist_taas_profile

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

as of ranking 7×3read in context →
ist_taas_profile — 7 rows by 3 columns, computed from US exchange, SIP and OPRA data.
ist_taaspurna_divas_mnardha_divas_mn
20:0013.58.9
21:007.78.4
22:0079.6
23:006.512.3
00:007.20
01:008.90
02:0012.20
Rows × columns
7 × 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 ist_taas_profile, derived from the stored result.
ColumnTypeRangeNotes
ist_taas text 7 distinct values (00:00, 01:00, 02:00…)
purna_divas_mn number 6.5 to 13.5
ardha_divas_mn number 0 to 12.3

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
    ist_taas,
    round(sumIf(vol, et_date = toDate('2025-11-26')) / 1e6, 1) AS purna_divas_mn,
    round(sumIf(vol, et_date = toDate('2025-11-28')) / 1e6, 1) AS ardha_divas_mn
FROM
(
    SELECT
        formatDateTime(toStartOfHour(toTimeZone(window_start, 'Asia/Kolkata')), '%H:%i') AS ist_taas,
        toDate(toTimeZone(window_start, 'America/New_York'))                             AS et_date,
        window_start                                                                     AS ts,
        toFloat64(volume)                                                                AS vol
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'SPY'
      AND window_start >= '2025-11-26 14:00:00'
      AND window_start <  '2025-11-29 00:00:00'
      AND toDate(toTimeZone(window_start, 'America/New_York')) IN (toDate('2025-11-26'), toDate('2025-11-28'))
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
)
GROUP BY ist_taas
ORDER BY min(ts)
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent