SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/5-bargain-stocks-low-price-sales-set-deliver-strong-upside","as_of":"2026-04-14T13:14:01.410660+00:00","canonical_url":"https://www.nasdaq.com/articles/5-bargain-stocks-low-price-sales-set-deliver-strong-upside","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/5-bargain-stocks-low-price-sales-set-deliver-strong-upside","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e44b4d7c74ee06be","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/5-bargain-stocks-low-price-sales-set-deliver-strong-upside","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-14T13:21:59.086640+00:00","extraction_method":"trafilatura","fetched_description":"Low price-to-sales stocks like SPB, AHKSY, APLE, PAM and FAF highlight bargain opportunities, with screening criteria pointing to undervalued companies poised for upside.","fetched_title":"5 Bargain Stocks With Low Price-to-Sales Set to Deliver Strong Upside | Nasdaq","final_url":"https://www.nasdaq.com/articles/5-bargain-stocks-low-price-sales-set-deliver-strong-upside","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/5-bargain-stocks-low-price-sales-set-deliver-strong-upside","source_event_id":"evt_87d1be65a06a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0257c7644c7925f4","kind":"new_listings","published_at":"2026-04-14T11:42:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Spectrum Brands Holdings, Inc.","relevance":"high","symbol":"SPB","type":"company"},{"asset_class":"equity","name":"Asahi Kasei Corporation","relevance":"high","symbol":"AHKSY","type":"company"},{"asset_class":"equity","name":"Apple Hospitality REIT, Inc.","relevance":"high","symbol":"APLE","type":"company"},{"asset_class":"equity","name":"Pampa Energia S.A.","relevance":"high","symbol":"PAM","type":"company"},{"asset_class":"equity","name":"First American Financial Corporation","relevance":"high","symbol":"FAF","type":"company"}],"event_type":"listing","information_gaps":["The signal type is labeled discovery_new_listings_delta, but the provided article text does not describe any new listings or listing changes; it appears to be a valuation/screening article.","The article excerpt does not provide the actual numeric P/S, P/E, P/B, or debt-to-equity values for each of the five companies.","The excerpt cuts off mid-sentence in the AHKSY section (\u201cIts healthcare s\u201d), so details for the remaining companies (AHKSY, APLE, PAM, FAF) are incomplete.","The article\u2019s claim of \u201cstrong upside\u201d is not quantified in the provided text (no target prices, return estimates, or time horizon are shown)."],"key_facts":["The article states that price-to-sales (P/S) compares market capitalization to revenues and is useful when earnings are minimal or volatile.","The article states that a P/S ratio below 1 is described as a \u201cgood bargain\u201d because investors pay less than $1 per $1 of revenue.","The article lists five companies described as having low P/S ratios: SPB, AHKSY, APLE, PAM, and FAF.","The article provides screening parameters including: P/S less than the industry median; P/E (F(1) estimate) less than the industry median; P/B (common equity) less than the industry median; debt-to-equity (most recent) less than the industry median; current price >= $5; Zacks Rank <= #2; and Value Score <= B.","The article states SPB currently has a Zacks Rank of 2 and a Value Score of B.","The article describes Spectrum Brands\u2019 business focus and mentions actions such as shifting supply chain away from China to mitigate rising tariffs and cost-management actions (headcount reductions, elimination of open positions, cuts to discretionary spending, and rightsizing of office/warehouse/distribution space)."],"numeric_claims":[{"label":"Current price threshold","value":"$5 (>= $5)"}],"primary_claim":"The article claims that five specific stocks (SPB, AHKSY, APLE, PAM, and FAF) qualified a screening for low P/S ratios and other value/debt/rank criteria, and are positioned to offer higher returns.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"The article argues that stocks with low price-to-sales (P/S) ratios\u2014screened using additional valuation, debt, price, and Zacks Rank/Value Score criteria\u2014may offer upside potential. It lists five qualifying companies: SPB, AHKSY, APLE, PAM, and FAF.","topics":["valuation metrics","price-to-sales (P/S) ratio","value investing screening","Zacks Rank","Value Score","debt-to-equity","tariffs/inflation headwinds"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"Low price-to-sales stocks like SPB, AHKSY, APLE, PAM and FAF highlight bargain opportunities, with screening criteria pointing to undervalued companies poised for upside.","tickers":[],"title":"5 Bargain Stocks With Low Price-to-Sales Set to Deliver Strong Upside","url":"https://www.nasdaq.com/articles/5-bargain-stocks-low-price-sales-set-deliver-strong-upside"}

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_2183a95d327f in signals