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/CBMi4wFBVV95cUxOOVhTRU1HbVpZbFlMSHlrczR3UXdaN0FqODdNUzBOSkhTTDlmU29UbWJkaWE5U0QyWUI5TlBDQWpBbDV5ZUV5SzdTTmJtT1owb3JzSWdZbk9GYzR5aG9zX09oMjQ1U0w4dWtJdUJlVFN6WE9xU1dPaW50OFpuY2dMTU1HNTR3dzY3emVKZ3Rld1hfaGZ2UFgtSUdYVnF1T0NUbHN3by1EY3FyNEJ2VVAtUzZwOWR6ZVpHMzV1bHpKWG5GWG52VTRqZHg0MUgtTzlEQ3h6RlZzWnpFR3FkaFNJRTQtUQ?oc=5","as_of":"2026-04-09T06:55:01.852019+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/CBMi4wFBVV95cUxOOVhTRU1HbVpZbFlMSHlrczR3UXdaN0FqODdNUzBOSkhTTDlmU29UbWJkaWE5U0QyWUI5TlBDQWpBbDV5ZUV5SzdTTmJtT1owb3JzSWdZbk9GYzR5aG9zX09oMjQ1U0w4dWtJdUJlVFN6WE9xU1dPaW50OFpuY2dMTU1HNTR3dzY3emVKZ3Rld1hfaGZ2UFgtSUdYVnF1T0NUbHN3by1EY3FyNEJ2VVAtUzZwOWR6ZVpHMzV1bHpKWG5GWG52VTRqZHg0MUgtTzlEQ3h6RlZzWnpFR3FkaFNJRTQtUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_880713197fa4a869","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-09T22:45:49.094092+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi4wFBVV95cUxOOVhTRU1HbVpZbFlMSHlrczR3UXdaN0FqODdNUzBOSkhTTDlmU29UbWJkaWE5U0QyWUI5TlBDQWpBbDV5ZUV5SzdTTmJtT1owb3JzSWdZbk9GYzR5aG9zX09oMjQ1U0w4dWtJdUJlVFN6WE9xU1dPaW50OFpuY2dMTU1HNTR3dzY3emVKZ3Rld1hfaGZ2UFgtSUdYVnF1T0NUbHN3by1EY3FyNEJ2VVAtUzZwOWR6ZVpHMzV1bHpKWG5GWG52VTRqZHg0MUgtTzlEQ3h6RlZzWnpFR3FkaFNJRTQtUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"stocktwits.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi4wFBVV95cUxOOVhTRU1HbVpZbFlMSHlrczR3UXdaN0FqODdNUzBOSkhTTDlmU29UbWJkaWE5U0QyWUI5TlBDQWpBbDV5ZUV5SzdTTmJtT1owb3JzSWdZbk9GYzR5aG9zX09oMjQ1U0w4dWtJdUJlVFN6WE9xU1dPaW50OFpuY2dMTU1HNTR3dzY3emVKZ3Rld1hfaGZ2UFgtSUdYVnF1T0NUbHN3by1EY3FyNEJ2VVAtUzZwOWR6ZVpHMzV1bHpKWG5GWG52VTRqZHg0MUgtTzlEQ3h6RlZzWnpFR3FkaFNJRTQtUQ?oc=5","source_event_id":"evt_898a45a6a3a5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"81e75d8a7c1575b5","published_at":"2026-04-09T01:42:12+00:00","publisher_domain":"stocktwits.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.45,"dates_mentioned":[],"entities":[{"asset_class":"crypto","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"asset"},{"asset_class":"equity","name":"Small-Cap Tech Stock","relevance":"high","symbol":"","type":"company"},{"asset_class":"media","name":"Stocktwits","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The specific company name/ticker for the \u201cSmall-Cap Tech Stock\u201d is not provided in the provided text.","The meaning/details of \u201cBitcoin Quantum Upgrade\u201d are not explained in the provided text.","No evidence is provided for what \u201crising industry risks\u201d refers to (e.g., regulatory, technical, competitive) or how it impacts the bet.","No article body content is available beyond the headline; therefore, the claim\u2019s underlying facts cannot be verified here."],"key_facts":["Headline states \u201cSmall-Cap Tech Stock Bets $400M On Bitcoin Quantum Upgrade.\u201d","Headline states this is \u201camid Rising Industry Risks.\u201d","Source is labeled as Stocktwits."],"numeric_claims":[{"label":"Bet size","value":"$400M"}],"primary_claim":"A small-cap tech stock is betting $400M on a Bitcoin quantum upgrade amid rising industry risks.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"A Stocktwits headline claims a small-cap tech stock is making a $400M bet on a Bitcoin-related \u201cquantum upgrade\u201d while noting rising industry risks.","topics":["Bitcoin","quantum upgrade","small-cap tech","industry risks","investment/bets","market sentiment"]},"source":"Stocktwits","source_domain":"stocktwits.com","source_url":"https://stocktwits.com","summary":"","tickers":[],"title":"Small-Cap Tech Stock Bets $400M On Bitcoin Quantum Upgrade Amid Rising Industry Risks - Stocktwits","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_f073bf8744a7 in signals