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_7547ae35980e in signals
id
sig_7547ae35980e
Primary key.
TEXT
event_id
481703
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/us-stocks-may-regain-ground-trump-extends-ceasefire","as_of":"2026-04-22T13:12:40.941923+00:00","canonical_url":"https://www.rttnews.com/3641286/u-s-stocks-may-regain-ground-as-trump-extends-ceasefire.aspx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/us-stocks-may-regain-ground-trump-extends-ceasefire","article_chars":3577,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4fa705488e6814c1","canonical_host":"rttnews.com","canonical_is_aggregator":false,"canonical_url":"https://www.rttnews.com/3641286/u-s-stocks-may-regain-ground-as-trump-extends-ceasefire.aspx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T13:15:28.908333+00:00","extraction_method":"trafilatura","fetched_description":"(RTTNews) - Stocks are likely to move to the upside in early trading on Wednesday, regaining ground following the pullback seen over the two previous sessions. The major index futures are currently pointing to a higher open for the markets, with the S&P 500 futures up by 0.6 perc","fetched_title":"U.S. Stocks May Regain Ground As Trump Extends Ceasefire | Nasdaq","final_url":"https://www.nasdaq.com/articles/us-stocks-may-regain-ground-trump-extends-ceasefire","html_truncated":false,"paywall_likely":false,"publisher_domain":"rttnews.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/us-stocks-may-regain-ground-trump-extends-ceasefire","source_event_id":"evt_5690c72e858e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"aa8808398eb34c17","kind":"unusual_volume","published_at":"2026-04-22T12:54:41+00:00","publisher_domain":"rttnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["Wednesday","Monday","Tuesday"],"entities":[{"asset_class":"","name":"President Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"high","symbol":"","type":"country"},{"asset_class":"","name":"U.S. ceasefire extension","relevance":"high","symbol":"","type":"event"},{"asset_class":"equity_index","name":"S&P 500 futures","relevance":"high","symbol":"SPX","type":"index_future"},{"asset_class":"equity_index","name":"Dow Jones Industrial Average","relevance":"medium","symbol":"DJI","type":"index"},{"asset_class":"equity_index","name":"Nasdaq Composite","relevance":"medium","symbol":"IXIC","type":"index"},{"asset_class":"equity_index","name":"S&P 500","relevance":"medium","symbol":"SPX","type":"index"},{"asset_class":"","name":"Capital.com (Daniela Hathorn)","relevance":"medium","symbol":"","type":"company_person"},{"asset_class":"","name":"Iran's Revolutionary Guard Navy","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"location"},{"asset_class":"commodity","name":"Crude oil futures","relevance":"low","symbol":"CL=F","type":"commodity_future"},{"asset_class":"commodity","name":"Gold","relevance":"low","symbol":"XAU","type":"commodity"}],"event_type":"geopolitical_risk","information_gaps":["This signal type is \u201cdiscovery_unusual_volume_delta,\u201d but the provided text contains no ticker-specific volume ratio, baseline volume, or unusual volume measurements.","No specific equity ticker(s) are identified for the volume event; only index-level futures and index performance are discussed.","The article does not quantify whether the described move is confirmed by unusual trading volume versus other factors; it frames the move as reaction to ceasefire news and broader risk/earnings sentiment.","No explicit statement links any volume anomaly to the ceasefire extension; the catalyst is described qualitatively as generating early buying interest."],"key_facts":["RTTNews says major index futures point to a higher open on Wednesday.","S&P 500 futures are up 0.6% (article states \u201cS&P 500 futures up by 0.6 percent\u201d).","The article attributes early buying interest to news that President Donald Trump extended the U.S. ceasefire with Iran.","Trump is quoted as saying the U.S. would hold off on attacking Iran until their leaders \u201ccome up with a unified proposal.\u201d","The article also states Trump directed the U.S. military to continue its blockade of all maritime traffic entering and exiting Iranian ports.","Iran dismissed the ceasefire extension as \u201cmeaningless\u201d and said the Strait of Hormuz will remain closed until the U.S. blockade is lifted.","The article says Iran\u2019s Revolutionary Guard Navy claimed it seized two container ships in the Strait of Hormuz for \u201cmaritime violations.\u201d","The article says traders remain hopeful about an eventual resolution despite uncertainty.","The article says traders are also optimistic about corporate results; earnings season is described as off to a solid start.","The article includes prior-session performance: Dow -0.6%, Nasdaq -0.6%, S&P 500 -0.6% on Tuesday (values provided)."],"numeric_claims":[{"label":"S&P 500 futures move","value":"+0.6%"},{"label":"Dow move (Tuesday)","value":"-0.6% (down 293.18 points to 49,149.38)"},{"label":"Nasdaq move (Tuesday)","value":"-0.6% (down 144.43 points to 24,529.96)"},{"label":"S&P 500 move (Tuesday)","value":"-0.6% (down 45.13 points to 7,064.01)"},{"label":"Crude oil futures","value":"$90.02 per barrel (up $0.35)"},{"label":"Gold","value":"$4,774.60 per ounce (up $55)"},{"label":"USD/JPY","value":"159.28"},{"label":"EUR/USD","value":"$1.1725"}],"primary_claim":"U.S. stock index futures were up at the open expectation (S&P 500 futures +0.6%) following news that Trump extended the U.S. ceasefire with Iran.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"RTTNews reports early Wednesday U.S. stock index futures are pointing higher, attributing the risk-on tone to President Trump extending a U.S. ceasefire with Iran. The article also notes ongoing tensions (Iran says the ceasefire is meaningless; Iran\u2019s Revolutionary Guard Navy claims seizure of two container ships) and that traders remain optimistic about corporate earnings.","topics":["U.S. equities","index futures","Iran ceasefire","Strait of Hormuz","maritime blockade","earnings season","risk sentiment"]},"source":"Nasdaq Markets","source_domain":"rttnews.com","summary":"(RTTNews) - Stocks are likely to move to the upside in early trading on Wednesday, regaining ground following the pullback seen over the two previous sessions. The major index futures are currently pointing to a higher open for the markets, with the S&P 500 futures up by 0.6 perc","tickers":[],"title":"U.S. Stocks May Regain Ground As Trump Extends Ceasefire","url":"https://www.rttnews.com/3641286/u-s-stocks-may-regain-ground-as-trump-extends-ceasefire.aspx"}
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_5690c72e858e"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:fc71e536829e8041
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-22T13:12:40.941923+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel