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/CBMi6gFBVV95cUxQTDh4MTBxSWFCdlZXS3JXclhhcDNPRGtIWGpkb0pxVWQzWEVzZUhLX0ZKNnBJbFhDeko3M2Z5WG5wWUR6NmJfUDc2VEtQOXNvQlBVRXdWVDZTbXlfa2VaNTlyVjlLNllqc2dILWlObWVMTjdOd0FfdERLQ21POXctMnFUZm1xUWdhMkhVekJnWEtrZHQtRHY5bllNYjFlZmhybzZFbmlGZEZzdGtFNmFUV25ZVFg0dzhiSjhlaEMzSGxBbmFEWk95MGsxQmxSZFVFeUVzd3BiVjJWcnRWU2EzdGoyS2dsR3hkT0E?oc=5","as_of":"2026-04-10T06:41:40.422215+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/CBMi6gFBVV95cUxQTDh4MTBxSWFCdlZXS3JXclhhcDNPRGtIWGpkb0pxVWQzWEVzZUhLX0ZKNnBJbFhDeko3M2Z5WG5wWUR6NmJfUDc2VEtQOXNvQlBVRXdWVDZTbXlfa2VaNTlyVjlLNllqc2dILWlObWVMTjdOd0FfdERLQ21POXctMnFUZm1xUWdhMkhVekJnWEtrZHQtRHY5bllNYjFlZmhybzZFbmlGZEZzdGtFNmFUV25ZVFg0dzhiSjhlaEMzSGxBbmFEWk95MGsxQmxSZFVFeUVzd3BiVjJWcnRWU2EzdGoyS2dsR3hkT0E?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bcc542f0147c90b8","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-10T06:42:28.942992+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi6gFBVV95cUxQTDh4MTBxSWFCdlZXS3JXclhhcDNPRGtIWGpkb0pxVWQzWEVzZUhLX0ZKNnBJbFhDeko3M2Z5WG5wWUR6NmJfUDc2VEtQOXNvQlBVRXdWVDZTbXlfa2VaNTlyVjlLNllqc2dILWlObWVMTjdOd0FfdERLQ21POXctMnFUZm1xUWdhMkhVekJnWEtrZHQtRHY5bllNYjFlZmhybzZFbmlGZEZzdGtFNmFUV25ZVFg0dzhiSjhlaEMzSGxBbmFEWk95MGsxQmxSZFVFeUVzd3BiVjJWcnRWU2EzdGoyS2dsR3hkT0E?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theglobeandmail.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi6gFBVV95cUxQTDh4MTBxSWFCdlZXS3JXclhhcDNPRGtIWGpkb0pxVWQzWEVzZUhLX0ZKNnBJbFhDeko3M2Z5WG5wWUR6NmJfUDc2VEtQOXNvQlBVRXdWVDZTbXlfa2VaNTlyVjlLNllqc2dILWlObWVMTjdOd0FfdERLQ21POXctMnFUZm1xUWdhMkhVekJnWEtrZHQtRHY5bllNYjFlZmhybzZFbmlGZEZzdGtFNmFUV25ZVFg0dzhiSjhlaEMzSGxBbmFEWk95MGsxQmxSZFVFeUVzd3BiVjJWcnRWU2EzdGoyS2dsR3hkT0E?oc=5","source_event_id":"evt_0edad0398f9f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c2419485cee3bbb0","published_at":"2026-04-10T05:54:14+00:00","publisher_domain":"theglobeandmail.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"}],"event_type":"price_action","information_gaps":["No article body text was provided, so the underlying data source/method (survey, on-chain metrics, timeframe) for the \u201cnearly 50%\u201d figure is unknown.","The headline is truncated/ambiguous at the end (\u201cMight Be Too\u201d); the exact phrasing/meaning (e.g., \u201cmight be too\u201d as in \u201cmight be thinking about selling too\u201d) cannot be fully verified from the provided text.","No market price move, timeframe, or confirmation of actual selling activity is included\u2014only the possibility of selling intent."],"key_facts":["Headline states: \u201cThinking About Selling Your Bitcoin? Nearly 50% of Holders Might Be Too.\u201d","Implied audience: Bitcoin holders considering selling."],"numeric_claims":[{"label":"Share of holders considering selling","value":"Nearly 50%"}],"primary_claim":"Nearly 50% of Bitcoin holders might be too (i.e., might be thinking about selling).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The Globe and Mail headline suggests that nearly half of Bitcoin holders may consider selling, implying elevated potential selling pressure among holders.","topics":["Bitcoin","holder sentiment","potential selling pressure"]},"source":"The Globe and Mail","source_domain":"theglobeandmail.com","source_url":"https://www.theglobeandmail.com","summary":"","tickers":[],"title":"Thinking About Selling Your Bitcoin? Nearly 50% of Holders Might Be Too. - The Globe and Mail","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_51318fadba98 in signals