Query editor
WITH recent_fills AS (SELECTevt_block_time AS block_time,productId AS product_id,CONCAT('0x', LOWER(SUBSTRING(CAST(subaccount AS VARCHAR), 3, 40))) AS user_address,quoteDelta / 1e18 AS quote_delta,feeAmount / 1e18 AS fee,CASEWHEN isTaker = True THEN 'taker'ELSE 'maker'END AS trade_typeFROM nado_ink.offchainexchange_evt_fillorderWHERE evt_block_time >= NOW() - INTERVAL '30' DAY),user_product_volumes AS (SELECTuser_address,product_id,SUM(ABS(quote_delta)) AS volume_30d,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_volume,SUM(CASE WHEN trade_type = 'maker' THEN fee ELSE 0 END) AS maker_fee,SUM(CASE WHEN trade_type = 'taker' THEN fee ELSE 0 END) AS taker_feeFROM recent_fillsGROUP BY user_address, product_id)SELECTuser_address,SUM(ROUND(volume_30d, 2)) AS volume_30d,SUM(ROUND(maker_volume, 2)) AS maker_volume_30d,SUM(ROUND(taker_volume, 2)) AS taker_volume_30d,SUM(ROUND(taker_fee, 2)) AS taker_fee_30d,SUM(ROUND(maker_fee, 2)) AS maker_fee_30d,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_30d DESC;