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/CBMizwFBVV95cUxPMFBWSEpJdl9KWnNIY1NudFhRblV3Vjh3SmY0VUI4Mzhnczd2NzBmZ2xWNFgxa1piZk14Z1ZkZFJRclpnQ1hyUWRreXE1VHVJT2kyT3FiY3VYUWtOUFdSOC1qaWk1YTgyQ0FWV0dPTXNCZHlJMUczWVA5bmVGQ1BHZHRsZno4bzlqeGltWWI1eUdyV0F3eWtjS2JTYUhaMEUtSjNRaV9kcGloXzgzc3V2QlR6UGZReWx6cUxQZFQ0S0c4Yy1MNjhGajMwN3N6VGc?oc=5","as_of":"2026-04-10T13:12:08.706840+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/CBMizwFBVV95cUxPMFBWSEpJdl9KWnNIY1NudFhRblV3Vjh3SmY0VUI4Mzhnczd2NzBmZ2xWNFgxa1piZk14Z1ZkZFJRclpnQ1hyUWRreXE1VHVJT2kyT3FiY3VYUWtOUFdSOC1qaWk1YTgyQ0FWV0dPTXNCZHlJMUczWVA5bmVGQ1BHZHRsZno4bzlqeGltWWI1eUdyV0F3eWtjS2JTYUhaMEUtSjNRaV9kcGloXzgzc3V2QlR6UGZReWx6cUxQZFQ0S0c4Yy1MNjhGajMwN3N6VGc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2a12dc96d7292f8b","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-10T13:15:33.120158+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMizwFBVV95cUxPMFBWSEpJdl9KWnNIY1NudFhRblV3Vjh3SmY0VUI4Mzhnczd2NzBmZ2xWNFgxa1piZk14Z1ZkZFJRclpnQ1hyUWRreXE1VHVJT2kyT3FiY3VYUWtOUFdSOC1qaWk1YTgyQ0FWV0dPTXNCZHlJMUczWVA5bmVGQ1BHZHRsZno4bzlqeGltWWI1eUdyV0F3eWtjS2JTYUhaMEUtSjNRaV9kcGloXzgzc3V2QlR6UGZReWx6cUxQZFQ0S0c4Yy1MNjhGajMwN3N6VGc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMizwFBVV95cUxPMFBWSEpJdl9KWnNIY1NudFhRblV3Vjh3SmY0VUI4Mzhnczd2NzBmZ2xWNFgxa1piZk14Z1ZkZFJRclpnQ1hyUWRreXE1VHVJT2kyT3FiY3VYUWtOUFdSOC1qaWk1YTgyQ0FWV0dPTXNCZHlJMUczWVA5bmVGQ1BHZHRsZno4bzlqeGltWWI1eUdyV0F3eWtjS2JTYUhaMEUtSjNRaV9kcGloXzgzc3V2QlR6UGZReWx6cUxQZFQ0S0c4Yy1MNjhGajMwN3N6VGc?oc=5","source_event_id":"evt_2548f46e74ba","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a6e7ed5a7c5f4662","kind":"unusual_volume","published_at":"2026-04-10T10:13:44+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Lloyds Enterprises","relevance":"high","symbol":"","type":"company"}],"event_type":"other","information_gaps":["Ticker symbol is not provided in the provided text.","Unusual volume ratio vs average is not provided (baseline volume and volume_ratio are null).","Direction of volume movement (up/down) is not provided.","Whether the clarification is confirmed by additional news vs unexplained is not stated in the provided text.","The most likely catalyst hypothesis is not described in the provided text.","No specific exchange name, date/time of inquiry, or quantitative trading metrics are included in the provided text."],"key_facts":["Headline states: \"Lloyds Enterprises Clarifies Volume Movement Following Stock Exchange Inquiry\".","No additional factual details (ticker, volume ratio, direction, catalyst) are present in the provided cleaned article text."],"numeric_claims":[],"primary_claim":"Lloyds Enterprises clarified its stock volume movement following a stock exchange inquiry.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The signal claims Lloyds Enterprises clarified unusual stock volume movement after a stock exchange inquiry. The provided article text contains no readable details about the ticker, volume ratio, or the stated catalyst.","topics":["unusual trading volume","stock exchange inquiry","company clarification"]},"source":"scanx.trade","source_domain":"gstatic.com","summary":"Lloyds Enterprises Clarifies Volume Movement Following Stock Exchange Inquiry scanx.trade","tickers":[],"title":"Lloyds Enterprises Clarifies Volume Movement Following Stock Exchange Inquiry - scanx.trade","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_204eb983967e in signals