Create
Query
event_store.db
—
signals
actions
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
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_8acd48059ebe in signals
id
sig_8acd48059ebe
Primary key.
TEXT
event_id
34253
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_options_flow_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/bull-day-broadcom-avgo-0","as_of":"2026-04-13T11:55:13.805835+00:00","canonical_url":"https://www.nasdaq.com/articles/bull-day-broadcom-avgo-0","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bull-day-broadcom-avgo-0","article_chars":4452,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e67d90595c2aa17b","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bull-day-broadcom-avgo-0","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-13T12:24:38.694241+00:00","extraction_method":"trafilatura","fetched_description":"This top semiconductor and AI leader is seeing strong earnings growth, rising estimates, and a potential breakout ahead.","fetched_title":"Bull of the Day: Broadcom (AVGO) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bull-day-broadcom-avgo-0","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bull-day-broadcom-avgo-0","source_event_id":"evt_7d5f5ca7fa4e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ab14b604c4ae6ded","kind":"options_flow","published_at":"2026-04-13T09:00:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["early March","late last year","2023","2024"],"entities":[{"asset_class":"equity","name":"Broadcom Inc.","relevance":"high","symbol":"AVGO","type":"company"},{"asset_class":"unknown","name":"Nasdaq, Inc.","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Options-flow details required by signal type are missing from the provided text: no call/put direction, no expiry dates/tenors, no flow size, no open-interest context, and no indication of whether positioning is informed.","The signal type is labeled discovery_options_flow_delta, but the article content provided is a fundamental/technical overview rather than an options-flow report.","No specific options contracts (strike, expiration, volume, OI) are mentioned."],"key_facts":["Broadcom is described as a Zacks Rank #1 (Strong Buy) and has a Zacks Style Score of \u201cB\u201d in Growth and Momentum.","The article states Broadcom reported earnings in early March with a 6% EPS beat.","AI revenue is stated to have surged 77% YoY to $4.1B, and infrastructure software grew 47% to $6.7B.","Gross margins are stated as 68%, and adjusted EBITDA is stated as $10.1B.","Broadcom guided Q2 revenue to $14.9B, above consensus, and projected AI revenue to $4.4B.","The article says analyst estimates have increased across time frames: current quarter $1.48 to $1.56 (5%), current year $6.31 to $6.56 (4%), next year $7.45 to $7.74 (4%).","A Morgan Stanley upgrade is mentioned as maintaining Overweight with a price target hike to $260 from $246.","Technically, the stock is described as trading sideways after hitting fresh highs late last year and consolidating after a 23% pullback from all-time highs.","The article states the 200-day moving average is at $183 and provides nearby levels including 21-day $194, 50-day $213, Fibonacci resistance $215, and a target area $210\u2013$215."],"numeric_claims":[{"label":"EPS beat","value":"6%"},{"label":"AI revenue (Q reported)","value":"$4.1B"},{"label":"AI revenue growth YoY","value":"77%"},{"label":"Infrastructure software revenue","value":"$6.7B"},{"label":"Infrastructure software growth YoY","value":"47%"},{"label":"Gross margin","value":"68%"},{"label":"Adjusted EBITDA","value":"$10.1B"},{"label":"Q2 revenue guidance","value":"$14.9B"},{"label":"AI revenue projected (Q2)","value":"$4.4B"},{"label":"Current quarter estimate","value":"$1.48 to $1.56 (5%)"},{"label":"Current year estimate","value":"$6.31 to $6.56 (4%)"},{"label":"Next year estimate","value":"$7.45 to $7.74 (4%)"},{"label":"Morgan Stanley price target","value":"$260 (from $246)"},{"label":"200-day moving average","value":"$183"},{"label":"Fibonacci resistance","value":"$215"},{"label":"23% pullback","value":"23%"}],"primary_claim":"Broadcom (AVGO) reported strong earnings momentum driven by AI, with analyst estimates rising and the stock consolidating after prior gains.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article is a bullish overview of Broadcom (AVGO), citing strong AI-related earnings, rising analyst estimates, and technical support after a sideways/consolidation period. It does not provide any specific options-flow metrics (calls/puts, expiry, or size vs open interest).","topics":["AI infrastructure","earnings beat","analyst estimate revisions","options flow (not provided)","technical analysis","semiconductors","infrastructure software"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"Reflecting a key player in the AI infrastructure buildout, Broadcom shares have been red-hot as of late, with a favorable demand picture keeping expectations bright.","tickers":["AVGO"],"title":"Bull of the Day: Broadcom (AVGO)","url":"https://www.nasdaq.com/articles/bull-day-broadcom-avgo-0"}
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_7d5f5ca7fa4e"]}
TEXT
dedupe_key
signal_enriched:discovery_options_flow_delta:873712f0880e6a2d
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-13T11:55:13.805835+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel