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/patterson-uti-energy-reaches-analyst-target-price-0","as_of":"2026-04-22T11:09:42.515872+00:00","canonical_url":"https://www.nasdaq.com/articles/patterson-uti-energy-reaches-analyst-target-price-0","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/patterson-uti-energy-reaches-analyst-target-price-0","article_chars":2138,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4b5133b9d7cbc5a0","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/patterson-uti-energy-reaches-analyst-target-price-0","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T11:15:23.632615+00:00","extraction_method":"trafilatura","fetched_description":"In recent trading, shares of Patterson-UTI Energy Inc. (Symbol: PTEN) have crossed above the average analyst 12-month target price of $17.11, changing hands for $17.16/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: downgra","fetched_title":"Patterson-UTI Energy Reaches Analyst Target Price | Nasdaq","final_url":"https://www.nasdaq.com/articles/patterson-uti-energy-reaches-analyst-target-price-0","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/patterson-uti-energy-reaches-analyst-target-price-0","source_event_id":"evt_3589fb6566ee","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"9606556da64f642d","kind":"new_listings","published_at":"2026-04-22T10:37:55+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Patterson-UTI Energy Inc.","relevance":"high","symbol":"PTEN","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 article text provided includes an inconsistency: the user-provided headline/source summary mentions $10.54/$10.56, while the cleaned article text states $17.11/$17.16; the correct figures are not verifiable from the provided text alone.","No specific analyst upgrade/downgrade or target-price change is shown in the provided excerpt\u2014only general possibilities are discussed.","The article references a table of analyst ratings/targets, but the table contents are not included in the provided text, so individual ratings and the distribution cannot be extracted.","The exact timing of the \u201crecent trading\u201d cross above the target is not specified."],"key_facts":["The article states PTEN crossed above the average analyst 12-month target price.","The article cites the average analyst 12-month target price as $17.11 per share.","The article states PTEN was changing hands for $17.16 per share in recent trading.","The article says there are 11 analyst targets within the Zacks coverage universe contributing to the average for PTEN.","The article states one analyst target is $11.00 and another is as high as $21.00.","The article states the standard deviation of analyst targets is $3.989.","The article describes possible analyst reactions when a stock reaches an analyst-set target (downgrade on valuation or re-adjust target upward), but does not provide a specific analyst action in the provided text."],"numeric_claims":[{"label":"PTEN trade price (stated)","value":"$17.16/share"},{"label":"Average analyst 12-month target (stated)","value":"$17.11/share"},{"label":"Number of analyst targets contributing to average","value":"11"},{"label":"Lowest cited analyst target","value":"$11.00"},{"label":"Highest cited analyst target","value":"$21.00"},{"label":"Standard deviation of targets","value":"3.989"}],"primary_claim":"PTEN crossed above the article\u2019s cited average analyst 12-month target price (average $17.11) and traded at about $17.16 per share.","relevance_score":0.55,"sentiment":"neutral","source_quality":"medium","summary":"Patterson-UTI Energy (PTEN) traded above the average analyst 12-month target price cited in the article, with shares changing hands around $17.16 versus an average target of $17.11.","topics":["analyst price targets","equity price action","valuation discussion","Zacks coverage universe"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"In recent trading, shares of Patterson-UTI Energy Inc. (Symbol: PTEN) have crossed above the average analyst 12-month target price of $10.54, changing hands for $10.56/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: downgra","tickers":[],"title":"Patterson-UTI Energy Reaches Analyst Target Price","url":"https://www.nasdaq.com/articles/patterson-uti-energy-reaches-analyst-target-price-0"}

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