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
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x6bec9d1d1a3762769575f96d52c1484da04f30c476295045960xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x078f358208685046a11c85e8ad32895ded33a2492023-05-02T15:41:28.000Z0xd22f9207d4b52815c5170710e10b56837744fae33e83da1cbf2ce0b5f7b1080f601545{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x6bec9d1d1a3762769575f96d52c1484da04f30c4”,“swapType”:1,“protocolFee”:{“share”:“0”,“beneficiary”:“0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7”},“callerCallData”:“0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000078f358208685046a11c85e8ad32895ded33a24900000000000000000000000000000000000000000000000000000000000004087c025200000000000000000000000000f01ef4051130cc8871fa0c17024a6d62e379e85600000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000078f358208685046a11c85e8ad32895ded33a249000000000000000000000000f01ef4051130cc8871fa0c17024a6d62e379e856000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000008d8dadf544fc00000000000000000000000000000000000000000000000000000000000000092355000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000025b00000000000000000000000000000000000000000000021d0001ef00018f00a007e5c0d200000000000000000000000000000000000000016b0000bb00006800001a4041b31f66aa3c1e785363f0875a1b74e27b85fd66c7d0e30db048202939df25c6818c5b5bbd35a3f29daccc52e81b34b31f66aa3c1e785363f0875a1b74e27b85fd66c7bd6015b40000000000000000000000009d86243ae7008ec1f9cce83c49d76f7a557b80cf00206ae4071118002dc6c09d86243ae7008ec1f9cce83c49d76f7a557b80cf0000000000000000000000000000000000000000000000000000000000091794b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e5120794a61358d6845594f94dc1db02a252b5b4814ad50b7545627a5162f82a992c33b87adc75187b2180024617ba03700000000000000000000000050b7545627a5162f82a992c33b87adc75187b2180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f01ef4051130cc8871fa0c17024a6d62e379e856000000000000000000000000000000000000000000000000000000000000044d00a0cd211e1e078f358208685046a11c85e8ad32895ded33a2490000000000000000000000000000000000000000000000000000000000092f17000000000000000000000000000000027fffd26d332c71daa06bb24dded5c3c167961e9eb99480a06c4eca27078f358208685046a11c85e8ad32895ded33a2491111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000000000000000000000000000008d8dadf544fc0000000000000051d40aca000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}010200000000000000000102000000000000000005988690
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0xdaf45073a54cf4afc3122bf39d26e9620192f1b49294918410xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e2023-05-02T08:31:11.000Z0xb6f1384e3bde497392b5ba4c8dfad3ef1d12426c266f0a7082784a4598bc2e40437190596{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0xdaf45073a54cf4afc3122bf39d26e9620192f1b4”,“swapType”:1,“protocolFee”:{“share”:“0”,“beneficiary”:“0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7”},“callerCallData”:“0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0000000000000000000000000000000000000000000000000000000000000244f0210929000000000000000000000000000000000000000000000000000000000000002000000000000000000000000039ded1e84463bc9791f5042ee93bc1eaa9cc42cc0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f000000000000000000000000daf45073a54cf4afc3122bf39d26e9620192f1b40000000000000000000000000000000000000000000000000000000000000000000000000000000000000000b97ef9ef8734c71904d8002f8b6bc66dd9c48a6e0000000000000000000000000000000000000000000000016b99192fbb3c00000000000000000000000000000000000000000000000000016b99192fbb3c0000000000000000000000000000000000000000000000000000000000001a0effc4000000000000000000000000000000000000000000000000000000006450ca6f00000000000000000000000000000000000000000000000000000187db9627790167616e64616c6674686562726f776e67786d786e6900187d2f3f783c15000000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000041f9d56ddee3c30a91fad74b8834f5cfeb539c81b76a3e72ac996498df63304507644a99e59953965ca7d154200cdc9468ade24f46bb56b7b0f937900f63eff2d11b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}026200000000000000000262000000000000000004371905960
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x022832b3dcc169d66a6409354bfca7cd7796c68f24294799270xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0xc7198437980c041c805a1edcba50c1ce5db951182023-05-02T01:46:09.000Z0x162653a3e8586d8facbf11b8dee9f1df206828413eae9fea2df785112e65f50c82963373{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x022832b3dcc169d66a6409354bfca7cd7796c68f”,“swapType”:1,“protocolFee”:{“share”:“0”,“beneficiary”:“0x7d20ab6d8af50d87a5e8def46e48f4d7dc2ea5c7”},“callerCallData”:“0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000064d2f9f44fe26c157d552ae7eaa613ca6587b59e00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000c7198437980c041c805a1edcba50c1ce5db951180000000000000000000000000000000000000000000000000000000000000244f02109290000000000000000000000000000000000000000000000000000000000000020000000000000000000000000cf19a556abfc75c1e4bc9d84fa3374046d3ea4f00000000000000000000000002008b6c3d07b061a84f790c035c2f6dc11a0be70000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f000000000000000000000000022832b3dcc169d66a6409354bfca7cd7796c68f0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000c7198437980c041c805a1edcba50c1ce5db951180000000000000000000000000000000000000000000000004563918244f400000000000000000000000000000000000000000000000000004563918244f400000000000000000000000000000000000000000000000000000000000004f1ebad0000000000000000000000000000000000000000000000000000000064506b6500000000000000000000000000000000000000000000000000000187da2337630167616e64616c6674686562726f776e67786d786e6900187bbc4f637dc8000000000000000000000000000000000000000000000000000000000000000001a00000000000000000000000000000000000000000000000000000000000000041d0037108eb9d3f6339a1145309bfd37e78cd6cf4618347086a943e8335ca314d4b84e8bfb95a7fb4ee53eb9a0d14d63b935fd6a94670ee1af02f77c0e3457da81b0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}050000000000000000005000000000000000000829633730
Query with partition filter
SELECT *
FROM `tt-contracts.zerion_v1_avalanche.Router_Executed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100