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/shj-wealth-advisors-opens-10-million-position-ishares-defense-industrials-active-etf-idef","as_of":"2026-04-09T04:42:09.468703+00:00","canonical_url":"https://www.fool.com/coverage/filings/2026/04/08/shj-wealth-advisors-opens-usd10-million-position-in-ishares-defense-industrials-active-etf-idef/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/shj-wealth-advisors-opens-10-million-position-ishares-defense-industrials-active-etf-idef","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ea3776dc758057a5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/filings/2026/04/08/shj-wealth-advisors-opens-usd10-million-position-in-ishares-defense-industrials-active-etf-idef/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T23:52:26.523544+00:00","extraction_method":"heuristic","fetched_description":"Key PointsSHJ acquired 311,318 shares in a new position; estimated trade size $10.19 million based on quarterly average price.","fetched_title":"SHJ Wealth Advisors Opens $10 Million Position in iShares Defense Industrials Active ETF (IDEF) | Nasdaq","final_url":"https://www.nasdaq.com/articles/shj-wealth-advisors-opens-10-million-position-ishares-defense-industrials-active-etf-idef","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/shj-wealth-advisors-opens-10-million-position-ishares-defense-industrials-active-etf-idef","source_event_id":"evt_e760b8c03dca","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3de0d33c9d507771","kind":"unusual_volume","published_at":"2026-04-09T02:38:37+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["April 8, 2026","May 2025","first quarter of 2026","April 08, 2026 \u2014 10:38 pm EDT"],"entities":[{"asset_class":"other","name":"SHJ Wealth Advisors","relevance":"high","symbol":"","type":"company_or_firm"},{"asset_class":"etf","name":"iShares Defense Industrials Active ETF","relevance":"high","symbol":"IDEF","type":"fund"},{"asset_class":"etf","name":"BlackRock ETF Trust - iShares Defense Industrials Active ETF","relevance":"medium","symbol":"IDEF","type":"fund"},{"asset_class":"other","name":"SEC","relevance":"medium","symbol":"","type":"regulator"},{"asset_class":"other","name":"United Nations (U.N.)","relevance":"low","symbol":"","type":"organization"}],"event_type":"listing","information_gaps":["This signal type requests an unusual volume delta (volume ratio vs average), but the provided text contains no volume figures or volume ratio information for IDEF.","The article describes the transaction via a SEC/13F filing, but does not confirm any market-wide \u201cunusual volume\u201d event or provide a volume-based catalyst.","No explicit confirmation is given that the trade was driven by a specific news catalyst on/around April 8, 2026; the catalyst discussion is presented as an investment thesis (defense tailwinds) rather than a confirmed trigger."],"key_facts":["The article states SHJ Wealth Advisors reported a new holding of 311,318 shares in iShares Defense Industrials Active ETF (NASDAQ: IDEF) in a SEC filing dated April 8, 2026.","The estimated transaction value is approximately $10.19 million, calculated using the average closing price for the first quarter of 2026.","The quarter-end position value increased by $10.19 million, reflecting the stake purchase and price effects.","Post-trade, SHJ holds 311,318 shares valued at $10.19 million.","The position represents a 1.37% increase in the fund\u2019s 13F reportable assets under management.","The article says IDEF is not among SHJ\u2019s top five holdings by value after the filing.","The article states IDEF has delivered total returns of 35% since its debut in May 2025 (doubling the S&P 500\u2019s returns over the same time).","The article provides an ETF overview including an expense ratio of 0.55% and AUM of $3.27 billion (as stated in the text).","The article suggests a catalyst hypothesis tied to defense/industrial modernization and a UN projection that global military spending could more than double by 2035."],"numeric_claims":[{"label":"shares_acquired","value":"311,318"},{"label":"estimated_transaction_value_usd","value":"$10.19 million"},{"label":"position_value_post_trade_usd","value":"$10.19 million"},{"label":"percent_of_13F_AUM","value":"1.37%"},{"label":"IDEF_total_returns_since_debut","value":"35%"},{"label":"expense_ratio","value":"0.55%"},{"label":"IDEF_AUM_usd","value":"$3.27 billion"},{"label":"IDEF_price_as_of_close_apr_8_2026","value":"33.97"}],"primary_claim":"SHJ Wealth Advisors opened a new position of 311,318 shares in iShares Defense Industrials Active ETF (NASDAQ: IDEF), with an estimated transaction value of about $10.19 million based on the first-quarter average closing price.","relevance_score":0.42,"sentiment":"mixed","source_quality":"high","summary":"SHJ Wealth Advisors disclosed a new $10.19 million position in the iShares Defense Industrials Active ETF (IDEF) via a SEC filing dated April 8, 2026. The article frames the move as a sizable new allocation (311,318 shares; ~1.37% of SHJ\u2019s 13F reportable AUM) amid strong recent ETF performance.","topics":["13F filing","ETF position disclosure","defense and industrials sector","fund flows/portfolio changes","investment thesis/tailwinds","expense ratio"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsSHJ acquired 311,318 shares in a new position; estimated trade size $10.19 million based on quarterly average price.","tickers":["IDEF"],"title":"SHJ Wealth Advisors Opens $10 Million Position in iShares Defense Industrials Active ETF (IDEF)","url":"https://www.fool.com/coverage/filings/2026/04/08/shj-wealth-advisors-opens-usd10-million-position-in-ishares-defense-industrials-active-etf-idef/"}

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