Skip to content
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 per parcel build (weekly from 2026-10-04)
Branches scored
73,219
MSAs covered
394
Market-share rows
11,880
Source
FDIC SOD

Access today

  • Listing status (2026-10-15). The Snowflake Marketplace listing is in review, so it cannot be subscribed to yet.
  • Access today. Access is a direct share by request: email sales@propraven.com with your Snowflake account identifier and the listings and states you need. It is not self-serve yet.
  • Requirements. The provider account runs on AWS (region on request). To accept the share you need a role with IMPORT SHARE and CREATE DATABASE (standard Snowflake share acceptance), so you can create a database from the share.
  • Cost. Snowflake delivery is sold as a Data License; see /pricing.

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 per parcel build (weekly from 2026-10-04). FDIC SOD source publishes annually; PropRaven analytics layer recalculates monthly. Most enrichment columns come from an April 2026 reference snapshot; the build currently served is shown on /data/live.

Freshness as of 2026-10-15. PROPRAVEN_PARCEL_INTELLIGENCE (the 620-column parcels table) was refreshed on 2026-10-15 from the parcels gateway's current per-state builds (most states 2026-10-12; ID 2026-10-11; CT 2026-10-04-rw1; WI 2026-10-18), loaded by serverless Snowpipe. The Ontology share's silver tables were refreshed the same day from silver built on that per-state map; its derived graph and intelligence tables (owner portfolio, ownership edges, distress, value-add, institutional ownership, lender exposure) are from the 2026-08-28 build. Per-row _LOADED_AT and _SOURCE_AS_OF columns expose the actual freshness for any row in your query result.

Questions? support@propraven.com — or browse the data dictionary and sample queries.