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

{"artifact_id":"artf_thesis_195f17738d8374f6","evidence_event_ids":["evt_7f7ec87adbea"],"kind":"opportunity_thesis","meta":{"confidence":0.56,"lane":"monitor","morning_holdback":false,"rank_score":0.56,"theme_keys":[],"urgency_reason":"not_urgent","urgent":false},"output_json":{"artifact_kind_detail":"research_thesis","catalysts":[],"confidence":0.56,"decision_reason_codes":["research_thesis","evidence_positive_earnings_esp_simo_8_99","evidence_positive_earnings_esp_shop_11_72","evidence_framework_positive_esp_plus_rank3_correlates_70pct","evidence_theme_mismatch_onshoring_not_explicit_for_simo_shop","evidence_no_additional_catalysts_provided"],"headline":"Silicon Motion (SIMO) and Shopify (SHOP) both have positive Earnings ESP figures (+8.99% for SIMO and +11.72% for SHOP) and could potentially post earnings beats in their next reports.","investigation_questions":["For SIMO and SHOP, what are the specific Most Accurate Estimate and Zacks Consensus Estimate figures that produce the stated Earnings ESP (+8.99% and +11.72%), and how stable are those estimates over the last several weeks?","Do SIMO and SHOP also meet the \u201cZacks Rank #3 (Hold) or better\u201d condition referenced in the evidence, and how does that rank compare to their prior rank history?","How do SIMO and SHOP\u2019s historical earnings surprise rates compare to the cited 70% benchmark when they have positive Earnings ESP?","Are there any company-specific factors (e.g., guidance changes, accounting/one-off items, or segment mix shifts) that could cause earnings to miss despite positive Earnings ESP?","Given the theme context (onshoring/industrial reshoring) is not explicitly tied to SIMO or SHOP in the provided evidence, what alternative thematic drivers (if any) better explain their earnings expectations?"],"portfolio_fit":{"applied":false,"boost":0.0,"exit_risk_flagged":false,"hedge_suggested":null,"matched_holdings":[],"matched_watchlist":[],"stub_version":"v1","why_you":""},"related_tickers":["SIMO","SHOP"],"risk_level":"medium","theme_keys":[],"thesis":"A basket thesis centered on \u201cearnings beat probability\u201d uses the provided Zacks Earnings ESP signals: SIMO\u2019s +8.99% and SHOP\u2019s +11.72% suggest both names have Most Accurate Estimates above the Zacks Consensus Estimate. If the historical relationship cited (positive ESP plus Zacks Rank #3 or better correlating with positive earnings surprises 70% of the time) holds for the next reporting cycle, both stocks could be positioned for upside earnings reactions."},"ready_at":"2026-04-20T19:11:55.520835+00:00","status":"ready","summary":"A basket thesis centered on \u201cearnings beat probability\u201d uses the provided Zacks Earnings ESP signals: SIMO\u2019s +8.99% and SHOP\u2019s +11.72% suggest both names have Most Accurate Estimates above the Zacks Consensus Estimate. If the historical relationship cited (positive ESP plus Zacks Rank #3 or better correlating with positive earnings surprises 70% of the time)","title":"[THESIS] SIMO \u2014 Silicon Motion (SIMO) and Shopify (SHOP) both have positive Earnings ESP figures (+8.99% for SIMO and +11.72% for SHOP) and could potentially post earnings beats in their next reports.","updated_at":"2026-04-20T19:11:55.520835+00:00"}

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