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
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0x176211869ca2b568f2a7d4ee941e073a821ee1ff27[“30”]363461479241[“0xde6b4964c4384bcdfa150a4a8be9865c5b91e29c”]121154302024-01-02T08:50:08.000Z0x1aecec9d70f79100847ef07e5aa7b4a62e7f7d833cc35485959f5638fef423f5
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0x176211869ca2b568f2a7d4ee941e073a821ee1ff18[“75”]1137551481562[“0x777bcc85d91ece0c641a6f03f35a2a98f4049777”]151673502024-01-02T12:42:14.000Z0xc1be26c9eb377e5645775c9014e1c7416a502dd235839f298bfe682a09f02862
0x6131b5fae19ea4f9d964eac0408e4408b66337b5falsetrue0x176211869ca2b568f2a7d4ee941e073a821ee1ff19[“5”]50001482171[“0x008f84b4f7b625636dd3e75045704b077d8db445”]100000002024-01-02T13:43:08.000Z0xacf8a75c0800396404267e3b38fbd942df0b6baf58798934ff8a948289805411
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_linea.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
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x30fdb4debefc1f57fe2eeefcb2fe8e09cf013d69410xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x0018d96c579121a94307249d47f053e2d687b5e781880530x30fdb4debefc1f57fe2eeefcb2fe8e09cf013d69229339819513500491102024-08-16T03:58:16.000Z65236637551228090xd0ffd7b919aaeea8adf48e907806eccca8989d751bfce728f068608701413578
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x30fdb4debefc1f57fe2eeefcb2fe8e09cf013d69140xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee0x0018d96c579121a94307249d47f053e2d687b5e781878840x30fdb4debefc1f57fe2eeefcb2fe8e09cf013d69425200000000000000002024-08-16T03:52:38.000Z122488950262621580x59d9c144d0a71b0ac565a2c6a85c79f6ac16d855c546766a601fb39a8e2062ce
0x6131b5fae19ea4f9d964eac0408e4408b66337b5false0x368cb4212abd097f35efcd34e291b6ee1d60e622210x176211869ca2b568f2a7d4ee941e073a821ee1ff0x0018d96c579121a94307249d47f053e2d687b5e781817000x368cb4212abd097f35efcd34e291b6ee1d60e6223000000000000000000002024-08-16T00:26:28.000Z2261616690x41e44bc548fed74bbce8db1e0206fb4701084add148d30582ea9f48722ebb20b
Query with partition filter
SELECT *
FROM `tt-contracts.kyber_v1_linea.MetaAggregationRouterV2_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100