Query editor
with foo as (select unnest("output_assetDeltas") as delta,unnest("assets") as token,evt_tx_hashfrom balancer_v2."Vault_evt_Swap" ainner join balancer_v2."Vault_call_batchSwap" bon a.evt_tx_hash = b.call_tx_hash),flashswappers as (select evt_tx_hash from (Select max(delta) as vMax, evt_tx_hashFrom fooGroup by 2) twhere vMax <= 0)select block_time, tx_hash, sum(usd_amount) as volume from dex.tradeswhere tx_hash in (select * from flashswappers)and project = 'Balancer'group by 1, 2order by 1 desc