Query editor
WITH tt (tx_day, evt_block_time, token_sell, token_buy, amount_usd, fee_usd, action) AS (SELECTtx_day,evt_block_time,token_sell,token_buy,amount / pow(10, amount_prices.decimals) * amount_prices.price,CASE WHEN fee_asset = 0x99ec76235f8a5A52611b0DA5F0C6B09e1dCD2C9eTHEN fee_amount / pow(10, 18) * fee_prices.priceELSE 0END,actionFROM query_3705001 AS trades_with_feesLEFT JOIN prices.usd AS amount_pricesONamount_prices.contract_address = trades_with_fees.amount_assetAND amount_prices.blockchain = 'arbitrum'AND amount_prices.minute = DATE_TRUNC('minute', trades_with_fees.evt_block_time)LEFT JOIN prices.usd AS fee_pricesONfee_prices.symbol = 'ETH'AND fee_prices.blockchain IS NULLAND fee_prices.minute = DATE_TRUNC('minute', trades_with_fees.evt_block_time)),ss (tx_day, evt_block_time, token_address, amount_usd, fee_usd, action) AS (SELECTtx_day,evt_block_time,token_sell,amount_usd,fee_usd,actionFROM ttUNIONSELECTtx_day,evt_block_time,token_buy,amount_usd,fee_usd,actionFROM tt),with_events (tx_day, evt_block_time, token_address, amount_usd, fee_usd, action) AS (SELECT * FROM ssUNIONSELECTDATE_TRUNC('day', evt_block_time) AS tx_day,evt_block_time,token_sell,0 AS amount_usd,fee_usd,'PaidFee' AS actionFROM query_4111104 AS paid_feeWHERE network = 'arbitrum'UNIONSELECTDATE_TRUNC('day', evt_block_time) AS tx_day,evt_block_time,token_buy,