Query editor
WITH safes as (select addr as addressfrom ambirewallet_bnb.IdentityFactory_evt_LogDeployedUNIONselect addr as addressfrom ambirewallet_polygon.IdentityFactory_evt_LogDeployedUNIONselect addr as addressfrom ambirewallet_ethereum.IdentityFactory_evt_LogDeployed),transfers as (SELECTevt_tx_hash AS tx_hash,tr."to" AS address,CAST(tr.value AS DOUBLE)/POWER(10,tk.decimals) as amount,tk.decimals,tk.symbol,tr.contract_addressFROM erc20_bnb.evt_transfer trjoin safes son tr."to" = s.addressleft outer join tokens.erc20 tkon tr.contract_address = tk.contract_addresswhere tk.contract_address != 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590UNION ALLSELECTevt_tx_hash AS tx_hash,tr."from" AS address,-CAST(tr.value AS DOUBLE)/POWER(10,tk.decimals) as amount,tk.decimals,tk.symbol,tr.contract_addressFROM erc20_bnb.evt_Transfer trjoin safes son tr."from" = s.addressleft outer join tokens.erc20 tkon tr.contract_address = tk.contract_addresswhere tk.contract_address != 0x2f6f07cdcf3588944bf4c42ac74ff24bf56e7590),balances as (SELECTcontract_address,abs(sum(amount)) as balanceFROM transfersGROUP BY 1),tvlByToken as (select b.contract_address, b.balance, p.price, b.balance * p.price as value from balances bjoin prices.usd_latest p on p.contract_address = b.contract_addressORDER BY value DESC)select sum(value) from tvlByToken