Listing · PROPRAVEN_BANKING_MARKETPLACE
PropRaven Banking Marketplace
Every U.S. bank branch with deposits, stability, and HHI-graded market concentration.
Bank corp-dev · Sell-side analysts · AntitrustRefreshed monthly
Description
PropRaven Banking Marketplace packages the FDIC Summary of Deposits — every retail bank branch in the U.S. with annual deposit balances, ownership chain, and geocoded location — together with derived analytics that pre-compute the work most teams build internally:
- Branch stability score — 5-year deposit trend, parent-acquisition flag, and closure-risk grade for every active branch (73,219 scored).
- MSA market share — bank-level deposit share for all 394 MSAs with year-over-year deltas (11,880 rows).
- HHI concentration index per MSA with antitrust-ready thresholds (under 1500 unconcentrated, 1500-2500 moderate, over 2500 highly concentrated).
Joinable to PropRaven Parcel Intelligence (companion listing) via FDIC RSSD_ID for branch-to-real-estate analytics.
What's included
FDIC_SOD_BRANCHES — every U.S. retail bank branch (geocoded).
FDIC_INSTITUTIONS — institution-level metadata, ownership chain, holding company.
BANK_BRANCH_STABILITY — 73,219 scored branches: 3-year deposit CAGR, age, capital ratio, MSA rank, stability score 0-100.
BANK_MSA_HHI — 394 MSAs with HHI, concentration level, institution count, branch count.
BANK_MSA_MARKET_SHARE — institution × MSA rollup with deposits, share %, YoY delta.
BANKING_DATA_DICTIONARY — full column reference.
BANKING_SAMPLE_BRANCHES and BANKING_SAMPLE_HHI — small free samples for evaluation.
Use cases
- Bank M&A target screening: pre-screen acquisition targets by deposit growth, branch density overlap, market-share contribution.
- CRE underwriting & site selection: evaluate retail-banking demand at parcel/MSA level for net-lease and shadow-anchor deals.
- Antitrust HHI pre-screen: pre-merger DOJ/Fed HHI thresholds embedded — examiner-facing analysis.
- CRA & fair-lending defense: branch coverage by MSA with concentration grade for assessment-area defense.
Sample query — most stable branches in your MSA
SELECT
bs.INSTITUTION_NAME,
bs.BRANCH_NAME,
bs.STABILITY_SCORE,
bs.DEPOSIT_GROWTH_CAGR_3YR,
bs.MSA_RANK
FROM PROPRAVEN_BANKING_MARKETPLACE.MARKETPLACE.BANK_BRANCH_STABILITY bs
JOIN PROPRAVEN_BANKING_MARKETPLACE.MARKETPLACE.FDIC_SOD_BRANCHES sod
USING (UNINUMBR)
WHERE sod.MSA_NAME = 'Tampa-St. Petersburg-Clearwater, FL'
AND bs.STABILITY_SCORE >= 80
ORDER BY bs.STABILITY_SCORE DESC
LIMIT 50;
Pre-merger HHI screen
Highly-concentrated MSAs (HHI over 2500) — DOJ/Fed antitrust trigger zones:
SELECT MSA_NAME, HHI, CONCENTRATION_LEVEL, INSTITUTION_COUNT, BRANCH_COUNT
FROM PROPRAVEN_BANKING_MARKETPLACE.MARKETPLACE.BANK_MSA_HHI
WHERE HHI > 2500
ORDER BY HHI DESC;
Refresh cadence
Refreshed monthly. FDIC SOD source publishes annually; PropRaven analytics layer recalculates monthly. Per-row _LOADED_AT and _SOURCE_AS_OF columns expose the actual freshness for any row in your query result.
Questions? hello@propraven.com — or browse the data dictionary and sample queries.