recoltes

8 rows where filon_id = 22

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: daily_yield_usd, date (date)

id ▼ filon_id date daily_yield_usd rebalances exited_pool notes position_value_usd pnl_usd
91 22 22 2026-03-08 0.0 0 0   0.0 0.0
92 22 22 2026-03-09 0.0 0 0   0.0 0.0
93 22 22 2026-03-10 0.3704 0 0   0.0 0.0
94 22 22 2026-03-11 0.5097 0 0   0.0 0.0
95 22 22 2026-03-12 0.4684 0 0   0.0 0.0
96 22 22 2026-03-13 0.4771 0 0   0.0 0.0
97 22 22 2026-03-14 0.5969 0 0   0.0 0.0
98 22 22 2026-03-15 0.1633 0 0   0.0 0.0

Advanced export

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

CSV options: 

CREATE TABLE recoltes (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            filon_id INTEGER NOT NULL,
            date DATE NOT NULL,
            daily_yield_usd REAL NOT NULL DEFAULT 0,
            rebalances INTEGER NOT NULL DEFAULT 0,
            exited_pool INTEGER NOT NULL DEFAULT 0,
            notes TEXT,
            position_value_usd REAL DEFAULT 0,
            pnl_usd REAL DEFAULT 0,
            FOREIGN KEY (filon_id) REFERENCES filons(id),
            UNIQUE(filon_id, date)
        );