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/ryohin-keikaku-co-ltd-rykky-upgraded-buy-heres-what-you-should-know","as_of":"2026-04-10T17:21:18.772571+00:00","canonical_url":"https://www.nasdaq.com/articles/ryohin-keikaku-co-ltd-rykky-upgraded-buy-heres-what-you-should-know","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ryohin-keikaku-co-ltd-rykky-upgraded-buy-heres-what-you-should-know","article_chars":4873,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_112f0ffcda40fa06","canonical_host":"nasdaq.com","canonical_is_aggregator":false,"canonical_url":"https://www.nasdaq.com/articles/ryohin-keikaku-co-ltd-rykky-upgraded-buy-heres-what-you-should-know","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-11T22:01:48.519192+00:00","extraction_method":"trafilatura","fetched_description":"Ryohin Keikaku Co. Ltd. (RYKKY) might move higher on growing optimism about its earnings prospects, which is reflected by its upgrade to a Zacks Rank #2 (Buy).","fetched_title":"Ryohin Keikaku Co. Ltd. (RYKKY) Upgraded to Buy: Here's What You Should Know | Nasdaq","final_url":"https://www.nasdaq.com/articles/ryohin-keikaku-co-ltd-rykky-upgraded-buy-heres-what-you-should-know","html_truncated":false,"paywall_likely":false,"publisher_domain":"nasdaq.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ryohin-keikaku-co-ltd-rykky-upgraded-buy-heres-what-you-should-know","source_event_id":"evt_da45fc747d67","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a380b458897bb604","kind":"new_listings","published_at":"2026-04-10T16:00:03+00:00","publisher_domain":"nasdaq.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["fiscal year ending August 2026","past three months","since 1988"],"entities":[{"asset_class":"equity","name":"Ryohin Keikaku Co. Ltd.","relevance":"high","symbol":"RYKKY","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 date of the Zacks upgrade.","No specific prior Zacks rank (before the upgrade) is stated.","The article does not quantify the magnitude/timing of any expected stock price move; it only states it 'might move higher' in the near term.","The article includes additional unrelated text about semiconductors/AI demand and a 'Zacks Names #1 Semiconductor Stock' section, but it does not clearly connect those details to Ryohin Keikaku within the provided excerpt.","No direct earnings estimate revision table or breakdown is included beyond the stated 3% increase in the Zacks Consensus Estimate over three months."],"key_facts":["The article states Ryohin Keikaku Co. Ltd. (RYKKY) was upgraded to a Zacks Rank #2 (Buy).","The article says the Zacks rating reflects changes in a company's earnings picture and that the sole determinant is the changing earnings picture.","For the fiscal year ending August 2026, the article states the expected EPS is $0.35 per share and that this is unchanged versus the year-ago reported number.","The article states that over the past three months, the Zacks Consensus Estimate for the company increased 3%.","The article claims that earnings estimate revisions are strongly correlated with near-term stock price movements (correlation described, not quantified in the text).","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 the Zacks Rank system uses four factors related to earnings estimates and classifies stocks into five groups from #1 (Strong Buy) to #5 (Strong Sell).","The article states that only the top 5% of Zacks-covered stocks get a Strong Buy rating and the next 15% get a Buy rating, implying top 20% placement for Zacks Rank #2."],"numeric_claims":[{"label":"Zacks Rank","value":"#2 (Buy)"},{"label":"EPS expectation (fiscal year ending Aug 2026)","value":"$0.35 per share"},{"label":"EPS change vs year-ago reported number","value":"unchanged"},{"label":"Zacks Consensus Estimate change (past three months)","value":"+3%"},{"label":"Average annual return for Zacks Rank #1 since 1988","value":"+25%"},{"label":"Zacks-covered universe size (as stated)","value":"more than 4,000 stocks"},{"label":"Top 5% threshold for Strong Buy","value":"5%"},{"label":"Next 15% threshold for Buy","value":"15%"}],"primary_claim":"Ryohin Keikaku Co. Ltd. (RYKKY) was upgraded to Zacks Rank #2 (Buy) due to an upward trend in earnings estimates.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Ryohin Keikaku Co. Ltd. (RYKKY) was upgraded to a Zacks Rank #2 (Buy), attributed in the article to upward revisions in earnings estimates. The article also cites specific EPS expectations and a recent increase in the Zacks Consensus Estimate.","topics":["earnings estimate revisions","Zacks Rank upgrade","EPS outlook","analyst consensus","stock price impact (as described by article)"]},"source":"Nasdaq Stocks","source_domain":"nasdaq.com","summary":"Ryohin Keikaku Co. Ltd. (RYKKY) might move higher on growing optimism about its earnings prospects, which is reflected by its upgrade to a Zacks Rank #2 (Buy).","tickers":["RYKKY","BUY"],"title":"Ryohin Keikaku Co. Ltd. (RYKKY) Upgraded to Buy: Here's What You Should Know","url":"https://www.nasdaq.com/articles/ryohin-keikaku-co-ltd-rykky-upgraded-buy-heres-what-you-should-know"}

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