Query editor
WITH token_meta AS (SELECTdecimalsFROM tokens_solana.fungibleWHERE token_mint_address = '9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump'LIMIT 1),raw_transfers AS (SELECTt.block_date AS day,t.from_owner,t.to_owner,CAST(t.amount AS DOUBLE) / POWER(10.0, tm.decimals) AS amountFROM tokens_solana.transfers tCROSS JOIN token_meta tmWHEREt.token_mint_address = '9BB6NFEcjBCtnNLFko2FqVQBq8HHM13kCyYcdQbgpump'AND (t.to_owner = 'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa'OR t.from_owner = 'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa')AND NOT ((t.from_owner = 'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa'AND t.to_owner IN ('44P5Ct5JkPz76Rs2K6juC65zXMpFRDrHatxcASJ4Dyra','5sTQ5ih7xtctBhMXHr3f1aWdaXazWrWfoehqWdqWnTFP'))OR (t.to_owner = 'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa'AND t.from_owner IN ('44P5Ct5JkPz76Rs2K6juC65zXMpFRDrHatxcASJ4Dyra','5sTQ5ih7xtctBhMXHr3f1aWdaXazWrWfoehqWdqWnTFP')))),wallet_transfers AS (SELECTday,CASEWHEN to_owner = 'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa'THEN amountELSE 0.0END AS amount_in,CASEWHEN from_owner = 'MfDuWeqSHEqTFVYZ7LoexgAK9dxk7cy4DFJWjWMGVWa'THEN amountELSE 0.0END AS amount_outFROM raw_transfers),daily AS (SELECTday,SUM(amount_in) AS amount_in,SUM(amount_out) AS amount_out,SUM(amount_in) - SUM(amount_out) AS net_change