SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/1-reason-buy-and-hold-costco-stock-next-10-years","as_of":"2026-04-10T12:11:33.277556+00:00","canonical_url":"https://www.fool.com/investing/2026/04/10/reason-buy-and-hold-costco-stock-for-next-decade/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/1-reason-buy-and-hold-costco-stock-next-10-years","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d5c44830868b33b2","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/10/reason-buy-and-hold-costco-stock-for-next-decade/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T12:13:17.439950+00:00","extraction_method":"heuristic","fetched_description":"Key PointsCostco's competitive advantage is in its members.","fetched_title":"1 Reason to Buy and Hold Costco Stock for the Next 10 Years | Nasdaq","final_url":"https://www.nasdaq.com/articles/1-reason-buy-and-hold-costco-stock-next-10-years","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/1-reason-buy-and-hold-costco-stock-next-10-years","source_event_id":"evt_a704abe983a0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b03085bd2194e13e","kind":"unusual_volume","published_at":"2026-04-10T11:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 10, 2026","fiscal 2025","Q2 2026","end of 2025","end of 2026"],"entities":[{"asset_class":"equity","name":"Costco Wholesale","relevance":"high","symbol":"COST","type":"company"},{"asset_class":"other","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Signal type is discovery_unusual_volume_delta, but the provided text contains no trading volume data, no volume ratio vs average, and no direction (e.g., above/below average).","No explicit catalyst for unusual volume is mentioned; the article is a long-term investment thesis rather than a volume/flow event.","No confirmation mechanism is described (e.g., news-driven volume vs unexplained volume); therefore confirmation status cannot be determined from the text."],"key_facts":["Article date/time shown as April 10, 2026 \u2014 07:05 am EDT.","Costco collected $5.3 billion in membership fees in fiscal 2025.","U.S. and Canada renewal rate is roughly 92%; worldwide renewal rate is nearly 90% as of Q2 2026.","Costco had 914 worldwide warehouses at the end of 2025 and plans to end 2026 with 942.","Costco forward price-to-earnings ratio is stated as 50.","Article frames Costco as generating revenue from membership fees even without customers shopping in stores."],"numeric_claims":[{"label":"Membership fees (fiscal 2025, $B)","value":"5.3"},{"label":"U.S./Canada renewal rate (%)","value":"~92"},{"label":"Worldwide renewal rate (%)","value":"~90"},{"label":"Warehouses end of 2025","value":"914"},{"label":"Planned warehouses end of 2026","value":"942"},{"label":"Forward P/E","value":"50"}],"primary_claim":"Costco generated $5.3 billion in fiscal 2025 membership fees and has roughly a 92% U.S./Canada renewal rate and nearly 90% worldwide renewal rate as of Q2 2026, supporting its long-term durability.","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The Motley Fool article argues Costco (COST) is a durable long-term hold based on its membership model and high renewal rates, despite a high forward P/E. No unusual trading volume information is provided in the text.","topics":["membership model","renewal rates","long-term investing thesis","valuation (forward P/E)","Costco expansion/warehouse count"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsCostco's competitive advantage is in its members.","tickers":[],"title":"1 Reason to Buy and Hold Costco Stock for the Next 10 Years","url":"https://www.fool.com/investing/2026/04/10/reason-buy-and-hold-costco-stock-for-next-decade/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_544d96f52146 in signals