Query editor
with-- This subquery is not executable on its own.filtered_trades as (select t.block_time,t.tx_hash,dex_swaps,num_trades,solver_name,solver_address,trader as trader_in,receiver as trader_out,sell_token_address as "sellToken",buy_token_address as "buyToken",atoms_sold as "sellAmount",atoms_bought as "buyAmount",'\x9008D19f58AAbD9eD0D60971565AA8510560ab41' :: bytea as contract_addressfrom gnosis_protocol_v2."trades" tjoin gnosis_protocol_v2."batches" b on t.tx_hash = b.tx_hashwhere b.block_time between '{{StartTime}}'and '{{EndTime}}'and casewhen '{{TxHash}}' = '0x' then trueelse replace('{{TxHash}}', '0x', '\x') :: bytea = t.tx_hashend),batchwise_traders as (selecttx_hash,array_agg(trader_in) as traders_in,array_agg(trader_out) as traders_outfrom filtered_tradesgroup by tx_hash),user_in as (select block_time,tx_hash,dex_swaps,num_trades,solver_address,solver_name,trader_in as sender,contract_address as receiver,"sellToken" as token,"sellAmount" as amount_wei,'IN_USER' as transfer_typefrom filtered_trades),user_out as (select block_time,tx_hash,dex_swaps,num_trades,solver_address,solver_name,contract_address as sender,trader_out as receiver,"buyToken" as token,"buyAmount" as amount_wei,