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-22T12:11:11.616908+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:34c8b80323317e65","evidence_event_ids":["evt_96ea914b35f0"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/philip-morris-international-reveals-drop-q1-bottom-line","as_of":"2026-04-22T12:11:11.616908+00:00","canonical_url":"https://www.rttnews.com/3641214/philip-morris-international-reveals-drop-in-q1-bottom-line.aspx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/philip-morris-international-reveals-drop-q1-bottom-line","article_chars":777,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_532d791da8907e36","canonical_host":"rttnews.com","canonical_is_aggregator":false,"canonical_url":"https://www.rttnews.com/3641214/philip-morris-international-reveals-drop-in-q1-bottom-line.aspx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T12:13:17.374561+00:00","extraction_method":"trafilatura","fetched_description":"(RTTNews) - Philip Morris International (PM) reported earnings for first quarter that Dropped, from the same period last year","fetched_title":"Philip Morris International Reveals Drop In Q1 Bottom Line | Nasdaq","final_url":"https://www.nasdaq.com/articles/philip-morris-international-reveals-drop-q1-bottom-line","html_truncated":false,"paywall_likely":false,"publisher_domain":"rttnews.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/philip-morris-international-reveals-drop-q1-bottom-line","source_event_id":"evt_96ea914b35f0","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"949c5f23e6f0ecc0","kind":"unusual_volume","published_at":"2026-04-22T11:15:37+00:00","publisher_domain":"rttnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Philip Morris International","relevance":"high","symbol":"PM","type":"company"},{"asset_class":"other","name":"RTTNews","relevance":"medium","symbol":"","type":"news_source"}],"event_type":"earnings","information_gaps":["Signal type is discovery_unusual_volume_delta, but the provided text contains no volume or volume-ratio vs average information (baseline volume, volume ratio, and direction are missing).","No explicit mention of whether any unusual volume move is confirmed by news or otherwise explained.","No catalyst hypothesis for volume is provided in the text; only earnings/guidance figures are included."],"key_facts":["Q1 bottom line totaled $2.438 billion, or $1.56 per share.","Q1 bottom line compared with $2.690 billion, or $1.72 per share, last year.","Revenue rose 9.1% to $10.146 billion from $9.301 billion last year.","Next quarter EPS guidance is $2.02 to $2.07.","Full year EPS guidance is $8.11 to $8.26."],"numeric_claims":[{"label":"Q1 bottom line (current)","value":"$2.438 billion"},{"label":"Q1 EPS (current)","value":"$1.56"},{"label":"Q1 bottom line (prior year)","value":"$2.690 billion"},{"label":"Q1 EPS (prior year)","value":"$1.72"},{"label":"Revenue (current)","value":"$10.146 billion"},{"label":"Revenue (prior year)","value":"$9.301 billion"},{"label":"Revenue growth","value":"9.1%"},{"label":"Next quarter EPS guidance low","value":"$2.02"},{"label":"Next quarter EPS guidance high","value":"$2.07"},{"label":"Full year EPS guidance low","value":"$8.11"},{"label":"Full year EPS guidance high","value":"$8.26"}],"primary_claim":"Philip Morris International\u2019s Q1 bottom-line earnings fell to $2.438B ($1.56/share) from $2.690B ($1.72/share) in the prior-year quarter.","relevance_score":0.62,"sentiment":"mixed","source_quality":"medium","summary":"RTTNews reports Philip Morris International (PM) Q1 results where bottom-line earnings declined year over year. Revenue increased, and the article provides next-quarter and full-year EPS guidance ranges.","topics":["earnings","Q1 results","EPS guidance","revenue growth","year-over-year comparison"]},"source":"Nasdaq Markets","source_domain":"rttnews.com","summary":"(RTTNews) - Philip Morris International (PM) reported earnings for first quarter that Dropped, from the same period last year","tickers":["PM"],"title":"Philip Morris International Reveals Drop In Q1 Bottom Line","url":"https://www.rttnews.com/3641214/philip-morris-international-reveals-drop-in-q1-bottom-line.aspx"}}

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