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/bank-stock-best-return-equity-its-sector","as_of":"2026-04-10T12:11:33.277556+00:00","canonical_url":"https://www.fool.com/investing/2026/04/10/bank-stock-with-best-return-on-equity-sector/","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/bank-stock-best-return-equity-its-sector","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_19e7ab0b2e64b756","canonical_host":"fool.com","canonical_is_aggregator":false,"canonical_url":"https://www.fool.com/investing/2026/04/10/bank-stock-with-best-return-on-equity-sector/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T12:12:24.909678+00:00","extraction_method":"heuristic","fetched_description":"Key PointsReturn on equity is a particularly important metric for banks.","fetched_title":"The Bank Stock With the Best Return on Equity in its Sector | Nasdaq","final_url":"https://www.nasdaq.com/articles/bank-stock-best-return-equity-its-sector","html_truncated":false,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/bank-stock-best-return-equity-its-sector","source_event_id":"evt_d68c0e57ddc0","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6498bd820d197608","kind":"unusual_volume","published_at":"2026-04-10T12:00:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["April 10, 2026","April 14, 2026","Dec. 31, 2025","Tuesday, April 14"],"entities":[{"asset_class":"equity","name":"JPMorgan Chase","relevance":"high","symbol":"JPM","type":"company"},{"asset_class":"other","name":"Federal Deposit Insurance Corp. (FDIC)","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"equity","name":"Wells Fargo","relevance":"medium","symbol":"WFC","type":"company"}],"event_type":"earnings","information_gaps":["Signal type is discovery_unusual_volume_delta, but the provided text contains no unusual volume ratio, baseline volume, or volume delta information.","No explicit statement confirms whether any volume change (if it exists) is driven by news; the article is primarily a fundamentals/ROE discussion.","No ticker-specific volume metrics are provided for JPM or any other stock."],"key_facts":["The article states the FDIC average ROE for all banks as of Dec. 31, 2025 was 11.82%.","The article states JPMorgan Chase had the highest ROE among the top 25 largest banks at 15%.","The article states JPMorgan Chase\u2019s ROTCE in the latest quarter was 18%.","The article states JPMorgan Chase reports first-quarter earnings on Tuesday, April 14, 2026.","The article states JPMorgan Chase stock is down about 8% year-to-date and is valued at roughly 13 times earnings (as stated in the article)."],"numeric_claims":[{"label":"FDIC average ROE (all banks, as of Dec. 31, 2025)","value":"11.82%"},{"label":"JPMorgan Chase ROE (top 25 largest banks)","value":"15%"},{"label":"JPMorgan Chase ROTCE (latest quarter)","value":"18%"},{"label":"JPMorgan Chase average annualized return (5 years)","value":"14.1%"},{"label":"Wells Fargo average annualized return (5 years)","value":"15.3%"},{"label":"JPMorgan Chase average annualized return (10 years)","value":"17.5%"},{"label":"JPMorgan Chase stock down year-to-date","value":"~8%"},{"label":"JPMorgan Chase valuation multiple","value":"~13x earnings"}],"primary_claim":"JPMorgan Chase has the highest ROE among the top 25 largest banks, at 15% (vs. an average bank ROE of 11.82% as of Dec. 31, 2025).","relevance_score":0.42,"sentiment":"positive","source_quality":"high","summary":"The article argues that JPMorgan Chase has the highest return on equity (ROE) among the top 25 largest U.S. banks, citing FDIC data and JPM\u2019s ROTCE. It notes JPMorgan Chase reports first-quarter earnings on April 14, 2026.","topics":["return on equity (ROE)","bank profitability metrics","return on tangible common equity (ROTCE)","FDIC data","JPMorgan Chase earnings date","valuation and stock performance"]},"source":"Nasdaq Markets","source_domain":"fool.com","summary":"Key PointsReturn on equity is a particularly important metric for banks.","tickers":[],"title":"The Bank Stock With the Best Return on Equity in its Sector","url":"https://www.fool.com/investing/2026/04/10/bank-stock-with-best-return-on-equity-sector/"}

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