Query editor
WITH wallet_flows AS (SELECT"from" AS wallet,-SUM(amount_usd) AS net_change_usdFROM tokens.transfersWHERE contract_address = {{token_address}}AND blockchain = '{{blockchain}}'AND block_date >= CURRENT_DATE - INTERVAL '{{lookback_days}}' DAYGROUP BY "from"UNION ALLSELECT"to" AS wallet,SUM(amount_usd) AS net_change_usdFROM tokens.transfersWHERE contract_address = {{token_address}}AND blockchain = '{{blockchain}}'AND block_date >= CURRENT_DATE - INTERVAL '{{lookback_days}}' DAYGROUP BY "to"),net_positions AS (SELECTwallet,SUM(net_change_usd) AS net_accumulated_usdFROM wallet_flowsGROUP BY wallet)SELECTnp.wallet,np.net_accumulated_usdFROM net_positions npWHERE np.net_accumulated_usd > 0AND NOT EXISTS (SELECT 1FROM labels.addresses lWHERE l.address = np.walletAND l.blockchain = '{{blockchain}}')ORDER BY np.net_accumulated_usd DESCLIMIT 50