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/CBMiogFBVV95cUxQMWZwZWtuN2xXUXBlaHJ1R1JZSDFoWGVVVzlYMHA3YkVGajVxdHZDUUJkbmxycnRSaFlSYjJFNEpva3Z2ZXc3M1ZZMnVNYm5WS1FjQWdvT05kclp1TjkweDlOVG5lWnVCWkRFc0FUcTF5SjRZMzRQYlZOTERDaFVjZXJ1VFlTVC03NUdHT0d0SlBzX0lQYlZYdWpnVFRlUTJ4LWc?oc=5","as_of":"2026-04-14T16:35:17.700150+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxQMWZwZWtuN2xXUXBlaHJ1R1JZSDFoWGVVVzlYMHA3YkVGajVxdHZDUUJkbmxycnRSaFlSYjJFNEpva3Z2ZXc3M1ZZMnVNYm5WS1FjQWdvT05kclp1TjkweDlOVG5lWnVCWkRFc0FUcTF5SjRZMzRQYlZOTERDaFVjZXJ1VFlTVC03NUdHT0d0SlBzX0lQYlZYdWpnVFRlUTJ4LWc?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6e90b74548f788af","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T17:18:44.364685+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxQMWZwZWtuN2xXUXBlaHJ1R1JZSDFoWGVVVzlYMHA3YkVGajVxdHZDUUJkbmxycnRSaFlSYjJFNEpva3Z2ZXc3M1ZZMnVNYm5WS1FjQWdvT05kclp1TjkweDlOVG5lWnVCWkRFc0FUcTF5SjRZMzRQYlZOTERDaFVjZXJ1VFlTVC03NUdHT0d0SlBzX0lQYlZYdWpnVFRlUTJ4LWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investopedia.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxQMWZwZWtuN2xXUXBlaHJ1R1JZSDFoWGVVVzlYMHA3YkVGajVxdHZDUUJkbmxycnRSaFlSYjJFNEpva3Z2ZXc3M1ZZMnVNYm5WS1FjQWdvT05kclp1TjkweDlOVG5lWnVCWkRFc0FUcTF5SjRZMzRQYlZOTERDaFVjZXJ1VFlTVC03NUdHT0d0SlBzX0lQYlZYdWpnVFRlUTJ4LWc?oc=5","source_event_id":"evt_fca338a3d656","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"a823ba182c6e8f74","published_at":"2026-04-14T11:30:00+00:00","publisher_domain":"investopedia.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"TSMC","relevance":"high","symbol":"TSM","type":"company"}],"event_type":"earnings","information_gaps":["The expected move magnitude (e.g., percent or range) is not provided.","The earnings date/timeframe and whether it refers to a specific upcoming or past earnings event are not provided.","No methodology (e.g., implied move, options pricing) or supporting figures are included.","No other entities (e.g., analysts, options market metrics) are mentioned in the provided text."],"key_facts":["Headline references an Investopedia piece: \u201cHere's How Much TSMC Stock Is Expected to Move After Earnings.\u201d","No article body, numeric estimate, or specific earnings date is included in the provided text."],"numeric_claims":[],"primary_claim":"Investopedia is publishing an article estimating how much TSMC stock is expected to move after earnings.","relevance_score":0.55,"sentiment":"neutral","source_quality":"unknown","summary":"The signal indicates an Investopedia article discussing the expected magnitude of TSMC\u2019s stock move following its earnings release. No additional earnings details, figures, or timing are provided in the provided text.","topics":["earnings","stock price move expectation","TSMC"]},"source":"Investopedia","source_domain":"investopedia.com","source_url":"https://www.investopedia.com","summary":"Here's How Much TSMC Stock Is Expected to Move After Earnings Investopedia","title":"Here's How Much TSMC Stock Is Expected to Move After Earnings - Investopedia","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.z46LtA-qfIg.L.X.O/am=GAIFAACAA2YBAwpA/d=1/ed=1/rs=ALs0n2PeUbKSDKfQ9Op-3wUE_8hlNgDpuA/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_74dfb4d8a3da in signals