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/CBMixAFBVV95cUxNd2R4aWtNcXFPOFFLWVpXbG5HcFI5aWMxWndyQmtMcmFqUUxfcjJrN1JvTXZyeXhuQ194WXRZRkp4ek1kLXpZaE5FY0FJU3FVcUlDd2hwb0FxZl9MMzMwaDRJNnllSTA0cXk3Nm40R3N0eVY0czFjR2hSME9FN0pmNFp1Tkp3Skt1dU80UFJRQUlhR1RsT2hBV190RVkwS2ZUdzVoYnZ5c3BsZEY4VGtmbTJFRkg0NEFlcXdoN0M4eWJIRk02?oc=5","as_of":"2026-04-08T19:34:44.183568+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/CBMixAFBVV95cUxNd2R4aWtNcXFPOFFLWVpXbG5HcFI5aWMxWndyQmtMcmFqUUxfcjJrN1JvTXZyeXhuQ194WXRZRkp4ek1kLXpZaE5FY0FJU3FVcUlDd2hwb0FxZl9MMzMwaDRJNnllSTA0cXk3Nm40R3N0eVY0czFjR2hSME9FN0pmNFp1Tkp3Skt1dU80UFJRQUlhR1RsT2hBV190RVkwS2ZUdzVoYnZ5c3BsZEY4VGtmbTJFRkg0NEFlcXdoN0M4eWJIRk02?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0d07a4d3f69c570e","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-09T15:37:11.756485+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxNd2R4aWtNcXFPOFFLWVpXbG5HcFI5aWMxWndyQmtMcmFqUUxfcjJrN1JvTXZyeXhuQ194WXRZRkp4ek1kLXpZaE5FY0FJU3FVcUlDd2hwb0FxZl9MMzMwaDRJNnllSTA0cXk3Nm40R3N0eVY0czFjR2hSME9FN0pmNFp1Tkp3Skt1dU80UFJRQUlhR1RsT2hBV190RVkwS2ZUdzVoYnZ5c3BsZEY4VGtmbTJFRkg0NEFlcXdoN0M4eWJIRk02?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMixAFBVV95cUxNd2R4aWtNcXFPOFFLWVpXbG5HcFI5aWMxWndyQmtMcmFqUUxfcjJrN1JvTXZyeXhuQ194WXRZRkp4ek1kLXpZaE5FY0FJU3FVcUlDd2hwb0FxZl9MMzMwaDRJNnllSTA0cXk3Nm40R3N0eVY0czFjR2hSME9FN0pmNFp1Tkp3Skt1dU80UFJRQUlhR1RsT2hBV190RVkwS2ZUdzVoYnZ5c3BsZEY4VGtmbTJFRkg0NEFlcXdoN0M4eWJIRk02?oc=5","source_event_id":"evt_46273e87405b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0da16cc54f16b317","published_at":"2026-04-08T15:59:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"Morgan Stanley","relevance":"high","symbol":"","type":"company"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptoasset"},{"asset_class":"other","name":"The New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"etf","name":"Morgan Stanley ETF","relevance":"high","symbol":"","type":"financial_product"},{"asset_class":"cryptocurrency","name":"Cryptos","relevance":"medium","symbol":"","type":"asset_class"}],"event_type":"listing","information_gaps":["No article body content was provided (only cleaned HTML/CSS), so details of the ETF (ticker, structure, launch date, underlying assets) are not available.","No specifics are provided about what The New York Times identified regarding Bitcoin\u2019s creator.","No quantitative market move (percent change, timeframe) is included in the provided text."],"key_facts":["Headline states: \u201cMorgan Stanley Launches ETF\u201d","Headline states: \u201cCryptos Rally\u201d","Headline includes: \u201cDid The NYT Identify Bitcoin's Creator?\u201d"],"numeric_claims":[],"primary_claim":"Morgan Stanley is launching an ETF, and cryptos are rallying in response, per the investors.com headline.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"The investors.com headline links a Morgan Stanley ETF launch to a crypto rally and also references a claim about Bitcoin\u2019s creator being identified by The New York Times.","topics":["ETF launch","cryptocurrency rally","Bitcoin","media claim about Bitcoin creator"]},"source":"investors.com","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"","tickers":[],"title":"Did The NYT Identify Bitcoin's Creator? Morgan Stanley Launches ETF, Cryptos Rally. - investors.com","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_b5945703c956 in signals