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/copa-holdings-cpa-surges-68-indication-further-gains","as_of":"2026-04-09T10:38:52.980302+00:00","canonical_url":"https://www.nasdaq.com/articles/copa-holdings-cpa-surges-68-indication-further-gains","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/copa-holdings-cpa-surges-68-indication-further-gains","article_chars":4339,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_f21f00bc6500b5f3","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/copa-holdings-cpa-surges-68-indication-further-gains","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T02:17:21.878761+00:00","extraction_method":"heuristic","fetched_description":"Copa Holdings (CPA) saw its shares surge in the last session with trading volume being higher than average. The latest trend in earnings estimate revisions may not translate into further price increase in the near term.","fetched_title":"Copa Holdings (CPA) Surges 6.8%: Is This an Indication of Further Gains? | Nasdaq","final_url":"https://www.nasdaq.com/articles/copa-holdings-cpa-surges-68-indication-further-gains","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/copa-holdings-cpa-surges-68-indication-further-gains","source_event_id":"evt_39213cd0b730","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"066c5b968e19297e","kind":"new_listings","published_at":"2026-04-09T08:53:00+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 09, 2026"],"entities":[{"asset_class":"equity","name":"Copa Holdings","relevance":"high","symbol":"CPA","type":"company"},{"asset_class":"unknown","name":"Bank of America","relevance":"medium","symbol":"","type":"institution"},{"asset_class":"equity","name":"Surf Air Mobility Inc.","relevance":"low","symbol":"SRFM","type":"company"}],"event_type":"price_action","information_gaps":["The article does not provide the exact trading volume figure or the average volume baseline used for \u201chigher-than-average.\u201d","No specific details are given about the magnitude/timing of Bank of America\u2019s reiterated Buy rating beyond the statement that it was reiterated.","The article does not specify the date/time of the \u201clast trading session\u201d beyond the publication timestamp.","The article does not provide the full earnings/revenue consensus range or analyst count behind the estimates.","The signal type is labeled as discovery_new_listings_delta, but the provided text describes a price move and analyst/estimate context rather than a new listing; no listing-related facts are present in the text."],"key_facts":["CPA shares ended the last trading session 6.8% higher at $119.17.","The session volume was higher than average (implied by \u201cimpressive volume with a higher-than-average number of shares changing hands\u201d).","CPA had an 11.1% loss over the past four weeks (as stated).","Bank of America reiterated a Buy rating on Copa Holdings.","The article attributes Bank of America\u2019s bullish stance to \u201cattractive valuation.\u201d","The article says the bullish stance came despite pressure induced by high oil prices.","Upcoming quarterly earnings for Copa Holdings are expected to be $4.54 per share.","The expected quarterly earnings are described as +6.1% year-over-year.","Revenues are expected to be $1.03 billion, up 14.2% year-over-year.","The consensus EPS estimate for the quarter was revised 17.4% lower over the last 30 days to the current level.","The article states that a negative trend in earnings estimate revisions doesn\u2019t usually translate into price appreciation.","CPA\u2019s Zacks Rank is #3 (Hold).","The article states Copa Holdings is part of the Zacks Transportation - Airline industry."],"numeric_claims":[{"label":"CPA last session close","value":"$119.17"},{"label":"CPA price change (last session)","value":"+6.8%"},{"label":"CPA performance (past four weeks)","value":"-11.1%"},{"label":"Expected quarterly EPS (CPA)","value":"$4.54"},{"label":"Expected quarterly EPS YoY change","value":"+6.1%"},{"label":"Expected quarterly revenue (CPA)","value":"$1.03 billion"},{"label":"Expected quarterly revenue YoY change","value":"+14.2%"},{"label":"EPS estimate revision over last 30 days","value":"-17.4%"},{"label":"Zacks Rank (CPA)","value":"#3 (Hold)"}],"primary_claim":"CPA shares ended the last trading session up 6.8% to $119.17 on higher-than-average volume after Bank of America reiterated a Buy rating.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Copa Holdings (CPA) rose 6.8% to $119.17 on higher-than-average volume, following Bank of America reiterating a Buy rating. The article notes earnings/revenue expectations and that recent earnings estimate revisions have moved lower, which may limit near-term upside.","topics":["stock surge","trading volume","analyst rating","earnings estimate revisions","airline industry","valuation"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"Copa Holdings (CPA) saw its shares surge in the last session with trading volume being higher than average. The latest trend in earnings estimate revisions may not translate into further price increase in the near term.","tickers":["CPA"],"title":"Copa Holdings (CPA) Surges 6.8%: Is This an Indication of Further Gains?","url":"https://www.nasdaq.com/articles/copa-holdings-cpa-surges-68-indication-further-gains"}

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