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-8th","as_of":"2026-04-08T11:34:02.408899+00:00","canonical_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-8th","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-8th","article_chars":3132,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5e8cfe17b53747bd","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-8th","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T11:38:54.184996+00:00","extraction_method":"heuristic","fetched_description":"AFLYY, AGIO and ARLP have been added to the Zacks Rank #5 (Strong Sell) List on April 8, 2025.","fetched_title":"New Strong Sell Stocks for April 8th | Nasdaq","final_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-8th","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-8th","source_event_id":"evt_ccb7ba569744","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"269552dc611a7f32","kind":"new_listings","published_at":"2026-04-08T09:58:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 8, 2026","April 08, 2025"],"entities":[{"asset_class":"equity","name":"Air France-KLM","relevance":"high","symbol":"AFLYY","type":"company"},{"asset_class":"equity","name":"Agios Pharmaceuticals","relevance":"high","symbol":"AGIO","type":"company"},{"asset_class":"equity","name":"Alliance Resource Partners, L.P.","relevance":"high","symbol":"ARLP","type":"company"}],"event_type":"listing","information_gaps":["The provided text also mentions ALK, FLNC, and JILL in the signal header, but the cleaned article text lists AFLYY, AGIO, and ARLP; the discrepancy is not resolved in the provided text.","The article excerpt does not provide the full Zacks Rank #5 list contents or the criteria beyond the stated earnings estimate revisions.","The excerpt does not specify whether the added stocks are the only changes to the list that day beyond the three named additions."],"key_facts":["The article states that three stocks were added to the Zacks Rank #5 (Strong Sell) list on April 8, 2026.","Air France-KLM (AFLYY): the Zacks Consensus Estimate for its current year earnings was revised 23.1% downward over the last 60 days.","Agios Pharmaceuticals (AGIO): the Zacks Consensus Estimate for its current year earnings was revised 18.9% downward over the last 60 days.","Alliance Resource Partners (ARLP): the Zacks Consensus Estimate for its current year earnings was revised almost 7.9% downward over the last 60 days.","The article includes a link/statement to view the entire Zacks Rank #5 list."],"numeric_claims":[{"label":"Air France-KLM earnings estimate revision (down, last 60 days)","value":"23.1%"},{"label":"Agios Pharmaceuticals earnings estimate revision (down, last 60 days)","value":"18.9%"},{"label":"Alliance Resource Partners earnings estimate revision (down, last 60 days)","value":"~7.9%"}],"primary_claim":"Air France-KLM (AFLYY), Agios Pharmaceuticals (AGIO), and Alliance Resource Partners (ARLP) were added to the Zacks Rank #5 (Strong Sell) list on April 8, 2026.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"On April 8, 2026, Zacks added three stocks to its Zacks Rank #5 (Strong Sell) list: Air France-KLM, Agios Pharmaceuticals, and Alliance Resource Partners.","topics":["Zacks Rank #5 (Strong Sell)","earnings estimate revisions","stock recommendations"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"ALK, FLNC and JILL have been added to the Zacks Rank #5 (Strong Sell) List on April 8, 2026.","tickers":[],"title":"New Strong Sell Stocks for April 8th","url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-8th"}

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