weekly_position_stats

0 rows where position_id = 20

✎ View and edit SQL

This data as json

0 records

CREATE TABLE weekly_position_stats (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            week_start DATE NOT NULL,
            position_id INTEGER NOT NULL,
            current_value_usd REAL,
            price_change_pct REAL,
            tx_fees_usd REAL DEFAULT 0,
            UNIQUE(week_start, position_id),
            FOREIGN KEY (position_id) REFERENCES positions(id)
        );