Open-source Cannabis Price Index — Methodology, SQL, And Sample Data

We’ve been running a weekly price index for the U.S. online cannabis market since December 2025. Today we’re open-sourcing the methodology, the SQL used to compute the index, and a sample dataset.

The index tracks average effective prices, discount rates, and discount depth across subcategories (Pre-Rolls, Cartridges, Gummies, etc.) relative to a fixed baseline week. It’s a straightforward avg-price-over-baseline calculation at the (category, subcategory) grain.

Repo: https://github.com/TheoV823/cannabis-price-index

Live index with full data: https://cannabisdealsus.com/cannabis-price-index/

Happy to answer questions about the approach or limitations.