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-03T14:12:18.871496+00:00","dedupe_key":"signal_enriched:discovery_sector_rotation_delta:9bf8fc36ccd21668","evidence_event_ids":["evt_bbcbfbe6c6a5"],"signal_type":"discovery_sector_rotation_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/plains-all-american-pipeline-reaches-analyst-target-price","as_of":"2026-04-03T14:12:18.871496+00:00","canonical_url":"https://www.nasdaq.com/articles/plains-all-american-pipeline-reaches-analyst-target-price","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/plains-all-american-pipeline-reaches-analyst-target-price","article_chars":3726,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_9e2fdf40dcfd750e","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/plains-all-american-pipeline-reaches-analyst-target-price","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-03T23:26:42.827091+00:00","extraction_method":"heuristic","fetched_description":"In recent trading, shares of Plains All American Pipeline LP (Symbol: PAA) have crossed above the average analyst 12-month target price of $22.12, changing hands for $22.14/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: do","fetched_title":"Plains All American Pipeline Reaches Analyst Target Price | Nasdaq","final_url":"https://www.nasdaq.com/articles/plains-all-american-pipeline-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/plains-all-american-pipeline-reaches-analyst-target-price","source_event_id":"evt_bbcbfbe6c6a5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d254e6fd05aebf74","kind":"sector_rotation","published_at":"2026-04-03T13:19:40+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["April 03, 2026"],"entities":[{"asset_class":"equity","name":"Plains All American Pipeline LP","relevance":"high","symbol":"PAA","type":"company"}],"event_type":"price_action","information_gaps":["No explicit macro driver for the price action is mentioned.","Uncertainty about whether this price movement indicates a regime shift or short-term rebalancing."],"key_facts":["PAA shares traded at $22.14, above the average target price of $22.12.","There are 16 analysts contributing to the average target price.","Analyst targets range from $17.00 to $26.00 with a standard deviation of $2.446."],"numeric_claims":[{"label":"Current share price","value":"$22.14"},{"label":"Average analyst target price","value":"$22.12"},{"label":"Lowest analyst target","value":"$17.00"},{"label":"Highest analyst target","value":"$26.00"},{"label":"Standard deviation of targets","value":"$2.446"}],"primary_claim":"PAA shares have crossed above the average analyst 12-month target price of $22.12, currently trading at $22.14.","relevance_score":0.8,"sentiment":"neutral","source_quality":"high","summary":"Plains All American Pipeline (PAA) shares have surpassed the average analyst target price of $22.12, trading at $22.14, prompting potential analyst reactions regarding future price adjustments.","topics":["stock price","analyst ratings","target price"]},"source":"Nasdaq ETFs","source_domain":"nasdaq.com","summary":"In recent trading, shares of Plains All American Pipeline LP (Symbol: PAA) have crossed above the average analyst 12-month target price of $22.12, changing hands for $22.14/share. When a stock reaches the target an analyst has set, the analyst logically has two ways to react: do","tickers":[],"title":"Plains All American Pipeline Reaches Analyst Target Price","url":"https://www.nasdaq.com/articles/plains-all-american-pipeline-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 7459 in events