Query editor
WITH cex_addresses AS (SELECTREGEXP_REPLACE(name, ' [0-9]+.*$', '') AS base_name,addressFROM labels.cex_ethereumWHERE address IS NOT NULLAND REGEXP_REPLACE(name, ' [0-9]+.*$', '') IN ('Bitstamp', 'Bitpanda', 'Luno', 'SwissBorg', 'Mercuryo','Wirex', 'CoinDCX', 'Revolut', 'CEX.IO', 'B2BinPay')GROUP BY 1, 2),token_balances AS (SELECTaddress,token_symbol,SUM(balance) AS total_balanceFROM tokens_ethereum.balancesWHEREtoken_address = 0xdac17f958d2ee523a2206206994597c13d831ec7 -- USDT token addressAND DATE(block_time) = CURRENT_DATEGROUP BY address, token_symbol),exchange_balances AS (SELECTca.base_name AS "Exchange Name",tb.token_symbol AS "Token Symbol",SUM(tb.total_balance) AS "Total USDT Balance"FROM token_balances tbLEFT JOIN cex_addresses caON tb.address = ca.addressWHERE ca.base_name IS NOT NULLGROUP BY ca.base_name, tb.token_symbol)SELECT *FROM exchange_balancesWHERE "Total USDT Balance" > 10000000 -- Restrict to balances above 10MORDER BY "Total USDT Balance" DESC;