daily_entries
5 rows where position_id = 9
This data as json, CSV (advanced)
Suggested facets: exited_pool, date (date)
| id ▼ | position_id | date | daily_yield_usd | rebalances | notes | exited_pool | position_value_usd |
|---|---|---|---|---|---|---|---|
| 142 | 9 9 | 2026-02-14 | 7.1277 | 0 | 0 | 0.0 | |
| 143 | 9 9 | 2026-02-15 | 0.1723 | 0 | 0 | 0.0 | |
| 144 | 9 9 | 2026-02-16 | 2.03 | 0 | 0 | 0.0 | |
| 145 | 9 9 | 2026-02-17 | 1.11 | 0 | 0 | 0.0 | |
| 146 | 9 9 | 2026-02-18 | 1.23 | 0 | 1 | 0.0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE daily_entries (
id INTEGER PRIMARY KEY AUTOINCREMENT,
position_id INTEGER NOT NULL,
date DATE NOT NULL,
daily_yield_usd REAL NOT NULL DEFAULT 0,
rebalances INTEGER NOT NULL DEFAULT 0,
notes TEXT, exited_pool INTEGER NOT NULL DEFAULT 0, position_value_usd REAL DEFAULT 0,
FOREIGN KEY (position_id) REFERENCES positions(id),
UNIQUE(position_id, date)
);