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/CBMi0AFBVV95cUxNQ3hEUEpFVmRnU0FXUDd6dXV5NUJHWWVxaHpRUTgxbFBUNlBVSVN2S3lUOVo5ckV0QlFvOVBMODN2THBjem1heWxJMHhQOVJUQ1l1bU1pOW5pWU1sQ3FXWHN0M2FlN2VySlE0Ml9oYzBVNTllLW5HNG1GdTVuaVFVWXcxQ011NFc2bXU3YkFpdVZ1QkZYRGo4MzZ4eDBJSHdoU1VVX0NvRkd0ektUWkRNRmtrLVl6Tlh2ZVRCQ2w5bExjdUUydlJGUVFBY3BsUmNI?oc=5","as_of":"2026-04-09T15:51:37.215999+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/CBMi0AFBVV95cUxNQ3hEUEpFVmRnU0FXUDd6dXV5NUJHWWVxaHpRUTgxbFBUNlBVSVN2S3lUOVo5ckV0QlFvOVBMODN2THBjem1heWxJMHhQOVJUQ1l1bU1pOW5pWU1sQ3FXWHN0M2FlN2VySlE0Ml9oYzBVNTllLW5HNG1GdTVuaVFVWXcxQ011NFc2bXU3YkFpdVZ1QkZYRGo4MzZ4eDBJSHdoU1VVX0NvRkd0ektUWkRNRmtrLVl6Tlh2ZVRCQ2w5bExjdUUydlJGUVFBY3BsUmNI?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a4cbb1e0c1893beb","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:42:31.205491+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxNQ3hEUEpFVmRnU0FXUDd6dXV5NUJHWWVxaHpRUTgxbFBUNlBVSVN2S3lUOVo5ckV0QlFvOVBMODN2THBjem1heWxJMHhQOVJUQ1l1bU1pOW5pWU1sQ3FXWHN0M2FlN2VySlE0Ml9oYzBVNTllLW5HNG1GdTVuaVFVWXcxQ011NFc2bXU3YkFpdVZ1QkZYRGo4MzZ4eDBJSHdoU1VVX0NvRkd0ektUWkRNRmtrLVl6Tlh2ZVRCQ2w5bExjdUUydlJGUVFBY3BsUmNI?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/CBMi0AFBVV95cUxNQ3hEUEpFVmRnU0FXUDd6dXV5NUJHWWVxaHpRUTgxbFBUNlBVSVN2S3lUOVo5ckV0QlFvOVBMODN2THBjem1heWxJMHhQOVJUQ1l1bU1pOW5pWU1sQ3FXWHN0M2FlN2VySlE0Ml9oYzBVNTllLW5HNG1GdTVuaVFVWXcxQ011NFc2bXU3YkFpdVZ1QkZYRGo4MzZ4eDBJSHdoU1VVX0NvRkd0ektUWkRNRmtrLVl6Tlh2ZVRCQ2w5bExjdUUydlJGUVFBY3BsUmNI?oc=5","source_event_id":"evt_096cca04609d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"da6197d859be6b70","published_at":"2026-04-09T15:34:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"Big Tech stocks","relevance":"high","symbol":"","type":"market_segment"},{"asset_class":"unknown","name":"Investors","relevance":"medium","symbol":"","type":"market_participant"},{"asset_class":"media","name":"MarketWatch","relevance":"low","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["No specific companies/tickers are named.","No valuation metrics (e.g., P/E, price targets) are provided in the provided text.","No timeframe for \u201cwhat is next for the market\u201d is specified.","No description of the catalyst (earnings, macro data, policy, rates) is included in the provided text."],"key_facts":["MarketWatch headline states Big Tech stocks look like especially good deals.","The headline links this perception to investors \u201ceye[ing] what is next for the market.\u201d"],"numeric_claims":[],"primary_claim":"Big Tech stocks are being seen as especially good deals by investors as they consider what is next for the market.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"MarketWatch says investors are viewing Big Tech stocks as especially attractive \u201cdeals\u201d while they look ahead to what comes next for the market.","topics":["equities","Big Tech","market outlook","valuation","investor sentiment"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"Big Tech stocks look like especially good deals as investors eye what is next for the market MarketWatch","title":"Big Tech stocks look like especially good deals as investors eye what is next for the market - 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_7bfd85782b27 in signals