Query editor
WITH recent_fills AS (select*,CAST(BYTEARRAY_SUBSTRING(subaccount, 1, 20) AS VARBINARY) AS walletfrom nado_ink.offchainexchange_evt_fillorderwhere evt_block_number <= {{block_number}})SELECTwallet,SUM(ABS(quoteDelta)) as volumeFROM recent_fills-- WHERE wallet = 0x093Fe1E81aDaf1fe56bA7Fa6849A9f5687c00254GROUP BY walletorder by volume desc