daily_entries
5 rows where position_id = 19
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 |
|---|---|---|---|---|---|---|---|
| 102 | 19 19 | 2026-03-01 | 0.0852 | 0 | 0 | 0.0 | |
| 103 | 19 19 | 2026-03-02 | 0.4935 | 0 | 0 | 0.0 | |
| 104 | 19 19 | 2026-03-03 | 0.8555 | 0 | 0 | 0.0 | |
| 105 | 19 19 | 2026-03-04 | 0.7983 | 0 | 0 | 0.0 | |
| 106 | 19 19 | 2026-03-05 | 0.9975 | 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)
);