STRASMORE/EXPLORE 2,170 QUERIES

A monthly buyer's lot prices and running average cost: VTI, July 2021 to December 2022

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-01, from Selling Mutual Funds at a Loss: How Basis Works.

as of series 18×4read in context →
A monthly buyer's lot prices and running average cost: VTI, July 2021 to December 2022 — 18 rows by 4 columns, computed from US exchange, SIP and OPRA data.
monthmonth_labellot_price_usdaverage_cost_usd
2021-07July 2021226.72226.72
2021-08August 2021233.17229.94
2021-09September 2021222.03227.31
2021-10October 2021236.92229.71
2021-11November 2021233.47230.46
2021-12December 2021241.48232.3
2022-01January 2022226.82231.52
2022-02February 2022221.16230.22
2022-03March 2022227.76229.95
2022-04April 2022207.14227.67
2022-05May 2022206.57225.75
2022-06June 2022188.74222.66
2022-07July 2022206.28221.4
2022-08August 2022198.56219.77
2022-09September 2022179.37217.08
2022-10October 2022194215.64
2022-11November 2022204.07214.96
2022-12December 2022191.25213.64
Rows × columns
18 × 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 A monthly buyer's lot prices and running average cost: VTI, July 2021 to December 2022, derived from the stored result.
ColumnTypeRangeNotes
month date 2021-07 to 2022-12
month_label text 18 distinct values (April 2022, August 2021, August 2022…)
lot_price_usd number 179.37 to 241.48 US dollars
average_cost_usd number 213.64 to 232.3 US dollars

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 monthly AS (
    SELECT toStartOfMonth(toDate(toTimeZone(window_start, 'America/New_York'))) AS month_start,
           argMax(close, window_start) AS close_price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'VTI'
      AND toDate(toTimeZone(window_start, 'America/New_York')) >= toDate('2021-07-01')
      AND toDate(toTimeZone(window_start, 'America/New_York')) <= toDate('2022-12-31')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY month_start
)
SELECT formatDateTime(month_start, '%Y-%m') AS month,
       formatDateTimeInJodaSyntax(month_start, 'MMMM yyyy') AS month_label,
       round(close_price, 2) AS lot_price_usd,
       round(avg(close_price) OVER (ORDER BY month_start
             ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW), 2) AS average_cost_usd
FROM monthly
ORDER BY month_start

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 analysisSelling Mutual Funds at a Loss: How Basis Works
The same monthly lots ranked by per share result at the December 2022 price ranking 18×3 → Distribution cadence: index and income funds, twelve months to June 30, 2026 ranking 9×4 → Daily tracking difference against SPY: broad US equity funds, first half of 2026 ranking 4×3 → One full 61 day wash sale window on the tape: AAPL, Dec 1 2025 through Jan 30 2026 series 42×3 → How many trading sessions fit inside a 61 day wash sale window series 30×4 → Every December session and how far its wash sale window reaches into the new year series 22×4 → See all 2,170 queries →