SQLite Web: event_store.db

Update row 474721 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-20T17:15:12.787981+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:3ae1ae87fa3a6e32","evidence_event_ids":["evt_b851ce2d2741"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/tsmc-tsm-upgraded-buy-heres-why","as_of":"2026-04-20T17:15:12.787981+00:00","canonical_url":"https://www.nasdaq.com/articles/tsmc-tsm-upgraded-buy-heres-why","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/tsmc-tsm-upgraded-buy-heres-why","article_chars":4999,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b64d484ccedd443b","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/tsmc-tsm-upgraded-buy-heres-why","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T22:45:55.937684+00:00","extraction_method":"trafilatura","fetched_description":"TSMC (TSM) might move higher on growing optimism about its earnings prospects, which is reflected by its upgrade to a Zacks Rank #2 (Buy).","fetched_title":"TSMC (TSM) Upgraded to Buy: Here's Why | Nasdaq","final_url":"https://www.nasdaq.com/articles/tsmc-tsm-upgraded-buy-heres-why","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/tsmc-tsm-upgraded-buy-heres-why","source_event_id":"evt_b851ce2d2741","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c55eca8f2876648b","kind":"new_listings","published_at":"2026-04-20T16:00:05+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["December 2026","past three months","since 1988"],"entities":[{"asset_class":"equity","name":"TSMC","relevance":"high","symbol":"TSM","type":"company"},{"asset_class":"other","name":"Zacks Rank","relevance":"high","symbol":"","type":"rating_system"}],"event_type":"earnings","information_gaps":["The article does not provide the specific date of the upgrade.","No details are given on the magnitude/direction of earnings estimate revisions for years other than the stated FY ending December 2026 and the 5.6% three-month change.","The article does not quantify the expected stock-price move; it only suggests the stock might move higher in the near term.","The article includes general claims about correlation between earnings estimate revisions and stock price movement, but does not provide the underlying study details within the provided text."],"key_facts":["TSMC was upgraded to a Zacks Rank #2 (Buy).","The article states the Zacks rating change reflects an upward trend in earnings estimates.","The article claims the Zacks Consensus Estimate (EPS consensus) for the current and following years is tracked by the system.","The article states the Zacks Consensus Estimate for the fiscal year ending December 2026 is $14.62 per share and is unchanged versus the year-ago reported number.","The article states that over the past three months, the Zacks Consensus Estimate for TSMC increased 5.6%.","The article states Zacks Rank #1 stocks have generated an average annual return of +25% since 1988 (as claimed by the article).","The article states Zacks Rank #2 (Buy) places the stock in the top 20% of Zacks-covered stocks in terms of estimate revisions, implying it might move higher in the near term."],"numeric_claims":[{"label":"Zacks Rank","value":"#2 (Buy)"},{"label":"EPS consensus (FY ending Dec 2026)","value":"$14.62 per share"},{"label":"EPS consensus change vs year-ago reported number","value":"unchanged"},{"label":"Zacks Consensus Estimate increase (past three months)","value":"5.6%"},{"label":"Average annual return for Zacks Rank #1 since 1988 (claimed)","value":"+25%"}],"primary_claim":"TSMC\u2019s upgrade to Zacks Rank #2 (Buy) reflects an upward trend in earnings estimates, with the article suggesting this could favorably impact the stock price.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"TSMC was upgraded to a Zacks Rank #2 (Buy), which the article attributes to upward revisions in earnings estimates and a potentially favorable near-term stock impact.","topics":["earnings estimate revisions","stock rating upgrade","Zacks Rank #2 (Buy)","EPS consensus","fiscal year ending December 2026"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"TSMC (TSM) might move higher on growing optimism about its earnings prospects, which is reflected by its upgrade to a Zacks Rank #2 (Buy).","tickers":["TSM","BUY"],"title":"TSMC (TSM) Upgraded to Buy: Here's Why","url":"https://www.nasdaq.com/articles/tsmc-tsm-upgraded-buy-heres-why"}}

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