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

{"created_at":"2026-04-17T14:13:05.509159+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:eb8f5f2a175abd0b","evidence_event_ids":["evt_653ba7bd63ba"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/what-know-about-29-million-defense-etf-buy-15-allocation-bet","as_of":"2026-04-17T14:13:05.509159+00:00","canonical_url":"https://www.fool.com/coverage/filings/2026/04/17/what-to-know-about-this-usd2-9-million-defense-etf-buy-in-a-1-5-allocation-bet/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/what-know-about-29-million-defense-etf-buy-15-allocation-bet","article_chars":4613,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_6cf333c427647e22","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/coverage/filings/2026/04/17/what-to-know-about-this-usd2-9-million-defense-etf-buy-in-a-1-5-allocation-bet/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T22:45:27.245293+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsTrue Vision MN bought 87,908 shares of IDEF in the first quarter.","fetched_title":"What to Know About This $2.9 Million Defense ETF Buy in a 1.5% Allocation Bet | Nasdaq","final_url":"https://www.nasdaq.com/articles/what-know-about-29-million-defense-etf-buy-15-allocation-bet","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/what-know-about-29-million-defense-etf-buy-15-allocation-bet","source_event_id":"evt_653ba7bd63ba","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"bbd74504812f255e","kind":"unusual_volume","published_at":"2026-04-17T13:55:43+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["first quarter","April 16, 2026","March 31, 2026","May 2025","April 17, 2026"],"entities":[{"asset_class":"equity_fund_or_adviser","name":"True Vision MN LLC","relevance":"high","symbol":"","type":"institutional_investor"},{"asset_class":"etf","name":"iShares Defense Industrials Active ETF","relevance":"high","symbol":"IDEF","type":"etf"}],"event_type":"listing","information_gaps":["The signal type requested 'unusual volume delta' (volume ratio vs average), but the provided text contains no trading volume data or volume ratio versus baseline.","No explicit confirmation is provided that the buy caused any unusual volume; the article frames the event as a disclosed SEC position rather than a volume anomaly.","The article does not provide a specific, evidence-backed catalyst tied to the trade beyond a general statement that it is 'likely no coincidence' with U.S.-Iran geopolitical tensions; this is presented as the author\u2019s likelihood rather than a confirmed causal link.","catalyst_hint_missing_for_volume_delta: volume_ratio_vs_average not available in provided text."],"key_facts":["SEC filing dated April 16, 2026 states True Vision MN initiated a new position in iShares Defense Industrials Active ETF (NASDAQ: IDEF) by purchasing 87,908 shares.","The quarter-end value of the IDEF stake was $2.88 million.","The IDEF position accounts for 1.48% of True Vision MN\u2019s $193.90 million in reportable U.S. equity assets as of March 31, 2026.","After the filing, IDEF is outside True Vision MN LLC\u2019s top five holdings.","The article describes IDEF as an actively managed ETF focused on defense and industrials sectors."],"numeric_claims":[{"label":"shares_bought","value":"87,908"},{"label":"position_value_usd","value":"$2.88 million"},{"label":"allocation_percent_of_reportable_assets","value":"1.48%"},{"label":"reportable_U.S._equity_assets_usd","value":"$193.90 million"},{"label":"quarter_end_stake_outside_top_five","value":"Yes"},{"label":"expense_ratio_percent","value":"0.55%"},{"label":"ETF_assets_about_usd","value":"$3.6 billion"},{"label":"ETF_holdings_about","value":"109"},{"label":"industrials_concentration_percent","value":"~88%"}],"primary_claim":"True Vision MN disclosed a new IDEF position of 87,908 shares valued at $2.88 million in an SEC filing dated April 16, 2026.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"True Vision MN initiated a new position in the iShares Defense Industrials Active ETF (NASDAQ: IDEF) in the first quarter, buying 87,908 shares worth $2.88 million. The position represents 1.48% of the fund\u2019s reportable U.S. equity assets as of March 31, 2026 and sits outside the adviser\u2019s top five holdings.","topics":["SEC filing","ETF position disclosure","defense/industrials sector exposure","portfolio allocation","satellite position"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsTrue Vision MN bought 87,908 shares of IDEF in the first quarter.","tickers":[],"title":"What to Know About This $2.9 Million Defense ETF Buy in a 1.5% Allocation Bet","url":"https://www.fool.com/coverage/filings/2026/04/17/what-to-know-about-this-usd2-9-million-defense-etf-buy-in-a-1-5-allocation-bet/"}}

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