STRASMORE/EXPLORE 2,170 QUERIES

Both funds rebased to 100 at the start of the window, month by month

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-08-10, from Contango and Roll Yield in Commodity ETFs.

as of series 60×4read in context →
Both funds rebased to 100 at the start of the window, month by month — 60 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthas_of_labeluso_indexusl_index
2021-01-01Jan 2021100100
2021-02-01Feb 2021117.42116.5
2021-03-01Mar 2021115.21115.24
2021-04-01Apr 2021123122.66
2021-05-01May 2021129.11128.99
2021-06-01Jun 2021141.79140.7
2021-07-01Jul 2021144142.96
2021-08-01Aug 2021136.55136.96
2021-09-01Sep 2021149.4148.84
2021-10-01Oct 2021162.45159.46
2021-11-01Nov 2021136.19136.4
2021-12-01Dec 2021154.52153.63
2022-01-01Jan 2022177.6174.15
2022-02-01Feb 2022191.81185.42
2022-03-01Mar 2022210.69204.4
2022-04-01Apr 2022219.33210.45
2022-05-01May 2022242.95231.46
2022-06-01Jun 2022228.4217.6
2022-07-01Jul 2022221.86213.15
2022-08-01Aug 2022207.82201.6
2022-09-01Sep 2022185.56178.66
2022-10-01Oct 2022203.33195.63
2022-11-01Nov 2022199.63196.09
2022-12-01Dec 2022199.29195.27
2023-01-01Jan 2023197.04193.45
2023-02-01Feb 2023191.05187.57
2023-03-01Mar 2023188.86185.53
2023-04-01Apr 2023191.87188.23
2023-05-01May 2023172.34170.78
2023-06-01Jun 2023180.64179.43
2023-07-01Jul 2023207.99204.95
2023-08-01Aug 2023213.36209.52
2023-09-01Sep 2023229.85220.55
2023-10-01Oct 2023213.25211.04
2023-11-01Nov 2023199.37201.16
2023-12-01Dec 2023189.45193.11
2024-01-01Jan 2024201.59202.53
2024-02-01Feb 2024208.53205.45
2024-03-01Mar 2024223.79219.25
2024-04-01Apr 2024222.8220
2024-05-01May 2024212.68213.6
2024-06-01Jun 2024226.24222.88
2024-07-01Jul 2024220.98217.56
2024-08-01Aug 2024211.31207.06
2024-09-01Sep 2024198.75197.63
2024-10-01Oct 2024207.73204.24
2024-11-01Nov 2024203.55201.27
2024-12-01Dec 2024214.75209.13
2025-01-01Jan 2025221.77211.44
2025-02-01Feb 2025213.81205.73
2025-03-01Mar 2025219.81210.15
2025-04-01Apr 2025180.67176.57
2025-05-01May 2025190.88182.25
2025-06-01Jun 2025207.82193.15
2025-07-01Jul 2025226.24207.51
2025-08-01Aug 2025212.73198.13
2025-09-01Sep 2025209.64195.82
2025-10-01Oct 2025206.25191.61
2025-11-01Nov 2025202.02188.14
2025-12-01Dec 2025196.59183.27
Rows × columns
60 × 4
Period covered
to
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 Both funds rebased to 100 at the start of the window, month by month, derived from the stored result.
ColumnTypeRangeNotes
month date 2021-01-01 to 2025-12-01
as_of_label text 60 distinct values (Apr 2021, Apr 2022, Apr 2023…)
uso_index number 100 to 242.95
usl_index number 100 to 231.46

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
WITH
    month_close AS
    (
        SELECT
            toStartOfMonth(date)           AS m,
            ticker,
            argMax(toFloat64(close), date) AS px
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('USO', 'USL')
          AND date >= '2021-01-01'
          AND date <  '2026-01-01'
        GROUP BY toStartOfMonth(date), ticker
    ),
    first_close AS
    (
        SELECT
            ticker,
            argMin(px, m) AS px0
        FROM month_close
        GROUP BY ticker
    )
SELECT
    toString(mc.m)                                           AS month,
    formatDateTime(mc.m, '%b %Y')                            AS as_of_label,
    round(anyIf(mc.px / fc.px0 * 100, mc.ticker = 'USO'), 2) AS uso_index,
    round(anyIf(mc.px / fc.px0 * 100, mc.ticker = 'USL'), 2) AS usl_index
FROM month_close AS mc
INNER JOIN first_close AS fc ON mc.ticker = fc.ticker
GROUP BY mc.m
ORDER BY mc.m

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 analysisContango and Roll Yield in Commodity ETFs
The financing leg: 3 month and 1 year Treasury yields by month series 91×4 Two listed crude oil funds, calendar year price change ranking 5×4 Growth of $100 in the 1x SOXX vs the 3x SOXL, Jan 2 to Jul 13 2026 series 131×3 SPY typical and largest daily move, month by month since 2019 series 91×4 Short term Treasury yields, the reference a stock margin loan is priced off series 91×4 Quoted spread through the session: large cap fund vs micro cap fund series 79×3 See all 2,170 queries →