Query editor
-- Adapted from query 6655619 (Sentora Advanced USDC) for Kraken Earn Advanced Yield BTC on Ink-- Vault: 0x7dee0120739b7ec048b469939efb178adbbb19b2with strategies as (select distinct to as strategyfrom tokens_ink.transferswhere "from" = 0x7dee0120739b7ec048b469939efb178adbbb19b2and block_date > cast('2025-10-01' as date)),silo_vaults as (select output_siloVault as vaultfrom silo_finance_v2_ink.silovaultsfactory_call_createsilovaultwhere call_success = true),protocols as (selects.strategy,casewhen exists (select 1 from morpho_blue_ink.morphoblue_evt_supply where onBehalf = s.strategy limit 1) then 'morpho'when exists (select 1 from morpho_blue_ink.morphoblue_evt_supplycollateral where onBehalf = s.strategy limit 1) then 'morpho'when s.strategy in (select vault from silo_vaults) then 'silo-vault'else nullend as protocolfrom strategies s),deallocated as (select"from" as strategy_d,symbol as symbol_d,contract_address as contract_address_d,sum(amount) as deallocatedfrom tokens_ink.transferswhere to = 0x7dee0120739b7ec048b469939efb178adbbb19b2and "from" in (select strategy from strategies)and block_date > cast('2025-10-01' as date)group by 1, 2, 3)selectget_href(concat('https://explorer.inkonchain.com/address/', cast(t.to as varchar)), cast(t.to as varchar)) as strategy,p.protocol,case when t.to in (select distinct token from merkl_ink.distributor_evt_claimed) then 'yes' else null end as merkl,t.symbol,sum(t.amount) as allocated,coalesce(d.deallocated, 0) as deallocated,sum(t.amount) - coalesce(d.deallocated, 0) as aum,count(*) as transfer_count,min(t.block_time) as first_alloc,max(t.block_time) as last_allocfrom tokens_ink.transfers tleft join deallocated d on t.symbol = d.symbol_d and t.to = d.strategy_d and t.contract_address = d.contract_address_dleft join protocols p on t.to = p.strategywhere t."from" = 0x7dee0120739b7ec048b469939efb178adbbb19b2and t.to in (select strategy from strategies)and t.block_date > cast('2025-10-01' as date)group by 1, 2, 3, 4, 6order by aum desc