Query editor
-- Decode manage() calls on Kraken Earn Advanced Yield BTC vault (Ink)-- Vault: 0x7dee0120739b7ec048b469939efb178adbbb19b2with single_calls as (selectcall_block_time,call_tx_hash,call_tx_from as strategist,target,substr(data_binary, 1, 4) as selector,data_binary,valuefrom kraken_earn_ink.advanced_yield_btc_call_managewhere call_success = trueand target is not nulland call_block_date > cast('2025-10-01' as date)),batched_calls as (selectc.call_block_time,c.call_tx_hash,c.call_tx_from as strategist,u.target,substr(u.data, 1, 4) as selector,u.data as data_binary,u.val as valuefrom kraken_earn_ink.advanced_yield_btc_call_manage ccross join unnest(c.targets, c.data_array_binary, c."values") as u(target, data, val)where c.call_success = trueand c.targets is not nulland c.call_block_date > cast('2025-10-01' as date)),all_calls as (select * from single_callsunion allselect * from batched_calls),selector_labels as (select selector, label from (values(0xa9059cbb, 'transfer(address,uint256)'),(0x095ea7b3, 'approve(address,uint256)'),(0x6e553f65, 'deposit(uint256,address) [ERC4626]'),(0xb6b55f25, 'deposit(uint256)'),(0xba087652, 'redeem(uint256,address,address) [ERC4626]'),(0x42966c68, 'burn(uint256)'),(0x9dc29fac, 'burn(address,uint256)'),(0x6fd3504e, 'depositForBurn [CCTP]'),(0xf856ddb6, 'depositForBurnWithCaller [CCTP]'),(0x238d6579, 'supply [Aave V2]'),(0x617ba037, 'supply [Aave V3]'),(0xe2bbb158, 'deposit(uint256,uint256)'),(0x47e7ef24, 'deposit(address,uint256)')) as t(selector, label))selectget_href(concat('https://explorer.inkonchain.com/address/', cast(a.target as varchar)), cast(a.target as varchar)) as target,