17 ms·
Show HN: Real-time 4/20 cannabis sales dashboard using Estuary and Tinybird
Built this dashboard to visualize cannabis sales in real time across North America during 4/20. The data updates live from thousands of dispensary POS transactions as the day unfolds.
Under the hood, we’re using Estuary for data streaming and Tinybird to power super fast analytical queries. The charts are made in Tremor and the map is D3.
- cactusplant7374 1y agoHow did you get access to the data?
- sv123 1y agoPoint of sale APIs.
- netsharc 1y agoHello OP, do you work for sales? So much bluster in your site but so little substance in this answer. Is there a law mandating realtime reporting, or something, or are there just limited number of POS providers and they all have realtime API(s)? I bet the dashboard doesn't have Johnny from my street corner's transaction...
- leehuffman 1y ago> Is there a law mandating realtime reporting, or something Not real time in WA, but all records are public and reported fairly consistently. See https://www.topshelfdata.com https://www.topshelfdata.com for an example of that. > or are there just limited number of POS providers and they all have realtime API(s)? This is Headset who is probably the largest retail POS provider (amongst other offerings on the producer/processor side and more) for legal marijuana sales. I'm assuming the data presented here is exclusively from their POS platform. I don't know of any public sources for real time sales data. > I bet the dashboard doesn't have Johnny from my street corner's transaction... Yes I'd also bet Johnny doesn't report his sales to a central database/platform.
- sv123 1y agoHeadset isn't a POS, we integrate with essentially all of the POS providers. At the bottom of the page there is a list with sales represented.
- leehuffman 1y agoMy mistake! I remember that now. Thanks for clarifying.
- sv123 1y agoNot sure what more substance you need, we integrate with close to 30 different POS providers, that's it. There is no law mandating realtime reporting. Every transaction from thousands of retailers is represented... What more do you want to know?
- 01HNNWZ0MV43FF 1y agoCan I buy everything from Johnny on the corner? He seems like a nice guy and not a snitch
- cactusplant7374 1y agoWhy would they give you access to that information?
- sv123 1y agoWe provide tools to manage their inventory, better sales reporting than what most POSs provide, marketing tools, etc.
- netsharc 1y agoThis is a better answer. "Point of sale APIs" is as clear as "we get the data in JSON format", i.e. not answering the question at all.
- verdverm 1y agoCool map, I'd speed it up a bit though FYI, the time displays are a bit off. The time box seems correct. The time slider is off. The animation goes beyond the last time. Up to you if the slider stops in the middle, or goes to 100% which becomes larger as the day progresses
- MisterTea 1y ago> I'd speed it up a bit though Clearly not partaking in 420 ;-)
- ivape 1y agoWalk-in sales indicate these stores are everywhere. It's kind of scary to be honest.
- sv123 1y agoWhat is the scary part?
- ivape 1y agoIt's high potency THC with things like live resin to get you even higher. It's marketed casually like alcohol. Teens and new adults casually getting into this stuff will have issues especially if they are predisposed to a variety of mental issues. The same is true for people who are depressed and use alcohol to "chill out", it's never ends well. We as a society don't have any clue when we roll out these "new features" on every corner. Same with anything, same with video games, same with social media. Your seven year old is addicted to tiktok, imagine that. Your 15 year old can't turn the fucking video games off. Your 25 year old can't put Instagram down. I'm not even talking about the whole class of drug addicts. Now imagine being addicted to all fucking 5 of those things? Then you get the 30 year old in therapy. I would personally limit the number of purchases like we do Pseudoephedrine, and if you need more, get a medical prescription. We'll probably realize this in about 20 years, like we are finally realizing about social media. Social media needs to be 18+, like porn sites. Took us 20 years, but many places are doing it. We never have a serious discussion about anything when we roll it out. Alcohol on every corner and supermarket was one of the stupidest things we ever did.
- Rodeoclash 1y agoI think of it as an equivalent to drinking alcohol. If someone is "waking and baking" every day then they have a substance abuse problem just as if they were waking up and driving half a bottle of scotch.
- MisterTea 1y ago> We don't have a clue as a society yet. Yes we do. Drugs are not new. We're tired of prohibition and the needless human suffering it has bought about. It has not and will never work. The answer is education and mental health services. Not treating the public like children.
- LightBug1 1y agoCool analysis ... but 420 has been made so cringe now ...
- deleted 1y ago[deleted]
- Babkock 1y agoCannabis?? Such a racy controversial topic... I don't know if I can talk about... Marry wanna... the debble's lettuce
- aaron695 1y ago[dead]
- dehugger 1y agoThe clock in your map covered the entirety of the section I actually wanted to see.