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
Branches scored
73,219
MSAs covered
394
Market-share rows
11,880
Source
FDIC SOD

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.