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_57468993aec4 in signals
id
sig_57468993aec4
Primary key.
TEXT
event_id
477856
TEXT NOT NULL
watcher_id
NULL
TEXT
signal_type
discovery_unusual_volume_delta
TEXT NOT NULL
value
{"aggregator_url":"https://www.nasdaq.com/articles/china-stock-market-tipped-open-red","as_of":"2026-04-22T02:02:59.137029+00:00","canonical_url":"https://www.rttnews.com/3472658/china-stock-market-tipped-to-open-in-the-red.aspx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/china-stock-market-tipped-open-red","article_chars":2981,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2edd697cad870415","canonical_host":"rttnews.com","canonical_is_aggregator":false,"canonical_url":"https://www.rttnews.com/3472658/china-stock-market-tipped-to-open-in-the-red.aspx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T02:04:24.957925+00:00","extraction_method":"trafilatura","fetched_description":"(RTTNews) - The China stock market has finished lower in consecutive trading days, surrendering almost 40 points or 1.4 percent along the way. The Shanghai Composite Index now sits just above the 2,800-point plateau and it's likely to extend its losses again on Wednesday.","fetched_title":"China Stock Market Tipped To Open In The Red | Nasdaq","final_url":"https://www.nasdaq.com/articles/china-stock-market-tipped-open-red","html_truncated":false,"paywall_likely":false,"publisher_domain":"rttnews.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/china-stock-market-tipped-open-red","source_event_id":"evt_598e58beba5a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e7d4f97141c810dd","kind":"unusual_volume","published_at":"2026-04-22T01:04:08+00:00","publisher_domain":"rttnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":["Wednesday","August","later this month","Tuesday","July"],"entities":[{"asset_class":"equity_index","name":"Shanghai Composite Index","relevance":"high","symbol":"","type":"index"},{"asset_class":"equity_index","name":"Shenzhen Composite Index","relevance":"medium","symbol":"","type":"index"},{"asset_class":"equity","name":"Industrial and Commercial Bank of China","relevance":"medium","symbol":"","type":"equity"},{"asset_class":"equity","name":"Bank of China","relevance":"medium","symbol":"","type":"equity"},{"asset_class":"equity","name":"China Construction Bank","relevance":"medium","symbol":"","type":"equity"},{"asset_class":"equity","name":"China Petroleum and Chemical (Sinopec)","relevance":"medium","symbol":"","type":"equity"},{"asset_class":"equity","name":"Aluminum Corp of China (Chalco)","relevance":"low","symbol":"","type":"equity"},{"asset_class":"equity","name":"PetroChina","relevance":"low","symbol":"","type":"equity"}],"event_type":"price_action","information_gaps":["Signal type requested: discovery_unusual_volume_delta. The provided text contains no volume ratio vs average, no baseline volume, and no ticker-specific unusual volume information.","The headline text mentions \u201copen in the red,\u201d but the article text provided focuses on Tuesday\u2019s closes and Wednesday expectations; it does not quantify expected open levels.","No explicit catalyst is stated for any unusual volume event; only macro/market drivers for broader market weakness are described."],"key_facts":["RTTNews states the Shanghai Composite Index finished slightly above the 2,800-point plateau after falling 8.06 points (0.29%) to 2,802.98 on Tuesday.","RTTNews states the Shanghai Composite traded between 2,794.91 and 2,814.90 on Tuesday.","RTTNews states the Shenzhen Composite Index rose 16.03 points (1.06%) to end at 1,530.73 on Tuesday.","RTTNews says European and U.S. markets were sharply lower and Asian bourses were tipped to follow suit on Wednesday.","RTTNews attributes Wall Street weakness to continued decline in U.S. manufacturing activity (ISM) and a modest decrease in U.S. construction spending (Commerce Department).","RTTNews notes traders are cashing in on previous gains amid uncertainty about interest rates and references FedWatch Tool probabilities (63.0% quarter-point cut; 37.0% half-point cut).","RTTNews states oil prices fell sharply to a nine-month low; WTI October futures ended down $3.21 (4.4%) at $70.34/bbl."],"numeric_claims":[{"label":"Shanghai Composite change (points)","value":"-8.06"},{"label":"Shanghai Composite change (%)","value":"-0.29%"},{"label":"Shanghai Composite close","value":"2,802.98"},{"label":"Shanghai Composite intraday range low","value":"2,794.91"},{"label":"Shanghai Composite intraday range high","value":"2,814.90"},{"label":"Shenzhen Composite change (points)","value":"+16.03"},{"label":"Shenzhen Composite change (%)","value":"+1.06%"},{"label":"Shenzhen Composite close","value":"1,530.73"},{"label":"Dow change (%)","value":"-1.51%"},{"label":"NASDAQ change (%)","value":"-3.26%"},{"label":"S&P 500 change (%)","value":"-2.12%"},{"label":"WTI Oct futures change ($)","value":"-3.21"},{"label":"WTI Oct futures change (%)","value":"-4.4%"},{"label":"WTI Oct futures settlement","value":"$70.34/bbl"},{"label":"FedWatch Tool quarter-point cut probability","value":"63.0%"},{"label":"FedWatch Tool half-point cut probability","value":"37.0%"}],"primary_claim":"The Shanghai Composite Index fell on Tuesday and Asian markets were tipped to open lower on Wednesday due to broadly negative global cues.","relevance_score":0.35,"sentiment":"negative","source_quality":"high","summary":"RTTNews reports China\u2019s Shanghai Composite and Shenzhen Composite moved in opposite directions on Tuesday, with a broadly negative global lead suggesting further weakness for Asian markets on Wednesday. The article does not provide any unusual trading volume metrics for a specific ticker.","topics":["China stock market","Shanghai Composite","Shenzhen Composite","global market weakness","U.S. macro data","Fed rate cut expectations","oil prices"]},"source":"Nasdaq Markets","source_domain":"rttnews.com","summary":"(RTTNews) - The China stock market has moved higher in back-to-back sessions, collecting almost 35 points or 0.8 percent along the way. The Shanghai Composite Index now sits just above the 4,085-point plateau although it's likely to be stuck in neutral on Wednesday.","tickers":[],"title":"China Stock Market Tipped To Open In The Red","url":"https://www.rttnews.com/3472658/china-stock-market-tipped-to-open-in-the-red.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_598e58beba5a"]}
TEXT
dedupe_key
signal_enriched:discovery_unusual_volume_delta:3d2e3cab5784e247
TEXT NOT NULL
throttle_s
INTEGER (default 0
created_at
2026-04-22T02:02:59.137029+00:00
TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')
Update
Cancel