thai_clock_volume

Name: thai_clock_volume
Creator: Strasmore
Published: 2026-10-09
License: https://www.strasmore.com/terms/

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 us-premarket-and-after-hours-thai-time.

as of 2026-10-09 ranking 19×4read in context →

thai_clock_volume — 19 rows by 4 columns, computed 2026-10-09 from US exchange, SIP and OPRA data.
ict_clock	et_clock	aapl_share_pct	etsy_share_pct
15:00	04:00	0.237	0.014
15:30	04:30	0.056	0.001
16:00	05:00	0.048	0.001
16:30	05:30	0.05	0.003
17:00	06:00	0.049	0.021
17:30	06:30	0.082	0.006
18:00	07:00	0.16	0.011
18:30	07:30	0.162	0.009
19:00	08:00	0.24	0.012
19:30	08:30	0.28	0.036
20:00	09:00	0.524	0.056
03:00	16:00	3.612	1.963
03:30	16:30	0.331	0.001
04:00	17:00	0.173	0.004
04:30	17:30	0.159	0.002
05:00	18:00	0.059	0.001
05:30	18:30	0.052	0
06:00	19:00	0.038	0
06:30	19:30	0.064	0.002

Rows × columns: 19 × 4
Computed: 2026-10-09
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 thai_clock_volume, derived from the stored result.
Column	Type	Range	Notes
`ict_clock`	text	19 distinct values (03:00, 03:30, 04:00…)
`et_clock`	text	19 distinct values (04:00, 04:30, 05:00…)
`aapl_share_pct`	number	0.038 to 3.612	percent
`etsy_share_pct`	number	0 to 1.963	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 2026-10-09, 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.

WITH bars AS
(
    SELECT
        ticker,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minute,
        formatDateTime(toStartOfInterval(toTimeZone(window_start, 'Asia/Bangkok'), INTERVAL 30 MINUTE), '%H:%i')      AS ict_clock,
        formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_bucket,
        toFloat64(volume)                                            AS vol
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'ETSY')
      AND window_start >= '2026-09-01 00:00:00'
      AND window_start <  '2026-10-01 00:00:00'
),
day_totals AS
(
    SELECT
        sumIf(vol, ticker = 'AAPL') AS aapl_day,
        sumIf(vol, ticker = 'ETSY') AS etsy_day
    FROM bars
    WHERE et_minute >= 240 AND et_minute < 1200
)
SELECT
    ict_clock,
    any(et_bucket)                                              AS et_clock,
    round(100 * sumIf(vol, ticker = 'AAPL') / any(aapl_day), 3) AS aapl_share_pct,
    round(100 * sumIf(vol, ticker = 'ETSY') / any(etsy_day), 3) AS etsy_share_pct
FROM bars
CROSS JOIN day_totals
WHERE (et_minute >= 240 AND et_minute < 570)
   OR (et_minute >= 960 AND et_minute < 1200)
GROUP BY ict_clock
ORDER BY min(et_minute)

SQL to run

WITH bars AS
(
    SELECT
        ticker,
        toHour(toTimeZone(window_start, 'America/New_York')) * 60
            + toMinute(toTimeZone(window_start, 'America/New_York')) AS et_minute,
        formatDateTime(toStartOfInterval(toTimeZone(window_start, 'Asia/Bangkok'), INTERVAL 30 MINUTE), '%H:%i')      AS ict_clock,
        formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_bucket,
        toFloat64(volume)                                            AS vol
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'ETSY')
      AND window_start >= '2026-09-01 00:00:00'
      AND window_start <  '2026-10-01 00:00:00'
),
day_totals AS
(
    SELECT
        sumIf(vol, ticker = 'AAPL') AS aapl_day,
        sumIf(vol, ticker = 'ETSY') AS etsy_day
    FROM bars
    WHERE et_minute >= 240 AND et_minute < 1200
)
SELECT
    ict_clock,
    any(et_bucket)                                              AS et_clock,
    round(100 * sumIf(vol, ticker = 'AAPL') / any(aapl_day), 3) AS aapl_share_pct,
    round(100 * sumIf(vol, ticker = 'ETSY') / any(etsy_day), 3) AS etsy_share_pct
FROM bars
CROSS JOIN day_totals
WHERE (et_minute >= 240 AND et_minute < 570)
   OR (et_minute >= 960 AND et_minute < 1200)
GROUP BY ict_clock
ORDER BY min(et_minute)

⌘/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