Query editor
WITH token0 AS (SELECT contract_address AS token0,tx_hashFROM hyperevm.logsWHERE 1=1AND tx_hash = 0xbae74521cbbc309572be0605a342f3e1165363160f4a660a8b916cf7f8fa5639AND index = 0ORDER BY block_time),token1 AS (SELECT contract_address AS token1,tx_hashFROM hyperevm.logsWHERE 1=1AND tx_hash = 0xbae74521cbbc309572be0605a342f3e1165363160f4a660a8b916cf7f8fa5639AND index = 1ORDER BY block_time),tx_info AS (SELECT 'SWAPPED WHYPE to USDC' AS action,VARBINARY_LTRIM(l.topic1) AS sender,VARBINARY_LTRIM(l.topic2) AS reciever,t0.token0 AS token0,(VARBINARY_TO_INT256(BYTEARRAY_SUBSTRING(l.data, 1, 32))/1e18) AS t0_sent,t1.token1 AS token1,(VARBINARY_TO_INT256(BYTEARRAY_SUBSTRING(l.data, 33, 32))/1e6) AS t1_recievedFROM hyperevm.logs lLEFT JOIN token0 t0 ON l.tx_hash = t0.tx_hashLEFT JOIN token1 t1 ON l.tx_hash = t1.tx_hashWHERE 1=1AND l.tx_hash = 0xbae74521cbbc309572be0605a342f3e1165363160f4a660a8b916cf7f8fa5639AND l.topic0 = 0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67ORDER BY l.block_time)SELECT action,sender,reciever,token0,t0.name || ' / ' || t0.symbol AS t0_info,t0_sent,token1,t1.name || ' / ' || t1.symbol AS t1_info,t1_recievedFROM tx_info txLEFT JOIN tokens.erc20 t0 ON tx.token0 = t0.contract_address AND t0.blockchain = 'hyperevm'LEFT JOIN tokens.erc20 t1 ON tx.token1 = t1.contract_address AND t1.blockchain = 'hyperevm'