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_new_listings_delta:bc90820cfb338c3b","evidence_event_ids":["evt_6bdeb43c7588"],"signal_type":"discovery_new_listings_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_2dd5cd4f254aa28c","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:15:32.435176+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_6bdeb43c7588","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"ba50d64b40193de8","kind":"new_listings","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":"Quandl.com","relevance":"low","symbol":"","type":"data_provider"}],"event_type":"price_action","information_gaps":["The headline text in the provided signal summary reports different target/price figures ($314.78 target and $315.56/share) than the cleaned article text ($287.56 target and $290.65/share); the discrepancy is unresolved.","No specific date/time for the \u201crecent trading\u201d cross is provided in the cleaned text.","The article references a table of analyst targets/ratings, but the actual table values are not included in the provided text beyond the scale description."],"key_facts":["The article states FFIV crossed above the average analyst 12-month target price.","In the cleaned article text, the average analyst 12-month target price is given as $287.56/share.","In the cleaned article text, FFIV is described as changing hands for $290.65/share in recent trading.","The article states there are 9 analyst targets within the Zacks coverage universe contributing to the average for FFIV.","The article states one analyst target is $260.00 and another is as high as $320.00.","The article states the standard deviation of analyst targets is $19.583.","The article notes the average rating in a table is on a 1-to-5 scale where 1 is Strong Buy and 5 is Strong Sell."],"numeric_claims":[{"label":"Average analyst 12-month target price (per article text)","value":"$287.56/share"},{"label":"FFIV trading price cited (per article text)","value":"$290.65/share"},{"label":"Number of analyst targets contributing to average","value":"9"},{"label":"Lowest cited analyst target","value":"$260.00"},{"label":"Highest cited analyst target","value":"$320.00"},{"label":"Standard deviation of targets","value":"$19.583"}],"primary_claim":"FFIV crossed above the article\u2019s stated average analyst 12-month target price (reported as $287.56/share in the cleaned text) and was last shown trading at $290.65/share.","relevance_score":0.45,"sentiment":"neutral","source_quality":"medium","summary":"F5 Inc (FFIV) traded above the average analyst 12-month target price cited by the article, indicating the stock crossed that benchmark during recent trading.","topics":["analyst price targets","equity valuation","trading above target","Zacks coverage"]},"source":"Nasdaq Stocks","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 480906 in events