trace_may

Name: trace_may
Creator: Strasmore
Published: 2026-09-20
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-09-20, from how-inverse-etfs-work.

as of 2026-09-20 series 21×5read in context →

trace_may — 21 rows by 5 columns, computed 2026-09-20 from US exchange, SIP and OPRA data.
session_date	day_label	soxx_indexed	soxs_indexed	naive_minus3x_indexed
2025-05-01	5月1日	100	100	100
2025-05-02	5月2日	103.5	89.9	89.5
2025-05-05	5月5日	102.7	91.7	91.9
2025-05-06	5月6日	101.7	94.7	94.8
2025-05-07	5月7日	103.5	89.9	89.5
2025-05-08	5月8日	104.4	87.1	86.7
2025-05-09	5月9日	105.6	84.4	83.1
2025-05-12	5月12日	113.2	66.2	60.3
2025-05-13	5月13日	116.4	60.6	50.7
2025-05-14	5月14日	117	59.8	49
2025-05-15	5月15日	116.2	60.9	51.3
2025-05-16	5月16日	116.1	61.2	51.7
2025-05-19	5月19日	115.4	62.4	53.8
2025-05-20	5月20日	115.2	62.7	54.3
2025-05-21	5月21日	113.1	66.2	60.7
2025-05-22	5月22日	112.1	68	63.8
2025-05-23	5月23日	110.3	71.2	69
2025-05-27	5月27日	114	64.1	58
2025-05-28	5月28日	113.4	65.1	59.7
2025-05-29	5月29日	113.9	64.4	58.3
2025-05-30	5月30日	111.6	68.4	65.1

Rows × columns: 21 × 5
Period covered: 2025-05-01 to 2025-05-30
Computed: 2026-09-20
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 trace_may, derived from the stored result.
Column	Type	Range
`session_date`	date	2025-05-01 to 2025-05-30
`day_label`	text	21 distinct values (5月12日, 5月13日, 5月14日…)
`soxx_indexed`	number	100 to 117
`soxs_indexed`	number	59.8 to 100
`naive_minus3x_indexed`	number	49 to 100

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-09-20, 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
    (
        SELECT toFloat64(argMin(close, date))
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SOXX' AND date >= '2025-05-01' AND date < '2025-06-01'
    ) AS soxx_base,
    (
        SELECT toFloat64(argMin(close, date))
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SOXS' AND date >= '2025-05-01' AND date < '2025-06-01'
    ) AS soxs_base
SELECT
    toString(date)                                                                        AS session_date,
    concat(toString(toMonth(date)), '月', toString(toDayOfMonth(date)), '日')             AS day_label,
    round(toFloat64(anyIf(close, ticker = 'SOXX')) / soxx_base * 100, 1)                  AS soxx_indexed,
    round(toFloat64(anyIf(close, ticker = 'SOXS')) / soxs_base * 100, 1)                  AS soxs_indexed,
    round((1 - 3 * (toFloat64(anyIf(close, ticker = 'SOXX')) / soxx_base - 1)) * 100, 1)  AS naive_minus3x_indexed
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('SOXX', 'SOXS')
  AND date >= '2025-05-01'
  AND date <  '2025-06-01'
GROUP BY date
ORDER BY date

SQL to run

WITH
    (
        SELECT toFloat64(argMin(close, date))
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SOXX' AND date >= '2025-05-01' AND date < '2025-06-01'
    ) AS soxx_base,
    (
        SELECT toFloat64(argMin(close, date))
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'SOXS' AND date >= '2025-05-01' AND date < '2025-06-01'
    ) AS soxs_base
SELECT
    toString(date)                                                                        AS session_date,
    concat(toString(toMonth(date)), '月', toString(toDayOfMonth(date)), '日')             AS day_label,
    round(toFloat64(anyIf(close, ticker = 'SOXX')) / soxx_base * 100, 1)                  AS soxx_indexed,
    round(toFloat64(anyIf(close, ticker = 'SOXS')) / soxs_base * 100, 1)                  AS soxs_indexed,
    round((1 - 3 * (toFloat64(anyIf(close, ticker = 'SOXX')) / soxx_base - 1)) * 100, 1)  AS naive_minus3x_indexed
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('SOXX', 'SOXS')
  AND date >= '2025-05-01'
  AND date <  '2025-06-01'
GROUP BY date
ORDER BY date

⌘/Ctrl + Enter