Query editor
WITH wallet_inflow AS (SELECTto_owner as address,token_mint_address AS token_address,SUM(amount) AS raw_amountFROMtokens_solana.transfersWHEREto_owner IN (SELECT DISTINCT wallet_address FROM dune.serotonin_data.result_solana_node_operators_render_ionet_ore_nosana)AND token_mint_address IN ('EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm', --WIF'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', --BONK'7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr', --POPCAT'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82', --BOME'63LfDmNb3MQ8mw9MtZ2To9bEA2M71kZUUGq5tiJxcqj9', --GIGA'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump', --GOAT'5z3EqYQo9HiCEs3R84RCDMu2n7anpDMxRhdK8PSWmrRC', --PONKE'5mbK36SZ7J19An8jFochhQS4of8g6BwUjbeCSxBSoWdp', --MICHI'A8C3xuqscfmyLrte3VmTqrAq8kgMASius9AFNANwpump', --FWOG'6ogzHhzdrQr9Pgv6hZ2MNze7UrzBMAFyBBWUYp1Fhitx', --RETARDIO'5LafQUrVco6o7KMz42eqVEJ9LW31StPyGjeeu5sKoMtA', --MUMU'HhJpBhRRn4g56VsyLuT8DL5Bv31HkXqsrahTTUCZeZg4', --MYRO'ED5nyyWEzpPPiWimP8vYm7sD7TD3LAt3Q3gRTWHzPJBY', --MOODENG'GiG7Hr61RVm4CSUxJmgiCoySFQtdiwxtqf64MsRppump', --SCF'7BgBvyjrZX1YKz4oh9mjb8ZScatkkwb8DzFx7LoiVkM3', --SLERF'4Cnk9EPnW5ixfLZatCPJjDB1PUtcRpVVgTQukm9epump', --DADDY'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' --WEN)AND action = 'transfer'GROUP BY 1,2),wallet_outflow AS (SELECTfrom_owner as address,token_mint_address AS token_address,SUM(amount) AS raw_amountFROMtokens_solana.transfersWHEREfrom_owner IN (SELECT DISTINCT wallet_address FROM dune.serotonin_data.result_solana_node_operators_render_ionet_ore_nosana)AND token_mint_address IN ('EKpQGSJtjMFqKZ9KQanSqYXRcF8fBopzLHYxdM65zcjm', --WIF'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263', --BONK'7GCihgDB8fe6KNjn2MYtkzZcRjQy3t9GHdC8uHYmW2hr', --POPCAT'ukHH6c7mMyiWCf1b9pnWe25TSpkDDt3H5pQZgZ74J82', --BOME'63LfDmNb3MQ8mw9MtZ2To9bEA2M71kZUUGq5tiJxcqj9', --GIGA'CzLSujWBLFsSjncfkh59rUFqvafWcY5tzedWJSuypump', --GOAT'5z3EqYQo9HiCEs3R84RCDMu2n7anpDMxRhdK8PSWmrRC', --PONKE'5mbK36SZ7J19An8jFochhQS4of8g6BwUjbeCSxBSoWdp', --MICHI'A8C3xuqscfmyLrte3VmTqrAq8kgMASius9AFNANwpump', --FWOG'6ogzHhzdrQr9Pgv6hZ2MNze7UrzBMAFyBBWUYp1Fhitx', --RETARDIO'5LafQUrVco6o7KMz42eqVEJ9LW31StPyGjeeu5sKoMtA', --MUMU'HhJpBhRRn4g56VsyLuT8DL5Bv31HkXqsrahTTUCZeZg4', --MYRO'ED5nyyWEzpPPiWimP8vYm7sD7TD3LAt3Q3gRTWHzPJBY', --MOODENG'GiG7Hr61RVm4CSUxJmgiCoySFQtdiwxtqf64MsRppump', --SCF'7BgBvyjrZX1YKz4oh9mjb8ZScatkkwb8DzFx7LoiVkM3', --SLERF'4Cnk9EPnW5ixfLZatCPJjDB1PUtcRpVVgTQukm9epump', --DADDY'WENWENvqqNya429ubCdR81ZmD69brwQaaBYY6p3LCpk' --WEN)AND action = 'transfer'GROUP BY 1,2