Query editor
WITH hmb (wallet) AS (VALUES (0xe61c7421f64587c75b85c63d748ac4088ef1ba41),(0xd41d2ae1dab4a1307894f7337dcb8c3b4f850581),(0x43e9df16f2e8ec1de38d46aeb03c0769a718f815),(0x2a52884ffef4dcc55cf1e406797c0a514b7e835d),(0x1e59e34ab49da197b3494b91f4f84db65e4439bb),(0x9130c0396614ae493ec0294b57a6eefb52e2be20),(0x2dc5ee1b8ac10b2c02ecbd86fe8a9cf8e059568d)),fills AS (SELECT format_datetime(date_trunc('month', l.block_time), 'YYYY-MM') AS month,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-08-01' AND l.block_date < DATE '2026-11-01')SELECT month,count(DISTINCT CASE WHEN is_taker THEN wallet END) AS taker_wallets,count(DISTINCT CASE WHEN NOT is_taker THEN wallet END) AS maker_wallets,count(DISTINCT CASE WHEN is_taker AND wallet NOT IN (SELECT wallet FROM hmb) AND subaccount <> 0x0000000000000000000000000000000000000000000000000000000100000000 THEN wallet END) AS taker_wallets_ex_hmb_vault,sum(CASE WHEN is_taker THEN notional_usd ELSE 0 END) AS venue_taker_usd,sum(CASE WHEN is_taker AND wallet IN (SELECT wallet FROM hmb) THEN notional_usd ELSE 0 END) AS hmb_taker_usd,sum(CASE WHEN is_taker AND subaccount = 0x0000000000000000000000000000000000000000000000000000000100000000 THEN notional_usd ELSE 0 END) AS vault_taker_usd,count(DISTINCT CASE WHEN is_taker AND notional_usd >= 1000 THEN wallet END) AS taker_wallets_1k_plusFROM fills GROUP BY 1 ORDER BY 1