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-17T18:02:19.234747+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:09f9d06e7820cc9a","evidence_event_ids":["evt_887cc0a3f82d"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/heres-why-i-wouldnt-touch-usa-rare-earth-10-foot-pole-critical-minerals-arms-race","as_of":"2026-04-17T18:02:19.234747+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/wouldnt-touch-usa-rare-earth-critical-minerals/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/heres-why-i-wouldnt-touch-usa-rare-earth-10-foot-pole-critical-minerals-arms-race","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5c6c993f5c2c3ff7","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/wouldnt-touch-usa-rare-earth-critical-minerals/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T23:24:07.750558+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsUSA Rare Earth wants to open a rare earth mine by 2028, along with a permanent magnet factory.","fetched_title":"Here's Why I Wouldn't Touch USA Rare Earth With a 10\u2011Foot Pole in This Critical\u2011Minerals Arms Race | Nasdaq","final_url":"https://www.nasdaq.com/articles/heres-why-i-wouldnt-touch-usa-rare-earth-10-foot-pole-critical-minerals-arms-race","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/heres-why-i-wouldnt-touch-usa-rare-earth-10-foot-pole-critical-minerals-arms-race","source_event_id":"evt_887cc0a3f82d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"37bcb5c918c38c81","kind":"unusual_volume","published_at":"2026-04-17T17:05:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["2028","later this year","midterm elections","next president","December 17, 2004","April 15, 2005","April 17, 2026"],"entities":[{"asset_class":"equity","name":"USA Rare Earth","relevance":"high","symbol":"USAR","type":"company"},{"asset_class":"sovereign","name":"U.S. federal government","relevance":"high","symbol":"","type":"government"},{"asset_class":"person","name":"Donald Trump","relevance":"medium","symbol":"","type":"person"},{"asset_class":"media","name":"Reuters","relevance":"medium","symbol":"","type":"news_outlet"},{"asset_class":"government","name":"White House","relevance":"medium","symbol":"","type":"government_body"}],"event_type":"other","information_gaps":["No explicit data is provided in the text about unusual trading volume, baseline volume, direction (up/down), or a volume ratio vs average.","The article references Reuters but does not quote specific Reuters figures or details in the provided text.","The article is an opinion piece (\u201cwouldn\u2019t touch\u2026\u201d, \u201cbacking away\u201d), so the catalyst hypotheses are not confirmed with direct evidence of the volume move.","unusual_volume.catalyst_hint is not specified in the provided text."],"key_facts":["USA Rare Earth (NASDAQ: USAR) aims to open a rare earth mine in 2028 and open its first magnet factory later this year (as stated in the article).","The company received a U.S. federal letter of intent for $1.6 billion (as stated in the article).","The article states the $1.6 billion deal includes a $1.3 billion loan and $277 million in federal funding (as stated in the article).","The article states the U.S. government would receive 16.1 million shares and warrants for another 17.6 million shares (as stated in the article).","The article states the deal gives the U.S. government an equity stake but does not guarantee funding, and that the government could keep its equity even if it never provides funding (as stated in the article).","The article hypothesizes that if the government exercises the 17.6 million warrants, dilution could occur without shareholders getting anything in return (as stated in the article).","The article cites Reuters reporting as making the narrative more complicated (as stated in the article).","The article suggests policy priorities could shift due to events like a war or budget fight, potentially delaying or redirecting capital (as stated in the article).","The article suggests election/administration changes could alter deal terms (as stated in the article)."],"numeric_claims":[{"label":"letter_of_intent_amount_usd","value":"$1.6 billion"},{"label":"loan_amount_usd","value":"$1.3 billion"},{"label":"federal_funding_amount_usd","value":"$277 million"},{"label":"shares_received_millions","value":"16.1 million"},{"label":"warrants_shares_millions","value":"17.6 million"},{"label":"mine_opening_year","value":"2028"}],"primary_claim":"USA Rare Earth received a U.S. federal letter of intent for $1.6 billion that grants the government an equity stake but does not guarantee funding, potentially enabling dilution if warrants are exercised.","relevance_score":0.42,"sentiment":"negative","source_quality":"high","summary":"The article argues that USA Rare Earth (USAR) faces significant uncertainty despite a U.S. federal letter of intent tied to $1.6B, including potential dilution risk and funding/priority uncertainty. It does not provide any specific unusual trading-volume ratio data in the text.","topics":["critical minerals","rare earth supply chain","permanent magnets","federal investment/letter of intent","equity stake and warrants","funding uncertainty","dilution risk","election/policy risk","pre-revenue mining company"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsUSA Rare Earth wants to open a rare earth mine by 2028, along with a permanent magnet factory.","tickers":[],"title":"Here's Why I Wouldn't Touch USA Rare Earth With a 10\u2011Foot Pole in This Critical\u2011Minerals Arms Race","url":"https://www.fool.com/investing/2026/04/17/wouldnt-touch-usa-rare-earth-critical-minerals/"}}

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