Query editor
/* WETHAddress: 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 *//* BotDeployerAddress: 0xf414d478934c29d9a80244a3626c681a71e53bb2 *//* BotDeployerFirstTransactionBlockNumber: 17345515 *//* BotDeployerFirstTransactionTimestamp: '2023-05-26 00:00:00.000 UTC' */WITHbotTradesWithFees AS (SELECTblock_time,blockchain,amount_usd,type,token_pair,project,version,fee_usd,--bribe_usd,project_contract_address,user,tx_hashFROM/* Banana Gun Bot Trades */query_2683548)SELECTRANK() OVER (ORDER BYSUM(amount_usd) DESC) AS pairRank,IF(token_pair IS NULL,SUBSTRING(CAST(project_contract_address AS VARCHAR), 1, 6),token_pair) AS token_pair,CONCAT('<a href="https://dexscreener.com/ethereum/',CAST(project_contract_address AS VARCHAR),'" target=_blank">',IF(token_pair IS NULL,SUBSTRING(CAST(project_contract_address AS VARCHAR), 1, 6),token_pair),'</a>') AS token_pair_url,blockchain,SUM(amount_usd) AS totalVolumeUSD,SUM(IF("type" = 'Buy', amount_usd, 0)) AS buyVolumeUSD,SUM(IF("type" = 'Sell', amount_usd, 0)) AS sellVolumeUSD,SUM(fee_usd) AS feesUSD,--SUM(bribe_usd) AS bribesUSD,COUNT(DISTINCT (tx_hash)) AS numberOfTrades,COUNT(DISTINCT (user)) AS numberOfUsers,project,version,project_contract_address,CONCAT('<a href="https://dexscreener.com/ethereum/',CAST(project_contract_address AS VARCHAR),'" target=_blank">',CAST(project_contract_address AS VARCHAR),