Query editor
SELECTcurrency_symbol,SUM(fee) AS total_fee, -- Fees are generally associated with withdrawalsCOUNT(tx_hash) AS total_transaction_countFROM(-- Select withdrawals with their feesSELECT currency_symbol, fee, tx_hash FROM tornado_cash.withdrawalsUNION ALLSELECT currency_symbol, fee, tx_hash FROM tornado_cash_ethereum.withdrawals -- [cite: 138]UNION ALLSELECT currency_symbol, fee, tx_hash FROM tornado_cash_bnb.withdrawals -- [cite: 139]UNION ALLSELECT currency_symbol, fee, tx_hash FROM tornado_cash_avalanche_c.withdrawals -- [cite: 139]UNION ALLSELECT currency_symbol, fee, tx_hash FROM tornado_cash_polygon.withdrawals -- [cite: 139]UNION ALLSELECT currency_symbol, fee, tx_hash FROM tornado_cash_optimism.withdrawals -- [cite: 140]UNION ALLSELECT currency_symbol, fee, tx_hash FROM tornado_cash_gnosis.withdrawals -- [cite: 140]UNION ALLSELECT currency_symbol, fee, tx_hash FROM tornado_cash_arbitrum.withdrawals -- [cite: 141]UNION ALL-- Select deposits, assigning 0 as fee, as protocol fees are usually on withdrawal sideSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash.deposits -- [cite: 141]UNION ALLSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash_ethereum.deposits -- [cite: 141]UNION ALLSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash_bnb.deposits -- [cite: 142]UNION ALLSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash_avalanche_c.deposits -- [cite: 142]UNION ALLSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash_polygon.deposits -- [cite: 143]UNION ALLSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash_optimism.deposits -- [cite: 143]UNION ALLSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash_gnosis.deposits -- [cite: 143]UNION ALLSELECT currency_symbol, 0 AS fee, tx_hash FROM tornado_cash_arbitrum.deposits -- [cite: 144]) AS combined_transactionsGROUP BYcurrency_symbolORDER BY -- Added ORDER BY for better readabilitytotal_fee DESC, total_transaction_count DESC;