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/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

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