Query editor
WITH my_deposit AS (SELECTSUM(bytearray_to_uint256(varbinary_substring(data, 1, 32)) / 1e6) AS deposited_usdc,MIN(block_time) AS deposit_dateFROM base.logsWHERE contract_address = 0xE34D43CA9152D198B60654868C8cD197196a492fAND topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7AND topic2 = 0x000000000000000000000000ad496b0e1f52b93181736272e988cf57932f8f56),weekly_observations AS (SELECT * FROM (VALUES(DATE '2026-05-23', 20.10, 4.02),(DATE '2026-06-02', 20.12, 3.87),(DATE '2026-06-08', 20.12, 3.44),(DATE '2026-06-17', 20.15, 4.39),(DATE '2026-06-24', 20.16, 3.94),(DATE '2026-06-28', 20.17, 3.94),(DATE '2026-07-24', 20.17, 3.94),(DATE '2026-08-24', 20.17, 3.94)) AS t(obs_date, position_usdc, apy_pct))SELECTw.obs_date AS date,d.deposited_usdc AS initial_deposit_usdc,w.position_usdc AS current_value_usdc,ROUND(w.position_usdc - d.deposited_usdc, 4) AS earned_usdc,w.apy_pct AS net_apy_pct,ROUND((w.position_usdc - d.deposited_usdc) / d.deposited_usdc * 100, 4) AS cumulative_return_pct,DATE_DIFF('day', CAST(d.deposit_date AS DATE), w.obs_date) AS days_activeFROM weekly_observations wCROSS JOIN my_deposit dORDER BY w.obs_date