fee_snapshot

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

12,941 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: snapshot_quarter, currency, frequency, channel, access_tier, valid_from (date)

Next page

CREATE TABLE fee_snapshot (
    id                  TEXT NOT NULL,
    snapshot_quarter    TEXT NOT NULL,
    product_id          TEXT NOT NULL,
    bank_id             TEXT NOT NULL,
    fee_type            TEXT NOT NULL,
    label               TEXT,
    amount              REAL,
    currency            TEXT,
    frequency           TEXT,
    tier                TEXT,
    channel             TEXT,
    note                TEXT,
    source_page         INTEGER,
    valid_from          TEXT,
    access_tier         TEXT,
    PRIMARY KEY (id, snapshot_quarter)
);
CREATE INDEX idx_fee_snapshot_bank    ON fee_snapshot(bank_id, snapshot_quarter);
CREATE INDEX idx_fee_snapshot_product ON fee_snapshot(product_id, snapshot_quarter);
CREATE INDEX idx_fee_snapshot_quarter ON fee_snapshot(snapshot_quarter);