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/oversold-conditions-prudential-financial-prh","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.nasdaq.com/articles/oversold-conditions-prudential-financial-prh","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/oversold-conditions-prudential-financial-prh","article_chars":2648,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_9be68e25ad03ee9f","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/oversold-conditions-prudential-financial-prh","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:44:44.445198+00:00","extraction_method":"heuristic","fetched_description":"Legendary investor Warren Buffett advises to be fearful when others are greedy, and be greedy when others are fearful. One way we can try to measure the level of fear in a given stock is through a technical analysis indicator called the Relative Strength Index, or RSI, which me","fetched_title":"Oversold Conditions For Prudential Financial (PRH) | Nasdaq","final_url":"https://www.nasdaq.com/articles/oversold-conditions-prudential-financial-prh","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/oversold-conditions-prudential-financial-prh","source_event_id":"evt_6505750e78dc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"022b1afd9a04c23b","kind":"unusual_volume","published_at":"2026-04-07T20:28:04+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 07, 2026","Tuesday"],"entities":[{"asset_class":"equity_security","name":"Prudential Financial Inc 5.950% Junior Subordina","relevance":"high","symbol":"PRH","type":"company_security"}],"event_type":"price_action","information_gaps":["The signal type is discovery_unusual_volume_delta, but the provided text does not include any volume ratio vs average, baseline volume, or unusual volume direction.","No specific news event or confirmed catalyst for the selling is described in the provided text.","The article frames a possible interpretation (selling exhausting itself) but does not provide evidence of confirmation or a concrete catalyst."],"key_facts":["Article date/time: April 07, 2026 \u2014 04:28 pm EDT.","Oversold definition used: RSI below 30.","PRH RSI reading: 29.4.","PRH traded as low as $23.44 per share.","Comparison RSI: SPY RSI is 46.9 (as stated in the article).","PRH 52-week low: $23.40; 52-week high: $26.145; last trade: $23.56 (as stated in the article)."],"numeric_claims":[{"label":"PRH RSI","value":"29.4"},{"label":"SPY RSI","value":"46.9"},{"label":"PRH intraday low (stated)","value":"$23.44"},{"label":"PRH 52-week low","value":"$23.40"},{"label":"PRH 52-week high","value":"$26.145"},{"label":"PRH last trade (stated)","value":"$23.56"}],"primary_claim":"PRH\u2019s RSI fell to 29.4 (oversold, below 30) on Tuesday after trading as low as $23.44 per share.","relevance_score":0.42,"sentiment":"neutral","source_quality":"high","summary":"BNK Invest reports that Prudential Financial Inc 5.950% Junior Subordinated (PRH) entered oversold territory with an RSI of 29.4 on Tuesday. The article does not provide an unusual volume ratio versus average, nor a specific news catalyst for the selling.","topics":["RSI oversold","technical analysis","Prudential Financial","trading Tuesday","market sentiment (fear/greed framing)"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"Legendary investor Warren Buffett advises to be fearful when others are greedy, and be greedy when others are fearful. One way we can try to measure the level of fear in a given stock is through a technical analysis indicator called the Relative Strength Index, or RSI, which me","tickers":["PRH"],"title":"Oversold Conditions For Prudential Financial (PRH)","url":"https://www.nasdaq.com/articles/oversold-conditions-prudential-financial-prh"}

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