Query editor
SELECTCONCAT('0x', TO_HEX(varbinary_substring(topic2, 13, 20))) AS depositor,SUM(bytearray_to_uint256(varbinary_substring(data, 1, 32)) / 1e6) AS total_usdc,COUNT(*) AS num_deposits,MIN(block_time) AS first_deposit,ROUND(SUM(bytearray_to_uint256(varbinary_substring(data, 1, 32)) / 1e6) * 100.0 /SUM(SUM(bytearray_to_uint256(varbinary_substring(data, 1, 32)) / 1e6)) OVER (),2) AS pct_of_vaultFROM base.logsWHERE contract_address = 0xE34D43CA9152D198B60654868C8cD197196a492fAND topic0 = 0xdcbc1c05240f31ff3ad067ef1ee35ce4997762752e3a095284754544f4c709d7AND block_time >= TIMESTAMP '2026-05-12'GROUP BY 1ORDER BY 2 DESC