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/CBMieEFVX3lxTE1laC13TTJheUNkVHBiYk5xVXJIdE5NUU9HbFFHSXJzNU9KdkJwSkYweG9Id1owdnhweEt6bVFrbnpJV1BHdnY4dWxMYmt6ZVhNWko0QjR0VG5UTFdTT3dQNlNzSjhaaEFjanJzVnFUMUMxbnBpeG5ubA?oc=5","as_of":"2026-04-11T18:52:10.023387+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/CBMieEFVX3lxTE1laC13TTJheUNkVHBiYk5xVXJIdE5NUU9HbFFHSXJzNU9KdkJwSkYweG9Id1owdnhweEt6bVFrbnpJV1BHdnY4dWxMYmt6ZVhNWko0QjR0VG5UTFdTT3dQNlNzSjhaaEFjanJzVnFUMUMxbnBpeG5ubA?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_3af97494b4ef0c2b","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:38:17.367508+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMieEFVX3lxTE1laC13TTJheUNkVHBiYk5xVXJIdE5NUU9HbFFHSXJzNU9KdkJwSkYweG9Id1owdnhweEt6bVFrbnpJV1BHdnY4dWxMYmt6ZVhNWko0QjR0VG5UTFdTT3dQNlNzSjhaaEFjanJzVnFUMUMxbnBpeG5ubA?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/CBMieEFVX3lxTE1laC13TTJheUNkVHBiYk5xVXJIdE5NUU9HbFFHSXJzNU9KdkJwSkYweG9Id1owdnhweEt6bVFrbnpJV1BHdnY4dWxMYmt6ZVhNWko0QjR0VG5UTFdTT3dQNlNzSjhaaEFjanJzVnFUMUMxbnBpeG5ubA?oc=5","source_event_id":"evt_5aaef1437eb6","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"d56f5cc92c2c1294","published_at":"2026-04-11T17:29:41+00:00","publisher_domain":"aol.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"MARA","relevance":"high","symbol":"MARA","type":"company"},{"asset_class":"cryptocurrency","name":"Bitcoin","relevance":"high","symbol":"BTC","type":"cryptoasset"}],"event_type":"price_action","information_gaps":["No article text is available, so the rationale, timing, and market impact of the sale are not provided.","No confirmation is given in the provided text about whether the sale has already occurred or when it occurred.","No details are provided about transaction price, proceeds, or how this affects MARA\u2019s future operations."],"key_facts":["Headline states MARA sold 15,133 Bitcoins.","Headline frames the sale as a move to \u201cescape the mining trap.\u201d","Headline states \u201cNow Comes the Hard Part,\u201d implying a subsequent challenge."],"numeric_claims":[{"label":"Bitcoins sold","value":"15,133"}],"primary_claim":"MARA sold 15,133 Bitcoins to escape the mining trap, and the headline implies the next phase will be harder.","relevance_score":0.62,"sentiment":"mixed","source_quality":"unknown","summary":"The headline claims that MARA sold 15,133 Bitcoins to avoid a \u201cmining trap,\u201d and suggests that a more difficult phase is next. No additional article details are provided.","topics":["Bitcoin","MARA","crypto mining","asset sales","market-moving headline"]},"source":"AOL.com","source_domain":"aol.com","source_url":"https://www.aol.com","summary":"","tickers":[],"title":"MARA Sold 15,133 Bitcoins to Escape the Mining Trap. Now Comes the Hard Part - 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_0f0514b5a6c3 in signals