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/CBMipAFBVV95cUxQcFNvWklBM0lySnZJVDVWdVptWEE3Y3Y2OVQtdEJyWFlMODBmUGUwZF9SaFg0cXZ0RU1ZT3pwa0lmNVZkZnB1bnZKbXg5bHVtak5wTW5URDU5cDdTamU1b1haa0xwOTBuZVdWTzJtbVp0bmhsZnZQaTdZa1QtVEh2bmxTUnl3WUJCMVJIcVUwNENDZVFfTWZvRXh4MEVxZGhSQUJjUw?oc=5","as_of":"2026-04-09T23:19:21.007857+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/CBMipAFBVV95cUxQcFNvWklBM0lySnZJVDVWdVptWEE3Y3Y2OVQtdEJyWFlMODBmUGUwZF9SaFg0cXZ0RU1ZT3pwa0lmNVZkZnB1bnZKbXg5bHVtak5wTW5URDU5cDdTamU1b1haa0xwOTBuZVdWTzJtbVp0bmhsZnZQaTdZa1QtVEh2bmxTUnl3WUJCMVJIcVUwNENDZVFfTWZvRXh4MEVxZGhSQUJjUw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d4b08c55a92db6e6","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-10T00:51:26.213341+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxQcFNvWklBM0lySnZJVDVWdVptWEE3Y3Y2OVQtdEJyWFlMODBmUGUwZF9SaFg0cXZ0RU1ZT3pwa0lmNVZkZnB1bnZKbXg5bHVtak5wTW5URDU5cDdTamU1b1haa0xwOTBuZVdWTzJtbVp0bmhsZnZQaTdZa1QtVEh2bmxTUnl3WUJCMVJIcVUwNENDZVFfTWZvRXh4MEVxZGhSQUJjUw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketwatch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxQcFNvWklBM0lySnZJVDVWdVptWEE3Y3Y2OVQtdEJyWFlMODBmUGUwZF9SaFg0cXZ0RU1ZT3pwa0lmNVZkZnB1bnZKbXg5bHVtak5wTW5URDU5cDdTamU1b1haa0xwOTBuZVdWTzJtbVp0bmhsZnZQaTdZa1QtVEh2bmxTUnl3WUJCMVJIcVUwNENDZVFfTWZvRXh4MEVxZGhSQUJjUw?oc=5","source_event_id":"evt_3ac72a884bfb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"b014ec31adff8c8c","published_at":"2026-04-09T21:58:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"","name":"MarketWatch","relevance":"source of the headline","symbol":"","type":"publisher"},{"asset_class":"equities","name":"Stocks","relevance":"subject of the headline question","symbol":"","type":"asset_class"}],"event_type":"geopolitical_risk","information_gaps":["The provided text does not include the article\u2019s supporting arguments, data, or any specific markets/sectors affected.","No timeframe for the rally or the cease-fire is stated in the provided content.","No specific stock tickers, index names, or magnitude of price moves are included.","The directionality (e.g., overvaluation risk vs. continued upside) is only implied by the headline question; the article\u2019s conclusion is not available."],"key_facts":["Headline: \u201cHas the cease-fire rally pushed stocks too high, too quickly?\u201d","Publisher: MarketWatch","No additional article details were provided beyond the headline/source summary."],"numeric_claims":[],"primary_claim":"The MarketWatch headline questions whether the cease-fire rally has pushed stocks too high too quickly.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"MarketWatch asks whether a stock-market rally tied to a cease-fire has run ahead of fundamentals, implying a potential \u201ctoo high, too quickly\u201d concern.","topics":["cease-fire","stock rally","valuation/pace of gains","market sentiment"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"Has the cease-fire rally pushed stocks too high, too quickly? MarketWatch","title":"Has the cease-fire rally pushed stocks too high, too quickly? - MarketWatch","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_3f6cef9d4d38 in signals