Create
Query
event_store.db
—
signals
actions
agent_runs
approvals
artifacts
attention_candidates
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_narrative_members
intel_narratives
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 sig_896d379d1055 in signals
id
sig_896d379d1055
Primary key.
TEXT
event_id
338851
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
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
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
discovery_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_9abaaad6c2d3"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:347ff51d88d37d17
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-19T20:14:07.003061+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel