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-17T21:52:12.771882+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:164ca1a792a5f262","evidence_event_ids":["evt_5874b2bd9a0b"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/ppl-now-302-largest-company-surpassing-devon-energy","as_of":"2026-04-17T21:52:12.771882+00:00","canonical_url":"https://www.nasdaq.com/articles/ppl-now-302-largest-company-surpassing-devon-energy","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ppl-now-302-largest-company-surpassing-devon-energy","article_chars":2366,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_adb577226491023b","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/ppl-now-302-largest-company-surpassing-devon-energy","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T23:47:23.921086+00:00","extraction_method":"trafilatura","fetched_description":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, PPL Corp (Symbol: PPL) has taken over the #302 spot from Devon Energy Corp. (Symbol: DVN), according to The Online Investor. Market capitalization is an important dat","fetched_title":"PPL Now #302 Largest Company, Surpassing Devon Energy | Nasdaq","final_url":"https://www.nasdaq.com/articles/ppl-now-302-largest-company-surpassing-devon-energy","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ppl-now-302-largest-company-surpassing-devon-energy","source_event_id":"evt_5874b2bd9a0b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a1e04b303c693bd7","kind":"unusual_volume","published_at":"2026-04-17T21:31:42+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.7,"dates_mentioned":["Friday"],"entities":[{"asset_class":"equity","name":"PPL Corp","relevance":"high","symbol":"PPL","type":"company"},{"asset_class":"equity","name":"Devon Energy Corp.","relevance":"high","symbol":"DVN","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"}],"event_type":"listing","information_gaps":["This signal type is discovery_unusual_volume_delta, but the provided text contains no unusual volume metrics (no volume ratio vs average, no baseline volume, and no direction for volume).","No catalyst for the ranking change is provided in the text (no confirmation by news beyond the ranking/market-cap comparison).","The article does not specify the exact date of the market-cap ranking update beyond referencing \u201cFriday\u201d for the closing performance.","No details are given about whether the ranking change is due to price moves, share count changes, or other factors."],"key_facts":["The article states PPL\u2019s market cap is $29.59 billion.","The article states DVN\u2019s market cap is $28.45 billion.","The article states PPL has taken over the #302 spot from DVN in the S&P 500 ordered by market capitalization.","The article states that at the closing bell on Friday, PPL is down about 0.8%.","The article states that at the closing bell on Friday, DVN is off about 3.5%.","The article includes charts comparing PPL vs DVN over time (size rank within the S&P 500 and three-month price history)."],"numeric_claims":[{"label":"PPL market cap (reported)","value":"$29.59 billion"},{"label":"DVN market cap (reported)","value":"$28.45 billion"},{"label":"PPL daily move at close (reported)","value":"-0.8%"},{"label":"DVN daily move at close (reported)","value":"-3.5%"}],"primary_claim":"PPL\u2019s market capitalization is reported as $29.59B versus DVN\u2019s $28.45B, with PPL taking over the #302 spot from DVN in the S&P 500 ranking.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The article reports that PPL Corp (PPL) has moved ahead of Devon Energy (DVN) in S&P 500 market-cap ranking, taking the #302 spot. It also notes both stocks\u2019 same-day performance at the closing bell.","topics":["market capitalization","S&P 500 ranking","PPL vs DVN comparison","stock performance","index component ranking"]},"source":"Nasdaq Markets","source_domain":"nasdaq.com","summary":"In the latest look at the underlying components of the S&P 500 ordered by largest market capitalization, PPL Corp (Symbol: PPL) has taken over the #302 spot from Devon Energy Corp. (Symbol: DVN), according to The Online Investor. Market capitalization is an important dat","tickers":[],"title":"PPL Now #302 Largest Company, Surpassing Devon Energy","url":"https://www.nasdaq.com/articles/ppl-now-302-largest-company-surpassing-devon-energy"}}

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