SQLite Web: event_store.db

Update row 63369 in events

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-16T18:53:43.260650+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:c9a4134e6377898a","evidence_event_ids":["evt_0d44587377b4"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/why-york-water-stock-just-sank-52-week-low","as_of":"2026-04-16T18:53:43.260650+00:00","canonical_url":"https://www.fool.com/investing/2026/04/16/why-york-water-stock-just-sank-to-a-52-week-low/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/why-york-water-stock-just-sank-52-week-low","article_chars":4084,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_72e97345e43bf63c","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/16/why-york-water-stock-just-sank-to-a-52-week-low/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T09:43:13.539522+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsYork Water is issuing new shares, and investors aren't happy with that.","fetched_title":"Why York Water Stock Just Sank to a 52-Week Low | Nasdaq","final_url":"https://www.nasdaq.com/articles/why-york-water-stock-just-sank-52-week-low","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/why-york-water-stock-just-sank-52-week-low","source_event_id":"evt_0d44587377b4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7bfddb3826930904","kind":"unusual_volume","published_at":"2026-04-16T18:01:37+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 16","Thursday","1 p.m. ET"],"entities":[{"asset_class":"equity","name":"York Water","relevance":"high","symbol":"YORW","type":"company"},{"asset_class":"other","name":"Motley Fool Stock Advisor","relevance":"low","symbol":"","type":"publication_or_service"}],"event_type":"price_action","information_gaps":["The signal type requests unusual volume delta (volume ratio vs average), but the provided text contains no volume figures or volume ratio.","It is not explicitly stated whether the unusual volume is confirmed by news; the article discusses price movement and a share issuance catalyst, not volume metrics.","No baseline average volume or current volume is provided, so the volume ratio cannot be computed."],"key_facts":["The article says York Water stock was trading 5% lower as of 1 p.m. ET Thursday after dropping 8.4% in early trading.","A regulatory filing dated April 16 states York Water plans to issue 1.5 million shares valued at $43 million.","The new shares were priced at $28.50 per share, discounted to the previous day's closing price of $30.84.","The share issue increases total shares outstanding, meaning each existing share receives a smaller portion of earnings and dividends.","Investors reacted by sending the stock to an intraday low of $28.26, which the article says is a new 52-week low.","The article states the stock has fallen nearly 18% over the past year.","The article states York Water plans to use proceeds for infrastructure, acquisitions, and reducing debt."],"numeric_claims":[{"label":"shares_to_issue","value":"1.5 million"},{"label":"share_issue_value","value":"$43 million"},{"label":"offering_price_per_share","value":"$28.50"},{"label":"previous_close_per_share","value":"$30.84"},{"label":"intraday_low_per_share","value":"$28.26"},{"label":"drop_early_trading_percent","value":"8.4%"},{"label":"down_as_of_1pm_et_percent","value":"5%"},{"label":"52_week_low_price","value":"$28.26"},{"label":"one_year_decline_percent","value":"nearly 18%"}],"primary_claim":"York Water announced plans to issue 1.5 million shares priced at $28.50 (total $43 million), discounted to the prior close, and the resulting dilution drove the stock down to a new 52-week low.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"York Water (NASDAQ: YORW) fell to a new 52-week low after announcing a discounted issuance of 1.5 million new shares, which investors viewed as dilutive. The article attributes the selloff to share dilution and the low offering price.","topics":["share issuance","share dilution","utility stocks","52-week low","dividends","regulatory filing"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsYork Water is issuing new shares, and investors aren't happy with that.","tickers":[],"title":"Why York Water Stock Just Sank to a 52-Week Low","url":"https://www.fool.com/investing/2026/04/16/why-york-water-stock-just-sank-to-a-52-week-low/"}}

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')

Cancel