SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxNLTRZajNaS2hSb3M2UUxEMlk1VThEQzAzLWd1Q3RwWU1FaGZnakJCOHVUSU5TZDM2ZlpSUUdkWUhHWE9Vd1ZveWxYOU1CaUZxSC15bnFNM3NVSEotQUZmd0lvSktmNGpRRGtPQmxobjZoS1A3V3Rsa1ZjUlg4NjdlcGZqUW5wOUNPdnpQdDhudmZka0lJb3g5WndBa0I0UC04QkJ4cW1wSEItRDlmNy1ja05vWWYtM3k2dHc?oc=5","as_of":"2026-04-09T15:51:36.511137+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxNLTRZajNaS2hSb3M2UUxEMlk1VThEQzAzLWd1Q3RwWU1FaGZnakJCOHVUSU5TZDM2ZlpSUUdkWUhHWE9Vd1ZveWxYOU1CaUZxSC15bnFNM3NVSEotQUZmd0lvSktmNGpRRGtPQmxobjZoS1A3V3Rsa1ZjUlg4NjdlcGZqUW5wOUNPdnpQdDhudmZka0lJb3g5WndBa0I0UC04QkJ4cW1wSEItRDlmNy1ja05vWWYtM3k2dHc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0bc42cd8dd562871","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:41:52.446521+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxNLTRZajNaS2hSb3M2UUxEMlk1VThEQzAzLWd1Q3RwWU1FaGZnakJCOHVUSU5TZDM2ZlpSUUdkWUhHWE9Vd1ZveWxYOU1CaUZxSC15bnFNM3NVSEotQUZmd0lvSktmNGpRRGtPQmxobjZoS1A3V3Rsa1ZjUlg4NjdlcGZqUW5wOUNPdnpQdDhudmZka0lJb3g5WndBa0I0UC04QkJ4cW1wSEItRDlmNy1ja05vWWYtM3k2dHc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gurufocus.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiugFBVV95cUxNLTRZajNaS2hSb3M2UUxEMlk1VThEQzAzLWd1Q3RwWU1FaGZnakJCOHVUSU5TZDM2ZlpSUUdkWUhHWE9Vd1ZveWxYOU1CaUZxSC15bnFNM3NVSEotQUZmd0lvSktmNGpRRGtPQmxobjZoS1A3V3Rsa1ZjUlg4NjdlcGZqUW5wOUNPdnpQdDhudmZka0lJb3g5WndBa0I0UC04QkJ4cW1wSEItRDlmNy1ja05vWWYtM3k2dHc?oc=5","source_event_id":"evt_3811c2f16d93","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"17d0db96df5b221b","published_at":"2026-04-09T14:06:01+00:00","publisher_domain":"gurufocus.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Alcoa","relevance":"high","symbol":"AA","type":"company"},{"asset_class":"unknown","name":"BMO Capital","relevance":"high","symbol":"","type":"analyst_firm"}],"event_type":"price_action","information_gaps":["The article text content is not provided (only CSS/HTML boilerplate), so the specific rating level (e.g., Buy/Hold/Sell) is not stated in the extracted text.","No prior price target value is provided, so the magnitude of the raise cannot be determined.","No rationale, timeframe, or expected catalysts are included in the provided content.","No confirmation of whether the rating is explicitly unchanged beyond the headline wording is available from the provided text."],"key_facts":["Headline states BMO Capital raised Alcoa (AA) price target to $75.00.","Headline states BMO Capital maintained its rating on AA."],"numeric_claims":[{"label":"Raised price target (USD)","value":"75.00"}],"primary_claim":"BMO Capital raised its Alcoa (AA) price target to $75.00 and maintained its rating.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"BMO Capital increased its price target for Alcoa (AA) to $75.00 while keeping its rating unchanged, per the provided headline.","topics":["analyst price target","equity research","Alcoa","AA rating maintained"]},"source":"GuruFocus","source_domain":"gurufocus.com","source_url":"https://www.gurufocus.com","summary":"","tickers":[],"title":"BMO Capital Raises Alcoa (AA) Price Target to $75.00, Maintains Rating | AA Stock News - GuruFocus","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

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