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/trustco-q1-profit-rises","as_of":"2026-04-22T10:08:37.182699+00:00","canonical_url":"https://www.rttnews.com/3641093/trustco-q1-profit-rises.aspx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/trustco-q1-profit-rises","article_chars":855,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_a8c781b6b2bcb04f","canonical_host":"rttnews.com","canonical_is_aggregator":false,"canonical_url":"https://www.rttnews.com/3641093/trustco-q1-profit-rises.aspx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T10:10:59.069241+00:00","extraction_method":"trafilatura","fetched_description":"(RTTNews) - TrustCo Bank Corp NY (TRST), posted higher profit for the first quarter on Wednesday, with growth in net interest income outpacing a decline in non-interest income.","fetched_title":"TrustCo Q1 Profit Rises | Nasdaq","final_url":"https://www.nasdaq.com/articles/trustco-q1-profit-rises","html_truncated":false,"paywall_likely":false,"publisher_domain":"rttnews.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/trustco-q1-profit-rises","source_event_id":"evt_f11fc97d8f36","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"d1e82edfc85e0fa2","kind":"unusual_volume","published_at":"2026-04-22T08:51:50+00:00","publisher_domain":"rttnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"TrustCo Bank Corp NY","relevance":"high","symbol":"TRST","type":"company"},{"asset_class":"other","name":"Nasdaq","relevance":"medium","symbol":"","type":"exchange"}],"event_type":"earnings","information_gaps":["No unusual trading volume data is provided (baseline volume, current volume, and volume ratio vs average are missing).","No explicit statement confirms whether any volume spike is news-driven or unexplained.","No catalyst hypothesis related to unusual volume is stated in the text; only earnings drivers (net interest income vs non-interest income/expenses) are described."],"key_facts":["Q1 net income was $16.29 million ($0.91/share), up from $14.28 million ($0.75/share) last year.","Net interest income rose to $44.71 million from $40.37 million in the prior year.","Non-interest income declined to $4.84 million from $4.97 million in the prior year.","Non-interest expenses increased to $26.98 million from $26.33 million in the prior year.","On Nasdaq, TrustCo shares closed Tuesday\u2019s regular trading 0.67% lower at $46.30."],"numeric_claims":[{"label":"Q1 net income (USD)","value":"16.29 million"},{"label":"Q1 EPS (USD)","value":"0.91"},{"label":"Prior-year Q1 net income (USD)","value":"14.28 million"},{"label":"Prior-year Q1 EPS (USD)","value":"0.75"},{"label":"Net interest income (Q1, USD)","value":"44.71 million"},{"label":"Prior-year net interest income (USD)","value":"40.37 million"},{"label":"Non-interest income (Q1, USD)","value":"4.84 million"},{"label":"Prior-year non-interest income (USD)","value":"4.97 million"},{"label":"Non-interest expenses (Q1, USD)","value":"26.98 million"},{"label":"Prior-year non-interest expenses (USD)","value":"26.33 million"},{"label":"Tuesday close change (%)","value":"-0.67%"},{"label":"Tuesday close price (USD)","value":"46.30"}],"primary_claim":"TRST\u2019s Q1 net income increased to $16.29 million ($0.91/share) from $14.28 million ($0.75/share) year-over-year.","relevance_score":0.55,"sentiment":"positive","source_quality":"medium","summary":"TrustCo Bank Corp NY (TRST) reported higher Q1 profit, driven by net interest income growth that outweighed declines in non-interest income. The provided text does not include any unusual trading volume metrics.","topics":["Q1 earnings","net interest income","non-interest income","non-interest expenses","TRST stock"]},"source":"Nasdaq Markets","source_domain":"rttnews.com","summary":"(RTTNews) - TrustCo Bank Corp NY (TRST), posted higher profit for the first quarter on Wednesday, with growth in net interest income outpacing a decline in non-interest income.","tickers":["TRST"],"title":"TrustCo Q1 Profit Rises","url":"https://www.rttnews.com/3641093/trustco-q1-profit-rises.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_ff22b0713bde in signals