Query editor
SELECTchain,SUM(size) AS total_volume,SUM(IF(position_side = 'LONG', size, 0)) AS long_volume,SUM(IF(position_side = 'SHORT', size, 0)) AS short_volume,SUM(fee) AS total_fees,ROUND(AVG(leverage), 0) AS avg_leverageFROM(SELECT'Arbitrum' AS chain,IF(`isLong`, 'LONG', 'SHORT') AS position_side,sizeDelta / 1e30 AS size,fee / 1e30 as fee,sizeDelta / collateralDelta AS leverageFROM gmx_arbitrum.Vault_evt_IncreasePositionWHERE account = '0x4e182b2176992f5fa6a178bdee1d1160396974fe'UNION ALLSELECT'Arbitrum' AS chain,IF(`isLong`, 'LONG', 'SHORT') AS position_side,sizeDelta / 1e30 as size,fee / 1e30 as fee,sizeDelta / collateralDelta AS leverageFROM gmx_arbitrum.Vault_evt_DecreasePositionWHERE account = '0x4e182b2176992f5fa6a178bdee1d1160396974fe')GROUP BY chain