SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:cd26ca08f27ece9e","evidence_event_ids":["evt_74f4b9fd93de"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 2519 in events