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-20T17:15:12.787981+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:862f03e2291ba2cb","evidence_event_ids":["evt_a6a66d18670f"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/monday-sector-leaders-water-utilities-television-radio-stocks","as_of":"2026-04-20T17:15:12.787981+00:00","canonical_url":"https://www.nasdaq.com/articles/monday-sector-leaders-water-utilities-television-radio-stocks","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/monday-sector-leaders-water-utilities-television-radio-stocks","article_chars":326,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6a7a718d4cd30ea7","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/monday-sector-leaders-water-utilities-television-radio-stocks","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:44:47.891529+00:00","extraction_method":"trafilatura","fetched_description":"In trading on Monday, water utilities shares were relative leaders, up on the day by about 3.1%. Leading the group were shares of Middlesex Water, up about 5.3% and shares of Consolidated Water up about 4.8% on the day.Also showing relative strength are television & radio","fetched_title":"Monday Sector Leaders: Water Utilities, Television & Radio Stocks | Nasdaq","final_url":"https://www.nasdaq.com/articles/monday-sector-leaders-water-utilities-television-radio-stocks","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/monday-sector-leaders-water-utilities-television-radio-stocks","source_event_id":"evt_a6a66d18670f","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"ed0691ead45529f1","kind":"new_listings","published_at":"2026-04-20T16:07:23+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.52,"dates_mentioned":["Monday"],"entities":[{"asset_class":"equity","name":"Middlesex Water","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Consolidated Water","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Ondas","relevance":"high","symbol":"","type":"company"},{"asset_class":"equity","name":"Scripps","relevance":"high","symbol":"","type":"company"}],"event_type":"price_action","information_gaps":["No standardized ticker symbols are provided for the named companies.","The text does not specify the exact date (calendar date) for \u201cMonday.\u201d","No market context (e.g., volume, intraday vs close) is provided\u2014only approximate day-over-day percentage moves.","The signal type is labeled as discovery_new_listings_delta, but the provided text describes sector/stock price performance rather than new listings; this mismatch is not resolved in the text."],"key_facts":["Water utilities shares were up about 3.1% on Monday (relative leaders).","Middlesex Water shares were up about 5.3% on Monday.","Consolidated Water shares were up about 4.8% on Monday.","Television & radio shares were up about 2.4% as a group on Monday.","Ondas shares were trading higher by about 10.4% on Monday.","Scripps shares were trading up by about 6% on Monday."],"numeric_claims":[{"label":"Water utilities group move (Monday)","value":"about +3.1%"},{"label":"Middlesex Water move (Monday)","value":"about +5.3%"},{"label":"Consolidated Water move (Monday)","value":"about +4.8%"},{"label":"Television & radio group move (Monday)","value":"about +2.4%"},{"label":"Ondas move (Monday)","value":"about +10.4%"},{"label":"Scripps move (Monday)","value":"about +6%"}],"primary_claim":"Water utilities shares rose about 3.1% on Monday, led by Middlesex Water (+5.3%) and Consolidated Water (+4.8%), while television & radio stocks rose about 2.4% as a group led by Ondas (+10.4%) and Scripps (+6%).","relevance_score":0.42,"sentiment":"positive","source_quality":"low","summary":"On Monday, water utilities were relative leaders, and television & radio stocks also showed relative strength. Middlesex Water and Consolidated Water led the water utilities group, while Ondas and Scripps led television & radio.","topics":["water utilities","television & radio","sector relative strength","equity price performance"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"In trading on Monday, water utilities shares were relative leaders, up on the day by about 3.1%. Leading the group were shares of Middlesex Water, up about 5.3% and shares of Consolidated Water up about 4.8% on the day. Also showing relative strength are television & radio","tickers":[],"title":"Monday Sector Leaders: Water Utilities, Television & Radio Stocks","url":"https://www.nasdaq.com/articles/monday-sector-leaders-water-utilities-television-radio-stocks"}}

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