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[“25”]7147825000000000020328751[“0x39041f1b366fe33f9a5a79de5120f2aee2577ebc”]285913000000000000002025-04-15T06:15:19.000Z0x3d12171671865f87c6eb8804f628c43f3c85d404528e4fc3c816df1ccf90c40d
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0[“25”]250000000000000020324502[“0x39041f1b366fe33f9a5a79de5120f2aee2577ebc”]10000000000000000002025-04-15T05:40:59.000Z0x424131b095e59d0ae9c8ae7203abb1454ed0bc6e6e7b11075ba9330f2b1357dd
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0[“25”]250000000000000000020361452[“0x39041f1b366fe33f9a5a79de5120f2aee2577ebc”]10000000000000000000002025-04-15T10:55:32.000Z0x883325ce1db605058f470d50ee2631d6c7eb288c414d0328904302cf370b1c68
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_sonic.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
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x726513925fe3423f73fa3b563572dcc78a6fdcb91030x9fb76f7ce5fceaa2c42887ff441d46095e4942060x29219dd400f2bf60e5a23d13be72b486d4038894495943030x000000e28faa823d5b53ff6c2922c28335840375180000000002025-10-07T04:21:14.000Z178641534250x8a038ed514c242f0376fb72351b69efdbbf7a37a1980bfb3bf28cf30d5f39d8f
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x726513925fe3423f73fa3b563572dcc78a6fdcb9900x9fb76f7ce5fceaa2c42887ff441d46095e4942060x29219dd400f2bf60e5a23d13be72b486d4038894495948450x000000e28faa823d5b53ff6c2922c2833584037528000000002025-10-07T04:27:07.000Z27583851510x27fa148facaa545ad7d57a59445925c44a4db968ea05893c2b93a6400f88d68a
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x726513925fe3423f73fa3b563572dcc78a6fdcb9320x9fb76f7ce5fceaa2c42887ff441d46095e4942060x29219dd400f2bf60e5a23d13be72b486d4038894496408160x000000e28faa823d5b53ff6c2922c2833584037530000000202025-10-07T12:30:15.000Z29517545920x92e74cde01f9acb56de3f6c679b85b33159b57d53e4645f2b899f1c64e81cc4c
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_sonic.MetaAggregationRouterV2_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100