Query editor
WITH trades_data AS (-- 导入你的 CSV 数据SELECTid,pairSymbol,fromToken,toToken,fromTokenSymbol,toTokenSymbol,amountUSD,inputAmountWei,CAST(okx_hash AS VARCHAR) as okx_hash,CAST(cow_hash AS VARCHAR) as cow_hash,-- 处理 ETH 地址兼容性CASEWHEN toToken = 0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeTHEN 0x0000000000000000000000000000000000000000ELSE toTokenEND as toToken_normalizedFROM dune.okxweb3wallet.dataset_dex_trades_compare_high_value),okx_tx_info AS (SELECTt.id,t.okx_hash,tx.block_number,tx.block_time,tx.gas_used,tx.gas_price,(tx.gas_used * tx.gas_price / 1e18) as gas_cost_eth,(tx.gas_used * tx.gas_price / 1e18) * p.price as gas_cost_usdFROM trades_data tLEFT JOIN ethereum.transactions txON tx.hash = from_hex(CASEWHEN substring(t.okx_hash, 1, 2) = '0x'THEN substring(t.okx_hash, 3)ELSE t.okx_hashEND)LEFT JOIN prices.usd pON p.blockchain = 'ethereum'AND p.symbol = 'ETH'AND date_trunc('minute', p.minute) = date_trunc('minute', tx.block_time)WHERE t.okx_hash IS NOT NULLAND length(t.okx_hash) > 2),cow_tx_info AS (SELECTt.id,t.cow_hash,tx.block_number,tx.block_time,tx.gas_used,tx.gas_price,(tx.gas_used * tx.gas_price / 1e18) as gas_cost_eth,(tx.gas_used * tx.gas_price / 1e18) * p.price as gas_cost_usdFROM trades_data tLEFT JOIN ethereum.transactions txON tx.hash = from_hex(CASE