Query editor
WITH params AS (SELECT0 AS min_btc_per_tx,3 AS lookback_hours,100 AS result_limit,500.0 AS whale_min,100.0 AS large_trader_min,10.0 AS significant_flow_threshold),tx_inputs AS (SELECTi.address,SUM(i.value / 1e8) AS total_sold_btc,COUNT(DISTINCT i.tx_id) AS sell_tx_countFROM bitcoin.inputs iCROSS JOIN params pWHERE i.block_time >= NOW() - INTERVAL '1' hour * p.lookback_hoursAND i.is_coinbase = FALSEAND i.address IS NOT NULLAND i.value >= p.min_btc_per_tx * 1e8GROUP BY i.address),tx_outputs AS (SELECTo.address,SUM(o.value / 1e8) AS total_bought_btc,COUNT(DISTINCT o.tx_id) AS buy_tx_countFROM bitcoin.outputs oCROSS JOIN params pWHERE o.block_time >= NOW() - INTERVAL '1' hour * p.lookback_hoursAND o.address IS NOT NULLAND o.value >= p.min_btc_per_tx * 1e8GROUP BY o.address),address_flows AS (SELECTCOALESCE(i.address, o.address) AS wallet_address,-- 核心资金指标ROUND(COALESCE(o.total_bought_btc, 0), 4) AS total_inflow, -- 总流入ROUND(COALESCE(i.total_sold_btc, 0), 4) AS total_outflow, -- 总流出ROUND(COALESCE(o.total_bought_btc, 0) - COALESCE(i.total_sold_btc, 0), 4) AS net_inflow, -- 净流入额(可正可负)ABS(COALESCE(o.total_bought_btc, 0) - COALESCE(i.total_sold_btc, 0)) AS net_inflow_abs, -- 净流入额绝对值-- 方向标记CASEWHEN (COALESCE(o.total_bought_btc,0) - COALESCE(i.total_sold_btc,0)) > 0 THEN '🟢 净流入'WHEN (COALESCE(o.total_bought_btc,0) - COALESCE(i.total_sold_btc,0)) < 0 THEN '🔴 净流出'ELSE '⚪ 平衡'END AS flow_direction,-- 交易者规模CASEWHEN (COALESCE(o.total_bought_btc,0) + COALESCE(i.total_sold_btc,0)) >= p.whale_minTHEN '🐋 巨鲸'WHEN (COALESCE(o.total_bought_btc,0) + COALESCE(i.total_sold_btc,0)) >= p.large_trader_minTHEN '🦈 大额交易者'ELSE '🐟 普通大户'END AS address_category,