Query editor
WITH ss (tx_day, evt_block_time, trader, token_sell, token_buy, amount, amount_asset, action) AS (SELECTDATE_TRUNC('day', open_positions.evt_block_time) AS tx_day,evt_block_time,trader,FROM_HEX(JSON_VALUE(position, 'strict $.soldAsset')) AS token_sell,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS token_buy,CAST(JSON_QUERY(position, 'strict $.positionAmount') AS UINT256) AS amount,FROM_HEX(JSON_VALUE(position, 'strict $.positionAsset')) AS amount_asset,'Open' AS actionFROM primex_arbitrum.PositionManager_evt_OpenPosition AS open_positionsUNIONSELECTDATE_TRUNC('day', close_positions.evt_block_time) AS tx_day,evt_block_time,trader,positionAsset AS token_sell,soldAsset AS token_buy,decreasePositionAmount AS amount,positionAsset AS amount_asset,'Close' AS actionFROM primex_arbitrum.PositionManager_evt_ClosePosition AS close_positionsUNIONSELECTDATE_TRUNC('day', swaps.evt_block_time) AS tx_day,evt_block_time,trader,tokenA AS token_sell,tokenB AS token_buy,amountSold AS amount,tokenA AS amount_asset,'Swap' AS actionFROM primex_arbitrum.SwapManager_evt_SpotSwap AS swapsUNIONSELECTDATE_TRUNC('day', swaps.evt_block_time) AS tx_day,evt_block_time,trader,tokenA AS token_sell,tokenB AS token_buy,amountSold AS amount,tokenA AS amount_asset,'Swap' AS actionFROM primex_arbitrum.SwapManagerV2_evt_SpotSwap AS swapsUNIONSELECTDATE_TRUNC('day', batch_close_positions.evt_block_time) AS tx_day,evt_block_time,trader,positionAsset AS token_sell,soldAsset AS token_buy,decreasePositionAmount AS amount,positionAsset AS amount_asset,'BatchClose' AS actionFROM primex_arbitrum.BatchManager_evt_ClosePosition AS batch_close_positionsUNIONSELECTDATE_TRUNC('day', batch_close_positions.evt_block_time) AS tx_day,evt_block_time,trader,