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
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0[“70”]9800000000000015957653[“0x27b9c20f64920eb7fbf64491423a54df9594188c”]140000000000000002024-06-18T09:57:33.000Z0x5aa3414afaa1e0d0763cb317f1325d3b2b4eb5df64c575242f4e3003cb690954
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0[“70”]1400000000000000015969854[“0x27b9c20f64920eb7fbf64491423a54df9594188c”]20000000000000000002024-06-18T16:44:15.000Z0x77b62e34a992a170dac2e97012f95efe1fb27078fe8d3efddc11f5f9e1d2af71
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0[“70”]168000000000000015979775[“0x27b9c20f64920eb7fbf64491423a54df9594188c”]2400000000000000002024-06-18T22:14:57.000Z0x22a8ac711e25786a9ec9c52ed474ba788358092e4a25445cdc44700148fe6b49
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_base.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
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x2aaaa9b71e479e6e2de7e091b09d61c25d2aaaa96850x833589fcd6edb6e08f4c7c32d4f71b54bda029130x000000000000012def132e61759048be5b5c6033315376620x2aaaa9b71e479e6e2de7e091b09d61c25d2aaaa92000000000000000000002025-06-14T01:31:11.000Z48887400x13e801ac93b9f2e88546748ad914cd4d9669d9544f0ff8ab62c86822b306d256
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x0a2854fbbd9b3ef66f17d47284e7f899b95093301380xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x000096630066820566162c94874a776532705231315597330x0a2854fbbd9b3ef66f17d47284e7f899b950933027311738267675313936002025-06-14T13:46:53.000Z47507520579549030xfd08ef4e6c39829e063950e6ecb2a35f18eb8570a4f148dc9531c11ce31438d0
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x0a2854fbbd9b3ef66f17d47284e7f899b95093302780x833589fcd6edb6e08f4c7c32d4f71b54bda029130x00309d634d11541b857f927be91ad2f0bd78894c315736050x0a2854fbbd9b3ef66f17d47284e7f899b9509330170000000000000000000002025-06-14T21:29:17.000Z1036920380x21c6602d887999fc718c2903a5e866f4d4a1f2828c68df009cede7826356fc18
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_base.MetaAggregationRouterV2_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100