daily_entries
8 rows where position_id = 20
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 |
|---|---|---|---|---|---|---|---|
| 107 | 20 20 | 2026-03-01 | 25.9545 | 0 | 0 | 0.0 | |
| 108 | 20 20 | 2026-03-02 | 0.2884 | 0 | 0 | 0.0 | |
| 109 | 20 20 | 2026-03-03 | 1.58 | 0 | 0 | 0.0 | |
| 110 | 20 20 | 2026-03-04 | 1.4 | 0 | 0 | 0.0 | |
| 111 | 20 20 | 2026-03-05 | 0.6971 | 0 | 0 | 0.0 | |
| 112 | 20 20 | 2026-03-06 | 1.54 | 0 | 0 | 0.0 | |
| 113 | 20 20 | 2026-03-07 | 2.86 | 0 | 0 | 0.0 | |
| 114 | 20 20 | 2026-03-08 | 10.44 | 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)
);