positions

14 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pair, blockchain, platform, open_date, close_date, status, open_date (date), close_date (date)

CREATE TABLE positions (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            pair TEXT NOT NULL,
            blockchain TEXT NOT NULL,
            platform TEXT NOT NULL,
            initial_investment_usd REAL NOT NULL,
            open_date DATE NOT NULL,
            close_date DATE,
            status TEXT NOT NULL DEFAULT 'open',
            notes TEXT
        , total_pnl_usd REAL, range_min REAL, range_max REAL);