Create
Query
event_store.db
—
signals
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 sig_310883c7371b in signals
id
sig_310883c7371b
Primary key.
TEXT
event_id
302232
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/market-shaky-these-2-stocks-are-built-long-haul","as_of":"2026-04-19T11:16:24.661615+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/the-market-is-shaky-but-these-2-stocks-are-built-f/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/market-shaky-these-2-stocks-are-built-long-haul","article_chars":4569,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a87b259d8ff510fe","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/the-market-is-shaky-but-these-2-stocks-are-built-f/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T11:46:36.617885+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsCostco's retention is extraordinary -- 9 out of 10 customers renew their memberships.","fetched_title":"The Market Is Shaky, But These 2 Stocks Are Built for the Long Haul | Nasdaq","final_url":"https://www.nasdaq.com/articles/market-shaky-these-2-stocks-are-built-long-haul","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/market-shaky-these-2-stocks-are-built-long-haul","source_event_id":"evt_77425959094a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"891acf223d71c8f2","kind":"unusual_volume","published_at":"2026-04-19T09:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["April 15","2025","2026","December 17, 2004","April 15, 2005","April 19, 2026","Q4 2025","second-quarter"],"entities":[{"asset_class":"equity","name":"Costco Wholesale","relevance":"high","symbol":"COST","type":"company"},{"asset_class":"equity","name":"MercadoLibre","relevance":"high","symbol":"MELI","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"N/A","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"N/A","type":"company"}],"event_type":"other","information_gaps":["The signal type is 'discovery_unusual_volume_delta', but the provided text contains no information about trading volume, volume ratio vs average, or any unusual volume confirmation.","No explicit catalyst tied to unusual volume is provided; the article\u2019s catalysts are fundamental/operational (retention, earnings, dividend, growth metrics).","Baseline volume and volume ratio are not stated for any ticker."],"key_facts":["Costco retention is described as extraordinary, with 9 out of 10 customers renewing memberships; retention remains above 90%.","Costco second-quarter net sales increased 9.1% year over year.","Costco has more than 600 warehouses in the U.S. and nearly 300 abroad.","On April 15, Costco announced an increase in its quarterly dividend to $1.47 per share.","Costco stock is stated to have risen 14% since the start of 2026.","MercadoLibre\u2019s Mercado Pago credit portfolio grew 90% year over year as of Q4 2025.","MercadoLibre net revenue increased 45% in the final quarter of last year to $8.76 billion.","MercadoLibre stock is stated to have fallen 7% year to date and is trading with a forward P/E slightly above 30.","The article notes regulatory and political risks for MercadoLibre."],"numeric_claims":[{"label":"Costco retention","value":"above 90% (9 out of 10 renew)"},{"label":"Costco Q2 net sales YoY","value":"9.1%"},{"label":"Costco dividend per share","value":"$1.47"},{"label":"Costco warehouses (U.S.)","value":"600+"},{"label":"Costco warehouses (abroad)","value":"nearly 300"},{"label":"Costco stock performance since start of 2026","value":"14%"},{"label":"Mercado Pago credit portfolio YoY growth (as of Q4 2025)","value":"90%"},{"label":"MercadoLibre net revenue (final quarter of last year)","value":"$8.76 billion"},{"label":"MercadoLibre net revenue YoY growth","value":"45%"},{"label":"MercadoLibre stock performance YTD","value":"-7%"},{"label":"MercadoLibre forward P/E","value":"slightly above 30"}],"primary_claim":"Costco\u2019s membership retention remains above 90% (9 out of 10 customers renew), and MercadoLibre is building an e-commerce and fintech ecosystem across Latin America.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The article argues that Costco and MercadoLibre are resilient long-term businesses despite market volatility, citing strong customer retention at Costco and rapid e-commerce/fintech growth at MercadoLibre.","topics":["stock-picking","consumer retail","e-commerce","fintech","membership retention","earnings","dividend","global expansion","regulatory risk"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsCostco's retention is extraordinary -- 9 out of 10 customers renew their memberships.","tickers":[],"title":"The Market Is Shaky, But These 2 Stocks Are Built for the Long Haul","url":"https://www.fool.com/investing/2026/04/19/the-market-is-shaky-but-these-2-stocks-are-built-f/"}
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_77425959094a"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:8345624f56ed2d79
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-19T11:16:24.661615+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel