Query editor
WITH symbols AS (SELECTCAST(json_extract_scalar(s, '$.product_id') AS bigint) AS product_id,json_extract_scalar(s, '$.symbol') AS symbol,json_extract_scalar(s, '$.type') AS product_typeFROM UNNEST(CAST(json_parse(http_get('https://gateway.prod.nado.xyz/v1/symbols')) AS array(json))) AS t(s)),labels (wallet, client) AS (VALUES(0x5494c260fd71799414d174aa802750efa2dca5dd, 'Selini'),(0x974c217250e69bbad9b975d3ed49f377e5bdb276, 'Selini'),(0xef3bca9ec5fdbae77c4486e58cbb86432dcff457, 'Selini'),(0x4e4b2d5e4eed07b80b31033783e65f5c4b6a7272, 'E4'),(0x8ff3360dd72945eaceb6feb4d9dcba9bd33f56ec, 'Deep Capital'),(0x1c574bf92ae7c274efcf5395c9eee275c0c2b1d1, 'Auros'),(0xee126d63237e0773507488df1a969fdaa656df18, 'GSR'),(0x80abe6aae21ec051cd434f264e12828b607cec13, 'IMC'),(0x6d16e0e0a1b9f5fa14c3047da73012f41033ac39, 'Ampersan'),(0xc78fd6ae0324b3a87dc41e11b235d2ccb4afeba0, 'Ampersan'),(0xf79ac4339acb5fc523e022df99b17b3ecb9a3b8b, 'Luminous Labs'),(0x53cae1682e41ae0990f73832e0a9c049688f8e00, 'Luminous Labs'),(0xe61c7421f64587c75b85c63d748ac4088ef1ba41, 'HMB Trading'),(0xd41d2ae1dab4a1307894f7337dcb8c3b4f850581, 'HMB Trading'),(0x43e9df16f2e8ec1de38d46aeb03c0769a718f815, 'HMB Trading'),(0x2a52884ffef4dcc55cf1e406797c0a514b7e835d, 'HMB Trading'),(0x1e59e34ab49da197b3494b91f4f84db65e4439bb, 'HMB Trading'),(0x9130c0396614ae493ec0294b57a6eefb52e2be20, 'HMB Trading'),(0x2dc5ee1b8ac10b2c02ecbd86fe8a9cf8e059568d, 'HMB Trading')),fills AS (SELECTformat_datetime(date_trunc('month', l.block_time), 'YYYY-MM') AS month,CAST(varbinary_to_uint256(l.topic1) AS bigint) AS product_id,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.product_id, f.is_taker, f.notional_usd,CASE WHEN f.subaccount = 0x0000000000000000000000000000000000000000000000000000000100000000 THEN 'NLP vault (Kappa)' ELSE lb.client END AS clientFROM fills f LEFT JOIN labels lb ON lb.wallet = f.wallet),venue AS (SELECT month, product_id,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_usdFROM fills GROUP BY 1, 2),by_client AS (SELECT month, product_id, client,sum(CASE WHEN NOT is_taker THEN notional_usd ELSE 0 END) AS maker_usd,sum(CASE WHEN is_taker THEN notional_usd ELSE 0 END) AS taker_usd,