Create
Query
event_store.db
—
signals
actions
approvals
artifacts
commitments
constraints
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
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_58b7eb6b08a6 in signals
id
sig_58b7eb6b08a6
Primary key.
TEXT
event_id
24418
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
opportunity_research_delta
TEXT NOT NULL
value
{"aggregator_url":"http://www.alcircle.com/news/middle-east-tensions-reshape-metals-markets-aluminium-crisis-deepens-as-copper-outlook-weakens-117898","as_of":"2026-04-05T09:14:50.317524+00:00","canonical_url":"http://www.alcircle.com/news/middle-east-tensions-reshape-metals-markets-aluminium-crisis-deepens-as-copper-outlook-weakens-117898","enrichment":{"aggregator_url":"http://www.alcircle.com/news/middle-east-tensions-reshape-metals-markets-aluminium-crisis-deepens-as-copper-outlook-weakens-117898","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_36344d7e4f93b318","canonical_host":"alcircle.com","canonical_is_aggregator":false,"canonical_url":"http://www.alcircle.com/news/middle-east-tensions-reshape-metals-markets-aluminium-crisis-deepens-as-copper-outlook-weakens-117898","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-05T22:14:26.023986+00:00","extraction_method":"heuristic","fetched_description":"Know why: Middle East conflict splits metals markets as aluminium supply crisis deepens, while copper faces demand slowdown risks.","fetched_title":"From copper oversupply to aluminium crisis: Middle East conflict reshapes metals market","final_url":"https://www.alcircle.com/news/middle-east-tensions-reshape-metals-markets-aluminium-crisis-deepens-as-copper-outlook-weakens-117898","html_truncated":false,"paywall_likely":false,"publisher_domain":"alcircle.com","publisher_resolution":"canonical_url","requested_url":"http://www.alcircle.com/news/middle-east-tensions-reshape-metals-markets-aluminium-crisis-deepens-as-copper-outlook-weakens-117898","source_event_id":"evt_a88c128da0d3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a1c3e3aea88b9085","published_at":"","publisher_domain":"alcircle.com","query":"aluminium market LME stocks smelter energy costs china supply update","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["2026-01-01"],"entities":[{"asset_class":"commodity","name":"Aluminium","relevance":"high","symbol":"AL","type":"metal"},{"asset_class":"commodity","name":"Copper","relevance":"high","symbol":"CU","type":"metal"}],"event_type":"supply_disruption","information_gaps":["Details on the duration of the supply disruption in the Strait of Hormuz are not provided.","Specific impacts on global aluminium supply volumes are not quantified."],"key_facts":["Aluminium prices fell 2.2% to $3,505 per tonne amid market weakness.","Copper prices reached an all-time high of over $14,500 per tonne in January 2026 before stabilizing around $13,088.88 per tonne.","Global exchange inventories of copper exceeded 1.4 million tonnes by the end of Q1 2026."],"numeric_claims":[{"label":"Aluminium price drop","value":"2.2% to $3,505/t"},{"label":"Copper price high","value":"over $14,500/t"},{"label":"Copper price stabilization","value":"around $13,088.88/t"}],"primary_claim":"The Strait of Hormuz, a critical trade corridor for alumina supply, has been shut down due to the conflict, severely impacting aluminium prices.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"The ongoing Middle East conflict is causing a significant shift in the metals market, leading to an aluminium supply crisis while copper faces a demand slowdown.","topics":["metals market","Middle East conflict","aluminium crisis","copper demand"]},"snippet":"Know why: Middle East conflict splits metals markets as aluminium supply crisis deepens, while copper faces demand slowdown risks.","source":"web_search","source_domain":"alcircle.com","summary":"Know why: Middle East conflict splits metals markets as aluminium supply crisis deepens, while copper faces demand slowdown risks.","title":"From copper oversupply to aluminium crisis: Middle East ...","url":"http://www.alcircle.com/news/middle-east-tensions-reshape-metals-markets-aluminium-crisis-deepens-as-copper-outlook-weakens-117898"}
TEXT NOT NULL
threshold
NULL
TEXT
direction
NULL
TEXT
severity
NULL
TEXT
window
NULL
TEXT
source
opportunity_research_ingestor
TEXT NOT NULL
reason_trace
{"_evidence_event_ids":["evt_a88c128da0d3"]}
TEXT
dedupe_key
signal_enriched:opportunity_research_delta:f78e02596c6a554e
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-05T09:14:50.317524+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel