One quarter, every credit union

Every credit union's total assets for one quarter, with its name and charter type, largest first:

SELECT a.cu_number,
       coalesce(p.credit_union_name, '(no profile row)') AS name,
       p.credit_union_type_id AS type,
       a.account_value AS total_assets
FROM read_parquet('https://data.quartercall.com/curated/accounts/quarter=2026Q2/data.parquet') a
LEFT JOIN read_parquet('https://data.quartercall.com/curated/profiles/quarter=2026Q2/data.parquet') p
  USING (cu_number)
WHERE a.account_code = 'A010'
ORDER BY total_assets DESC;

examples/recipes/one-quarter-all-credit-unions/largest.sql

The join is LEFT, and a credit union with no profile row is kept and labelled rather than dropped (gotcha 3). The name is the one NCUA held when callbase fetched the filing, which for an older quarter can be a later name (gotcha 2).

To cover the federally insured population, which is what QuarterCall's own figures cover, keep type IN ('FCU', 'FISCU'). The NFICU filers are privately insured and published like any other.