On-Chain Analysis

SELECT
  address,
  eth_balance,
  tx_count,
  last_active
FROM ethereum.balances
WHERE eth_balance > 1000
ORDER BY eth_balance DESC
LIMIT 100;

SELECT
  exchange_name,
  SUM(value_usd) as total_inflow,
  COUNT(*) as tx_count
FROM token_transfers
WHERE to_address IN (SELECT address FROM exchanges)
  AND block_time > NOW() - INTERVAL '24 hours'
GROUP BY exchange_name
ORDER BY total_inflow DESC;

SELECT
  address,
  SUM(CASE WHEN is_buy THEN amount ELSE -amount END) as net_change,
  COUNT(*) as trades
FROM trades
WHERE token = '0x...'
  AND block_time > NOW() - INTERVAL '7 days'
GROUP BY address
HAVING SUM(CASE WHEN is_buy THEN amount ELSE -amount END) > 10000
ORDER BY net_change DESC;

SELECT
  address,
  total_pnl,
  win_rate,
  avg_hold_time,
  trade_count
FROM wallet_pnl
WHERE trade_count > 50
  AND win_rate > 0.6
ORDER BY total_pnl DESC
LIMIT 50;