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/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5","as_of":"2026-04-09T13:30:32.171766+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/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ece72e762ac6f21d","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:26:10.225737+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pro.thestreet.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirgFBVV95cUxNLWQtZkJUM0ZpaWFxVEdoeEcxVzBRRF9Ta1JiMHBjdWtENWRrT1lZdUxhXzVXTWVCcUVHX210aFNaZDdKcTJReWtGN1BBNzhzWWNTSWx5YnpYNW5UYmZUSXMybmhTTWx2dG1SQWowZEg1N01nMGN3UG95bUoxY0xBYWItTHFPRUdoN2t3U2R4R3lxUXI2b2VfVlA3MXJVb0FCUUNuMjJKQ1RUbF9kd3c?oc=5","source_event_id":"evt_6e59afb4a95e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7a963e69ed854446","published_at":"2026-04-09T12:36:00+00:00","publisher_domain":"pro.thestreet.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.62,"dates_mentioned":["Thursday"],"entities":[{"asset_class":"commodity","name":"Oil prices","relevance":"high","symbol":"CL=F","type":"commodity"}],"event_type":"price_action","information_gaps":["The supplied article text is only HTML/CSS and does not include the actual content of the eight items.","No specific oil price level, percentage change, or timeframe is provided.","No stock tickers or indices are mentioned in the provided text.","The direction of market impact (bullish/bearish) beyond the oil-price rise is not specified."],"key_facts":["TheStreet Pro headline states: \"8 Key Items Shaping the Stock Market Thursday.\"","The headline includes: \"Oil Prices Back on the Rise.\"","No additional of the other seven items are provided in the supplied text."],"numeric_claims":[],"primary_claim":"Oil prices are back on the rise, and this is listed as one of eight key items shaping the stock market Thursday.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"TheStreet Pro headline indicates that oil prices are rising and are one of several factors expected to influence the stock market on Thursday.","topics":["stock market outlook","oil prices","market drivers"]},"source":"TheStreet Pro","source_domain":"pro.thestreet.com","source_url":"https://pro.thestreet.com","summary":"","tickers":[],"title":"8 Key Items Shaping the Stock Market Thursday: Oil Prices Back on the Rise - TheStreet Pro","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_963ced1170e9 in signals