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/CBMingFBVV95cUxNOGhZQ1A1dmVLbDdtQzNMc1FhTnFwcklsOEJHdHJFRm96VmIzSWoyT1hPZVJuVW9MTXA1NjR5NHRYeDhGd1JRa3d4eHo3Vm00T2F2Q1RlY1Vpbm9TY2NfclRUbGVmQUZuRWxxc1pmLVRoTEpjTzRvQWRzdVJBcEpWbXRYVzVpUF9PV1lmemJSRWw1bjIwR1BXTnlYWGpUdw?oc=5","as_of":"2026-04-11T21:52:09.397687+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/CBMingFBVV95cUxNOGhZQ1A1dmVLbDdtQzNMc1FhTnFwcklsOEJHdHJFRm96VmIzSWoyT1hPZVJuVW9MTXA1NjR5NHRYeDhGd1JRa3d4eHo3Vm00T2F2Q1RlY1Vpbm9TY2NfclRUbGVmQUZuRWxxc1pmLVRoTEpjTzRvQWRzdVJBcEpWbXRYVzVpUF9PV1lmemJSRWw1bjIwR1BXTnlYWGpUdw?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_eba527fc31917a01","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-11T22:50:59.740645+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMingFBVV95cUxNOGhZQ1A1dmVLbDdtQzNMc1FhTnFwcklsOEJHdHJFRm96VmIzSWoyT1hPZVJuVW9MTXA1NjR5NHRYeDhGd1JRa3d4eHo3Vm00T2F2Q1RlY1Vpbm9TY2NfclRUbGVmQUZuRWxxc1pmLVRoTEpjTzRvQWRzdVJBcEpWbXRYVzVpUF9PV1lmemJSRWw1bjIwR1BXTnlYWGpUdw?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/CBMingFBVV95cUxNOGhZQ1A1dmVLbDdtQzNMc1FhTnFwcklsOEJHdHJFRm96VmIzSWoyT1hPZVJuVW9MTXA1NjR5NHRYeDhGd1JRa3d4eHo3Vm00T2F2Q1RlY1Vpbm9TY2NfclRUbGVmQUZuRWxxc1pmLVRoTEpjTzRvQWRzdVJBcEpWbXRYVzVpUF9PV1lmemJSRWw1bjIwR1BXTnlYWGpUdw?oc=5","source_event_id":"evt_f9f2be75159f","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"b8f8510d30fafd51","published_at":"2026-04-11T21:11:15+00:00","publisher_domain":"aol.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"mentioned in headline as an investment option","symbol":"BTC","type":"asset"},{"asset_class":"cryptocurrency basket","name":"Diversified basket of cryptocurrencies","relevance":"mentioned in headline as an alternative investment option","symbol":"","type":"asset_class_or_strategy"}],"event_type":"other","information_gaps":["No article text or source summary is provided, so no claims about performance, forecasts, catalysts, or market direction can be extracted.","No tickers beyond the generic mention of Bitcoin are explicitly provided in the text.","No indication of trend continuation vs reversal is stated in the available headline alone."],"key_facts":["Headline (AOL.com) asks whether to invest in Bitcoin or a basket of diversified cryptocurrencies."],"numeric_claims":[],"primary_claim":"The headline presents a decision framework: investing in Bitcoin versus investing in a diversified basket of cryptocurrencies.","relevance_score":0.25,"sentiment":"neutral","source_quality":"unknown","summary":"The headline asks whether investors should choose Bitcoin or instead invest in a diversified basket of cryptocurrencies. No market-moving data, price levels, or specific catalysts are provided in the available text.","topics":["cryptocurrency investing","Bitcoin vs diversified crypto basket"]},"source":"AOL.com","source_domain":"aol.com","source_url":"https://www.aol.com","summary":"","tickers":[],"title":"Should You Be Investing in Bitcoin... or a Basket of Diversified Cryptocurrencies? - 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_c5fdb828cb33 in signals