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/CBMigAFBVV95cUxOYTNQVGhURHloNjRmenpVaTk4VF9TUkFYRF9EZm41QlBDS0VfWTNfdVI0dDk1UU1qTERWYWt4bW5XMTVVVTE2ekNRVmlUMW1LUVZqNktkdzh2akpJb2J1SXY0VWhTSll4SGVtRUZhZFREUVVnRVdfeGdYU3R4eTlzYQ?oc=5","as_of":"2026-04-08T12:08:42.000109+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/CBMigAFBVV95cUxOYTNQVGhURHloNjRmenpVaTk4VF9TUkFYRF9EZm41QlBDS0VfWTNfdVI0dDk1UU1qTERWYWt4bW5XMTVVVTE2ekNRVmlUMW1LUVZqNktkdzh2akpJb2J1SXY0VWhTSll4SGVtRUZhZFREUVVnRVdfeGdYU3R4eTlzYQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b5e807b9885636aa","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-08T12:09:34.126891+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxOYTNQVGhURHloNjRmenpVaTk4VF9TUkFYRF9EZm41QlBDS0VfWTNfdVI0dDk1UU1qTERWYWt4bW5XMTVVVTE2ekNRVmlUMW1LUVZqNktkdzh2akpJb2J1SXY0VWhTSll4SGVtRUZhZFREUVVnRVdfeGdYU3R4eTlzYQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"aol.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigAFBVV95cUxOYTNQVGhURHloNjRmenpVaTk4VF9TUkFYRF9EZm41QlBDS0VfWTNfdVI0dDk1UU1qTERWYWt4bW5XMTVVVTE2ekNRVmlUMW1LUVZqNktkdzh2akpJb2J1SXY0VWhTSll4SGVtRUZhZFREUVVnRVdfeGdYU3R4eTlzYQ?oc=5","source_event_id":"evt_b90f4556812f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5a70c5214b96f6be","published_at":"2026-04-08T10:40:50+00:00","publisher_domain":"aol.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"other","information_gaps":["No article body text was provided (the cleaned content appears to be HTML/CSS), so the specific reasons behind the bull case are unknown.","No market context (e.g., current price, timeframe, catalysts) is available from the provided text.","No additional tickers or tradable instruments besides Bitcoin are mentioned in the provided content."],"key_facts":["Headline: \u201cThe Bull Case for Bitcoin That Has Nothing to Do With Price Predictions - AOL.com\u201d.","The headline indicates the bull case is not based on price predictions."],"numeric_claims":[],"primary_claim":"The article presents a bull case for Bitcoin that has nothing to do with price predictions.","relevance_score":0.45,"sentiment":"positive","source_quality":"high","summary":"AOL.com published an article framed as a \u201cbull case\u201d for Bitcoin, explicitly stating it is not based on price predictions. The headline suggests the argument is about fundamentals or other factors rather than forecasting Bitcoin\u2019s price.","topics":["Bitcoin","bull case","price predictions","investment thesis"]},"source":"AOL.com","source_domain":"aol.com","source_url":"https://www.aol.com","summary":"","tickers":[],"title":"The Bull Case for Bitcoin That Has Nothing to Do With Price Predictions - AOL.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_52ddffb63989 in signals