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/CBMisgFBVV95cUxOR1B1WXp2dG1na3FuSElFV0ZybkxfZEtHcXVnaUZpSi1jSmZHajl4d1Eycjl6djllcFM1ZTJEVHpvUVROQTM4Vmc5aE1tRm5UWDl4YVcxSHhxbmxxUjQ0LU0zU25IMmJ3U29xM1BfMDVkcXNYUk1rVWNNLUVHNVE1SzBPLXNVckZkeG5pbnI1MGZLWjk2VHJ4SXl4TV92SVRKdHJGaDVQcGVDVHd0NDRBWHVR?oc=5","as_of":"2026-04-09T04:35:26.096487+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/CBMisgFBVV95cUxOR1B1WXp2dG1na3FuSElFV0ZybkxfZEtHcXVnaUZpSi1jSmZHajl4d1Eycjl6djllcFM1ZTJEVHpvUVROQTM4Vmc5aE1tRm5UWDl4YVcxSHhxbmxxUjQ0LU0zU25IMmJ3U29xM1BfMDVkcXNYUk1rVWNNLUVHNVE1SzBPLXNVckZkeG5pbnI1MGZLWjk2VHJ4SXl4TV92SVRKdHJGaDVQcGVDVHd0NDRBWHVR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ceade05aa23d5b4f","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-09T22:37:24.450055+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMisgFBVV95cUxOR1B1WXp2dG1na3FuSElFV0ZybkxfZEtHcXVnaUZpSi1jSmZHajl4d1Eycjl6djllcFM1ZTJEVHpvUVROQTM4Vmc5aE1tRm5UWDl4YVcxSHhxbmxxUjQ0LU0zU25IMmJ3U29xM1BfMDVkcXNYUk1rVWNNLUVHNVE1SzBPLXNVckZkeG5pbnI1MGZLWjk2VHJ4SXl4TV92SVRKdHJGaDVQcGVDVHd0NDRBWHVR?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/CBMisgFBVV95cUxOR1B1WXp2dG1na3FuSElFV0ZybkxfZEtHcXVnaUZpSi1jSmZHajl4d1Eycjl6djllcFM1ZTJEVHpvUVROQTM4Vmc5aE1tRm5UWDl4YVcxSHhxbmxxUjQ0LU0zU25IMmJ3U29xM1BfMDVkcXNYUk1rVWNNLUVHNVE1SzBPLXNVckZkeG5pbnI1MGZLWjk2VHJ4SXl4TV92SVRKdHJGaDVQcGVDVHd0NDRBWHVR?oc=5","source_event_id":"evt_07f4a9b4d68c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e3a75da289fb940e","published_at":"2026-04-09T03:32:00+00:00","publisher_domain":"finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"Yahoo Finance","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"equities","name":"Middle Eastern stocks","relevance":"high","symbol":"","type":"market_region"}],"event_type":"other","information_gaps":["Which specific Middle Eastern countries/markets are covered is not stated.","No specific stocks/companies are named.","No timing for catalysts (e.g., earnings dates, policy decisions) is provided.","No performance metrics, valuations, or portfolio recommendations are included in the supplied text.","The article\u2019s thesis details (why opportunities exist) are not present in the provided content."],"key_facts":["Headline states: \u201cDiscovering Hidden Opportunities in Middle Eastern Stocks.\u201d","Source summary repeats the same headline theme.","No company names, tickers, or specific market catalysts are included in the provided text."],"numeric_claims":[],"primary_claim":"The Yahoo Finance piece is about discovering hidden opportunities in Middle Eastern stocks.","relevance_score":0.25,"sentiment":"neutral","source_quality":"high","summary":"Yahoo Finance headline frames an article about finding \u201chidden opportunities\u201d in Middle Eastern stocks. No specific countries, companies, or market moves are provided in the supplied text.","topics":["regional equities","investment opportunities","stock selection"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"Discovering Hidden Opportunities in Middle Eastern Stocks Yahoo Finance","title":"Discovering Hidden Opportunities in Middle Eastern Stocks - 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_645c9ed139f3 in signals