Cboe U.S. Equities Historical Market Volume Data 2019
- Rows
- 3,970
- Columns
- 14
- Data range
- 2019-01-02 to 2019-12-31
Daily historical market volume, notional value, and trade counts for U.S. equities exchanges and TRFs for 2019.
AI analysis
Dataset Analysis: Cboe U.S. Equities Historical Market Volume Data 2019
1. Dataset Overview & Correlation Value
This dataset, sourced from Cboe's official statistics portal (cdn.cboe.com/resources/us/equities/market-statistics/historical-market-volume/), captures daily U.S. equity market microstructure activity across 16 distinct market participants throughout the full 2019 trading year. The 252 distinct dates align precisely with the standard U.S. trading calendar, confirming clean temporal coverage with no missing sessions. The structure — segmented by Tape A (NYSE-listed), Tape B (regional exchange-listed), and Tape C (Nasdaq-listed) securities — provides a rare three-dimensional view of market fragmentation across share volume, notional dollar value, and trade count simultaneously. This layered granularity makes the dataset exceptionally valuable for studying competitive dynamics between exchanges, intraday liquidity patterns, and the relationship between trade count and notional value as proxies for algorithmic versus institutional activity.
2. Data Quality Observations
Data quality here is notably strong. Total null cells across all 14 columns register at zero, which is exceptional for a financial time-series dataset of this size and eliminates the need for imputation strategies in any downstream analysis. The duplicate row count is noted as pending Phase D recomputation, which warrants a verification pass before joining or aggregating — given that 3,970 rows across 252 trading days and 16 participants implies exactly ~15.75 rows per date on average, a fractional result suggesting either one participant appears on some dates but not others, or the 16th participant is intermittent. This asymmetry should be investigated. All numeric columns are appropriately typed (Integer vs. Decimal), with Tape A/B/C Notional correctly stored as Decimal to preserve dollar precision — a quality signal that the source pipeline handled financial figures responsibly. No columns show disproportionate nulls or type mismatches, though the minimum values of 0 across multiple share and notional columns (e.g., Tape A Shares min=0, Tape B Notional min=0) deserve scrutiny, as true zero-volume sessions for a market participant may indicate either legitimate non-participation or data suppression artifacts.
3. Key Column Distributions & Statistical Highlights
The volume and notional columns all exhibit pronounced right skew, with skewness values ranging from 1.98 (Total Shares) to 2.41 (Tape A Notional), which is characteristic of financial volume data dominated by a few large participants or high-volatility trading sessions. The divergence between mean and median is dramatic: Total Shares mean=446M vs. median=224M, and Total Notional mean=$20.4B vs. median=$9.6B, confirming that a small number of market participants or dates are pulling averages significantly upward. Outlier counts are substantial — 682 outliers in Tape A Notional and 564 in Tape A Shares — suggesting that NYSE-listed securities experience the most episodic volume spikes, consistent with the concentration of large-cap names on Tape A. Trade count distributions tell a different story: Tape A Trade Count skew=1.22 is notably lower than Tape C's skew=2.22, implying that Nasdaq-listed securities see more extreme clustering of high-frequency trade bursts. The Q1-to-Q3 spread for Total Trade Count (559K to 3.03M) represents a 5.4x interquartile range, reflecting enormous structural differences between smaller regional participants and dominant venues like Cboe BZX or Nasdaq.
4. Recommended Join Key Columns
The Date column is the primary join key, with 252 distinct values cleanly matching the 2019 U.S. trading calendar and carrying no nulls — it should serve as the anchor for any time-series merge. The Market Participant column (16 distinct string values) functions as a secondary join dimension, enabling participant-level cross-dataset linkage if external datasets encode venue names or MIC codes consistently. For aggregated market-level studies, joining on Date alone after grouping by Market Participant will produce clean daily totals. One caution: string-matching on Market Participant across datasets may require a venue name normalization mapping (e.g., mapping "CBOE BZX" to its ISO MIC code "BATS") to avoid join failures due to naming convention differences across publishers.
5. Recommended Pairing Datasets for Correlation Discovery
Several dataset categories would unlock high-value correlations with this data. VIX daily closing values (also published by Cboe) would directly test whether volume spikes and elevated trade counts correlate with volatility regimes — the heavy right skew in all volume metrics suggests volatility-driven outlier days are already embedded in this data. Federal Reserve or FRED economic releases calendar (e.g., FOMC meeting dates, CPI releases in 2019) could reveal whether macro announcement days drive the outlier observations in Tape A Notional. SEC Rule 605/606 execution quality reports broken down by venue would pair naturally on the Market Participant dimension to correlate market share with fill quality metrics. For competitive dynamics analysis, FINRA ATS transparency data (OTC/dark pool volume) would allow computation of lit-versus-dark market share ratios across the same 2019 period. Finally, S&P 500 or Russell 2000 daily returns mapped onto Tape A and Tape C respectively could test whether negative return days systematically produce higher trade counts (panic selling fragmentation) relative to positive days — a hypothesis directly testable given this dataset's trade count and notional granularity.
Columns
- Date (date)
- Market Participant (string)
- Tape A Shares (integer)
- Tape B Shares (integer)
- Tape C Shares (integer)
- Total Shares (integer)
- Tape A Notional (decimal)
- Tape B Notional (decimal)
- Tape C Notional (decimal)
- Total Notional (decimal)
- Tape A Trade Count (integer)
- Tape B Trade Count (integer)
- Tape C Trade Count (integer)
- Total Trade Count (integer)