Query editor
WITHmode_evt_transfer AS (SELECT l.tx_to AS to, l.tx_from AS "from", bytearray_to_uint256(bytearray_substring(data, 1, 32)) AS valueFROM mode.logs lWHERE contract_address = 0x1217BfE6c773EEC6cc4A38b5Dc45B92292B6E189AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef),balance_updates AS (SELECT"to" AS user,value / 1e6 AS deltaFROM mode_evt_transferUNION ALLSELECT"from" AS user,- value / 1e6 AS deltaFROM mode_evt_transfer),holders AS (SELECTuser,SUM(delta) AS balanceFROM balance_updatesWHERE user <> 0x0000000000000000000000000000000000000000AND user IN (SELECT recipientFROM dune.l3.result_explore_the_superchain_with_open_usdt_quest_data)GROUP BY user)SELECTuser,balance,COUNT(*) OVER (ORDER BY balance DESC) AS rolling_countFROM holdersWHERE balance > 0ORDER BY 3 DESC