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-22T11:09:42.515872+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:bc90820cfb338c3b","evidence_event_ids":["evt_a2ca5b3cc567"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/f5-reaches-analyst-target-price","as_of":"2026-04-22T11:09:42.515872+00:00","canonical_url":"https://www.nasdaq.com/articles/f5-reaches-analyst-target-price","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/f5-reaches-analyst-target-price","article_chars":2151,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4445a8a4f9d4819f","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/f5-reaches-analyst-target-price","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T11:11:24.711884+00:00","extraction_method":"trafilatura","fetched_description":"In recent trading, shares of F5 Inc (Symbol: FFIV) have crossed above the average analyst 12-month target price of $287.56, changing hands for $290.65/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: downgrade on valuation,","fetched_title":"F5 Reaches Analyst Target Price | Nasdaq","final_url":"https://www.nasdaq.com/articles/f5-reaches-analyst-target-price","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/f5-reaches-analyst-target-price","source_event_id":"evt_a2ca5b3cc567","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"ba50d64b40193de8","kind":"unusual_volume","published_at":"2026-04-22T10:37:53+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"F5 Inc","relevance":"high","symbol":"FFIV","type":"company"},{"asset_class":"unknown","name":"Zacks Investment Research","relevance":"medium","symbol":"","type":"data_provider"},{"asset_class":"unknown","name":"Nasdaq, Inc.","relevance":"low","symbol":"","type":"publisher"}],"event_type":"price_action","information_gaps":["The signal type requested is discovery_unusual_volume_delta, but the provided text contains no volume or volume-ratio vs average information.","The headline text in the prompt mentions different target/price figures ($314.78 and $315.56) than the cleaned article text ($287.56 and $290.65); the discrepancy is not resolved in the provided content.","No explicit confirmation by news is provided beyond the analyst-target/price-target discussion; no specific catalyst (earnings, guidance, macro, product, etc.) is identified in the text.","No baseline volume, current volume, or computed volume ratio is included, so unusual volume cannot be extracted."],"key_facts":["FFIV crossed above the average analyst 12-month target price.","Average analyst 12-month target price cited: $287.56 per share.","Recent trading price cited: $290.65 per share.","The article discusses possible analyst reactions when a stock reaches an analyst-set target (downgrade on valuation or re-adjust target upward).","The article states there are 9 analyst targets within the Zacks coverage universe contributing to the average for FFIV.","The article notes one analyst target is $260.00 and another is as high as $320.00.","The article cites a standard deviation of $19.583 for the analyst targets."],"numeric_claims":[{"label":"Average analyst 12-month target price (USD)","value":"287.56"},{"label":"Recent trading price (USD)","value":"290.65"},{"label":"Analyst target low (USD)","value":"260.00"},{"label":"Analyst target high (USD)","value":"320.00"},{"label":"Standard deviation of targets (USD)","value":"19.583"}],"primary_claim":"FFIV recently traded above the average analyst 12-month target price of $287.56, at $290.65 per share.","relevance_score":0.42,"sentiment":"neutral","source_quality":"medium","summary":"The article reports that F5 Inc (FFIV) traded above the average analyst 12-month target price, with the stock at $290.65 versus an average target of $287.56. It frames this as a potential prompt for analysts to adjust targets or ratings, depending on underlying fundamentals.","topics":["analyst price targets","equity price action","valuation discussion","Zacks coverage"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"In recent trading, shares of F5 Inc (Symbol: FFIV) have crossed above the average analyst 12-month target price of $314.78, changing hands for $315.56/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: downgrade on valuation,","tickers":[],"title":"F5 Reaches Analyst Target Price","url":"https://www.nasdaq.com/articles/f5-reaches-analyst-target-price"}}

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