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/new-strong-sell-stocks-april-9th","as_of":"2026-04-09T10:38:52.980302+00:00","canonical_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-9th","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-9th","article_chars":2978,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a933ea414efd3378","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-9th","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:17:05.610274+00:00","extraction_method":"heuristic","fetched_description":"CSIQ, ARMP and DAR have been added to the Zacks Rank #5 (Strong Sell) List on April 9, 2025.","fetched_title":"New Strong Sell Stocks for April 9th | Nasdaq","final_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-9th","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-9th","source_event_id":"evt_6b7f1906f36c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fe8e51bf6221f7ab","kind":"new_listings","published_at":"2026-04-09T09:11:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 9, 2026","April 09, 2025","last 60 days"],"entities":[{"asset_class":"equity","name":"Canadian Solar Inc.","relevance":"high","symbol":"CSIQ","type":"company"},{"asset_class":"equity","name":"Armata Pharmaceuticals, Inc.","relevance":"high","symbol":"ARMP","type":"company"},{"asset_class":"equity","name":"Darling Ingredients Inc.","relevance":"high","symbol":"DAR","type":"company"}],"event_type":"listing","information_gaps":["The provided headline mentions APLD, EPC, and OPAL, but the cleaned article text only discusses CSIQ, ARMP, and DAR; the discrepancy is not resolved in the provided text.","The article text does not provide the full Zacks Rank #5 list contents or confirm whether APLD/EPC/OPAL are included elsewhere.","No specific rationale beyond earnings estimate revisions is provided for the Strong Sell additions in the excerpt."],"key_facts":["The article says three stocks were added to the Zacks Rank #5 (Strong Sell) list on April 9, 2026: CSIQ, ARMP, and DAR.","CSIQ: Zacks Consensus Estimate for current-year earnings revised 93.4% downward over the last 60 days.","ARMP: Zacks Consensus Estimate for current-year earnings revised 14.1% downward over the last 60 days.","DAR: Zacks Consensus Estimate for current-year earnings revised almost 11.4% downward over the last 60 days.","The article includes a statement: \u201cView the entire Zacks Rank #5 List.\u201d"],"numeric_claims":[{"label":"CSIQ earnings estimate revision (downward, last 60 days)","value":"93.4%"},{"label":"ARMP earnings estimate revision (downward, last 60 days)","value":"14.1%"},{"label":"DAR earnings estimate revision (downward, last 60 days)","value":"almost 11.4%"}],"primary_claim":"CSIQ, ARMP, and DAR were added to the Zacks Rank #5 (Strong Sell) list on April 9, 2026, with current-year earnings consensus estimates revised downward over the last 60 days.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"On April 9, 2026, Zacks added three stocks to its Zacks Rank #5 (Strong Sell) list: CSIQ, ARMP, and DAR. The article also states that each stock\u2019s current-year earnings consensus estimate was revised downward over the prior 60 days.","topics":["Zacks Rank #5 (Strong Sell)","earnings estimate revisions","equity research","stocks added to list"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"APLD, EPC and OPAL have been added to the Zacks Rank #5 (Strong Sell) List on April 9, 2026.","tickers":[],"title":"New Strong Sell Stocks for April 9th","url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-9th"}

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