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/bce-now-oversold","as_of":"2026-04-07T23:23:54.391414+00:00","canonical_url":"https://www.nasdaq.com/articles/bce-now-oversold","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bce-now-oversold","article_chars":2567,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_1b84aa08e01a2be4","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bce-now-oversold","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T00:44:50.402635+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":"BCE is Now Oversold | Nasdaq","final_url":"https://www.nasdaq.com/articles/bce-now-oversold","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bce-now-oversold","source_event_id":"evt_74f4b9fd93de","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"684f2987f6385172","kind":"unusual_volume","published_at":"2026-04-07T20:27:57+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","name":"BCE Inc","relevance":"high","symbol":"BCE","type":"company"},{"asset_class":"ETF","name":"S&P 500 ETF","relevance":"medium","symbol":"SPY","type":"ETF"}],"event_type":"price_action","information_gaps":["Signal type is discovery_unusual_volume_delta, but the provided text contains no unusual-volume data (no volume ratio vs average, no baseline volume, and no direction of volume change).","No explicit confirmation by news is provided for the oversold/volume claim; the article is framed as technical-analysis commentary.","No specific catalyst hypothesis is stated in the provided text beyond a general interpretation that selling may be exhausting."],"key_facts":["Oversold threshold defined as RSI below 30.","BCE entered oversold territory with an RSI reading of 28.5.","BCE shares traded as low as $23.8039 per share (intraday low mentioned).","The article compares BCE\u2019s RSI to the current RSI reading of SPY at 46.9.","BCE\u2019s 52-week low is stated as $20.28 and 52-week high as $26.52; last trade is stated as $23.83."],"numeric_claims":[{"label":"BCE RSI","value":"28.5"},{"label":"Oversold RSI threshold","value":"30"},{"label":"SPY RSI","value":"46.9"},{"label":"BCE intraday low (mentioned)","value":"$23.8039"},{"label":"BCE 52-week low","value":"$20.28"},{"label":"BCE 52-week high","value":"$26.52"},{"label":"BCE last trade (mentioned)","value":"$23.83"}],"primary_claim":"BCE\u2019s RSI reading fell to 28.5 on Tuesday, placing it in oversold territory (RSI < 30).","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"BNK Invest reports that BCE Inc (BCE) entered oversold territory on Tuesday, with RSI dropping to 28.5 (below the 30 oversold threshold). The article frames this as potential exhaustion of recent selling, but does not provide an unusual-volume metric or a specific volume catalyst.","topics":["technical analysis","RSI oversold","market commentary","BCE","trading signals"]},"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":[],"title":"BCE is Now Oversold","url":"https://www.nasdaq.com/articles/bce-now-oversold"}

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