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/w-r-berkley-corporation-q1-income-advances","as_of":"2026-04-21T21:31:18.735453+00:00","canonical_url":"https://www.rttnews.com/3640897/w-r-berkley-corporation-q1-income-advances.aspx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/w-r-berkley-corporation-q1-income-advances","article_chars":682,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_4fb58f0f0f699af2","canonical_host":"rttnews.com","canonical_is_aggregator":false,"canonical_url":"https://www.rttnews.com/3640897/w-r-berkley-corporation-q1-income-advances.aspx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:30:42.292697+00:00","extraction_method":"trafilatura","fetched_description":"(RTTNews) - W. R. Berkley Corporation (WRB) released a profit for its first quarter that Increased, from the same period last year","fetched_title":"W. R. Berkley Corporation Q1 Income Advances | Nasdaq","final_url":"https://www.nasdaq.com/articles/w-r-berkley-corporation-q1-income-advances","html_truncated":false,"paywall_likely":false,"publisher_domain":"rttnews.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/w-r-berkley-corporation-q1-income-advances","source_event_id":"evt_623759157917","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"5ddbf925dfc9b2e9","kind":"unusual_volume","published_at":"2026-04-21T20:47:40+00:00","publisher_domain":"rttnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.68,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"W. R. Berkley Corporation","relevance":"high","symbol":"WRB","type":"company"}],"event_type":"earnings","information_gaps":["No unusual trading volume data is provided (baseline volume, current volume, volume ratio vs average, and direction are missing).","No explicit statement links the volume change to this earnings release; the signal is not confirmed by any volume-related news in the provided text.","No catalyst hypothesis for unusual volume is stated in the provided text beyond the earnings update."],"key_facts":["Q1 earnings: $515.21 million vs. $417.57 million last year (GAAP).","Q1 EPS: $1.31 vs. $1.04 last year.","Q1 revenue: $3.69 billion vs. $3.54 billion last year.","Revenue increased 4.2% year-over-year."],"numeric_claims":[{"label":"Q1 earnings (GAAP)","value":"$515.21 million"},{"label":"Q1 earnings prior year (GAAP)","value":"$417.57 million"},{"label":"Q1 EPS","value":"$1.31"},{"label":"Q1 EPS prior year","value":"$1.04"},{"label":"Q1 revenue","value":"$3.69 billion"},{"label":"Q1 revenue prior year","value":"$3.54 billion"},{"label":"Revenue growth","value":"4.2%"}],"primary_claim":"W. R. Berkley Corporation\u2019s Q1 profit increased to $515.21 million ($1.31 EPS) from $417.57 million ($1.04 EPS) in the same quarter last year, with revenue up 4.2% to $3.69 billion.","relevance_score":0.55,"sentiment":"positive","source_quality":"low","summary":"RTTNews reports that W. R. Berkley Corporation (WRB) reported higher Q1 profit and revenue year-over-year. The provided signal text does not include any unusual trading volume metrics or a volume ratio versus average.","topics":["earnings","quarterly results","revenue growth","EPS growth"]},"source":"Nasdaq Markets","source_domain":"rttnews.com","summary":"(RTTNews) - W. R. Berkley Corporation (WRB) released a profit for its first quarter that Increased, from the same period last year","tickers":["WRB"],"title":"W. R. Berkley Corporation Q1 Income Advances","url":"https://www.rttnews.com/3640897/w-r-berkley-corporation-q1-income-advances.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_42ed53aa93de in signals