Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
attention_candidates
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_narrative_members
intel_narratives
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 480063 in events
seq
Primary key.
INTEGER
id
evt_b134fb183ea8
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-22T09:09:56.920215+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-22T09:08:08.862046+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:c52e85b981c5e466","evidence_event_ids":["evt_3c8898b7f011"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/3-warren-buffett-stocks-hold-forever-0","as_of":"2026-04-22T09:08:08.862046+00:00","canonical_url":"https://www.fool.com/investing/2024/07/03/3-warren-buffett-stocks-to-hold-forever/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/3-warren-buffett-stocks-hold-forever-0","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5229273db2133a3a","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2024/07/03/3-warren-buffett-stocks-to-hold-forever/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T09:09:56.920166+00:00","extraction_method":"trafilatura","fetched_description":"Warren Buffett is widely considered one of the world's best investors. His success spans decades via his holding company, Berkshire Hathway, one of today's largest corporations. Inside Berkshire, Buffett and his team manage a massive stock portfolio worth over $385 billion.","fetched_title":"3 Warren Buffett Stocks to Hold Forever | Nasdaq","final_url":"https://www.nasdaq.com/articles/3-warren-buffett-stocks-hold-forever-0","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/3-warren-buffett-stocks-hold-forever-0","source_event_id":"evt_3c8898b7f011","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3020fc63ea09e0e4","kind":"unusual_volume","published_at":"2026-04-22T08:30:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["this past quarter","over the past decade","this decade","2019","April 15, 2005"],"entities":[{"asset_class":"equity","name":"Berkshire Hathaway","relevance":"high","symbol":"BRK.B","type":"company"},{"asset_class":"equity","name":"Apple","relevance":"high","symbol":"AAPL","type":"company"},{"asset_class":"equity","name":"American Express","relevance":"high","symbol":"AXP","type":"company"},{"asset_class":"equity","name":"Kroger","relevance":"high","symbol":"KR","type":"company"},{"asset_class":"other","name":"Federal Trade Commission","relevance":"medium","symbol":"","type":"regulator"}],"event_type":"other","information_gaps":["No unusual trading volume data is provided (baseline volume, volume ratio vs average, direction, or ticker-specific volume metrics are missing).","The signal type suggests a volume anomaly, but the article text provided does not mention volume spikes or confirmation by market/news data.","No explicit catalyst tied to unusual volume is stated; the only catalyst-like item mentioned is the FTC lawsuit regarding a Kroger\u2013Albertsons merger, but it is not linked to any volume change in the provided text."],"key_facts":["The article states Berkshire Hathaway manages a stock portfolio worth over $385 billion.","The article states Apple is 43.1% of Berkshire\u2019s portfolio and that Buffett trimmed shares \u201cthis past quarter.\u201d","The article states Apple is described as generating over $381 billion in annual sales and $101 billion in free cash flow.","The article states Apple has reduced its share count by 36% over the past decade.","The article states American Express is a payment network and also a bank providing financial services.","The article states American Express ranks first among U.S. card issuers in customer satisfaction (as stated in the article).","The article states American Express has bought back enough stock to retire over 30% of its shares this decade.","The article states U.S. credit card debt is at all-time highs (as stated in the article).","The article states Kroger is the largest-supermarket company in the U.S. and has a store footprint spanning over 2,700 stores.","The article states Kroger is battling an FTC lawsuit over a $24.6 billion merger with Albertsons.","The article states the article\u2019s thesis is that food and medicine are basic consumer staples and Kroger is recession-proof (as stated in the article).","The article states Kroger\u2019s dividend has been raised by nearly 300% over the past decade and it has repurchased over a quarter of its outstanding shares."],"numeric_claims":[{"label":"Berkshire portfolio value (stated)","value":"over $385 billion"},{"label":"Apple share of Berkshire portfolio (stated)","value":"43.1%"},{"label":"Apple annual sales (stated)","value":"over $381 billion"},{"label":"Apple free cash flow (stated)","value":"$101 billion"},{"label":"Apple share count reduction (stated)","value":"36% over the past decade"},{"label":"Active Apple devices (stated)","value":"over 2.2 billion"},{"label":"American Express share retirement via buybacks (stated)","value":"over 30% this decade"},{"label":"Kroger store count (stated)","value":"over 2,700 stores"},{"label":"FTC lawsuit merger value (stated)","value":"$24.6 billion"},{"label":"Potential Kroger locations if merger succeeds (stated)","value":"over 5,000 locations"},{"label":"Kroger dividend increase (stated)","value":"nearly 300% over the past decade"},{"label":"Kroger repurchases (stated)","value":"over a quarter of outstanding shares"}],"primary_claim":"The article claims Apple, American Express, and Kroger are Buffett-style stocks investors can hold long term, citing Berkshire\u2019s large stakes and cash-return/dividend/repurchase characteristics.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The article is a Motley Fool piece arguing that three Berkshire Hathaway-linked Buffett stocks\u2014Apple, American Express, and Kroger\u2014are long-term \u201chold forever\u201d candidates. It does not provide any unusual trading volume metrics or a volume-vs-average ratio for any ticker.","topics":["Buffett stocks","Berkshire Hathaway portfolio","long-term investing","dividends","share repurchases","Apple ecosystem","credit cards","Kroger-Albertsons merger lawsuit"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsBerkshire Hathaway will make $848 million in dividends this year from Coca-Cola stock alone.","tickers":[],"title":"3 Warren Buffett Stocks to Hold Forever","url":"https://www.fool.com/investing/2024/07/03/3-warren-buffett-stocks-to-hold-forever/"}}
TEXT NOT NULL
source_ref
candidate:sc_5229273db2133a3a
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:c52e85b981c5e466
TEXT
episode_id
NULL
TEXT
created_at
2026-04-22T09:09:56.920258+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel