{"id":40240,"date":"2026-04-07T20:10:30","date_gmt":"2026-04-07T18:10:30","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/open-source-cannabis-price-index-methodology-sql-and-sample-data\/"},"modified":"2026-04-07T20:10:30","modified_gmt":"2026-04-07T18:10:30","slug":"open-source-cannabis-price-index-methodology-sql-and-sample-data","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/open-source-cannabis-price-index-methodology-sql-and-sample-data\/","title":{"rendered":"Open-source Cannabis Price Index \u2014 Methodology, SQL, And Sample Data"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>We&#8217;ve been running a weekly price index for the U.S. online cannabis market since December 2025. Today we&#8217;re open-sourcing the methodology, the SQL used to compute the index, and a sample dataset.<\/p>\n<p>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&#8217;s a straightforward avg-price-over-baseline calculation at the (category, subcategory) grain.<\/p>\n<p>Repo: <a href=\"https:\/\/github.com\/TheoV823\/cannabis-price-index\">https:\/\/github.com\/TheoV823\/cannabis-price-index<\/a><\/p>\n<p>Live index with full data: <a href=\"https:\/\/cannabisdealsus.com\/cannabis-price-index\/\">https:\/\/cannabisdealsus.com\/cannabis-price-index\/<\/a><\/p>\n<p>Happy to answer questions about the approach or limitations.<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/theov666\"> \/u\/theov666 <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1sf2u96\/opensource_cannabis_price_index_methodology_sql\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1sf2u96\/opensource_cannabis_price_index_methodology_sql\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-40240 jlk' href='javascript:void(0)' data-task='like' data-post_id='40240' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-40240 lc'>0<\/span><\/a><\/div><\/div> <div class='status-40240 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>We&#8217;ve been running a weekly price index for the U.S. online cannabis market since December 2025. Today&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-40240","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/40240","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=40240"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/40240\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=40240"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=40240"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=40240"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}