Query editor
WITH tx_legs AS (SELECT tx_hash, block_date, block_time, to_address AS addr, amount AS amtFROM query_7839505WHERE flow_type = 'transfer'UNION ALLSELECT tx_hash, block_date, block_time, from_address AS addr, -amount AS amtFROM query_7839505WHERE flow_type = 'transfer'),net_per_tx_address AS (SELECTtx_hash,MIN(block_date) AS block_date,MIN(block_time) AS block_time,addr,SUM(amt) AS net_amountFROM tx_legsGROUP BY 1, 4HAVING SUM(amt) != 0)SELECT'solana' AS chain,n.tx_hash,n.block_date,n.block_time,n.addr,n.net_amount,CASE WHEN n.net_amount > 0 THEN 'net_inflow' ELSE 'net_outflow' END AS directionFROM net_per_tx_address nLEFT JOIN query_7839514 cON c.addr = n.addrWHERE COALESCE(c.is_infrastructure, false) = false