SQLite Web: event_store.db

Update row 438192 in events

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-20T13:10:00.946643+00:00","dedupe_key":"signal_enriched:discovery_options_flow_delta:62bf9bc4225ce318","evidence_event_ids":["evt_c4c53256907f"],"signal_type":"discovery_options_flow_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/bull-day-bp-bp","as_of":"2026-04-20T13:10:00.946643+00:00","canonical_url":"https://www.nasdaq.com/articles/bull-day-bp-bp","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bull-day-bp-bp","article_chars":3268,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_e6857d3aa23a5253","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/bull-day-bp-bp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T13:10:48.695491+00:00","extraction_method":"trafilatura","fetched_description":"If you think oil prices are suddenly going to reverse and the crude trade is over, think again.","fetched_title":"Bull of the Day: BP (BP) | Nasdaq","final_url":"https://www.nasdaq.com/articles/bull-day-bp-bp","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bull-day-bp-bp","source_event_id":"evt_c4c53256907f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7710d9a7473546e4","kind":"options_flow","published_at":"2026-04-20T11:00:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["last couple of months","over the last sixty days"],"entities":[{"asset_class":"equity","name":"BP","relevance":"high","symbol":"BP","type":"company"},{"asset_class":"other","name":"Zacks Rank","relevance":"high","symbol":"","type":"rating_framework"},{"asset_class":"other","name":"US-Iran conflict","relevance":"medium","symbol":"","type":"geopolitical_event"},{"asset_class":"equity","name":"Microsoft","relevance":"low","symbol":"MSFT","type":"company"},{"asset_class":"equity","name":"Google","relevance":"low","symbol":"GOOGL","type":"company"},{"asset_class":"equity","name":"Amazon","relevance":"low","symbol":"AMZN","type":"company"},{"asset_class":"equity","name":"Oracle","relevance":"low","symbol":"ORCL","type":"company"},{"asset_class":"equity","name":"Meta","relevance":"low","symbol":"META","type":"company"},{"asset_class":"equity","name":"Tesla","relevance":"low","symbol":"TSLA","type":"company"}],"event_type":"earnings","information_gaps":["This signal type is 'discovery_options_flow_delta', but the provided text contains no options-flow details (no calls/puts, no expiry dates, no open interest context, no flow size).","No options contract metrics are provided (e.g., relative size vs open interest, days to expiry, or whether positioning appears informed).","No explicit date of the Zacks Rank assignment or the timing of the earnings revisions beyond 'last couple of months' / 'last sixty days'.","The article includes promotional quantum computing content; it is not connected to BP options flow in the provided text."],"key_facts":["BP is described as Zacks Rank #1 (Strong Buy).","The article states that analysts have increased BP\u2019s earnings estimates over the last couple of months.","It says that over the last sixty days, eight analysts increased their earnings estimates for the current year.","It says that seven analysts increased their earnings estimates for next year.","The article reports BP\u2019s Zacks Consensus Estimates for the current year increased from $2.66 to $4.59.","The article reports next year\u2019s Zacks Consensus Estimates increased from $3.15 to $3.88.","The article attributes bullishness to stable crude prices, disciplined capital spending, and strong cash flow generation.","The article states BP has shareholder returns via dividends and buybacks.","The article states BP is investing in energy transition initiatives including renewables and low-carbon technologies."],"numeric_claims":[{"label":"analysts increased current-year estimates (last 60 days)","value":"8"},{"label":"analysts increased next-year estimates","value":"7"},{"label":"current-year consensus estimate (from)","value":"$2.66"},{"label":"current-year consensus estimate (to)","value":"$4.59"},{"label":"next-year consensus estimate (from)","value":"$3.15"},{"label":"next-year consensus estimate (to)","value":"$3.88"}],"primary_claim":"BP\u2019s bullish case is driven by analysts steadily raising earnings estimates for the current and next year over the last couple of months, supporting a Zacks Rank #1 (Strong Buy).","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"The article presents BP as Zacks Rank #1 (Strong Buy), citing upward earnings estimate revisions over the last ~60 days and resilience in energy markets amid US-Iran conflict-related uncertainty.","topics":["earnings estimate revisions","Zacks Rank #1 (Strong Buy)","energy sector resilience","oil prices","US-Iran conflict","capital spending","shareholder returns","energy transition initiatives","quantum computing promotional content"]},"source":"Nasdaq Investing","source_domain":"nasdaq.com","summary":"If you think oil prices are suddenly going to reverse and the crude trade is over, think again.","tickers":["BP"],"title":"Bull of the Day: BP (BP)","url":"https://www.nasdaq.com/articles/bull-day-bp-bp"}}

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')

Cancel