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/CBMi6wFBVV95cUxNZFByVmFUS1lCS25DYm5LRVdUaTdMSEtjcEZyQkd0X2JkT05kWlJ6am1LVnFMUVA1dl9NaWIwcDU2Q3pjYWY4bjhwZTNreXgzV2NYQnpBOXRtaWpGQlFuY0pHVlFPTEZOLWxHVXFpZFRmYjU1VzZucmt6M3ZkWi1HR1dVcHZOOFRyRlFGV001Ums2aXJqaFJXYVhmR1NlODBBQ1RrUUdGNzVKR0lkTDFoSjdzWGtocnRyODFlY001bUFhQlNUa3hReVhyemZMZEtZWU4wWjlzd01OVHlWUzcwYWZZcm5UNzJ5dVl3?oc=5","as_of":"2026-04-08T19:57:42.365437+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/CBMi6wFBVV95cUxNZFByVmFUS1lCS25DYm5LRVdUaTdMSEtjcEZyQkd0X2JkT05kWlJ6am1LVnFMUVA1dl9NaWIwcDU2Q3pjYWY4bjhwZTNreXgzV2NYQnpBOXRtaWpGQlFuY0pHVlFPTEZOLWxHVXFpZFRmYjU1VzZucmt6M3ZkWi1HR1dVcHZOOFRyRlFGV001Ums2aXJqaFJXYVhmR1NlODBBQ1RrUUdGNzVKR0lkTDFoSjdzWGtocnRyODFlY001bUFhQlNUa3hReVhyemZMZEtZWU4wWjlzd01OVHlWUzcwYWZZcm5UNzJ5dVl3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_479ebad75decaa89","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-10T01:00:40.631015+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxNZFByVmFUS1lCS25DYm5LRVdUaTdMSEtjcEZyQkd0X2JkT05kWlJ6am1LVnFMUVA1dl9NaWIwcDU2Q3pjYWY4bjhwZTNreXgzV2NYQnpBOXRtaWpGQlFuY0pHVlFPTEZOLWxHVXFpZFRmYjU1VzZucmt6M3ZkWi1HR1dVcHZOOFRyRlFGV001Ums2aXJqaFJXYVhmR1NlODBBQ1RrUUdGNzVKR0lkTDFoSjdzWGtocnRyODFlY001bUFhQlNUa3hReVhyemZMZEtZWU4wWjlzd01OVHlWUzcwYWZZcm5UNzJ5dVl3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMi6wFBVV95cUxNZFByVmFUS1lCS25DYm5LRVdUaTdMSEtjcEZyQkd0X2JkT05kWlJ6am1LVnFMUVA1dl9NaWIwcDU2Q3pjYWY4bjhwZTNreXgzV2NYQnpBOXRtaWpGQlFuY0pHVlFPTEZOLWxHVXFpZFRmYjU1VzZucmt6M3ZkWi1HR1dVcHZOOFRyRlFGV001Ums2aXJqaFJXYVhmR1NlODBBQ1RrUUdGNzVKR0lkTDFoSjdzWGtocnRyODFlY001bUFhQlNUa3hReVhyemZMZEtZWU4wWjlzd01OVHlWUzcwYWZZcm5UNzJ5dVl3?oc=5","source_event_id":"evt_2d5615c6ab2f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2683cf60d0ee3115","kind":"ipo_calendar","published_at":"2026-04-08T18:46:24+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[],"event_type":"price_action","information_gaps":["Stock name/ticker is not present in the provided text.","The article body content is missing; only CSS/HTML styling is included, so no additional grounded facts (e.g., dates, company details, reasons for decline) can be extracted.","\u201cPenny stock\u201d threshold definition and the current share price are not provided.","The specific \u201c52-week lows\u201d value (price) and the date of that measurement are not provided."],"key_facts":["Headline mentions a \u201c$575 Million IPO\u201d and that the stock became a \u201cpenny stock\u201d in \u201cLess Than a Decade.\u201d","Headline references the stock being at \u201c52-Week Lows.\u201d","The provided article text content is only CSS/HTML styling and does not include the actual article body or the stock ticker/name."],"numeric_claims":[{"label":"IPO size (USD)","value":"575 million"},{"label":"Time from IPO to penny stock","value":"less than a decade"}],"primary_claim":"The article headline states the stock went from a $575 million IPO to a penny stock in less than a decade and is currently at 52-week lows.","relevance_score":0.55,"sentiment":"negative","source_quality":"high","summary":"The Barchart.com headline frames a stock\u2019s decline from a $575 million IPO to a penny stock within less than a decade, and discusses whether there is any hope while the stock is at 52-week lows.","topics":["IPO","penny stock","52-week lows","stock decline","Barchart.com"]},"source":"Barchart.com","source_domain":"gstatic.com","summary":"From $575 Million IPO to Penny Stock in Less Than a Decade: Is There Any Hope Left for This Stock at 52-Week Lows? Barchart.com","tickers":[],"title":"From $575 Million IPO to Penny Stock in Less Than a Decade: Is There Any Hope Left for This Stock at 52-Week Lows? - Barchart.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_e94289e5c766 in signals