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-21T00:08:29.826903+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:51ffabcbad987993","evidence_event_ids":["evt_215edbd763b5"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/coterra-energy-ctra-ascends-while-market-falls-some-facts-note","as_of":"2026-04-21T00:08:29.826903+00:00","canonical_url":"https://www.nasdaq.com/articles/coterra-energy-ctra-ascends-while-market-falls-some-facts-note","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/coterra-energy-ctra-ascends-while-market-falls-some-facts-note","article_chars":3654,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2d8326fd18004cad","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/coterra-energy-ctra-ascends-while-market-falls-some-facts-note","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:25:44.573251+00:00","extraction_method":"trafilatura","fetched_description":"Coterra Energy (CTRA) closed the most recent trading day at $28.04, moving +1.15% from the previous trading session.","fetched_title":"Coterra Energy (CTRA) Ascends While Market Falls: Some Facts to Note | Nasdaq","final_url":"https://www.nasdaq.com/articles/coterra-energy-ctra-ascends-while-market-falls-some-facts-note","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/coterra-energy-ctra-ascends-while-market-falls-some-facts-note","source_event_id":"evt_215edbd763b5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d20008937a509720","kind":"new_listings","published_at":"2026-04-20T22:15:05+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Coterra Energy","relevance":"high","symbol":"CTRA","type":"company"},{"asset_class":"index","name":"S&P 500","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"Dow","relevance":"medium","symbol":"","type":"index"},{"asset_class":"index","name":"Nasdaq","relevance":"medium","symbol":"","type":"index"},{"asset_class":"sector","name":"Oils-Energy sector","relevance":"medium","symbol":"","type":"sector"},{"asset_class":"industry","name":"Oil and Gas - Exploration and Production - United States","relevance":"low","symbol":"","type":"industry"}],"event_type":"price_action","information_gaps":["The provided headline/source summary states Coterra Energy settled at $31.42 (+1.72%), but the article text says the close was $28.04 (+1.15%). The discrepancy is not resolved within the provided text.","No specific date for the \u201clatest trading day\u201d or the \u201cpast month\u201d is provided.","The article discusses an upcoming earnings release but does not provide the release date in the provided text."],"key_facts":["CTRA closed at $28.04, a +1.15% change from the previous session.","S&P 500 fell 0.76% on the day; Dow fell 0.28%; Nasdaq fell 1.2%.","CTRA shares are up 5.64% over the last month.","Oils-Energy sector gained 4.11% over the last month; S&P 500 gained 2.71% over the last month.","Upcoming EPS is projected at $0.42, a 19.23% drop versus the same quarter of the prior year.","Quarterly revenue consensus is $1.39 billion, down 12.96% year over year.","Zacks Consensus EPS estimate moved 13.26% higher within the past month.","CTRA has a Zacks Rank of #3 (Hold).","CTRA\u2019s forward P/E is 8.23 versus industry average forward P/E of 9.01.","CTRA\u2019s PEG ratio is 0.53; industry PEG ratio is 1.33.","Oil and Gas - Exploration and Production - United States has a Zacks Industry Rank of 58 (top 24% of 250+ industries)."],"numeric_claims":[{"label":"CTRA close (latest trading day)","value":"$28.04"},{"label":"CTRA daily change","value":"+1.15%"},{"label":"S&P 500 daily change","value":"-0.76%"},{"label":"Dow daily change","value":"-0.28%"},{"label":"Nasdaq daily change","value":"-1.2%"},{"label":"CTRA 1-month change","value":"+5.64%"},{"label":"Oils-Energy sector 1-month change","value":"+4.11%"},{"label":"S&P 500 1-month change","value":"+2.71%"},{"label":"Projected EPS (upcoming)","value":"$0.42"},{"label":"Projected EPS YoY change","value":"-19.23%"},{"label":"Projected quarterly revenue (consensus)","value":"$1.39 billion"},{"label":"Revenue YoY change","value":"-12.96%"},{"label":"Zacks Consensus EPS change (past month)","value":"+13.26%"},{"label":"Forward P/E (CTRA)","value":"8.23"},{"label":"Forward P/E (industry average)","value":"9.01"},{"label":"PEG ratio (CTRA)","value":"0.53"},{"label":"PEG ratio (industry)","value":"1.33"},{"label":"Zacks Industry Rank","value":"58"}],"primary_claim":"Coterra Energy (CTRA) closed the latest trading day at $28.04, up +1.15% from the prior session, outperforming the S&P 500\u2019s -0.76% daily loss.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Coterra Energy (CTRA) closed the latest trading day higher (+1.15%) while major U.S. indices fell. The article also cites upcoming earnings expectations and recent analyst estimate revisions, with CTRA rated a Zacks Rank of #3 (Hold).","topics":["equities","stock performance","market indices","earnings expectations","analyst estimate revisions","valuation metrics","Zacks Rank"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"The latest trading day saw Coterra Energy (CTRA) settling at $31.42, representing a +1.72% change from its previous close.","tickers":["CTRA"],"title":"Coterra Energy (CTRA) Ascends While Market Falls: Some Facts to Note","url":"https://www.nasdaq.com/articles/coterra-energy-ctra-ascends-while-market-falls-some-facts-note"}}

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