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
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x49ec04f2cfd2ac7a18a39f871e1bdd474a4d1487324193664490xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x111111111117dc0aa78b770fa6a738034120c3022022-07-08T08:55:06.000Z0x078245a7df10454219f98ac45a8393f6355d6d8e023c8d2c27437e24a0887fed34466944802661317419{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x49ec04f2cfd2ac7a18a39f871e1bdd474a4d1487”,“swapType”:1,“protocolFee”:{“share”:“5000000000000000”,“beneficiary”:“0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54”},“callerCallData”:“0x000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a0000000000000000000000000111111111117dc0aa78b770fa6a738034120c30200000000000000000000000000000000000000000000000000000000000005287c02520000000000000000000000000005ad60d9a2f1aa30ba0cdbaf1e0a0a145fbea16f00000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee000000000000000000000000111111111117dc0aa78b770fa6a738034120c30200000000000000000000000005ad60d9a2f1aa30ba0cdbaf1e0a0a145fbea16f000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f000000000000000000000000000000000000000000000000016345785d8a0000000000000000000000000000000000000000000000000001de501fff29966a45000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000038000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000003000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000000200000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000000000000000000000000000016345785d8a000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000004d0e30db0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000064d1660f99000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000095783044c406715164d452d87fb5c54557bbef2000000000000000000000000000000000000000000000000016345785d8a00000000000000000000000000000000000000000000000000000000000080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed6000000000000000000000000095783044c406715164d452d87fb5c54557bbef2000000000000000000000000bb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c000000000000000000000000111111111117dc0aa78b770fa6a738034120c3020000000000000000001e84801111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}172334724013306587100000000000000000100000000000000000342946100786480126360
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x2a812626c2838dccb53fde027fd4d6fc3f6d7ce720193826580x8ac76a51cc950d9822d68b83fe1ad97b32cd580d0x1af3f329e8be154074d8769d1ffa4ee058b1dbc32022-07-08T22:26:27.000Z0x3b05a291e3e782a17b20d3f1aa01164e0ac40ab77b1c597d543019522fc32ede139839075871805366867{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x2a812626c2838dccb53fde027fd4d6fc3f6d7ce7”,“swapType”:1,“protocolFee”:{“share”:“0”,“beneficiary”:“0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54”},“callerCallData”:“0x0000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff000000000000000000000000def1c0ded9bec7f1a1670819833240f027b25eff00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc30000000000000000000000000000000000000000000000000000000000000148c43c9ef6000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000796e3ea3f8ab00000000000000000000000000000000000000000000000000007832d8b57f77b1618000000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000030000000000000000000000008ac76a51cc950d9822d68b83fe1ad97b32cd580d000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc3869584cd0000000000000000000000007cba0eb7a94068324583be7771c5ecda25e4c4d10000000000000000000000000000000000000000000000efc1b6b18262c8af04000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}01400000000000000000001400000000000000000001384406851130873190800
0xd7f1dd5d49206349cae8b585fcb0ce3d96f1696ffalse0x022fe87e83f3d6662862ed51ef74de33ed16ff2577193827400xe9e7cea3dedca5984780bafc599bd69add087d560x1af3f329e8be154074d8769d1ffa4ee058b1dbc32022-07-08T22:30:33.000Z0xe954506430d203701276c29c26a53e78d64b31263c49d022abaa5cf78aa86e834973633219481922471{“caller”:“0xc629bf86f02ef13e8f1f5f75ade8a8165587998f”,“account”:“0x022fe87e83f3d6662862ed51ef74de33ed16ff25”,“swapType”:1,“protocolFee”:{“share”:“5000000000000000”,“beneficiary”:“0x4a183b7ed67b9e14b3f45abfb2cf44ed22c29e54”},“callerCallData”:“0x000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d0000000000000000000000001111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000a00000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc300000000000000000000000000000000000000000000000000000000000003487c02520000000000000000000000000005ad60d9a2f1aa30ba0cdbaf1e0a0a145fbea16f00000000000000000000000000000000000000000000000000000000000000600000000000000000000000000000000000000000000000000000000000000180000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc300000000000000000000000066fdb2eccfb58cf098eaa419e5efde841368e489000000000000000000000000d7f1dd5d49206349cae8b585fcb0ce3d96f1696f0000000000000000000000000000000000000000000000004563918244f4000000000000000000000000000000000000000000000000000044aca96bf5c9514a00000000000000000000000000000000000000000000000000000000000000040000000000000000000000000000000000000000000000000000000000000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001a000000000000000000000000000000000000000000000000000000000000000400000000000000000000000000000000000000000000000000000000000000001000000000000000000000000000000000000000000000000000000000000002080000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006000000000000000000000000000000000000000000000000000000000000000a4b757fed600000000000000000000000066fdb2eccfb58cf098eaa419e5efde841368e489000000000000000000000000e9e7cea3dedca5984780bafc599bd69add087d560000000000000000000000001af3f329e8be154074d8769d1ffa4ee058b1dbc30000000000000000002625a01111111254fb6c44bac0bed2854e76f90643097d00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000051d40aca000000000000000000000000000000000000000000000000”,“marketplaceFee”:{“share”:“0”,“beneficiary”:“0x0000000000000000000000000000000000000000”}}248681660974096125000000000000000000500000000000000000049238968872871034880
Query with partition filter
SELECT *
FROM `tt-contracts.zerion_v1_bsc.Router_Executed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100