STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

How to Store Market Data PCAPs: Split, Compress
Retention arithmetic for a 2 TB per day feed at three compression ratios (illustrative inputs)series · 2026-09-17 · 3×4Preview: a 3-point series, ending lower.
Retention arithmetic for a 2 TB per day feed at three compression ratios (illustrative inputs)

Retention arithmetic for a 2 TB per day feed at three compression ratios (illustrative inputs)

most recentas of series 3×4read in context →
Retention arithmetic for a 2 TB per day feed at three compression ratios (illustrative inputs) — 3 rows by 4 columns, computed from US exchange, SIP and OPRA data.
scenariogb_per_daytb_per_yeartb_two_years
ratio 3667166.7333.3
ratio 5400100200
ratio 825062.5125
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
Related queries
AAPL trade counts and distinct prices per quarter hour series 64×3 → Uncompressed footprint of five names as retention grows ranking 6×2 → Distinct prices per name, and how often each one repeats ranking 5×3 → One session of trade prints, five household names ranking 5×3 → See all 3,293 queries →
$