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/trump-leans-missile-defense-his-iran-strategy-raytheon-has-never-been-more-critical","as_of":"2026-04-20T14:11:25.277652+00:00","canonical_url":"https://www.fool.com/investing/2026/04/20/trump-missile-defense-iran-strategy-raytheon-rtx/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/trump-leans-missile-defense-his-iran-strategy-raytheon-has-never-been-more-critical","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_b51370555737c1a0","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/20/trump-missile-defense-iran-strategy-raytheon-rtx/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-20T14:13:13.689386+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsRTX may be a winner as the U.S. re-arms following the ongoing war in Iran.","fetched_title":"As Trump Leans on Missile Defense in His Iran Strategy, Raytheon Has Never Been More Critical | Nasdaq","final_url":"https://www.nasdaq.com/articles/trump-leans-missile-defense-his-iran-strategy-raytheon-has-never-been-more-critical","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/trump-leans-missile-defense-his-iran-strategy-raytheon-has-never-been-more-critical","source_event_id":"evt_b84cb8873fda","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9f1b41f325068ba9","kind":"unusual_volume","published_at":"2026-04-20T13:32:13+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["Last Friday","By Saturday","As of Monday morning","2023 rebranding","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity","name":"Raytheon Technologies (RTX)","relevance":"high","symbol":"RTX","type":"company"},{"asset_class":"equity","name":"Raytheon","relevance":"high","symbol":"","type":"company_brand"},{"asset_class":"equity","name":"United Technologies","relevance":"medium","symbol":"","type":"company"},{"asset_class":"other","name":"Tomahawk missile","relevance":"high","symbol":"","type":"military_product"},{"asset_class":"other","name":"U.S. military / Uncle Sam","relevance":"high","symbol":"","type":"government_actor"},{"asset_class":"other","name":"Iran","relevance":"high","symbol":"","type":"country"}],"event_type":"supply_disruption","information_gaps":["No unusual trading volume ratio vs average is provided in the supplied text (baseline volume and volume ratio are null).","The article does not explicitly state whether any volume spike is confirmed by news; it only discusses price action and a thesis about missile procurement.","The most likely catalyst hypothesis for unusual volume cannot be grounded from the provided text because no volume data is included; only a general catalyst thesis (U.S. missile replenishment/rearmament) is described."],"key_facts":["The article states that in the first month of the Iran war, the U.S. flew 319 Tomahawk missiles, described as equivalent to 10% of its total stockpile.","The article states Raytheon can produce 500 Tomahawks per year under typical conditions.","The article states the government ordered Raytheon to double its Tomahawk production due to rapid depletion.","The article states RTX is pledging to, in some cases, quadruple current production rates.","The article states the U.S. is boosting orders for mission-critical missile categories including air-to-air defense missiles and interceptor missiles.","The article notes RTX lost 2.55% last week while the broader market rallied amid hopes of cooling Middle East tensions and progress in U.S.-Iran negotiations."],"numeric_claims":[{"label":"RTX weekly price change","value":"-2.55% (last week, per article)"},{"label":"Tomahawk missiles flown in first month of war","value":"319"},{"label":"Tomahawk share of total stockpile (as stated)","value":"10%"},{"label":"Typical Tomahawk production rate","value":"500 per year"}],"primary_claim":"The U.S. has been using Raytheon-produced Tomahawk missiles in the Iran war and has ordered RTX to increase production (including doubling and in some cases quadrupling rates) to replenish depleted stockpiles.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"The article argues that RTX (Raytheon) could benefit from U.S. rearmament needs tied to the Iran conflict, citing missile depletion and government orders to increase production. It does not provide a specific unusual trading volume ratio in the provided text.","topics":["aerospace and defense","missile production","U.S. rearmament","Iran conflict","Tomahawk missile stockpile replenishment","government procurement orders","RTX production rate increases"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsRTX may be a winner as the U.S. re-arms following the ongoing war in Iran.","tickers":[],"title":"As Trump Leans on Missile Defense in His Iran Strategy, Raytheon Has Never Been More Critical","url":"https://www.fool.com/investing/2026/04/20/trump-missile-defense-iran-strategy-raytheon-rtx/"}

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