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/better-stock-buy-visa-or-mastercard","as_of":"2026-04-10T00:01:31.055484+00:00","canonical_url":"https://www.fool.com/investing/2026/04/09/better-stock-to-buy-visa-or-mastercard/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/better-stock-buy-visa-or-mastercard","article_chars":3342,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4887b3aea74b6bc5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/09/better-stock-to-buy-visa-or-mastercard/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:01:39.142660+00:00","extraction_method":"heuristic","fetched_description":"Visa (NYSE: V) and Mastercard (NYSE: MA) are two of the most profitable companies in the world.","fetched_title":"Better Stock to Buy: Visa or Mastercard? | Nasdaq","final_url":"https://www.nasdaq.com/articles/better-stock-buy-visa-or-mastercard","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/better-stock-buy-visa-or-mastercard","source_event_id":"evt_d422c25495cb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"18f6ef42e6dbe267","kind":"unusual_volume","published_at":"2026-04-09T23:26:57+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 09, 2026","April 7, 2026","December 17, 2004","April 15, 2005","April 9, 2026"],"entities":[{"asset_class":"equity","name":"Visa","relevance":"high","symbol":"V","type":"company"},{"asset_class":"equity","name":"Mastercard","relevance":"high","symbol":"MA","type":"company"},{"asset_class":"other","name":"The Motley Fool","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Unusual volume delta details are missing: no baseline volume, no current volume, no volume ratio vs average, and no direction (e.g., above/below average).","No explicit catalyst is described that would explain any volume change.","No confirmation by news or market event is provided in the text; the signal type (discovery_unusual_volume_delta) is not evidenced by the article content."],"key_facts":["Headline asks: \"Better Stock to Buy: Visa or Mastercard?\"","Article date/time shown as April 09, 2026 \u2014 07:26 pm EDT.","Text states: \"Visa (NYSE: V) and Mastercard (NYSE: MA) are two of the most profitable companies in the world.\"","No volume information (baseline volume, volume ratio, or direction) is included in the provided text.","The article includes promotional/marketing content about Stock Advisor and mentions that Mastercard wasn\u2019t one of the 10 best stocks identified by the analyst team."],"numeric_claims":[],"primary_claim":"The article states that Visa (NYSE: V) and Mastercard (NYSE: MA) are two of the most profitable companies in the world and frames a comparison of which is the better stock to buy.","relevance_score":0.25,"sentiment":"mixed","source_quality":"high","summary":"The Motley Fool article compares Visa (V) and Mastercard (MA) as potential buys, but it does not provide any unusual trading volume metrics or a volume-vs-average ratio.","topics":["stock picking","Visa vs Mastercard","profitability","investor newsletter/promotion"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Visa (NYSE: V) and Mastercard (NYSE: MA) are two of the most profitable companies in the world.","tickers":[],"title":"Better Stock to Buy: Visa or Mastercard?","url":"https://www.fool.com/investing/2026/04/09/better-stock-to-buy-visa-or-mastercard/"}

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_49cfd6dcc308 in signals