Query editor
WITH cex_wallets AS (SELECTaddress,CASEWHEN LOWER(cex_name) LIKE '%okx%' OR LOWER(cex_name) LIKE '%okex%' THEN 'OKX'WHEN LOWER(cex_name) LIKE '%binance%' THEN 'Binance'WHEN LOWER(cex_name) LIKE '%bybit%' THEN 'Bybit'END AS exchangeFROM cex.addressesWHERE blockchain = 'ethereum'AND (LOWER(cex_name) LIKE '%okx%'OR LOWER(cex_name) LIKE '%okex%'OR LOWER(cex_name) LIKE '%binance%'OR LOWER(cex_name) LIKE '%bybit%')GROUP BY 1, 2),big_stables AS (SELECTblock_time,symbol,"from" AS sender,"to" AS receiver,amount_usd,tx_hashFROM tokens.transfersWHERE blockchain = 'ethereum'AND block_date >= CURRENT_DATE - INTERVAL '7' DAYAND contract_address IN (0xdac17f958d2ee523a2206206994597c13d831ec7, -- USDT0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 -- USDC)AND amount_usd >= 5000000)SELECTs.block_time AS time_utc,COALESCE(r.exchange, f.exchange) AS exchange,CASEWHEN r.exchange IS NOT NULL AND f.exchange IS NULL THEN 'Deposit (Inflow)'ELSE 'Withdrawal (Outflow)'END AS direction,s.symbol,ROUND(s.amount_usd / 1e6, 2) AS amount_m_usd,'<a href="https://etherscan.io/tx/' || CAST(s.tx_hash AS VARCHAR) || '" target="_blank">View Tx</a>' AS tx_linkFROM big_stables sLEFT JOIN cex_wallets r ON s.receiver = r.addressLEFT JOIN cex_wallets f ON s.sender = f.addressWHERE (r.exchange IS NOT NULL AND f.exchange IS NULL)OR (f.exchange IS NOT NULL AND r.exchange IS NULL)ORDER BY s.block_time DESCLIMIT 50