retention_arithmetic

Name: retention_arithmetic
Creator: Strasmore
Published: 2026-09-17
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-17, from how-to-store-market-data-pcaps.

as of 2026-09-17 series 3×4read in context →

retention_arithmetic — 3 rows by 4 columns, computed 2026-09-17 from US exchange, SIP and OPRA data.
scenario	gb_per_day	tb_per_year	tb_two_years
ratio 3	667	166.7	333.3
ratio 5	400	100	200
ratio 8	250	62.5	125

Rows × columns: 3 × 4
Computed: 2026-09-17
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 retention_arithmetic, derived from the stored result.
Column	Type	Range
`scenario`	text	3 distinct values (ratio 3, ratio 5, ratio 8)
`gb_per_day`	number	250 to 667
`tb_per_year`	number	62.5 to 166.7
`tb_two_years`	number	125 to 333.3

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-17, and the query below is what returned them.

the exact SQL behind every number

SELECT
    concat('ratio ', toString(ratio)) AS scenario,
    round(raw_tb_per_day * 1000 / ratio) AS gb_per_day,
    round(raw_tb_per_day * sessions / ratio, 1) AS tb_per_year,
    round(raw_tb_per_day * sessions * 2 / ratio, 1) AS tb_two_years
FROM
(
    SELECT
        2 AS raw_tb_per_day,
        250 AS sessions,
        arrayJoin([3, 5, 8]) AS ratio
)
ORDER BY ratio

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.