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 338851 in events
seq
Primary key.
INTEGER
id
evt_52694ec541b3
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-19T20:44:36.010226+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-19T20:14:07.003061+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:347ff51d88d37d17","evidence_event_ids":["evt_9abaaad6c2d3"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/best-small-cap-stock-buy-right-now-explosive-long-term-gains","as_of":"2026-04-19T20:14:07.003061+00:00","canonical_url":"https://www.fool.com/investing/2026/04/19/best-small-cap-stock-buy-now-long-term-gain/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/best-small-cap-stock-buy-right-now-explosive-long-term-gains","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_6aa930949ccf8ec5","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/19/best-small-cap-stock-buy-now-long-term-gain/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-19T20:44:36.010167+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsSmaller companies\u2019 values often under-reflect that organization\u2019s long-term potential.","fetched_title":"The Best Small-Cap Stock to Buy Right Now for Explosive Long-Term Gains | Nasdaq","final_url":"https://www.nasdaq.com/articles/best-small-cap-stock-buy-right-now-explosive-long-term-gains","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/best-small-cap-stock-buy-right-now-explosive-long-term-gains","source_event_id":"evt_9abaaad6c2d3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7d6ea200b0a2c629","kind":"unusual_volume","published_at":"2026-04-19T18:38:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["2019","December 17, 2004","April 15, 2005","April 19, 2026"],"entities":[{"asset_class":"equity","name":"USA Rare Earth","relevance":"high","symbol":"USAR","type":"company"},{"asset_class":"equity","name":"Nvidia","relevance":"medium","symbol":"","type":"company"},{"asset_class":"equity","name":"Intel","relevance":"medium","symbol":"","type":"company"},{"asset_class":"unknown","name":"Texas Mineral Resource","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"unknown","name":"IMARC Group","relevance":"medium","symbol":"","type":"organization"}],"event_type":"other","information_gaps":["No unusual trading volume ratio vs average is provided (baseline volume, volume ratio, and direction are all missing).","The signal\u2019s catalyst hypothesis for the volume change is not described; the article is a promotional thesis rather than a volume/market-activity report.","The excerpt does not explicitly state the year for \u201cbefore the middle of this year,\u201d limiting time precision."],"key_facts":["The article identifies USA Rare Earth as a small-cap mining company (market cap stated as less than $4 billion).","It cites a 2019 study (Texas Mineral Resource) estimating the Sierra Blanca deposit could produce 20,000 tons of valuable rare earth elements every day for 20 years.","The same study is said to suggest the Round Top site could yield marketable elements for over 100 years.","At current prices, the mine is described as potentially producing more than $100 million in annual rare-earth element revenue, plus about $200 million in yearly aluminum and lithium production (as stated).","The company is described as finalizing construction of a neo-magnet facility in Stillwater, Oklahoma, with production expected to start before the middle of this year (year not explicitly stated in the excerpt).","At maximum capacity, the facility is described as able to manufacture up to 5,000 tons of critical magnets per year.","The article claims the company would help reduce U.S. dependence on China for rare-earth elements and rare-earth magnets.","It states analysts\u2019 consensus 12-month price target is $32.25, described as nearly twice the stock\u2019s current price (current price not stated).","The article notes USA Rare Earth was not included in Stock Advisor\u2019s identified 10 best stocks list mentioned in the text."],"numeric_claims":[{"label":"Market cap","value":"< $4 billion"},{"label":"Sierra Blanca production estimate","value":"20,000 tons/day for 20 years"},{"label":"Round Top production estimate","value":"> 100 years"},{"label":"Annual rare-earth element revenue (at current prices)","value":"> $100 million"},{"label":"Annual aluminum and lithium production revenue (order of magnitude)","value":"~ $200 million/year"},{"label":"Neo-magnet facility location","value":"Stillwater, Oklahoma"},{"label":"Neo-magnet facility capacity","value":"up to 5,000 tons of magnets per year"},{"label":"Neo-magnet market size (IMARC estimate)","value":"$20 billion/year now; > $30 billion by 2034"},{"label":"Analysts\u2019 consensus 12-month price target","value":"$32.25"}],"primary_claim":"USA Rare Earth (USAR) has estimated long-term rare-earth and related production potential and is finalizing a neo-magnet facility expected to begin production before mid-2026 (as stated in the article).","relevance_score":0.25,"sentiment":"positive","source_quality":"high","summary":"The article promotes USA Rare Earth (NASDAQ: USAR) as a small-cap rare-earth/mining opportunity, citing large estimated resource potential and planned neo-magnet facility production. No specific unusual trading volume ratio or volume delta is provided in the text.","topics":["small-cap investing","rare earths","mining","neo-magnet facility","U.S. supply chain dependence on China","market size estimates","analyst price target"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsSmaller companies\u2019 values often under-reflect that organization\u2019s long-term potential.","tickers":[],"title":"The Best Small-Cap Stock to Buy Right Now for Explosive Long-Term Gains","url":"https://www.fool.com/investing/2026/04/19/best-small-cap-stock-buy-now-long-term-gain/"}}
TEXT NOT NULL
source_ref
candidate:sc_6aa930949ccf8ec5
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:347ff51d88d37d17
TEXT
episode_id
NULL
TEXT
created_at
2026-04-19T20:44:36.010349+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel