Query editor
WITH airdrop AS(SELECT "from"FROM ethereum.transactionsWHERE "to" = '\x5474b3abF3E58A2b32F329F3633406a0d2941E6F'AND block_time >=' 2021-08-17'),duplicates AS(SELECT tx_hashFROM dex.tradesWHERE (token_a_address = '\xba5bde662c17e2adff1075610382b9b691296350'OR token_b_address = '\xba5bde662c17e2adff1075610382b9b691296350')AND trader_a in(SELECT *FROM airdrop)GROUP BY 1HAVING count(*) > 1)SELECT trader_a AS address,name,sum(CASEWHEN token_b_address = '\xba5bde662c17e2adff1075610382b9b691296350' THEN token_b_amount_rawELSE -token_a_amount_rawEND / 1e18) AS tokensFROM dex.tradesINNER JOIN superrare.usernames ON trader_a = addressAND (token_a_address = '\xba5bde662c17e2adff1075610382b9b691296350'OR token_b_address = '\xba5bde662c17e2adff1075610382b9b691296350')AND block_time >= '2021-08-17'AND trader_a in(SELECT *FROM airdrop)AND (tx_hash not in(SELECT *FROM duplicates)OR category != 'Aggregator')GROUP BY 1,2ORDER BY 3 DESC