Query editor
WITH cex_addrs AS (SELECT addressFROM cex.addressesWHERE cex_name IN ('Binance','Coinbase','Kraken','Kucoin','OKX'/*...常见交易所列表*/))SELECTdate_trunc('day', block_time) AS day,-- 总流入:所有to在交易所地址列表的交易SUM(CASE WHEN "to" IN (SELECT address FROM cex_addrs)THEN value/1e18 ELSE 0 END) AS eth_in_exchange,-- 总流出:所有from在交易所地址列表的交易SUM(CASE WHEN "from" IN (SELECT address FROM cex_addrs)THEN value/1e18 ELSE 0 END) AS eth_out_exchange,-- 净流入(正表示流入为主,负表示流出为主)SUM(CASEWHEN "to" IN (SELECT address FROM cex_addrs) THEN value/1e18WHEN "from" IN (SELECT address FROM cex_addrs) THEN -value/1e18ELSE 0END) AS net_flowFROM ethereum.transactionsGROUP BY 1ORDER BY 1;