Skip to main content

​
Tables

​
MetaAggregationRouterV2_Fee_event

Fee collection events from Kyber Network’s MetaAggregationRouterV2 contract. Records token addresses, fee amounts in basis points (BPS) or absolute values, recipient addresses, and total swap amounts for protocol fee tracking across DEX aggregation transactions.
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_tokenSTRINGToken address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_totalAmountSTRINGTotal amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
in_totalFeeSTRINGTotal fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
in_recipientsARRAY<STRING>Array of recipient addresses for fee distribution. Hex-encoded, 0x-prefixed, 42-character strings.
in_amountsARRAY<STRING>Array of token amounts involved in the operation. String-encoded integers representing amounts in the token’s smallest unit (e.g., wei for ETH).
in_isBpsBOOLBoolean flag indicating whether fee amounts are denominated in basis points (BPS) rather than absolute token units.
addressremovedin_isBpsin_tokenlog_indexin_amountsin_totalFeeblock_numberin_recipientsin_totalAmountblock_timestamptransaction_hash
0x3f95ef3f2eaca871858dbe20a93c01daf6c2e923falsetrue0x3355df6d4c9c3035724fd0e3914de96a5a83aaf49[“20”]200006621773[“0x8d61d7fe817efc69a2169f0d5f39b41ed5c89409”]100000002023-06-21T11:12:03.000Z0xab7b46c792566a3b6e760fc11cfee05a099e039bd8cf295d31455cf35065a8f5
0x3f95ef3f2eaca871858dbe20a93c01daf6c2e923falsetrue0x2039bb4116b4efc145ec4f0e2ea75012d6c0f18117[“20”]712820000000000017280582[“0x8d61d7fe817efc69a2169f0d5f39b41ed5c89409”]35641000000000000002023-10-25T13:48:59.000Z0xab53a0ac950e2f31848b5768d7d8cbcfb2ee5fc356feef8e539aad88db8393a2
0x3f95ef3f2eaca871858dbe20a93c01daf6c2e923falsetrue0x2039bb4116b4efc145ec4f0e2ea75012d6c0f18153[“20”]234032000000000017271363[“0x8d61d7fe817efc69a2169f0d5f39b41ed5c89409”]11701600000000000002023-10-25T11:08:14.000Z0x0def9df43b198bf3a115d43b0377e0ba25175d9993ebd3e980e9fc49bd1089c4
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_zksyncera.MetaAggregationRouterV2_Fee_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
MetaAggregationRouterV2_Swapped_event

Swap execution events emitted by KyberSwap’s MetaAggregationRouterV2 contract containing source token, destination token, input amount, output amount, sender, and receiver addresses. Used for tracking DEX aggregator trade flows and price execution analytics.
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_senderSTRINGAddress that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_srcTokenSTRINGContract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
in_dstTokenSTRINGContract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_dstReceiverSTRINGAddress that receives the destination tokens from the swap. Hex-encoded, 0x-prefixed, 42-character string.
in_spentAmountSTRINGActual amount of source tokens spent in the swap. Numeric string representation of token quantity in smallest denomination.
in_returnAmountSTRINGActual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.
addressremovedin_senderlog_indexin_dstTokenin_srcTokenblock_numberin_dstReceiverin_spentAmountblock_timestampin_returnAmounttransaction_hash
0x3f95ef3f2eaca871858dbe20a93c01daf6c2e923false0x53e3487a9821678159c3a13b370771b2354860e1200x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d420xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee202330920x53e3487a9821678159c3a13b370771b2354860e15620852245115302023-11-29T15:17:11.000Z30219891939253439110x8368aab2d7a5b1bcc7de4cb18ebf3ede28197545e8d600268d1e64906ed9e54b
0x3f95ef3f2eaca871858dbe20a93c01daf6c2e923false0xdf3e4da3ee75f1018d277222967ce3d69f3271d9190x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d420x5aea5775959fbc2557cc8789bc1bf90a239d9a91202515180xdf3e4da3ee75f1018d277222967ce3d69f3271d9162296685816484052023-11-29T20:30:47.000Z867908074118624527390x23b11549769a939ac117b80453af23cee73f0ac0746316d317163fc0e0c74c68
0x3f95ef3f2eaca871858dbe20a93c01daf6c2e923false0xd07ce88fe0d7ee421e9d484e4ddbb497c2e2236f220x0e97c7a0f8b2c9885c8ac9fc6136e829cbc21d420x5aea5775959fbc2557cc8789bc1bf90a239d9a91202449420xd07ce88fe0d7ee421e9d484e4ddbb497c2e2236f881100000000000002023-11-29T18:37:27.000Z4708757364134069770820x2376da03aebe38279e1a79c1ffe84dd881559d4ca34b9ea48e810093345e62f8
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_zksyncera.MetaAggregationRouterV2_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100