daily_entries
2 rows where position_id = 15
This data as json, CSV (advanced)
Suggested facets: date (date)
| id ▼ | position_id | date | daily_yield_usd | rebalances | notes | exited_pool | position_value_usd |
|---|---|---|---|---|---|---|---|
| 153 | 15 15 | 2026-02-22 | 8.4879 | 0 | 0 | 0.0 | |
| 154 | 15 15 | 2026-02-23 | 4.9021 | 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)
);