Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_memory
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 102850 in events
seq
Primary key.
INTEGER
id
evt_dea6a37645d1
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-17T23:32:49.635269+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-17T18:53:17.406169+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:207e97fb814bd628","evidence_event_ids":["evt_0c72ef1cb831"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/where-will-green-thumb-industries-stock-be-5-years","as_of":"2026-04-17T18:53:17.406169+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/where-will-green-thumb-industries-stock-be-in-5-ye/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/where-will-green-thumb-industries-stock-be-5-years","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2b1496d29d655d6e","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/where-will-green-thumb-industries-stock-be-in-5-ye/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T23:32:49.635236+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsGreen Thumb Industries could benefit from recent regulatory changes in the legal cannabis market.","fetched_title":"Where Will Green Thumb Industries Stock Be in 5 Years? | Nasdaq","final_url":"https://www.nasdaq.com/articles/where-will-green-thumb-industries-stock-be-5-years","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/where-will-green-thumb-industries-stock-be-5-years","source_event_id":"evt_0c72ef1cb831","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"cc4d777f98742f04","kind":"unusual_volume","published_at":"2026-04-17T17:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["last year","over the past five years","since 2021","early next decade","next five years"],"entities":[{"asset_class":"equity","name":"Green Thumb Industries","relevance":"high","symbol":"GTBIF","type":"company"},{"asset_class":"other","name":"President Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"regulation","information_gaps":["This signal type is 'discovery_unusual_volume_delta', but the provided text contains no volume ratio, baseline volume, or confirmation of unusual trading volume.","No explicit catalyst is tied to unusual volume; the article\u2019s catalysts are regulatory changes (Schedule 3 reclassification) and potential federal legalization, but the relationship to volume is not stated.","The article does not provide specific quantitative guidance for margins/profits beyond qualitative expectations."],"key_facts":["Green Thumb Industries is described as a leading multistate operator (MSO) with 113 stores across 14 U.S. states.","The article states that last year President Trump signed an executive order that led to marijuana being reclassified to Schedule 3.","The article claims Schedule 3 reclassification would make banking services easier for Green Thumb Industries to access.","The article claims Schedule 3 reclassification would allow the company to deduct normal business expenses.","The article suggests the next five years should bring stronger operating margins and profits as a result of these changes (with mixed impact overall).","The article discusses a possibility of federal legalization by early next decade, which it says could enable interstate commerce and access to more traditional financial services.","The article warns federal legalization could be a double-edged sword by reducing the company\u2019s competitive edge in limited-license states and by attracting larger adjacent competitors.","The article states Green Thumb Industries has generated profits and that its medium-term outlook is highly uncertain due to the sector\u2019s complex regulatory landscape."],"numeric_claims":[{"label":"stores","value":"113"},{"label":"states","value":"14"},{"label":"market value decline (past 5 years)","value":"over 70%"},{"label":"estimated cannabis market potential","value":"$100 billion"}],"primary_claim":"Green Thumb Industries is expected to benefit over the next five years from recent regulatory changes, including marijuana\u2019s reclassification to Schedule 3, which the article says will make banking easier and allow normal business expense deductions.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The article argues Green Thumb Industries (GTBIF) could benefit over the next five years from recent U.S. regulatory changes that reclassified marijuana to a Schedule 3, improving access to banking and tax treatment. It also notes potential upside from possible federal legalization but highlights that outcomes are mixed and regulatory uncertainty remains high.","topics":["legal cannabis","U.S. marijuana scheduling","banking access","tax treatment","federal legalization","multistate operators (MSOs)","regulatory uncertainty","stock outlook"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsGreen Thumb Industries could benefit from recent regulatory changes in the legal cannabis market.","tickers":[],"title":"Where Will Green Thumb Industries Stock Be in 5 Years?","url":"https://www.fool.com/investing/2026/04/17/where-will-green-thumb-industries-stock-be-in-5-ye/"}}
TEXT NOT NULL
source_ref
candidate:sc_2b1496d29d655d6e
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:207e97fb814bd628
TEXT
episode_id
NULL
TEXT
created_at
2026-04-17T23:32:49.635339+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel