Skip to main content

Tables

MetaAggregationRouter_Swapped_event

Token swap execution events from KyberSwap’s MetaAggregationRouter contract containing sender address, source and destination token addresses, amounts spent and received, and recipient address. Used for tracking DEX aggregator trade flows and analyzing swap execution efficiency.
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
0x617dee16b86534a5d792a4d7a62fb491b544111efalse0x5b745324fb96f79a5936c36a56d054b3b614c2c2150x095bc617b36ab227a379550633dfdcbf43f236f60x2791bca1f2de4661ed88a30c99a7a9449aa84174326009410x5b745324fb96f79a5936c36a56d054b3b614c2c210000000002022-09-02T14:52:38.000Z13119463761128793699130xd9228f3b86f11992c8cc645da2d26b19683a2096aa852058fb3c20932f2c4458
0x617dee16b86534a5d792a4d7a62fb491b544111efalse0xd5ee5e7b380a61d225da4d0be702dde418f9cdfb580x095bc617b36ab227a379550633dfdcbf43f236f60x2791bca1f2de4661ed88a30c99a7a9449aa84174326002950xd5ee5e7b380a61d225da4d0be702dde418f9cdfb20000000002022-09-02T14:26:10.000Z26910419621414729106170x0191a42c77989827b411f413c63a0faa013f8e707ea4eca3fb481224be3fdb31
0x617dee16b86534a5d792a4d7a62fb491b544111efalse0xd5ee5e7b380a61d225da4d0be702dde418f9cdfb190x095bc617b36ab227a379550633dfdcbf43f236f60x2791bca1f2de4661ed88a30c99a7a9449aa84174326057680xd5ee5e7b380a61d225da4d0be702dde418f9cdfb5000000002022-09-02T17:38:47.000Z7267089517778190361980xa3be48f7098ddcc256f16bc3148564e9d4ea97f58498840ab543f220c07b7da5
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_polygon.MetaAggregationRouter_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0x0c705862f56cd8ec70337f5f5184fea4158a3c00365[“30”]499085199480000000043830146[“0x96c195f6643a3d797cb90cb6ba0ae2776d51b5f3”]16636173316000000000002023-06-12T14:42:17.000Z0xa8d8c61dc22c0de131db76eb687679248da2c206c7350d607b1517ac18505283
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0x2791bca1f2de4661ed88a30c99a7a9449aa84174270[“10”]315043824725[“0xeff33ab0474f593ef9cf7e5baaccda950cdbaae7”]31500002023-06-12T11:10:07.000Z0x732277653cce8edeff879c23f24870cf7143ae12cc2d4ecc0c67340473f47276
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0x2791bca1f2de4661ed88a30c99a7a9449aa84174178[“10”]385243837046[“0xeff33ab0474f593ef9cf7e5baaccda950cdbaae7”]38520002023-06-12T19:12:20.000Z0xfdd76755f513992eb02b184a5d5d11cfcd2f62d93ea6059018f565a354d3de5b
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_polygon.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
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x00000688768803bbd44095770895ad27ad6b0d95750xd6df932a45c0f255f85145f286ea0b292b21c90b0xc2132d05d31c914a87c6611c10748aeb04b58e8f744801020x00000688768803bbd44095770895ad27ad6b0d956050000002025-07-27T16:42:09.000Z20149888373485877650xccb175325db584490cfa8a51b66b4d2add5e9fe630e8a069be0dea41a6ab401e
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x00000688768803bbd44095770895ad27ad6b0d95160xc2132d05d31c914a87c6611c10748aeb04b58e8f0x3c499c542cef5e3811e1192ce70d8cc03d5c3359744705170x00000688768803bbd44095770895ad27ad6b0d952064465712025-07-27T11:01:03.000Z2063505930xc421db7b30d7adaed26499357540493c22b36315b0d575c783f424d99c84db59
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x00e3bca3fe363a41ccec3c1ce507291c46b2b9973260xc2132d05d31c914a87c6611c10748aeb04b58e8f0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee744916740x00e3bca3fe363a41ccec3c1ce507291c46b2b997730000000000000000002025-07-27T23:34:41.000Z174681370x3a034a758d23e6548dd8a5a6a8668e10de92df50c718a2acd3463f92b89876ec
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_polygon.MetaAggregationRouterV2_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100