Query editor
SELECT block_time,contract_address,topic0,VARBINARY_LTRIM(topic1) AS token0,VARBINARY_LTRIM(topic2) AS token1,VARBINARY_TO_UINT256(topic3) AS pool_fee,VARBINARY_LTRIM(BYTEARRAY_SUBSTRING(data, 33, 32)) AS pool_address,get_href('https://hyperevmscan.io/tx/' || CAST(tx_hash AS VARCHAR), CAST(tx_hash AS VARCHAR)) AS tx_hash,tx_from,tx_toFROM megaeth.logsWHERE 1=1AND contract_address = 0xf67cF9d6FC433e97Ec39Ae4b7E4451B56B171C8aAND topic0 = 0x783cca1c0412dd0d695e784568c96da2e9c22ff989357a2e8b1d9b2b4e6b7118