home / bankproducts

Interest rates

One row per interest rate. rate_type matches product category per atom #316 (mortgage_rate, consumer_credit, overdraft, credit, savings_rate, leasing_rate, penalty). snapshot_date is when we observed the rate; valid_from is when the bank declared it effective.

Data license: CC-BY-4.0 · Data source: bankproducts.info

14 rows where product_id = "postfinance:festhypothek" sorted by snapshot_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: note, snapshot_date (date), valid_from (date)

id product_id bank_id rate_type rate tier_floor tier_ceiling tenor_months currency snapshot_date ▲ valid_from note source_document_id
postfinance:festhypothek:mortgage:2yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.25     24 CHF 2026-07-09 2026-05-08 Indikativ, beste Bonitaet, selbst bewohntes Wohneigentum  
postfinance:festhypothek:mortgage:3yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.3     36 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:4yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.4     48 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:5yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.45     60 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:6yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.51     72 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:7yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.56     84 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:8yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.6     96 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:9yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.65     108 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:10yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.7     120 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:11yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.73     132 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:12yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.77     144 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:13yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.81     156 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:14yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.84     168 CHF 2026-07-09 2026-05-08 Indikativ  
postfinance:festhypothek:mortgage:15yr Festhypothek postfinance:festhypothek PostFinance AG postfinance mortgage_rate 1.86     180 CHF 2026-07-09 2026-05-08 Indikativ  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE interest_rate (
    id                 TEXT PRIMARY KEY,       -- sgkb:sparkonto:credit:tier1
    product_id         TEXT NOT NULL REFERENCES product(id),
    bank_id            TEXT NOT NULL REFERENCES bank(id),  -- denormalized
    rate_type          TEXT NOT NULL,          -- credit (paid to customer), debit (charged to customer),
                                               -- bonus (conditional extra), discount (reduction on base),
                                               -- overdraft (penalty rate)
    rate               REAL,                   -- percentage value (0.050 = 0.050%); NULL = on request / not published
    tier_floor         REAL,                   -- balance threshold lower bound; NULL = from zero
    tier_ceiling       REAL,                   -- balance threshold upper bound; NULL = unlimited
    tenor_months       INTEGER,                -- term length in months (24 = 2yr); NULL = no fixed term
    currency           TEXT DEFAULT 'CHF',
    snapshot_date      TEXT NOT NULL,          -- date the rate was observed (YYYY-MM-DD)
    valid_from         TEXT,                   -- date the rate took effect (YYYY-MM-DD)
    note               TEXT,                   -- conditions, fine print
    source_document_id INTEGER REFERENCES source_document(id)
);
CREATE INDEX idx_interest_rate_product ON interest_rate(product_id);
CREATE INDEX idx_interest_rate_bank ON interest_rate(bank_id);
CREATE INDEX idx_interest_rate_snapshot ON interest_rate(bank_id, snapshot_date);
CREATE INDEX idx_interest_rate_type ON interest_rate(rate_type, bank_id);
Powered by Datasette · Queries took 31.231ms · Data license: CC-BY-4.0 · Data source: bankproducts.info