Query editor
-- Nado: DMM monthly maker / taker volume, Jun 1 2026 to yesterday (UTC)-- v2 of query 8761026. Adds Ampersan (2 wallets), Luminous Labs (2 wallets),-- the NLP vault (matched on its full subaccount id) and HMB Trading (7 wallets, reference only).WITH labels (wallet, client, entity_type) AS (VALUES(0x5494c260fd71799414d174aa802750efa2dca5dd, 'Selini', 'DMM'),(0x974c217250e69bbad9b975d3ed49f377e5bdb276, 'Selini', 'DMM'),(0xef3bca9ec5fdbae77c4486e58cbb86432dcff457, 'Selini', 'DMM'),(0x4e4b2d5e4eed07b80b31033783e65f5c4b6a7272, 'E4', 'DMM'),(0x8ff3360dd72945eaceb6feb4d9dcba9bd33f56ec, 'Deep Capital', 'DMM'),(0x1c574bf92ae7c274efcf5395c9eee275c0c2b1d1, 'Auros', 'DMM'),(0xee126d63237e0773507488df1a969fdaa656df18, 'GSR', 'DMM'),(0x80abe6aae21ec051cd434f264e12828b607cec13, 'IMC', 'DMM'),(0x6d16e0e0a1b9f5fa14c3047da73012f41033ac39, 'Ampersan', 'DMM'),(0xc78fd6ae0324b3a87dc41e11b235d2ccb4afeba0, 'Ampersan', 'DMM'),(0xf79ac4339acb5fc523e022df99b17b3ecb9a3b8b, 'Luminous Labs', 'DMM'),(0x53cae1682e41ae0990f73832e0a9c049688f8e00, 'Luminous Labs', 'DMM'),(0xe61c7421f64587c75b85c63d748ac4088ef1ba41, 'HMB Trading', 'Reference'),(0xd41d2ae1dab4a1307894f7337dcb8c3b4f850581, 'HMB Trading', 'Reference'),(0x43e9df16f2e8ec1de38d46aeb03c0769a718f815, 'HMB Trading', 'Reference'),(0x2a52884ffef4dcc55cf1e406797c0a514b7e835d, 'HMB Trading', 'Reference'),(0x1e59e34ab49da197b3494b91f4f84db65e4439bb, 'HMB Trading', 'Reference'),(0x9130c0396614ae493ec0294b57a6eefb52e2be20, 'HMB Trading', 'Reference'),(0x2dc5ee1b8ac10b2c02ecbd86fe8a9cf8e059568d, 'HMB Trading', 'Reference')),fills AS (SELECTdate_trunc('month', l.block_time) AS month,date_trunc('day', l.block_time) AS day,l.topic3 AS subaccount,varbinary_substring(l.topic3, 1, 20) AS wallet,varbinary_substring(l.data, 1 + 32*6, 32)<> 0x0000000000000000000000000000000000000000000000000000000000000000 AS is_taker,abs(cast(varbinary_to_int256(varbinary_substring(l.data, 1 + 32*9, 32)) AS double)+ cast(varbinary_to_int256(varbinary_substring(l.data, 1 + 32*7, 32)) AS double)) / 1e18 AS notional_usdFROM ink.logs lWHERE l.contract_address = 0x8373c3aa04153abc0cfd28901c3c971a946994abAND l.topic0 = 0xb563bd3722620e7af6c3dae109897ca2f45fbbc5975fb6553bb2d53b77e54bf3AND l.block_date >= DATE '2026-06-01'AND l.block_time >= TIMESTAMP '2026-06-01 00:00:00'AND l.block_time < date_trunc('day', now())),tagged AS (SELECT f.month, f.is_taker, f.notional_usd,CASE WHEN f.subaccount = 0x0000000000000000000000000000000000000000000000000000000100000000THEN 'NLP vault (Kappa)' ELSE lb.client END AS clientFROM fills fLEFT JOIN labels lb ON lb.wallet = f.wallet),venue AS (SELECT month,sum(CASE WHEN NOT is_taker THEN notional_usd ELSE 0 END) AS venue_maker_usd,sum(CASE WHEN is_taker THEN notional_usd ELSE 0 END) AS venue_taker_usd,count(DISTINCT day) AS days_coveredFROM fills GROUP BY 1),clients (client, entity_type) AS (SELECT DISTINCT client, entity_type FROM labels