Query editor
WITH tvl_events AS (SELECTDATE_TRUNC('day', block_time) AS date,MAX(bytearray_to_uint256(varbinary_substring(data, 1, 32)) / 1e6) AS tvl_usdcFROM base.logsWHERE contract_address = 0xE34D43CA9152D198B60654868C8cD197196a492fAND topic0 = 0x4dec04e750ca11537cabcd8a9eab06494de08da3735bc8871cd41250e190bc04AND block_time >= TIMESTAMP '2026-05-12'GROUP BY 1),date_series AS (SELECT CAST(date_trunc('day', t) AS DATE) AS dateFROM UNNEST(SEQUENCE(TIMESTAMP '2026-05-12',CAST(CURRENT_DATE AS TIMESTAMP),INTERVAL '1' DAY)) AS t(t)),filled AS (SELECTd.date,MAX(e.tvl_usdc) OVER (ORDER BY d.dateROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS tvl_usdc,20.09 AS my_positionFROM date_series dLEFT JOIN tvl_events e ON d.date = CAST(e.date AS DATE))SELECT date, tvl_usdc, my_positionFROM filledWHERE tvl_usdc IS NOT NULLORDER BY date