Query editor
WITH safes as (select addr as addressfrom ambirewa_bnb.AmbireFactory_evt_LogDeployedUNIONselect addr as addressfrom ambirewallet_polygon.AmbireFactory_evt_LogDeployedUNIONselect addr as addressfrom ambirewallet_ethereum.AmbireFactory_evt_LogDeployedUNIONselect addr as addressfrom ambirewallet_optimism.AmbireFactory_evt_LogDeployedUNIONselect addr as addressfrom ambirewallet_arbitrum.AmbireFactory_evt_LogDeployedUNIONselect addr as addressfrom ambirewallet_base.AmbireFactory_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_optimism.evt_transfer trjoin safes son tr."to" = s.addressleft outer join tokens.erc20 tkon tr.contract_address = tk.contract_addresswhere tk.blockchain = 'optimism'UNION 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_optimism.evt_Transfer trjoin safes son tr."from" = s.addressleft outer join tokens.erc20 tkon tr.contract_address = tk.contract_addresswhere tk.blockchain = 'optimism'),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)