Query editor
with relayer_metrics as (selectrelayer,blockchain,currency_symbol,tornado_version,COUNT(*) as total_withdrawals,COUNT(distinct recipient) as unique_recipients,SUM(amount) as total_amount_relayed,SUM(fee) as total_fees_collected,AVG(fee) as avg_fee_per_withdrawal,MIN(block_time) as first_seen_time,MAX(block_time) as last_seen_timefrom (selectrelayer,blockchain,currency_symbol,tornado_version,recipient,amount,fee,block_timefrom tornado_cash.withdrawalsunion allselectrelayer,blockchain,currency_symbol,tornado_version,recipient,amount,fee,block_timefrom tornado_cash_ethereum.withdrawalsunion allselectrelayer,blockchain,currency_symbol,tornado_version,recipient,amount,fee,block_timefrom tornado_cash_bnb.withdrawalsunion allselectrelayer,blockchain,currency_symbol,tornado_version,recipient,amount,fee,block_timefrom tornado_cash_avalanche_c.withdrawalsunion allselectrelayer,