Skip to main content

​
Tables

​
Router_Executed_event

Token swap execution event emitted by the Zerion Router contract. Records swap parameters including input/output tokens, amounts exchanged, protocol and marketplace fees charged, and swap routing details via callerCallData.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_inputTokenSTRINGContract address of the token being deposited or transferred. Hex-encoded, 0x-prefixed, 42-character string.
in_absoluteInputAmountSTRINGAmount of input tokens specified for the swap operation. String-encoded integer representing the quantity in the smallest denomination of the input token.
in_inputBalanceChangeSTRINGActual change in the sender’s input token balance for the swap operation. String-encoded integer representing the quantity in the smallest denomination of the input token.
in_outputTokenSTRINGContract address of the token to be received on the destination chain. Hex-encoded, 0x-prefixed, 42-character string.
in_absoluteOutputAmountSTRINGAmount of output tokens expected from the swap operation before fees are deducted. String-encoded integer representing the quantity in the smallest denomination of the output token.
in_returnedAmountSTRINGAmount of tokens returned to the user after completing the swap or settlement operation. String-encoded integer representing the quantity in the smallest denomination of the output token.
in_protocolFeeAmountSTRINGAmount of fees collected by the protocol from the transaction. String-encoded integer representing the fee in the smallest denomination of the token.
in_marketplaceFeeAmountSTRINGAmount of fees collected by a marketplace partner or third-party integrator from the swap transaction. String-encoded integer representing the fee in the smallest denomination of the token.
in_swapDescriptionSTRUCT<swapType INT64, protocolFee STRUCT<share STRING, beneficiary STRING>, marketplaceFee STRUCT<share STRING, beneficiary STRING>, account STRING, caller STRING, callerCallData STRING>Structured data describing the swap operation parameters and fee configuration. Contains swap type identifier, protocol and marketplace fee structures with beneficiary addresses, user account address, caller contract address, and hex-encoded calldata for the swap execution.
in_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
addressremovedin_senderlog_indexblock_numberin_inputTokenin_outputTokenblock_timestamptransaction_hashin_returnedAmountin_swapDescriptionin_protocolFeeAmountin_inputBalanceChangein_absoluteInputAmountin_absoluteOutputAmountin_marketplaceFeeAmount
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x83e91a9c91d14f6b6e670cf7b33cb540cc90e51831036682080xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x7f5c764cbc14f9669b88837ca1490cca17c316072023-06-01T21:30:28.000Z0xca2d2c162fb15f6aa34438b4acc7557aa642bc65e698d957175f90ac53e9f91f18717769{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x83e91a9c91d14f6b6e670cf7b33cb540cc90e518”,“swapType”:1,“protocolFee”:{“share”:“0”,“beneficiary”:“0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7”},“callerCallData”:“0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000000000000000244f021092900000000000000000000000000000000000000000000000000000000000000200000000000000000000000003b87eed5a8f40b81ebd8a01ac1891f04cb59fd660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000083e91a9c91d14f6b6e670cf7b33cb540cc90e51800000000000000000000000000000000000000000000000000000000000000000000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c31607000000000000000000000000000000000000000000000000002386f26fc10000000000000000000000000000000000000000000000000000002386f26fc1000000000000000000000000000000000000000000000000000000000000011d9c490000000000000000000000000000000000000000000000000000000064790e1b0000000000000000000000000000000000000000000000000000018878de80540167616e64616c6674686562726f776e67786d786e6900191a779854242b000000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000041bdb1a1d95855151e6c7fd119b3a27bb73b15be8d1c03db370522162a5f6bb31b66a85263f81def8c419a37f38d1b67b4b9ee2ce986f079d8ce7720a3fd6c21101c0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}01000000000000000010000000000000000187177690
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x69155e7ca2e688ccdc247f6c4ddf374b3ae77bd631035660950xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x7f5c764cbc14f9669b88837ca1490cca17c316072023-06-01T12:44:20.000Z0x816d8f3fd82d7e7a4ab9fe7c3bd8446c4af0654de1f00b5fcaedc3f521ce784b37208674{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x69155e7ca2e688ccdc247f6c4ddf374b3ae77bd6”,“swapType”:1,“protocolFee”:{“share”:“0”,“beneficiary”:“0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7”},“callerCallData”:“0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000000000000000244f021092900000000000000000000000000000000000000000000000000000000000000200000000000000000000000003b87eed5a8f40b81ebd8a01ac1891f04cb59fd660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000069155e7ca2e688ccdc247f6c4ddf374b3ae77bd600000000000000000000000000000000000000000000000000000000000000000000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c3160700000000000000000000000000000000000000000000000000470de4df82000000000000000000000000000000000000000000000000000000470de4df820000000000000000000000000000000000000000000000000000000000000237c26200000000000000000000000000000000000000000000000000000000647892b70000000000000000000000000000000000000000000000000000018876fc7f3e0167616e64616c6674686562726f776e67786d786e6900191895973e2d5b000000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000000418f9cd76b5833e6e79de644d944f4df5555900394bfcb264a21b2fdddd50fefc01005424d589c5d580b76d89083170d0cd2fed0167eb24ab957f865b0e35ad6df1b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}02000000000000000020000000000000000372086740
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x21d90e6f18f3848d9e45f34bdb4dfdde3fa09d1a31035445910xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x7f5c764cbc14f9669b88837ca1490cca17c316072023-06-01T11:06:33.000Z0xe7ca3e9d4a3b64e53a738a98462e43f9cd3e636e0738b3ddd4fdee1ef822315f46490855{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x21d90e6f18f3848d9e45f34bdb4dfdde3fa09d1a”,“swapType”:1,“protocolFee”:{“share”:“0”,“beneficiary”:“0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7”},“callerCallData”:“0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc000000000000000000000000b3999f658c0391d94a37f7ff328f3fec942bcadc00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000000000000000244f021092900000000000000000000000000000000000000000000000000000000000000200000000000000000000000003b87eed5a8f40b81ebd8a01ac1891f04cb59fd660000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f00000000000000000000000021d90e6f18f3848d9e45f34bdb4dfdde3fa09d1a00000000000000000000000000000000000000000000000000000000000000000000000000000000000000007f5c764cbc14f9669b88837ca1490cca17c316070000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000058d15e176280000000000000000000000000000000000000000000000000000000000002c564e70000000000000000000000000000000000000000000000000000000064787be20000000000000000000000000000000000000000000000000000018876a350040167616e64616c6674686562726f776e67786d786e690019183c68042d5b000000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000000410fbbca3db75cbcde4fd59a1d7ca3e3b7b3a457fbb2e3d224620c35c8607d5319102420f6cdfa93f67465b6ee5f569d2e874414f93784bbc5079f0b5b800953031b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}02500000000000000025000000000000000464908550
Query with partition filter
SELECT *
FROM `tt-contracts.zerion_v1_optimism.Router_Executed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100