Query editor
with txns_table as (selectdepositor as "address",amount as "deposit_amount",0 as "withdrawal_amount",block_time as "block_time",blockchain as "blockchain",currency_symbol as "currency_symbol",tx_hash as "tx_hash"from tornado_cash.depositsUNION ALLselectrecipient as "address",0 as "deposit_amount",amount as "withdrawal_amount",block_time as "block_time",blockchain as "blockchain",currency_symbol as "currency_symbol",tx_hash as "tx_hash"from tornado_cash.withdrawals)selectdistinct tdeps.address,CASEWHEN array_agg( distinct "currency_symbol" ) = array['BNB'] THEN concat( cast('<a href="https://bscscan.com/address/' as varchar), cast(tdeps.address as varchar), cast('" target="_blank">🔗</a> ' as varchar), cast(tdeps.address as varchar) )WHEN array_agg( distinct "currency_symbol" ) = array['AVAX'] THEN concat( cast('<a href="https://snowtrace.io/address/' as varchar), cast(tdeps.address as varchar), cast('" target="_blank">🔗</a> ' as varchar), cast(tdeps.address as varchar) )ELSE concat( cast('<a href="https://etherscan.io/address/' as varchar), cast(tdeps.address as varchar), cast('" target="_blank">🔗</a> ' as varchar), cast(tdeps.address as varchar) )END AS "address_link",count(distinct tx_hash) as "tx_count",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'ETH') as "amount_eth",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'BNB') as "amount_bnb",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'AVAX') as "amount_avax",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'xDAI') as "amount_xdai",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'MATIC') as "amount_matic",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'WBTC') as "amount_wbtc",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'DAI') as "amount_dai",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'USDT') as "amount_usdt",sum(deposit_amount) FILTER (WHERE "currency_symbol" = 'USDC') as "amount_usdc",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'ETH') as "w_amount_eth",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'BNB') as "w_amount_bnb",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'AVAX') as "w_amount_avax",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'xDAI') as "w_amount_xdai",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'MATIC') as "w_amount_matic",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'WBTC') as "w_amount_wbtc",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'DAI') as "w_amount_dai",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'USDT') as "w_amount_usdt",sum(withdrawal_amount) FILTER (WHERE "currency_symbol" = 'USDC') as "w_amount_usdc",array_agg( distinct "currency_symbol" ) as "currency_symbols",array_agg( distinct tdeps."blockchain" ) as "blockchains",