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/preferred-bank-bottom-line-advances-q1","as_of":"2026-04-22T13:12:40.941923+00:00","canonical_url":"https://www.rttnews.com/3641262/preferred-bank-bottom-line-advances-in-q1.aspx","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/preferred-bank-bottom-line-advances-q1","article_chars":663,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_b670d84f79f8e725","canonical_host":"rttnews.com","canonical_is_aggregator":false,"canonical_url":"https://www.rttnews.com/3641262/preferred-bank-bottom-line-advances-in-q1.aspx","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T13:15:54.686908+00:00","extraction_method":"trafilatura","fetched_description":"(RTTNews) - PREFERRED BANK (PFBC) announced a profit for its first quarter that Increased, from the same period last year","fetched_title":"PREFERRED BANK Bottom Line Advances In Q1 | Nasdaq","final_url":"https://www.nasdaq.com/articles/preferred-bank-bottom-line-advances-q1","html_truncated":false,"paywall_likely":false,"publisher_domain":"rttnews.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/preferred-bank-bottom-line-advances-q1","source_event_id":"evt_2af8d88f9668","source_quality":"low","status_code":200,"version":"signal_enrichment_v2"},"fp":"a616434c28044cfd","kind":"unusual_volume","published_at":"2026-04-22T12:12:50+00:00","publisher_domain":"rttnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Preferred Bank","relevance":"high","symbol":"PFBC","type":"company"}],"event_type":"earnings","information_gaps":["Unusual volume delta details are missing: no baseline volume, no current volume, and no volume ratio are provided.","No explicit confirmation or explanation is given linking any volume change to this earnings announcement.","No specific Q1 date or earnings release date is stated in the provided text.","No catalyst hypothesis for unusual volume can be grounded because volume metrics are not included."],"key_facts":["RTTNews reports Preferred Bank (PFBC) announced first-quarter profit that increased versus the same period last year.","Earnings totaled $31.14 million in Q1, compared with $30.02 million last year.","EPS was $2.53 in Q1, compared with $2.23 last year.","Revenue rose 2.1% to $116.88 million from $114.53 million last year."],"numeric_claims":[{"label":"Q1 earnings (USD)","value":"31.14 million"},{"label":"Q1 EPS (USD)","value":"2.53"},{"label":"Prior-year Q1 earnings (USD)","value":"30.02 million"},{"label":"Prior-year Q1 EPS (USD)","value":"2.23"},{"label":"Q1 revenue (USD)","value":"116.88 million"},{"label":"Prior-year Q1 revenue (USD)","value":"114.53 million"},{"label":"Revenue growth","value":"2.1%"}],"primary_claim":"PFBC\u2019s Q1 earnings increased to $31.14 million ($2.53 per share) from $30.02 million ($2.23 per share) in the same period last year.","relevance_score":0.55,"sentiment":"positive","source_quality":"low","summary":"Preferred Bank (PFBC) reported Q1 profit and revenue that increased year over year, with earnings of $31.14M ($2.53 EPS) versus $30.02M ($2.23 EPS) last year.","topics":["Q1 earnings","profit increased YoY","EPS increased","revenue increased","RTTNews earnings report"]},"source":"Nasdaq Markets","source_domain":"rttnews.com","summary":"(RTTNews) - PREFERRED BANK (PFBC) announced a profit for its first quarter that Increased, from the same period last year","tickers":["PFBC"],"title":"PREFERRED BANK Bottom Line Advances In Q1","url":"https://www.rttnews.com/3641262/preferred-bank-bottom-line-advances-in-q1.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_c36316bae3ac in signals