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_23f66b4b9bf9 in signals
id
sig_23f66b4b9bf9
Primary key.
TEXT
event_id
10494
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/prediction-ai-stock-will-join-sp-500-year-end","as_of":"2026-04-09T04:42:09.468703+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/prediction-this-ai-stock-will-join-the-sp-500-befo/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/prediction-ai-stock-will-join-sp-500-year-end","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_12fd1bbf388a24e5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/prediction-this-ai-stock-will-join-the-sp-500-befo/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:49:01.908612+00:00","extraction_method":"heuristic","fetched_description":"Key PointsUnsurprisingly, the advent of artificial intelligence is the chief reason this company has grown to become the industry-leading name it is today.","fetched_title":"Prediction: This AI Stock Will Join the S&P 500 Before Year-End | Nasdaq","final_url":"https://www.nasdaq.com/articles/prediction-ai-stock-will-join-sp-500-year-end","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/prediction-ai-stock-will-join-sp-500-year-end","source_event_id":"evt_0db7070091ab","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f6f604bc40a357ce","kind":"unusual_volume","published_at":"2026-04-09T04:20:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 09, 2026"],"entities":[{"asset_class":"equity","name":"Symbotic","relevance":"high","symbol":"SYM","type":"company"},{"asset_class":"other","name":"Standard & Poor's (S&P) selection committee","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"index","name":"S&P 500","relevance":"high","symbol":"^GSPC","type":"index"}],"event_type":"listing","information_gaps":["No unusual trading volume ratio vs average is provided in the text (baseline volume, volume ratio, and direction are all missing).","No explicit confirmation is given that any volume spike is related to S&P 500 speculation; the article is a prediction rather than a news-confirmed event.","The article does not cite a specific S&P decision, filing, or announcement date\u2014only a speculative \u201ccould be before the end of the year\u201d framing."],"key_facts":["The article states Symbotic (NASDAQ: SYM) is not yet part of the S&P 500 but \u201cvery well could be before the end of the year.\u201d","The article claims Symbotic sold and serviced $2.2 billion worth of robotics last year, up 25% year over year.","The article states Symbotic is \u201cstill technically operating in the red,\u201d but suggests it could reach profitability within the timeframe discussed.","The article cites an S&P 500 minimum market cap for being an S&P 500 stock of $22.7 billion.","The article claims Symbotic\u2019s market capitalization has been consistently greater than $22.7 billion since the middle of last year.","The article states S&P 500 inclusion \u201cdramatically increases a stock's institutional ownership,\u201d which it describes as bullish."],"numeric_claims":[{"label":"Robotics sales/service (last year)","value":"$2.2 billion"},{"label":"Robotics sales/service growth (YoY)","value":"25%"},{"label":"S&P 500 minimum market cap","value":"$22.7 billion"},{"label":"Symbotic market cap (current, per article)","value":"more than $30 billion"},{"label":"AI robotics industry growth (avg annual pace)","value":"nearly 21% through 2034"},{"label":"AI robotics industry value (per year, per article)","value":"nearly $50 billion per year"}],"primary_claim":"Symbotic (SYM) is a candidate to be added to the S&P 500 before the end of the year based on its growth and market-cap size relative to S&P 500 minimums.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article argues that Symbotic (NASDAQ: SYM) could be added to the S&P 500 before year-end, citing its AI robotics growth and meeting S&P 500 minimum market-cap criteria. The signal does not provide any unusual trading volume metrics, so the \u201cunusual volume delta\u201d aspect is not confirmed in the text.","topics":["S&P 500 inclusion","AI robotics","Symbotic growth","market capitalization threshold","institutional ownership"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsUnsurprisingly, the advent of artificial intelligence is the chief reason this company has grown to become the industry-leading name it is today.","tickers":[],"title":"Prediction: This AI Stock Will Join the S&P 500 Before Year-End","url":"https://www.fool.com/investing/2026/04/09/prediction-this-ai-stock-will-join-the-sp-500-befo/"}
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_0db7070091ab"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:076644a6c2fe627d
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-09T04:42:09.468703+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel