Dynamics of the Second-Hand Bicycle Market: In this information visualization project, Peter Woolery tackles a major blind spot within the cycling industry: the historical unavailability of reliable second-hand bicycle data. Because liquidity in the secondary market heavily influences new-bike pricing, accessibility, and sustainability, stakeholders desperately need standardized industry insights.

To bridge this critical gap, Woolery aggregated and analyzed a proprietary dataset containing 2.6 million U.S. used-bike listings spanning 34 months of continuous coverage. Utilizing tools like MariaDB, Python, Pandas, and Plotly, the project presents five comprehensive visual arguments.

Key Findings:

• Geographic Concentration: Listing supply is jointly driven by climate and population, clustering heavily along the coasts and the Sunbelt.
• Softening Valuations: Mean asking prices across the top-five bicycle categories have steadily drifted downward since mid-2024.
• Market Scale: The secondary market is highly structural, with unique used listings equating to roughly 15–20% of annual new-bike sales volume.

Peter Woolery is a data analyst by trade, returning to SJSU to reinforce the fundamentals that are skipped when diving right into startup mode. Living in San Jose, CA, Peter started Bicycle Market Research LLC to develop software tools to gather first-party research on the bicycle industry. SJSU’s online courses have made it possible to work, study and raise two young children at the same time.