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/keycorp-moves-market-cap-rank-passing-ch-robinson-worldwide","as_of":"2026-04-16T20:41:43.224690+00:00","canonical_url":"https://www.nasdaq.com/articles/keycorp-moves-market-cap-rank-passing-ch-robinson-worldwide","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/keycorp-moves-market-cap-rank-passing-ch-robinson-worldwide","article_chars":2360,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_73693e5cae667f77","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/keycorp-moves-market-cap-rank-passing-ch-robinson-worldwide","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T11:12:59.576667+00:00","extraction_method":"trafilatura","fetched_description":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, KeyCorp (Symbol: KEY) has taken over the #368 spot from C.H. Robinson Worldwide, Inc. (Symbol: CHRW), according to The Online Investor. Market capitalization is an im","fetched_title":"KeyCorp Moves Up In Market Cap Rank, Passing C.H. Robinson Worldwide | Nasdaq","final_url":"https://www.nasdaq.com/articles/keycorp-moves-market-cap-rank-passing-ch-robinson-worldwide","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/keycorp-moves-market-cap-rank-passing-ch-robinson-worldwide","source_event_id":"evt_0113498e4ca2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"851f4bd18939be00","kind":"unusual_volume","published_at":"2026-04-16T20:38:06+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Thursday"],"entities":[{"asset_class":"equity","name":"KeyCorp","relevance":"high","symbol":"KEY","type":"company"},{"asset_class":"equity","name":"C.H. Robinson Worldwide, Inc.","relevance":"high","symbol":"CHRW","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"}],"event_type":"price_action","information_gaps":["This signal type is 'discovery_unusual_volume_delta', but the provided text contains no unusual volume metrics (no volume ratio vs average, no baseline volume, and no volume direction).","No explicit catalyst for the market-cap rank change is provided in the excerpt.","The excerpt does not state the exact mechanism (e.g., price move vs share count change) behind the market-cap ranking change.","The article references charts and 'three month price history' but provides no chart-derived numeric details beyond the cited market caps and daily % moves."],"key_facts":["The Online Investor reports KeyCorp (KEY) took over the #368 market-cap spot in the S&P 500 from C.H. Robinson Worldwide (CHRW).","The article cites KeyCorp market capitalization as $23.50 billion and CHRW as $19.81 billion.","At the closing bell, KEY was up about 0.4% on Thursday.","At the closing bell, CHRW was up about 8.1% on Thursday."],"numeric_claims":[{"label":"KEY market cap (billion USD)","value":"23.50"},{"label":"CHRW market cap (billion USD)","value":"19.81"},{"label":"KEY daily move (%)","value":"0.4"},{"label":"CHRW daily move (%)","value":"8.1"}],"primary_claim":"The article states that KeyCorp (KEY) took over the #368 S&P 500 market-cap spot from C.H. Robinson Worldwide (CHRW), with KEY market cap at $23.50B versus CHRW at $19.81B.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"KeyCorp (KEY) reportedly moved up in S&P 500 market-cap ranking, passing C.H. Robinson Worldwide (CHRW), with KEY market cap cited as $23.50B vs CHRW at $19.81B. The article also notes both stocks were up on the day, with KEY up ~0.4% and CHRW up ~8.1%.","topics":["market capitalization","S&P 500 component rankings","relative company size","stock performance","KEY vs CHRW"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, KeyCorp (Symbol: KEY) has taken over the #368 spot from C.H. Robinson Worldwide, Inc. (Symbol: CHRW), according to The Online Investor. Market capitalization is an im","tickers":[],"title":"KeyCorp Moves Up In Market Cap Rank, Passing C.H. Robinson Worldwide","url":"https://www.nasdaq.com/articles/keycorp-moves-market-cap-rank-passing-ch-robinson-worldwide"}

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