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/CBMilwFBVV95cUxPdHFwQWN0UWxkRGtjNVFmNVhpd01iNEpmc3hpQkZvQldWcmhYOUtubEZHRE80X2NrOFhvVEJoRGNZUTg1bVdPOTJET2dCT2xtVmZNSk9hZXZHc2JydlJkalM1a09iUW1BZnBlenNyaUtMRmJSTFdNX1NGZHhRM0JlbEZudnVEUzZLU1NMaVhuQy03NlRxLXlB?oc=5","as_of":"2026-04-13T09:40:14.055632+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/CBMilwFBVV95cUxPdHFwQWN0UWxkRGtjNVFmNVhpd01iNEpmc3hpQkZvQldWcmhYOUtubEZHRE80X2NrOFhvVEJoRGNZUTg1bVdPOTJET2dCT2xtVmZNSk9hZXZHc2JydlJkalM1a09iUW1BZnBlenNyaUtMRmJSTFdNX1NGZHhRM0JlbEZudnVEUzZLU1NMaVhuQy03NlRxLXlB?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2dfe47ed156d744c","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-13T10:23:36.215492+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPdHFwQWN0UWxkRGtjNVFmNVhpd01iNEpmc3hpQkZvQldWcmhYOUtubEZHRE80X2NrOFhvVEJoRGNZUTg1bVdPOTJET2dCT2xtVmZNSk9hZXZHc2JydlJkalM1a09iUW1BZnBlenNyaUtMRmJSTFdNX1NGZHhRM0JlbEZudnVEUzZLU1NMaVhuQy03NlRxLXlB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxPdHFwQWN0UWxkRGtjNVFmNVhpd01iNEpmc3hpQkZvQldWcmhYOUtubEZHRE80X2NrOFhvVEJoRGNZUTg1bVdPOTJET2dCT2xtVmZNSk9hZXZHc2JydlJkalM1a09iUW1BZnBlenNyaUtMRmJSTFdNX1NGZHhRM0JlbEZudnVEUzZLU1NMaVhuQy03NlRxLXlB?oc=5","source_event_id":"evt_bbc0e09d7bf3","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"51824319ad3039ab","published_at":"2026-04-13T08:07:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Two \u201cmonster stocks\u201d (unspecified)","relevance":"high","symbol":"","type":"equity"}],"event_type":"other","information_gaps":["The two stocks\u2019 names and ticker symbols are not provided.","No details on why they will rebound (catalysts, fundamentals, valuation, or technical levels) are provided.","No near-term timing (e.g., days/weeks/months) is provided.","No evidence or data from the article is available beyond the headline text."],"key_facts":["Headline states: \u201c2 Monster Stocks to Double Up On Right Now Before They Rebound.\u201d","No stock names or ticker symbols are included in the provided text.","No rebound timing or catalysts are described in the provided text."],"numeric_claims":[],"primary_claim":"Yahoo Finance claims there are two \u201cmonster stocks\u201d that investors can buy now to double up before they rebound.","relevance_score":0.25,"sentiment":"positive","source_quality":"unknown","summary":"The Yahoo Finance headline promotes two unspecified \u201cmonster stocks\u201d as buy opportunities to double up on before they rebound. No company names, tickers, timing, or supporting details are provided in the supplied text.","topics":["stock picking","rebound","buy opportunity","Yahoo Finance"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"2 Monster Stocks to Double Up On Right Now Before They Rebound Yahoo Finance","title":"2 Monster Stocks to Double Up On Right Now Before They Rebound - Yahoo Finance","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_5c7b4c9acd5a in signals