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 224917 in events
seq
Primary key.
INTEGER
id
evt_1b1de16bf0d3
TEXT NOT NULL
kind
signal_ingest
TEXT NOT NULL
ts
2026-04-18T19:17:45.284548+00:00
TEXT NOT NULL
actor
daemon:signal_enrichment
TEXT
subject_entity_ids
[]
TEXT
payload
{"created_at":"2026-04-18T18:48:29.555162+00:00","dedupe_key":"signal_enriched:discovery_unusual_volume_delta:4511e3be1683dfae","evidence_event_ids":["evt_947838d6c7e5"],"signal_type":"discovery_unusual_volume_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/retail-sentiment-tmc-has-flipped-bullish-even-stock-sits-17-down-year","as_of":"2026-04-18T18:48:29.555162+00:00","canonical_url":"https://www.fool.com/investing/2026/04/18/retail-sentiment-tmc-metals-company-bullish-stock/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/retail-sentiment-tmc-has-flipped-bullish-even-stock-sits-17-down-year","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_42d1e023c65c2127","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/18/retail-sentiment-tmc-metals-company-bullish-stock/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-18T19:17:45.284111+00:00","extraction_method":"trafilatura","fetched_description":"Key PointsRetail investors appear to be warming up to TMC The Metals Company stock.","fetched_title":"Retail Sentiment on TMC Has Flipped Bullish Even as the Stock Sits 17% Down This Year | Nasdaq","final_url":"https://www.nasdaq.com/articles/retail-sentiment-tmc-has-flipped-bullish-even-stock-sits-17-down-year","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/retail-sentiment-tmc-has-flipped-bullish-even-stock-sits-17-down-year","source_event_id":"evt_947838d6c7e5","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ef79a5b8dd796abb","kind":"unusual_volume","published_at":"2026-04-18T17:50:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["September 2021","March","2026","December 17, 2004","April 15, 2005"],"entities":[{"asset_class":"equity","name":"TMC The Metals Company","relevance":"high","symbol":"TMC","type":"company"},{"asset_class":"other","name":"Stocktwits","relevance":"high","symbol":"","type":"platform"},{"asset_class":"other","name":"National Oceanic and Atmospheric Administration (NOAA)","relevance":"medium","symbol":"","type":"government_agency"},{"asset_class":"other","name":"Deep Seabed Hard Mineral Resources Act","relevance":"medium","symbol":"","type":"law"},{"asset_class":"other","name":"Trump administration","relevance":"low","symbol":"","type":"government"}],"event_type":"price_action","information_gaps":["Unusual volume delta details are not provided: no baseline volume, no volume ratio, and no direction (e.g., above/below average) are stated in the provided text.","The article does not explicitly confirm that the sentiment flip is caused by the unusual volume event; it only reports sentiment shift and discusses regulatory context.","No specific catalyst is tied directly to the volume change; the most concrete catalyst discussed is NOAA\u2019s \u201csubstantial compliance\u201d feedback and the expectation of permits within the next year.","catalyst_hypothesis_most_likely_from_text_only: The most likely catalyst hypothesis mentioned is favorable regulatory progress (NOAA feedback and expected permits) supporting commercialization prospects, alongside broader retail interest in critical minerals amid geopolitical dynamics."],"key_facts":["The article states retail sentiment on Stocktwits for TMC shifted from bearish to bullish in recent months.","The article states TMC\u2019s share price is down 13.5% in 2026 (and down double digits in 2026).","The article describes TMC as a high-profile speculative play in critical minerals and deep-sea mining.","The article states TMC received news from NOAA in March that its consolidated mining application was in \u201csubstantial compliance\u201d with guidelines and standards under the Deep Seabed Hard Mineral Resources Act.","The article states that, following the NOAA news, TMC expects to receive necessary exploration and extraction permits within the next year to begin recovery operations.","The article states the Trump administration is prioritizing domestic critical mineral sourcing.","The article states TMC estimates the net present value (NPV) of targeted minerals is $23.9 billion.","The article states TMC has yet to record any sales across its time as a publicly traded company and has a market capitalization of roughly $2.2 billion."],"numeric_claims":[{"label":"down in 2026","value":"13.5%"},{"label":"NPV of targeted minerals","value":"$23.9 billion"},{"label":"market capitalization","value":"~$2.2 billion"},{"label":"up over last year","value":"81%"},{"label":"down from valuation peak","value":"50%"}],"primary_claim":"Retail sentiment among Stocktwits users for TMC has flipped from bearish to bullish in recent months.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"The article says retail sentiment for TMC (The Metals Company) has shifted from bearish to bullish, even though the stock is still down double digits in 2026. It attributes potential upside to favorable regulatory developments for deep-sea mining, including NOAA feedback and expectations for permits.","topics":["retail sentiment","critical minerals","deep-sea mining","regulatory approvals","NOAA","Stocktwits sentiment shift","high-risk speculative stock"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsRetail investors appear to be warming up to TMC The Metals Company stock.","tickers":[],"title":"Retail Sentiment on TMC Has Flipped Bullish Even as the Stock Sits 17% Down This Year","url":"https://www.fool.com/investing/2026/04/18/retail-sentiment-tmc-metals-company-bullish-stock/"}}
TEXT NOT NULL
source_ref
candidate:sc_42d1e023c65c2127
TEXT
confidence
REAL (default 0.0
dedupe_key
signal_enriched:discovery_unusual_volume_delta:4511e3be1683dfae
TEXT
episode_id
NULL
TEXT
created_at
2026-04-18T19:17:45.284604+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel