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-09T15:06:58.940339+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:7a0f031d092354a1","evidence_event_ids":["evt_a10b6eff62dc"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/cw-crosses-above-average-analyst-target-1","as_of":"2026-04-09T15:06:58.940339+00:00","canonical_url":"https://www.nasdaq.com/articles/cw-crosses-above-average-analyst-target-1","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/cw-crosses-above-average-analyst-target-1","article_chars":3708,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_c482dfcfa3836966","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/cw-crosses-above-average-analyst-target-1","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:56:34.345191+00:00","extraction_method":"heuristic","fetched_description":"In recent trading, shares of Curtiss-Wright Corp. (Symbol: CW) have crossed above the average analyst 12-month target price of $248.25, changing hands for $250.01/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: downgrade on","fetched_title":"CW Crosses Above Average Analyst Target | Nasdaq","final_url":"https://www.nasdaq.com/articles/cw-crosses-above-average-analyst-target-1","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/cw-crosses-above-average-analyst-target-1","source_event_id":"evt_a10b6eff62dc","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"79c98814b367049d","kind":"sector_rotation","published_at":"2026-04-09T14:04:17+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["March 25, 2024"],"entities":[{"asset_class":"equity","name":"Curtiss-Wright Corp.","relevance":"high","symbol":"CW","type":"company"},{"asset_class":"unknown","name":"Zacks Investment Research (via Quandl.com)","relevance":"medium","symbol":"","type":"data_provider"},{"asset_class":"unknown","name":"BNK Invest","relevance":"low","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["No sector gaining/losing information is provided in the text, despite the signal type being sector rotation delta.","No macro driver is identified in the provided article text.","No explicit determination is made whether this is a regime shift versus short-term rebalancing; the article only frames the event as a prompt for reassessment.","The article includes a discrepancy in the headline/source summary text (target $711.43 and price $728.96) versus the cleaned article body (target $248.25 and price $250.01); the cleaned body is used for grounded extraction, but the inconsistency remains unresolved."],"key_facts":["CW crossed above the average analyst 12-month target price of $248.25.","CW was changing hands at $250.01/share at the time referenced.","The article notes there are 4 analyst targets within the Zacks coverage universe contributing to the average.","The article states analyst targets range from $228.00 (low) to $260.00 (high), with a standard deviation of $14.103.","The article provides an analyst rating breakdown showing Strong buy: 5, Buy: 0, Hold: 0, Sell: 0, Strong sell: 0, and an average rating of 1.0 (consistent across 1 month ago, 2 months ago, and 3 months ago).","The article discusses two possible analyst reactions when a stock reaches a target: downgrade on valuation or re-adjust the target price higher, depending on fundamentals."],"numeric_claims":[{"label":"Average analyst 12-month target (USD)","value":"248.25"},{"label":"CW trading price at time referenced (USD)","value":"250.01"},{"label":"Low analyst target (USD)","value":"228.00"},{"label":"High analyst target (USD)","value":"260.00"},{"label":"Standard deviation of targets","value":"14.103"},{"label":"Number of analyst targets contributing to average","value":"4"},{"label":"Average analyst rating (1=Strong Buy, 5=Strong Sell)","value":"1.0"},{"label":"Strong buy ratings count","value":"5"}],"primary_claim":"Curtiss-Wright Corp. (CW) crossed above the average analyst 12-month target price of $248.25, trading at $250.01 per share.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"Curtiss-Wright (CW) traded above the average analyst 12-month target price, with the stock at $250.01 versus an average target of $248.25. The article frames this as a potential prompt for analysts to adjust targets upward or reassess valuation, but it does not identify sector winners/losers or a macro driver.","topics":["analyst targets","equity price vs target","rating distribution","market signal"]},"source":"Nasdaq ETFs","source_domain":"nasdaq.com","summary":"In recent trading, shares of Curtiss-Wright Corp. (Symbol: CW) have crossed above the average analyst 12-month target price of $711.43, changing hands for $728.96/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: downgrade on","tickers":[],"title":"CW Crosses Above Average Analyst Target","url":"https://www.nasdaq.com/articles/cw-crosses-above-average-analyst-target-1"}}

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 11668 in events