Query editor
WITH safes AS (SELECTblock_time,address,tx_hash,blockchainFROM safe.transactions_allUNION ALLSELECTblock_time,safe_address AS address,tx_hash,blockchainFROM dune.safe.result_cross_chain_safe_4337_user_ops)SELECTDATE_TRUNC('month', e.evt_block_time) AS month,s.blockchain,-- e.contract_address,SUM(e.value/pow(10,decimals)*price) AS usd_amtFROM safes sJOIN evms.erc20_transfers eON e.evt_tx_hash = s.tx_hashJOIN (SELECT minute, price, decimals, contract_address, blockchainFROM prices.usd) pON p.minute = DATE_TRUNC('minute', s.block_time)AND p.contract_address = e.contract_addressAND p.blockchain = e.blockchainGROUP BY 1,2