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/raymond-james-financial-now-325-largest-company-surpassing-citizens-financial-group","as_of":"2026-04-08T21:48:34.772061+00:00","canonical_url":"https://www.nasdaq.com/articles/raymond-james-financial-now-325-largest-company-surpassing-citizens-financial-group","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/raymond-james-financial-now-325-largest-company-surpassing-citizens-financial-group","article_chars":3933,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_ba6260777520c4c7","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/raymond-james-financial-now-325-largest-company-surpassing-citizens-financial-group","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:09:50.719085+00:00","extraction_method":"heuristic","fetched_description":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, Raymond James Financial Inc (Symbol: RJF) has taken over the #325 spot from Citizens Financial Group Inc (Symbol: CFG), according to The Online Investor. Market capit","fetched_title":"Raymond James Financial Now #325 Largest Company, Surpassing Citizens Financial Group | Nasdaq","final_url":"https://www.nasdaq.com/articles/raymond-james-financial-now-325-largest-company-surpassing-citizens-financial-group","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/raymond-james-financial-now-325-largest-company-surpassing-citizens-financial-group","source_event_id":"evt_049d635664a5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4b812f3478869e12","kind":"unusual_volume","published_at":"2026-04-08T20:38:49+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["April 08, 2026","Wednesday"],"entities":[{"asset_class":"equity","name":"Raymond James Financial Inc","relevance":"high","symbol":"RJF","type":"company"},{"asset_class":"equity","name":"Citizens Financial Group Inc","relevance":"high","symbol":"CFG","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 confirmation about volume).","No explicit catalyst is provided for the ranking change beyond the reported market-cap figures.","The article does not specify the exact method/date for the ranking update beyond the publication timestamp and the phrase \u201clatest look.\u201d","No confirmation from independent news sources is provided; the ranking is attributed to The Online Investor within the article."],"key_facts":["RJF is reported to be ranked #325 in the S&P 500 by market capitalization, surpassing CFG.","The article states RJF market capitalization is $28.06 billion versus CFG at $26.18 billion.","At the closing bell on Wednesday, RJF was up about 3.8% and CFG was up about 3.5% on the day.","The article attributes the ranking change to \u201cThe Online Investor.\u201d"],"numeric_claims":[{"label":"RJF market cap (billion USD)","value":"28.06"},{"label":"CFG market cap (billion USD)","value":"26.18"},{"label":"RJF daily move at close (%)","value":"3.8"},{"label":"CFG daily move at close (%)","value":"3.5"}],"primary_claim":"Raymond James Financial (RJF) has taken the #325 spot in the S&P 500 by market capitalization from Citizens Financial Group (CFG), with market caps of $28.06B vs. $26.18B.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"The article reports that Raymond James Financial (RJF) moved up to #325 in the S&P 500 by market capitalization, surpassing Citizens Financial Group (CFG). It cites market caps of $28.06B for RJF versus $26.18B for CFG and notes both stocks were up at the close on Wednesday.","topics":["S&P 500 market-cap ranking","Raymond James Financial","Citizens Financial Group","market capitalization","relative stock performance"]},"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, Raymond James Financial Inc (Symbol: RJF) has taken over the #325 spot from Citizens Financial Group Inc (Symbol: CFG), according to The Online Investor. Market capit","tickers":[],"title":"Raymond James Financial Now #325 Largest Company, Surpassing Citizens Financial Group","url":"https://www.nasdaq.com/articles/raymond-james-financial-now-325-largest-company-surpassing-citizens-financial-group"}

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