Query editor
selectblockchain,project,count(distinct taker) as traders,count(distinct tx_hash) as trades,sum(case when token_bought_address = 0xaca92e438df0b2401ff60da7e4337b687a2435da then token_bought_amount else 0 end) as swap_to_amount,sum(case when token_sold_address = 0xaca92e438df0b2401ff60da7e4337b687a2435da then token_sold_amount else 0 end) as swap_from_amount,sum(casewhen token_bought_address = 0xaca92e438df0b2401ff60da7e4337b687a2435da then token_bought_amountwhen token_sold_address = 0xaca92e438df0b2401ff60da7e4337b687a2435da then token_sold_amountelse 0 end) as trade_amountfrom dex.tradeswhere (token_bought_address = 0xaca92e438df0b2401ff60da7e4337b687a2435daor token_sold_address = 0xaca92e438df0b2401ff60da7e4337b687a2435da)group by 1,2