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/CBMinAFBVV95cUxQOVFqRm9tUWx6WEljeGIwTDZDcU9TcnJGRmppZFBSZzZJemhYaUM2Tk9wTTd4dlMzZXlrNU5pcEVWTjVJb0U4R2U5SWtOOVRnMEhkRHhiSWE0MW55WnFoeGQ5a2kxZ0FuMXpaR0tTSkQxSnlmaWZ2S0VQV3Nmcmp2QWNkWEZEMmxINDAzUEpqZFRkcVNLTGxmMEM4eUU?oc=5","as_of":"2026-04-10T04:36:21.543055+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/CBMinAFBVV95cUxQOVFqRm9tUWx6WEljeGIwTDZDcU9TcnJGRmppZFBSZzZJemhYaUM2Tk9wTTd4dlMzZXlrNU5pcEVWTjVJb0U4R2U5SWtOOVRnMEhkRHhiSWE0MW55WnFoeGQ5a2kxZ0FuMXpaR0tTSkQxSnlmaWZ2S0VQV3Nmcmp2QWNkWEZEMmxINDAzUEpqZFRkcVNLTGxmMEM4eUU?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_35bc24a0c5296222","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-10T04:37:01.468216+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxQOVFqRm9tUWx6WEljeGIwTDZDcU9TcnJGRmppZFBSZzZJemhYaUM2Tk9wTTd4dlMzZXlrNU5pcEVWTjVJb0U4R2U5SWtOOVRnMEhkRHhiSWE0MW55WnFoeGQ5a2kxZ0FuMXpaR0tTSkQxSnlmaWZ2S0VQV3Nmcmp2QWNkWEZEMmxINDAzUEpqZFRkcVNLTGxmMEM4eUU?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxQOVFqRm9tUWx6WEljeGIwTDZDcU9TcnJGRmppZFBSZzZJemhYaUM2Tk9wTTd4dlMzZXlrNU5pcEVWTjVJb0U4R2U5SWtOOVRnMEhkRHhiSWE0MW55WnFoeGQ5a2kxZ0FuMXpaR0tTSkQxSnlmaWZ2S0VQV3Nmcmp2QWNkWEZEMmxINDAzUEpqZFRkcVNLTGxmMEM4eUU?oc=5","source_event_id":"evt_9278cc6941a1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ef65b3305343ed45","published_at":"2026-04-10T03:50:00+00:00","publisher_domain":"finance.yahoo.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"},{"asset_class":"equity","name":"Circle","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Bullish","relevance":"medium","symbol":"","type":"company"}],"event_type":"price_action","information_gaps":["The provided article text contains only CSS/HTML styling and does not include the actual article content.","No specific tickers for Circle or Bullish are provided in the provided text.","No details are given on what \u201creclaims\u201d means operationally (e.g., intraday vs. close) or the timeframe.","No supporting fundamentals or specific fundamental metrics are included in the provided text."],"key_facts":["Headline states: \u201cBTC Reclaims $72K\u201d.","Headline states: \u201cCircle and Bullish Remind the Market That Crypto Stocks Still Trade on Fundamentals\u201d.","No additional article details are present in the provided text beyond the headline and metadata."],"numeric_claims":[{"label":"BTC price level","value":"72000"}],"primary_claim":"BTC has reclaimed $72K, and the article argues that crypto stocks (via Circle and Bullish) trade on fundamentals rather than solely on BTC price.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The headline says Bitcoin has reclaimed the $72K level, while Circle and Bullish are presented as reminders that crypto-related stocks still move based on fundamentals.","topics":["Bitcoin price level","$72K reclaim","crypto stocks","fundamentals","Circle","Bullish"]},"source":"Yahoo Finance","source_domain":"finance.yahoo.com","source_url":"https://finance.yahoo.com","summary":"","tickers":[],"title":"BTC Reclaims $72K, but Circle and Bullish Remind the Market That Crypto Stocks Still Trade on Fundamentals - Yahoo Finance","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_e4e414057c04 in signals