daily_entries
8 rows where position_id = 22
This data as json, CSV (advanced)
Suggested facets: daily_yield_usd, date (date)
| id ▼ | position_id | date | daily_yield_usd | rebalances | notes | exited_pool | position_value_usd |
|---|---|---|---|---|---|---|---|
| 91 | 22 22 | 2026-03-08 | 0.0 | 0 | 0 | 0.0 | |
| 92 | 22 22 | 2026-03-09 | 0.0 | 0 | 0 | 0.0 | |
| 93 | 22 22 | 2026-03-10 | 0.3704 | 0 | 0 | 0.0 | |
| 94 | 22 22 | 2026-03-11 | 0.5097 | 0 | 0 | 0.0 | |
| 95 | 22 22 | 2026-03-12 | 0.4684 | 0 | 0 | 0.0 | |
| 96 | 22 22 | 2026-03-13 | 0.4771 | 0 | 0 | 0.0 | |
| 97 | 22 22 | 2026-03-14 | 0.5969 | 0 | 0 | 0.0 | |
| 98 | 22 22 | 2026-03-15 | 0.1633 | 0 | 0 | 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)
);