interest_rate_snapshot

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

4,118 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: snapshot_quarter, rate_type, tier_floor, tier_ceiling, tenor_months, currency, snapshot_date (date), valid_from (date)

Next page

CREATE TABLE interest_rate_snapshot (
    id                  TEXT NOT NULL,
    snapshot_quarter    TEXT NOT NULL,
    product_id          TEXT NOT NULL,
    bank_id             TEXT NOT NULL,
    rate_type           TEXT NOT NULL,
    rate                REAL,                        -- NULL preserved (on-request / not published)
    tier_floor          REAL,
    tier_ceiling        REAL,
    tenor_months        INTEGER,
    currency            TEXT,
    snapshot_date       TEXT,                        -- original observation date (not the snapshot quarter)
    valid_from          TEXT,
    note                TEXT,
    PRIMARY KEY (id, snapshot_quarter)
);
CREATE INDEX idx_ir_snapshot_bank    ON interest_rate_snapshot(bank_id, snapshot_quarter);
CREATE INDEX idx_ir_snapshot_product ON interest_rate_snapshot(product_id, snapshot_quarter);
CREATE INDEX idx_ir_snapshot_quarter ON interest_rate_snapshot(snapshot_quarter);