Query editor
with addr_tbl as (selectaddress,label,risk_level,current_timestamp as updated_atfrom (values(0xa602141bfc2577a37b43d6156728b09c900b33c3, 'security wallet', 'high'),(0xd5258c2b820d43ac77d42db0f71b2907a4d076b8, 'bridge wallet', 'high'),(0xd541e6cfc610def494fc36cce99a5dbdf84111f6, 'bridge wallet', 'high'),(0xdeed889efaaff02f72aad928ce4a7b51773ca563, 'bridge wallet', 'high'),(0xbca5b698f0349593c0f7ef8561e3288448b85eaf, 'bridge wallet', 'high'),(0x4efe127e2975cf2703d74261298c72b6193a8270, 'bridge wallet', 'high'),(0xea3e6886f77317427a9aa524e4a7fde1afb81d38, 'escrow wallet', 'medium'),(0x166d2025bde6abc7b52a041cbf2503ff4346eab4, 'admin wallet', 'medium'),(0xd43ce272cdde24d7686223967031fa5044c37651, 'pass through wallet', 'low'),(0x45a71484168336dd1083346c844f94c19058bd35, 'deposit through wallet', 'low'),(0x886cb5476616e03d646cf22120cc4f5c0535e975, 'deposit through wallet', 'low')) t(address, label, risk_level)),base_data as (selectts_source,tx_hash_source,source_chain,source_contract,ts_destination,destination_chain,destination_contract,tx_hash_destination,addr_from,usd_valuefrom layerzero.messageswhere addr_from in (select cast(address as varchar(100)) from addr_tbl))select sum(usd_value) as total_volumefrom base_data