home / defi

daily_entries

8 rows where position_id = 20

✎ View and edit SQL

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

CSV options:

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)
        );
Powered by Datasette · Queries took 6.402ms