SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://www.nasdaq.com/articles/i-finally-pulled-trigger-rare-earth-stock-and-its-not-mp-materials-or-usa-rare-earth","as_of":"2026-04-11T01:41:34.996216+00:00","canonical_url":"https://www.fool.com/investing/2026/04/10/i-finally-pulled-the-trigger-on-a-rare-earth-stock/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/i-finally-pulled-trigger-rare-earth-stock-and-its-not-mp-materials-or-usa-rare-earth","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_bab957b25afba0e6","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/10/i-finally-pulled-the-trigger-on-a-rare-earth-stock/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-11T12:38:55.771385+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsMP Materials and USA Rare Earth are two of the more common rare-earth stocks on investors' radars today.","fetched_title":"I Finally Pulled the Trigger on a Rare-Earth Stock (and It's Not MP Materials or USA Rare Earth) | Nasdaq","final_url":"https://www.nasdaq.com/articles/i-finally-pulled-trigger-rare-earth-stock-and-its-not-mp-materials-or-usa-rare-earth","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/i-finally-pulled-trigger-rare-earth-stock-and-its-not-mp-materials-or-usa-rare-earth","source_event_id":"evt_a1218c49c77e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7bd02381784a40b2","kind":"unusual_volume","published_at":"2026-04-11T00:25:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["late February","first half of 2027"],"entities":[{"asset_class":"equity","name":"REalloys","relevance":"high","symbol":"ALOY","type":"company"},{"asset_class":"equity","name":"MP Materials","relevance":"medium","symbol":"MP","type":"company"},{"asset_class":"equity","name":"USA Rare Earth","relevance":"medium","symbol":"USAR","type":"company"},{"asset_class":"unknown","name":"U.S. Critical Materials","relevance":"low","symbol":"","type":"company/organization"}],"event_type":"other","information_gaps":["No unusual volume ratio vs average is provided in the text (baseline volume, volume ratio, and direction are missing).","No explicit confirmation is given that any volume spike is driven by a specific news catalyst; the article frames the stock as newly available after a SPAC merger.","The signal type suggests unusual volume delta, but the provided content does not include trading-volume data or a volume comparison.","catalyst_hint (most likely, based on text only) : SPAC merger / recent public-market debut of REalloys (late February).","unexplained_or_news_confirmed: Unclear/Not stated in provided text."],"key_facts":["REalloys (NASDAQ: ALOY) debuted on public markets in late February after a business merger with a SPAC.","REalloys is headquartered in Ohio and is developing a vertically integrated rare-earth operation including recycling, mining, oxide production, metallization, alloying, and magnet manufacturing.","The article states REalloys plans to use mined material from a variety of sources.","The article states REalloys signed a memorandum of understanding with U.S. Critical Materials supporting securing up to 10% of mineral production from Sheep Creek.","The article states REalloys plans to develop both light and heavy rare-earth elements.","The article says REalloys is pre-revenue and expects its rare-earth separation and metallization facility to begin production in the first half of 2027.","The article says there is no guarantee REalloys will be profitable once commercial operations begin."],"numeric_claims":[{"label":"Sheep Creek mineral production secured (via MoU)","value":"up to 10%"}],"primary_claim":"REalloys (NASDAQ: ALOY) became available recently after a business merger with a SPAC and is positioned as a vertically integrated rare-earth company using multiple feedstock sources.","relevance_score":0.45,"sentiment":"mixed","source_quality":"high","summary":"The article highlights REalloys (NASDAQ: ALOY) as a newly available rare-earth stock after its SPAC merger, contrasting it with MP Materials (MP) and USA Rare Earth (USAR). It does not provide any specific unusual trading volume ratio or confirm a volume spike with news.","topics":["rare-earths","SPAC merger","vertically integrated rare-earth processing","feedstock sourcing","light and heavy rare-earth elements","investment risk"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsMP Materials and USA Rare Earth are two of the more common rare-earth stocks on investors' radars today.","tickers":[],"title":"I Finally Pulled the Trigger on a Rare-Earth Stock (and It's Not MP Materials or USA Rare Earth)","url":"https://www.fool.com/investing/2026/04/10/i-finally-pulled-the-trigger-on-a-rare-earth-stock/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_4e881fda2bbe in signals