Query editor
WITH inflows AS (SELECT "to" AS wallet, SUM(amount) AS amtFROM tokens.transfersWHERE contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND blockchain = 'ethereum'AND block_date >= CURRENT_DATE - INTERVAL '90' DAYAND "to" != 0x0000000000000000000000000000000000000000GROUP BY 1),outflows AS (SELECT "from" AS wallet, -SUM(amount) AS amtFROM tokens.transfersWHERE contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND blockchain = 'ethereum'AND block_date >= CURRENT_DATE - INTERVAL '90' DAYAND "from" != 0x0000000000000000000000000000000000000000GROUP BY 1),balances AS (SELECT wallet, SUM(amt) AS net_flowFROM (SELECT * FROM inflows UNION ALL SELECT * FROM outflows)GROUP BY walletHAVING ABS(SUM(amt)) > 10)SELECTROW_NUMBER() OVER (ORDER BY net_flow DESC) AS rank,wallet,ROUND(net_flow, 2) AS net_weth_90d,CASE WHEN net_flow > 0 THEN 'Accumulating' ELSE 'Distributing' END AS signalFROM balancesORDER BY net_flow DESCLIMIT 50