Query editor
WITH flows AS (SELECT "to" AS wallet, block_date, amount AS net_inFROM tokens.transfersWHERE contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND blockchain = 'ethereum'AND block_date >= CURRENT_DATE - INTERVAL '90' DAYAND "to" != 0x0000000000000000000000000000000000000000UNION ALLSELECT "from" AS wallet, block_date, -amount AS net_inFROM tokens.transfersWHERE contract_address = 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2AND blockchain = 'ethereum'AND block_date >= CURRENT_DATE - INTERVAL '90' DAYAND "from" != 0x0000000000000000000000000000000000000000)SELECTwallet,ROUND(SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '7' DAY THEN net_in ELSE 0 END), 2) AS net_7d,ROUND(SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' DAY THEN net_in ELSE 0 END), 2) AS net_30d,ROUND(SUM(net_in), 2) AS net_90d,CASEWHEN SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' DAY THEN net_in ELSE 0 END) > 0AND SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '7' DAY THEN net_in ELSE 0 END) > 0THEN 'Strong Accumulating'WHEN SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '30' DAY THEN net_in ELSE 0 END) > 0THEN 'Accumulating'WHEN SUM(CASE WHEN block_date >= CURRENT_DATE - INTERVAL '7' DAY THEN net_in ELSE 0 END) > 0THEN 'Recovering'ELSE 'Distributing'END AS signalFROM flowsGROUP BY walletHAVING ABS(SUM(net_in)) > 10ORDER BY net_30d DESCLIMIT 50