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/ftse-100-down-marginally-cautious-trade","as_of":"2026-04-07T12:52:53.052514+00:00","canonical_url":"https://www.rttnews.com/3500640/ftse-100-down-marginally-in-cautious-trade.aspx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/ftse-100-down-marginally-cautious-trade","article_chars":3148,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_cf788be15098738e","canonical_host":"rttnews.com","canonical_is_aggregator":false,"canonical_url":"https://www.rttnews.com/3500640/ftse-100-down-marginally-in-cautious-trade.aspx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-07T20:02:08.350573+00:00","extraction_method":"heuristic","fetched_description":"(RTTNews) - U.K. stocks are down in negative territory Monday morning, weighed down by rating downgrades of a few big name stocks.","fetched_title":"FTSE 100 Down Marginally In Cautious Trade | Nasdaq","final_url":"https://www.nasdaq.com/articles/ftse-100-down-marginally-cautious-trade","html_truncated":false,"paywall_likely":false,"publisher_domain":"rttnews.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/ftse-100-down-marginally-cautious-trade","source_event_id":"evt_d1a869fe00ca","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d25d8bce0a13f39c","kind":"unusual_volume","published_at":"2026-04-07T11:50:14+00:00","publisher_domain":"rttnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["January 06, 2025"],"entities":[{"asset_class":"equity","name":"FTSE 100","relevance":"high","symbol":"FTSE","type":"index"}],"event_type":"price_action","information_gaps":["Volume ratio vs average is not provided.","Specific unusual volume details are missing."],"key_facts":["FTSE 100 dropped to 8,197.50 earlier in the session.","WPP down more than 3% due to rating downgrade.","Rolls-Royce Holdings down nearly 3% after Citigroup cut its rating.","Unilever down sharply after RBC lowered its rating."],"numeric_claims":[],"primary_claim":"The FTSE 100 index is down marginally due to rating downgrades of several big-name stocks.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"The FTSE 100 index is experiencing cautious trading, influenced by rating downgrades of major stocks and ongoing concerns regarding the U.S.-Iran conflict.","topics":["FTSE 100","stock ratings","market trends"]},"source":"Nasdaq Markets","source_domain":"rttnews.com","summary":"(RTTNews) - After a slightly positive start and a subsequent fall below the flat line, UK's benchmark index FTSE 100 moved modestly higher Tuesday morning but retreated again in cautious trade with investors closely tracking news about U.S.-Iran conflict.","tickers":[],"title":"FTSE 100 Down Marginally In Cautious Trade","url":"https://www.rttnews.com/3500640/ftse-100-down-marginally-in-cautious-trade.aspx"}

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_a606bad181d9 in signals