Create
Query
event_store.db
—
signals
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 sig_3f95a73e99a1 in signals
id
sig_3f95a73e99a1
Primary key.
TEXT
event_id
105907
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/one-two-punch-launched-dutch-bros-revenues-higher-29","as_of":"2026-04-17T23:00:32.547123+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/this-one-two-punch-launched-dutch-bros-revenues-hi/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/one-two-punch-launched-dutch-bros-revenues-higher-29","article_chars":4154,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4069329785d08240","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/this-one-two-punch-launched-dutch-bros-revenues-hi/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T23:59:23.137919+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsDutch Bros opened new locations at a rapid clip in 2025.","fetched_title":"This One-Two Punch Launched Dutch Bros' Revenues Higher By 29% | Nasdaq","final_url":"https://www.nasdaq.com/articles/one-two-punch-launched-dutch-bros-revenues-higher-29","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/one-two-punch-launched-dutch-bros-revenues-higher-29","source_event_id":"evt_9bcd9b614c22","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7ab7784d1e898003","kind":"unusual_volume","published_at":"2026-04-17T21:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["2025","2026","December 17, 2004","April 15, 2005","April 17, 2026","Q4 2025"],"entities":[{"asset_class":"equity","name":"Dutch Bros","relevance":"high","symbol":"BROS","type":"company"},{"asset_class":"equity","name":"Starbucks","relevance":"medium","symbol":"SBUX","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"earnings","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided text does not include any trading volume ratio vs average, baseline volume, or confirmation that unusual volume occurred.","No explicit catalyst is tied to unusual volume; the article\u2019s stated catalysts are operational (new store openings and same-store sales growth).","The article does not specify whether the revenue/EPS figures are from a particular earnings report or filing within the provided excerpt."],"key_facts":["Dutch Bros opened 154 shops in 2025, increasing store count by 16%.","Dutch Bros grew same-store sales every quarter of 2025; same-store sales increased 5.6% for the year and 7.7% in Q4.","Transaction volume rose 3.2% (per the article), implying growth was not only from price increases.","The article states Dutch Bros grew revenue by 29% in 2025.","The article states earnings were $0.64 per share in 2025, up 88% year over year.","The article states the plan is for at least another 181 new shops in 2026."],"numeric_claims":[{"label":"Revenue growth (2025)","value":"29%"},{"label":"New shops opened (2025)","value":"154"},{"label":"Store count increase (2025)","value":"16%"},{"label":"Same-store sales increase (2025, full year)","value":"5.6%"},{"label":"Same-store sales increase (Q4 2025)","value":"7.7%"},{"label":"Transaction volume increase","value":"3.2%"},{"label":"EPS (2025)","value":"$0.64"},{"label":"EPS growth (YoY, 2025)","value":"88%"},{"label":"Planned new shops (2026, minimum)","value":"181"}],"primary_claim":"Dutch Bros grew its 2025 revenue by 29% driven by opening 154 new shops in 2025 and increasing same-store sales by 5.6% for the year (7.7% in Q4).","relevance_score":0.55,"sentiment":"positive","source_quality":"high","summary":"The article claims Dutch Bros (BROS) grew revenues 29% in 2025, attributing growth to rapid new store openings and rising same-store sales. It does not provide any explicit unusual trading volume ratio versus average in the text.","topics":["same-store sales","store openings","revenue growth","transaction volume","earnings per share","growth strategy"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsDutch Bros opened new locations at a rapid clip in 2025.","tickers":[],"title":"This One-Two Punch Launched Dutch Bros' Revenues Higher By 29%","url":"https://www.fool.com/investing/2026/04/17/this-one-two-punch-launched-dutch-bros-revenues-hi/"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_9bcd9b614c22"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:f1d1b0db564275a6
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-17T23:00:32.547123+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel