Create
Query
event_store.db
—
events
actions
agent_runs
approvals
artifacts
commitments
constraints
conversation_compaction
conversation_state
conversation_turns
dead_letters
decisions
deliveries
effects
email_messages
email_reply_drafts
email_threads
entities
entity_aliases
entity_tags
episode_context_index
episodes
event_subjects
events
events_archive
fact_sources
facts
inbox_items
inbox_links
intel_memory
jobs
leader_leases
links
memory_candidates
memory_embeddings
memory_items
memory_items_fts
(v)
memory_items_fts_config
memory_items_fts_data
memory_items_fts_idx
opportunity_memory
pending_interactions
proposal_sources
proposals
reminders
schedules
schema_migrations
signal_candidates
signal_fps
signals
sms_conversations
sms_messages
sms_reply_drafts
source_cursors
sources
sqlite_sequence
sqlite_stat1
stream_cursors
threads
watchers
Toggle helper tables
memory_items_fts_content
memory_items_fts_docsize
memory_items_fts_segdir
memory_items_fts_segments
memory_items_fts_stat
Structure
Content
Query
Insert
Drop
Import
Export
Update row 90226 in events
seq
Primary key.
INTEGER
id
evt_f1a1b3e45d4d
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-17T21:48:49.066487+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-17T05:13:38.534721+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:7b16337a4a1563fa","evidence_event_ids":["evt_aac56fb61d3b"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/forget-usa-rare-earth-why-trumps-bet-critical-minerals-play-could-backfire-investors","as_of":"2026-04-17T05:13:38.534721+00:00","canonical_url":"https://www.fool.com/investing/2026/04/17/forget-usa-rare-earth-why-trumps-bet-on-this-criti/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/forget-usa-rare-earth-why-trumps-bet-critical-minerals-play-could-backfire-investors","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_69fdc0fd1498e56f","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/17/forget-usa-rare-earth-why-trumps-bet-on-this-criti/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-17T21:48:49.066441+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsDespite promising developments, high uncertainty remains with USA Rare Earth, a pre-revenue start-up focused on building a rare-earth value chain.","fetched_title":"Forget USA Rare Earth: Why Trump's Bet on This Critical Minerals Play Could Backfire for Investors | Nasdaq","final_url":"https://www.nasdaq.com/articles/forget-usa-rare-earth-why-trumps-bet-critical-minerals-play-could-backfire-investors","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/forget-usa-rare-earth-why-trumps-bet-critical-minerals-play-could-backfire-investors","source_event_id":"evt_aac56fb61d3b","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5832bd537baf5332","kind":"unusual_volume","published_at":"2026-04-17T04:35:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["January 2026","Earlier this month (no exact date provided)","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":"government","name":"U.S. Department of Commerce","relevance":"high","symbol":"","type":"government_agency"},{"asset_class":"politician","name":"Zoe Lofgren","relevance":"medium","symbol":"","type":"person"},{"asset_class":"politician","name":"Howard Lutnick","relevance":"medium","symbol":"","type":"person"},{"asset_class":"company","name":"Carester","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"low","symbol":"NVDA","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"low","symbol":"INTC","type":"company"}],"event_type":"other","information_gaps":["The provided signal type is discovery_unusual_volume_delta, but the article text does not include any volume ratio, baseline volume, or confirmation details tied to unusual trading volume.","No explicit statement is provided about whether the unusual volume is confirmed by news events or is unexplained.","The headline suggests a potential investor backfire narrative, but the article excerpt does not quantify the \u201cunusual volume delta\u201d itself.","catalyst_hint_for_volume_delta_unavailable_due_to_missing_data: The most likely catalyst hypothesis for the volume spike cannot be grounded from the provided text; however, the article references recent developments (e.g., the Carester investment and the Commerce LOI headlines) as potential narrative drivers. This is a hypothesis only, not confirmed by volume data in the excerpt."],"key_facts":["USA Rare Earth (NASDAQ: USAR) is described as a pre-revenue rare-earth minerals exploration/value-chain company.","The U.S. Department of Commerce entered a nonbinding letter of intent (LOI) proposing up to $1.6 billion in funding and loans after USA Rare Earth raised an additional $1.5 billion in private capital (as stated in the article).","The article emphasizes the $1.6B promise is nonbinding and pending full approval.","The article cites concerns raised by U.S. Rep. Zoe Lofgren about possible conflicts of interest involving entities connected to Commerce Secretary Howard Lutnick.","The article states that if federal funding does not come through, USA Rare Earth may need alternative financing, potentially increasing equity dilution.","The article notes USA Rare Earth previously projected reaching $2.6 billion in sales and $1.2 billion in EBITDA by 2030, but says it has only made early progress with its Stillwater, Colorado processing facility and Round Top rare-earth mining site (as stated).","The article\u2019s stance shifts from cautiously bullish to leaning bearish and suggests investors may want to wait until the government financing package is approved."],"numeric_claims":[{"label":"Federal funding proposed (up to)","value":"$1.6 billion"},{"label":"Additional private capital required (raised)","value":"$1.5 billion"},{"label":"Sales projection by 2030","value":"$2.6 billion"},{"label":"EBITDA projection by 2030","value":"$1.2 billion"}],"primary_claim":"USA Rare Earth\u2019s potential $1.6B U.S. Department of Commerce funding is nonbinding and still pending approval, so investors face significant funding, dilution, and execution risk.","relevance_score":0.45,"sentiment":"negative","source_quality":"high","summary":"The article argues that USA Rare Earth (NASDAQ: USAR) remains a high-risk, pre-revenue rare-earth value-chain start-up despite recent progress and a nonbinding U.S. Department of Commerce funding LOI. It warns that pending federal approval, potential congressional scrutiny, and execution/dilution risks could undermine investor expectations.","topics":["rare-earths","critical minerals","U.S. federal funding","nonbinding LOI","share dilution risk","execution risk","congressional scrutiny","China rare-earth dominance","Carester investment","Stillwater processing facility","Round Top mining site"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsDespite promising developments, high uncertainty remains with USA Rare Earth, a pre-revenue start-up focused on building a rare-earth value chain.","tickers":[],"title":"Forget USA Rare Earth: Why Trump's Bet on This Critical Minerals Play Could Backfire for Investors","url":"https://www.fool.com/investing/2026/04/17/forget-usa-rare-earth-why-trumps-bet-on-this-criti/"}}
TEXT NOT NULL
source_ref
candidate:sc_69fdc0fd1498e56f
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:7b16337a4a1563fa
TEXT
episode_id
NULL
TEXT
created_at
2026-04-17T21:48:49.066538+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel