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_4faae7aefaa3 in signals
id
sig_4faae7aefaa3
Primary key.
TEXT
event_id
26186
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/25-billion-reasons-apple-might-be-best-artificial-intelligence-ai-stock-buy-today","as_of":"2026-04-11T22:36:44.237167+00:00","canonical_url":"https://www.fool.com/investing/2026/04/11/25-billion-reasons-apple-might-be-the-best-ai-buy/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/25-billion-reasons-apple-might-be-best-artificial-intelligence-ai-stock-buy-today","article_chars":3868,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a36467ba15e1065e","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/11/25-billion-reasons-apple-might-be-the-best-ai-buy/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-11T23:25:52.214608+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsApple has 2.5 billion active devices, giving it exposure to a massive AI userbase.","fetched_title":"2.5 Billion Reasons Apple Might Be the Best Artificial Intelligence (AI) Stock to Buy Today | Nasdaq","final_url":"https://www.nasdaq.com/articles/25-billion-reasons-apple-might-be-best-artificial-intelligence-ai-stock-buy-today","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/25-billion-reasons-apple-might-be-best-artificial-intelligence-ai-stock-buy-today","source_event_id":"evt_3205317017d6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6c06b72781009073","kind":"unusual_volume","published_at":"2026-04-11T21:39:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Jan. 25","fiscal 2026 first quarter","April 11, 2026"],"entities":[{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"Alphabet","relevance":"high","symbol":"GOOG","type":"company"},{"asset_class":"equity","name":"Alphabet","relevance":"high","symbol":"GOOGL","type":"company"},{"asset_class":"person","name":"Tim Cook","relevance":"medium","symbol":"","type":"person"},{"asset_class":"software","name":"Siri","relevance":"medium","symbol":"","type":"product"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Amazon","relevance":"low","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Microsoft","relevance":"low","symbol":"MSFT","type":"company"},{"asset_class":"equity","name":"Meta Platforms","relevance":"low","symbol":"META","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"other","information_gaps":["No unusual volume ratio vs average is provided in the provided text (baseline volume, volume ratio, and direction are missing).","The signal type is discovery_unusual_volume_delta, but the article content does not mention trading volume or confirmation of any volume anomaly.","The Alphabet deal terms are described as 'reportedly' for the $1 billion figure; the article does not provide primary documentation in the provided text.","No explicit catalyst tied to a specific trading-day volume spike is stated; the article provides general strategic catalysts (Gemini deal, Siri update, iPhone sales growth).","No explicit confirmation that any unusual volume is news-driven versus unexplained is included in the provided text."],"key_facts":["CEO Tim Cook said Apple has 2.5 billion active devices (fiscal 2026 first quarter ended Jan. 25).","The article states Apple has a deal with Alphabet to use Gemini instead of developing its own LLM for Apple Intelligence foundation models.","The article says Apple is reportedly going to pay Alphabet $1 billion annually for use of the LLM.","The article states Apple is expected to launch an updated Siri in the coming months.","The article claims iPhone sales increased 23% year over year in the first quarter and total sales increased 16%.","The article notes the market was disappointed with Apple Intelligence advances last year and expected deeper AI entry compared with peers."],"numeric_claims":[{"label":"Active devices (Apple)","value":"2.5 billion"},{"label":"LLM payment to Alphabet (reported)","value":"$1 billion annually"},{"label":"iPhone sales growth (YoY)","value":"23%"},{"label":"Total sales growth (YoY)","value":"16%"}],"primary_claim":"Apple has 2.5 billion active devices and is using Alphabet\u2019s Gemini LLM for its Apple Intelligence foundation models, with iPhone sales up 23% year over year in the fiscal 2026 first quarter.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article argues Apple is well-positioned for AI exposure due to its large installed base and a reported deal to use Alphabet\u2019s Gemini for Apple Intelligence. It also cites strong iPhone sales growth as investor reassurance.","topics":["AI strategy","Apple Intelligence","Alphabet Gemini deal","installed user base","iPhone sales growth","Siri update","LLM development approach"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsApple has 2.5 billion active devices, giving it exposure to a massive AI userbase.","tickers":["AI"],"title":"2.5 Billion Reasons Apple Might Be the Best Artificial Intelligence (AI) Stock to Buy Today","url":"https://www.fool.com/investing/2026/04/11/25-billion-reasons-apple-might-be-the-best-ai-buy/"}
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_3205317017d6"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:b7214c31bb90a4d1
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-11T22:36:44.237167+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel