SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-06T12:11:16.372821+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:f4e3ccd700cc5ed3","evidence_event_ids":["evt_09c1a1310866"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-6th","as_of":"2026-04-06T12:11:16.372821+00:00","canonical_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-6th","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-6th","article_chars":3195,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_eaef2d1e66f9c85d","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-6th","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-06T12:16:37.582373+00:00","extraction_method":"heuristic","fetched_description":"AAWH, BSET and KHC have been added to the Zacks Rank #5 (Strong Sell) List on April 6, 2026.","fetched_title":"New Strong Sell Stocks for April 6th | Nasdaq","final_url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-6th","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-6th","source_event_id":"evt_09c1a1310866","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f114c58637a3e1b7","kind":"new_listings","published_at":"2026-04-06T10:38:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-04-06"],"entities":[{"asset_class":"stock","name":"Ascend Wellness Holdings, Inc.","relevance":"added to Strong Sell List","symbol":"AAWH","type":"company"},{"asset_class":"stock","name":"Bassett Furniture Industries, Incorporated","relevance":"added to Strong Sell List","symbol":"BSET","type":"company"},{"asset_class":"stock","name":"The Kraft Heinz Company","relevance":"added to Strong Sell List","symbol":"KHC","type":"company"}],"event_type":"listing","information_gaps":["No details on the reasons for the downward revisions in earnings estimates."],"key_facts":["AAWH's earnings estimate revised downward by 22.2% over the last 60 days.","BSET's earnings estimate revised downward by 11.9% over the last 60 days.","KHC's earnings estimate revised downward by 19.4% over the last 60 days."],"numeric_claims":[{"label":"AAWH earnings estimate revision","value":"22.2% downward"},{"label":"BSET earnings estimate revision","value":"11.9% downward"},{"label":"KHC earnings estimate revision","value":"19.4% downward"}],"primary_claim":"AAWH, BSET, and KHC have been added to the Zacks Rank #5 (Strong Sell) List on April 6, 2026.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Three stocks have been added to the Zacks Rank #5 (Strong Sell) List on April 6, 2026: Ascend Wellness Holdings, Inc. (AAWH), Bassett Furniture Industries, Incorporated (BSET), and The Kraft Heinz Company (KHC).","topics":["stock market","investment","earnings estimates"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"AAWH, BSET and KHC have been added to the Zacks Rank #5 (Strong Sell) List on April 6, 2026.","tickers":[],"title":"New Strong Sell Stocks for April 6th","url":"https://www.nasdaq.com/articles/new-strong-sell-stocks-april-6th"}}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 30836 in events