Create
Query
event_store.db
—
events
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 237682 in events
seq
Primary key.
INTEGER
id
evt_29264882a62a
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-18T21:44:04.622996+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-18T20:18:18.677149+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:a26f093625640d2c","evidence_event_ids":["evt_2e02b15ab5f4"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/2-reasons-rivian-once-decade-stock-pick-long-term-investors","as_of":"2026-04-18T20:18:18.677149+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/2-reasons-rivian-is-a-once-in-a-decade-stock-pick/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/2-reasons-rivian-once-decade-stock-pick-long-term-investors","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1a324f810f5df3f6","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/2-reasons-rivian-is-a-once-in-a-decade-stock-pick/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T21:44:04.622972+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsRivian is about to reach two massive growth catalysts.","fetched_title":"2 Reasons Rivian Is a Once-in-a-Decade Stock Pick for Long-Term Investors | Nasdaq","final_url":"https://www.nasdaq.com/articles/2-reasons-rivian-once-decade-stock-pick-long-term-investors","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/2-reasons-rivian-once-decade-stock-pick-long-term-investors","source_event_id":"evt_2e02b15ab5f4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"efe72de511aaa4f0","kind":"unusual_volume","published_at":"2026-04-18T19:13:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2026 began","2017","2020","earlier this year","2031","April 18, 2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity","name":"Rivian Automotive","relevance":"high","symbol":"RIVN","type":"company"},{"asset_class":"equity","name":"Tesla","relevance":"medium","symbol":"TSLA","type":"company"},{"asset_class":"equity","name":"Uber Technologies","relevance":"medium","symbol":"UBER","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":"other","information_gaps":["The provided text does not include any unusual trading volume metrics (e.g., volume ratio vs average, baseline volume, or direction).","The signal type is discovery_unusual_volume_delta, but no volume delta/confirmation details are present in the article excerpt.","The article does not specify the exact timing/date for when R2 deliveries begin (only that it should begin deliveries soon).","The article does not provide evidence that the volume change (if any) is confirmed by news; it is purely an investment thesis."],"key_facts":["The article states Rivian shares are down more than 15% since 2026 began.","The article identifies two growth catalysts: (1) an affordable model (R2 SUV) expected to begin deliveries soon, and (2) AI/autonomous-driving investment and traction.","The article states the R2 SUV is priced under $50,000.","The article claims Rivian is investing aggressively in AI and has pushed out profitability targets (timing not specified).","The article states Uber agreed to a $1.25 billion deal with Rivian earlier this year, including an order of up to 50,000 R2 SUVs and potential additional investment through 2031 subject to autonomous performance milestones.","The article states Rivian trades at 3.5 times sales, while Tesla trades at 13.5 times sales.","The article states the author expects the discount to narrow as R2 deliveries ramp up and AI ambitions gain traction."],"numeric_claims":[{"label":"Rivian share decline since 2026 began","value":"more than 15%"},{"label":"R2 SUV price","value":"under $50,000"},{"label":"Uber deal size","value":"$1.25 billion"},{"label":"Uber R2 SUV order cap","value":"up to 50,000"},{"label":"Uber investment through 2031","value":"up to $1.25 billion"},{"label":"Rivian valuation multiple (sales)","value":"3.5x"},{"label":"Tesla valuation multiple (sales)","value":"13.5x"},{"label":"Rivian vs Tesla discount (as stated)","value":"75% discount"}],"primary_claim":"Rivian is expected to benefit from upcoming growth catalysts (R2 deliveries and AI/autonomous-driving traction), and the article claims the market has not priced this growth potential in.","relevance_score":0.35,"sentiment":"positive","source_quality":"high","summary":"The article argues Rivian (RIVN) has two near-term growth catalysts\u2014R2 SUV deliveries and AI/autonomous-driving progress\u2014that the author believes are not yet reflected in the stock price.","topics":["EVs","Rivian R2 SUV","vehicle deliveries ramp","AI","autonomous driving","robotaxi","valuation multiples","stock-picking commentary"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsRivian is about to reach two massive growth catalysts.","tickers":[],"title":"2 Reasons Rivian Is a Once-in-a-Decade Stock Pick for Long-Term Investors","url":"https://www.fool.com/investing/2026/04/18/2-reasons-rivian-is-a-once-in-a-decade-stock-pick/"}}
TEXT NOT NULL
source_ref
candidate:sc_1a324f810f5df3f6
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:a26f093625640d2c
TEXT
episode_id
NULL
TEXT
created_at
2026-04-18T21:44:04.623048+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel