recoltes

6 rows where filon_id = 23

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: daily_yield_usd, notes, date (date)

id ▼ filon_id date daily_yield_usd rebalances exited_pool notes position_value_usd pnl_usd
180 23 23 2026-03-22 0.0 0 0   200.0 0.0
183 23 23 2026-03-23 5.23 0 0   199.0 4.29
186 23 23 2026-03-24 5.68 0 0   173.0 -16.03
188 23 23 2026-03-25 3.12 0 0   178.0 -4.18
190 23 23 2026-03-26 0.0 0 0 Hors range, 0 fees. Estimé. 130.0 -52.0
192 23 23 2026-03-27 0.0 0 0 OUT OF RANGE. Liquidity 105. P&L -80.32. Attend bougie verte pour sortir. 105.0 -80.32

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)
        );