daily_entries
5 rows where position_id = 12
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 |
|---|---|---|---|---|---|---|---|
| 147 | 12 12 | 2026-02-18 | 5.92 | 0 | 0 | 0.0 | |
| 148 | 12 12 | 2026-02-19 | 5.87 | 0 | 0 | 0.0 | |
| 149 | 12 12 | 2026-02-20 | 20.51 | 0 | 0 | 0.0 | |
| 150 | 12 12 | 2026-02-21 | 8.02 | 0 | 0 | 0.0 | |
| 151 | 12 12 | 2026-02-22 | 15.7 | 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)
);