Query editor
WITH parsed_fills AS (SELECTblock_time,block_number,CAST(topic3 AS VARBINARY) AS subaccount,BYTEARRAY_TO_UINT256(topic1) AS product_id,tx_hash,index,topic2 AS digest,CAST(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1, 32)) AS DOUBLE) / 1e18 AS fill_price,CAST(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1 + 32, 32)) AS DOUBLE) / 1e18 AS amount,BYTEARRAY_TO_UINT256(BYTEARRAY_SUBSTRING(data, 1 + 32 * 2, 32)) AS expiration,BYTEARRAY_TO_UINT256(BYTEARRAY_SUBSTRING(data, 1 + 32 * 3, 32)) AS nonce,BYTEARRAY_TO_UINT256(BYTEARRAY_SUBSTRING(data, 1 + 32 * 4, 32)) AS appendix,"RIGHT"(CAST(BYTEARRAY_SUBSTRING(data, 1 + 32 * 5, 32) AS VARCHAR), 1) AS isIsolated,"RIGHT"(CAST(BYTEARRAY_SUBSTRING(data, 1 + 32 * 6, 32) AS VARCHAR), 1) AS isTaker,CAST(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1 + 32 * 7, 32)) AS DOUBLE) / 1e18 AS feeAmount,CAST(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1 + 32 * 8, 32)) AS DOUBLE) / 1e18 AS baseDelta,CAST(BYTEARRAY_TO_INT256(BYTEARRAY_SUBSTRING(data, 1 + 32 * 9, 32)) AS DOUBLE) / 1e18 AS quoteDeltaFROM ink.logsWHERE contract_address = 0x8373C3Aa04153aBc0cfD28901c3c971a946994abAND topic0 = 0xb563bd3722620e7af6c3dae109897ca2f45fbbc5975fb6553bb2d53b77e54bf3)SELECT * FROM parsed_fills limit 100