Query editor
withlast_rates as (selectvault,name,q.symbol,q.asset,max(rate) as last_rate,(SELECTCOALESCE(max(price),1)FROMprices.latest as pWHEREp.blockchain = q.chain and q.asset = p.contract_address) as asset_pricefromquery_3836498 as qgroup byvault,q.symbol,name,q.asset,chain)selectq.vault,q.symbol,q.name,q.chain,concat(q.name, ' (', q.chain, ')') as full_name,from_utf8(newConnectorName) as connector,concat(from_utf8(newConnectorName), ' (', q.chain, ')') as connector_full_name,split_part(from_utf8(newConnectorName),'_', 1) as connector_short_name,sum(casewhen q.action = 'Deposit' then q.shareselse - q.sharesend) / power(10, decimals) * last_rate as asset_tvl,sum(casewhen q.action = 'Deposit' then q.shareselse - q.sharesend) / power(10, decimals) * last_rate * l.asset_price as dollar_tvl,count(distinct owner) as unique_depositors,integratorfromquery_3836498 as qleft join last_rates as l on q.vault = l.vaultinner join query_3895718 cnu on q.vault = cnu.contract_addressgroup byq.vault,q.symbol,last_rate,decimals,q.name,q.chain,concat(q.name, ' (', q.chain, ')'),