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/CBMipAFBVV95cUxPMmlndzhTRk51MEpxcFhmMEI4UnZGZVB5UTFaR3R5Sm1LSDN0UDFQM1BRRlZ2QVdxek1kcGVYNXNFOXZBZlBFOER0Z19VUGdQUmYwNEpDWXRKSThBTlVXLUtCWTE1OHRqRFNTZjdmaWdoaXJGOEZ1eTRsQkFjU1Z2bmMxRE1ZMzBWb2dZMnc5am5BTmViaWQ2R0FZQnpxSWFMSVEwNA?oc=5","as_of":"2026-04-09T11:22:55.155765+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/CBMipAFBVV95cUxPMmlndzhTRk51MEpxcFhmMEI4UnZGZVB5UTFaR3R5Sm1LSDN0UDFQM1BRRlZ2QVdxek1kcGVYNXNFOXZBZlBFOER0Z19VUGdQUmYwNEpDWXRKSThBTlVXLUtCWTE1OHRqRFNTZjdmaWdoaXJGOEZ1eTRsQkFjU1Z2bmMxRE1ZMzBWb2dZMnc5am5BTmViaWQ2R0FZQnpxSWFMSVEwNA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_536a91909479dd51","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:15:02.246067+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxPMmlndzhTRk51MEpxcFhmMEI4UnZGZVB5UTFaR3R5Sm1LSDN0UDFQM1BRRlZ2QVdxek1kcGVYNXNFOXZBZlBFOER0Z19VUGdQUmYwNEpDWXRKSThBTlVXLUtCWTE1OHRqRFNTZjdmaWdoaXJGOEZ1eTRsQkFjU1Z2bmMxRE1ZMzBWb2dZMnc5am5BTmViaWQ2R0FZQnpxSWFMSVEwNA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"stockstory.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipAFBVV95cUxPMmlndzhTRk51MEpxcFhmMEI4UnZGZVB5UTFaR3R5Sm1LSDN0UDFQM1BRRlZ2QVdxek1kcGVYNXNFOXZBZlBFOER0Z19VUGdQUmYwNEpDWXRKSThBTlVXLUtCWTE1OHRqRFNTZjdmaWdoaXJGOEZ1eTRsQkFjU1Z2bmMxRE1ZMzBWb2dZMnc5am5BTmViaWQ2R0FZQnpxSWFMSVEwNA?oc=5","source_event_id":"evt_663bc464d7c4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"12e1543a53a10b0b","published_at":"2026-04-09T08:21:11+00:00","publisher_domain":"stockstory.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity_research_media","name":"StockStory","relevance":"primary source","symbol":"","type":"publisher"},{"asset_class":"equity_research_media","name":"3 Profitable Stocks We Think Twice About","relevance":"article being summarized","symbol":"","type":"article_title"}],"event_type":"other","information_gaps":["The three stocks (company names and tickers) are not provided in the supplied text.","No details are given on why the authors \u201cthink twice\u201d (valuation, risks, guidance, balance sheet, etc.).","No timing/catalyst information is included (e.g., earnings dates, upcoming events).","No market impact direction can be inferred beyond the qualitative \u201cthink twice\u201d framing."],"key_facts":["Headline states: \u201c3 Profitable Stocks We Think Twice About - StockStory.\u201d","Source summary repeats the same headline theme: \u201c3 Profitable Stocks We Think Twice About StockStory.\u201d","No stock tickers, company names, financial metrics, or rationale are present in the provided text."],"numeric_claims":[],"primary_claim":"The article \u201c3 Profitable Stocks We Think Twice About\u201d presents three profitable stocks that the authors advise investors to reconsider.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"StockStory published an article titled \u201c3 Profitable Stocks We Think Twice About,\u201d implying it discusses three profitable stocks that the authors are cautious about. The provided text does not include the stock names or any specific reasons/catalysts.","topics":["equity research","stock selection","investor caution","profitable stocks"]},"source":"StockStory","source_domain":"stockstory.org","source_url":"https://stockstory.org","summary":"3 Profitable Stocks We Think Twice About StockStory","title":"3 Profitable Stocks We Think Twice About - StockStory","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_a1b29017bba8 in signals