Query editor
WITH recent_fills AS (SELECTblock_time,CAST(bytearray_to_uint256(topic1) AS INTEGER) AS product_id,CONCAT('0x', LOWER(SUBSTRING(CAST(topic3 AS VARCHAR), 3, 40))) AS user_address,bytearray_to_int256(bytearray_substring(data, 289, 32)) / 1e18 AS quote_delta,CASEWHEN bytearray_to_uint256(bytearray_substring(data, 193, 32)) = 1 THEN 'taker'ELSE 'maker'END AS trade_typeFROM ink.logsWHERE contract_address = 0x8373C3Aa04153aBc0cfD28901c3c971a946994abAND topic0 = 0xb563bd3722620e7af6c3dae109897ca2f45fbbc5975fb6553bb2d53b77e54bf3AND block_time >= NOW() - INTERVAL '{{Timeframe - days}}' DAY),user_product_volumes AS (SELECTuser_address,product_id,SUM(ABS(quote_delta)) AS volume_365d,SUM(CASE WHEN trade_type = 'maker' THEN ABS(quote_delta) ELSE 0 END) AS maker_volume,SUM(CASE WHEN trade_type = 'taker' THEN ABS(quote_delta) ELSE 0 END) AS taker_volumeFROM recent_fillsGROUP BY user_address, product_id)SELECTuser_address,SUM(ROUND(volume_365d, 2)) AS volume_365d,SUM(ROUND(maker_volume, 2)) AS maker_volume_365d,SUM(ROUND(taker_volume, 2)) AS taker_volume_365d,CASEWHEN SUM(taker_volume) > 0 THEN ROUND(CAST(SUM(maker_volume) AS DOUBLE) / CAST(SUM(taker_volume) AS DOUBLE), 2)ELSE NULLEND AS maker_taker_ratioFROM user_product_volumesWHERE product_id = {{product_id}} OR {{product_id}} = 0GROUP BY user_addressORDER BY volume_365d DESC;