Query editor
-- V2 Query: https://dune.com/queries/1373033?d=1WITHnum_tokens_traded as (selecthash,count(distinct(token)) num_tokensfrom (select evt_tx_hash as hash, "buyToken" token from gnosis_protocol_v2."GPv2Settlement_evt_Trade"UNIONselect evt_tx_hash as hash, "sellToken" token from gnosis_protocol_v2."GPv2Settlement_evt_Trade") as all_tokensgroup by hash)SELECTblock_time,num_trades,num_tokens,dex_swaps,batch_value,gas_per_trade,CONCAT('<a href="https://etherscan.io/address/', CONCAT('0x', ENCODE(solver_address, 'hex')), '" target="_blank">', solver_name, '</a>') as solver,CONCAT('<a href="https://etherscan.io/tx/', CONCAT('0x', ENCODE(tx_hash, 'hex')), '" target="_blank">', CONCAT('0x', ENCODE(tx_hash, 'hex')), '</a>') as txHash,gas_price_gwei as gas_price,gas_used,tx_cost_usd,fee_value,call_data_size,unwraps,token_approvals,case when tx_cost_usd > 0 then fee_value / tx_cost_usd else null end as coverageFROM gnosis_protocol_v2."batches" bJOIN num_tokens_tradedON hash = tx_hashwhere block_time > now() - interval '1 month'ORDER BY block_time DESC;