Query editor
WITH tt_arb AS (SELECTPositionManager_evt_PaidProtocolFee.*,FROM_HEX(JSON_VALUE(position, 'strict $.soldAsset')) AS token_sell,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS token_buy,'arbitrum' AS networkFROM primex_arbitrum.PositionManager_evt_PaidProtocolFeeLEFT JOIN primex_arbitrum.PositionManager_evt_OpenPositionON primex_arbitrum.PositionManager_evt_OpenPosition.positionId = primex_arbitrum.PositionManager_evt_PaidProtocolFee.positionIdUNIONSELECTBatchManagerV2_evt_PaidProtocolFee.*,FROM_HEX(JSON_VALUE(position, 'strict $.soldAsset')) AS token_sell,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS token_buy,'arbitrum' AS networkFROM primex_arbitrum.BatchManagerV2_evt_PaidProtocolFeeLEFT JOIN primex_arbitrum.PositionManager_evt_OpenPositionON primex_arbitrum.PositionManager_evt_OpenPosition.positionId = primex_arbitrum.BatchManagerV2_evt_PaidProtocolFee.positionId),tt_polygon AS (SELECTprimex_polygon.PositionManager_evt_PaidProtocolFee.*,FROM_HEX(JSON_VALUE(position, 'strict $.soldAsset')) AS token_sell,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS token_buy,'polygon' AS networkFROM primex_polygon.PositionManager_evt_PaidProtocolFeeLEFT JOIN primex_polygon.PositionManager_evt_OpenPositionON primex_polygon.PositionManager_evt_OpenPosition.positionId = primex_polygon.PositionManager_evt_PaidProtocolFee.positionIdUNIONSELECTprimex_polygon.BatchManagerV3_evt_PaidProtocolFee.*,FROM_HEX(JSON_VALUE(position, 'strict $.soldAsset')) AS token_sell,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS token_buy,'polygon' AS networkFROM primex_polygon.BatchManagerV3_evt_PaidProtocolFeeLEFT JOIN primex_polygon.PositionManager_evt_OpenPositionON primex_polygon.PositionManager_evt_OpenPosition.positionId = primex_polygon.BatchManagerV3_evt_PaidProtocolFee.positionId),tt_eth AS (SELECTprimex_ethereum.PositionManager_evt_PaidProtocolFee.*,FROM_HEX(JSON_VALUE(position, 'strict $.soldAsset')) AS token_sell,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS token_buy,'ethereum' AS networkFROM primex_ethereum.PositionManager_evt_PaidProtocolFeeLEFT JOIN primex_ethereum.PositionManager_evt_OpenPositionON primex_ethereum.PositionManager_evt_OpenPosition.positionId = primex_ethereum.PositionManager_evt_PaidProtocolFee.positionIdUNIONSELECTprimex_ethereum.BatchManagerV2_evt_PaidProtocolFee.*,FROM_HEX(JSON_VALUE(position, 'strict $.soldAsset')) AS token_sell,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS token_buy,'ethereum' AS networkFROM primex_ethereum.BatchManagerV2_evt_PaidProtocolFeeLEFT JOIN primex_ethereum.PositionManager_evt_OpenPositionON primex_ethereum.PositionManager_evt_OpenPosition.positionId = primex_ethereum.BatchManagerV2_evt_PaidProtocolFee.positionId),all_networks AS (SELECT*