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/CBMickFVX3lxTFBWcGpRajhtRWtKSnhLSHduTGZXVGxDajVhWDVXX2pOTnlnV3Nrb2pULU9UdEd1eTREdjc5b2l0dmV6ZDhhVVRYLUM5bVdqbGhuS20wX0d2X0Y0OU9tU2RUT3BWR19hTGp2THREZ20wTGtNQQ?oc=5","as_of":"2026-04-10T17:15:05.637152+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/CBMickFVX3lxTFBWcGpRajhtRWtKSnhLSHduTGZXVGxDajVhWDVXX2pOTnlnV3Nrb2pULU9UdEd1eTREdjc5b2l0dmV6ZDhhVVRYLUM5bVdqbGhuS20wX0d2X0Y0OU9tU2RUT3BWR19hTGp2THREZ20wTGtNQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_fe44ffa1ad3fab63","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-10T17:17:43.170676+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMickFVX3lxTFBWcGpRajhtRWtKSnhLSHduTGZXVGxDajVhWDVXX2pOTnlnV3Nrb2pULU9UdEd1eTREdjc5b2l0dmV6ZDhhVVRYLUM5bVdqbGhuS20wX0d2X0Y0OU9tU2RUT3BWR19hTGp2THREZ20wTGtNQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMickFVX3lxTFBWcGpRajhtRWtKSnhLSHduTGZXVGxDajVhWDVXX2pOTnlnV3Nrb2pULU9UdEd1eTREdjc5b2l0dmV6ZDhhVVRYLUM5bVdqbGhuS20wX0d2X0Y0OU9tU2RUT3BWR19hTGp2THREZ20wTGtNQQ?oc=5","source_event_id":"evt_736bce07aab8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"75442c3ba4e43855","published_at":"2026-04-10T16:06:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equities (gold-related)","name":"Gold stocks","relevance":"high","symbol":"","type":"asset_class"}],"event_type":"price_action","information_gaps":["The specific \u201celite list\u201d name/rules are not provided in the provided text.","No tickers or company names for the gold stocks are included.","No timing details (exact dates) for the hiatus or rejoining are provided.","No stated reason/catalyst for the rejoining is included in the provided text."],"key_facts":["The headline states that gold stocks \u201cquickly rejoin\u201d an \u201celite list.\u201d","The headline says this occurred after a \u201cbrief hiatus.\u201d","The source is Investor's Business Daily (investors.com)."],"numeric_claims":[],"primary_claim":"Gold stocks rejoined an \u201celite list\u201d after a brief hiatus, according to Investor's Business Daily.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"Investor's Business Daily reports that gold-related stocks have returned to an \u201celite list\u201d after a short period away.","topics":["gold stocks","elite list","market/stock screening"]},"source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Gold Stocks Quickly Rejoin This Elite List After A Brief Hiatus Investor's Business Daily","title":"Gold Stocks Quickly Rejoin This Elite List After A Brief Hiatus - Investor's Business Daily","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_39cd24bd4cee in signals