Query editor
SELECTSUM(CASE WHEN "to" = '0x84e755a3e38c7e31047d93c6d2bb90d14baff170' THEN amount ELSE -amount END) AS net_balance,SUM(CASE WHEN "to" = '0x84e755a3e38c7e31047d93c6d2bb90d14baff170' THEN amount ELSE 0 END) AS total_in,SUM(CASE WHEN "from" = '0x84e755a3e38c7e31047d93c6d2bb90d14baff170' THEN amount ELSE 0 END) AS total_out,COUNT(CASE WHEN "from" = '0x84e755a3e38c7e31047d93c6d2bb90d14baff170' AND block_time > NOW() - INTERVAL '24' hour THEN 1 END) AS sells_last_24h,COUNT(CASE WHEN "from" = '0x84e755a3e38c7e31047d93c6d2bb90d14baff170' AND block_time > NOW() - INTERVAL '7' day THEN 1 END) AS sells_last_7d,MAX(CASE WHEN "from" = '0x84e755a3e38c7e31047d93c6d2bb90d14baff170' THEN block_time END) AS last_sell_timeFROM tokens.transfersWHERE blockchain = 'base'AND contract_address = '0x590830dfdf9a3f68afcdde2694773debdf267774'AND ('0x84e755a3e38c7e31047d93c6d2bb90d14baff170' IN ("to", "from"))