STRASMORE/EXPLORE 2,401 QUERIES

fez_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-09-19, from euro-stoxx-50-daily-options.

as of series 32×3read in context →
fez_clock — 32 rows by 3 columns, computed from US exchange, SIP and OPRA data.
et_timeshare_pctmarker
04:000.01
04:300
05:000
05:300
06:000
06:300
07:000.01
07:300.01
08:000.03
08:300
09:000.02
09:3012.41
10:007.26
10:305.62
11:005.7
11:308.4Eurex close (17:30 CET)
12:003.74
12:304.76
13:003.4
13:302.94
14:004.6
14:305.79
15:005.89
15:3027.51
16:001.87
16:300
17:000
17:300.01
18:000
18:300
19:000
19:300
Rows × columns
32 × 3
Computed
Completeness
Some fields are partly empty — see the columns below
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 fez_clock, derived from the stored result.
ColumnTypeRangeNotes
et_time text 32 distinct values (04:00, 04:30, 05:00…)
share_pct number 0 to 27.51 percent
marker text 1 distinct value (Eurex close (17:30 CET)) 1 of 32 rows populated

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.

the exact SQL behind every number 
SELECT
    cal.et_time                                                    AS et_time,
    round(100 * coalesce(toFloat64(t.shares), 0)
              / toFloat64((SELECT sum(volume)
                           FROM global_markets.delayed_stocks_minute_aggs
                           WHERE ticker = 'FEZ'
                             AND window_start >= today() - 60
                             AND window_start <  today() - 2)), 2)   AS share_pct,
    if(cal.et_time = '11:30', 'Eurex close (17:30 CET)', '')       AS marker
FROM
(
    SELECT formatDateTime(toDateTime('2000-01-03 04:00:00', 'UTC') + 1800 * arrayJoin(range(32)), '%H:%i', 'UTC') AS et_time
) AS cal
LEFT JOIN
(
    SELECT
        formatDateTime(toStartOfInterval(toTimeZone(window_start, 'America/New_York'), INTERVAL 30 MINUTE), '%H:%i') AS et_time,
        sum(volume)                                                                                                 AS shares
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'FEZ'
      AND window_start >= today() - 60
      AND window_start <  today() - 2
    GROUP BY et_time
) AS t ON t.et_time = cal.et_time
ORDER BY et_time

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysiseuro-stoxx-50-daily-options
front_ladder series 10×4 → dte_share ranking 5×2 → spread_monthly series 604×5 → One SPY $600 LEAPS call's price over two years (expired Jan 16 2026) series 470×2 → 3m10y and 2s10s spreads, monthly averages over twenty years series 241×4 → 2s10s spread, monthly average: last 20 years series 240×2 → See all 2,401 queries →