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 = 0x590830dfdf9a3f68afcdde2694773debdf267774AND ("to" = 0x84e755a3e38c7e31047d93c6d2bb90d14baff170 OR "from" = 0x84e755a3e38c7e31047d93c6d2bb90d14baff170)