kyber_v1_bsc

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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstReceiver`	`STRING`	Address that receives the destination tokens from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_spentAmount`	`STRING`	Actual amount of source tokens spent in the swap. Numeric string representation of token quantity in smallest denomination.
`in_returnAmount`	`STRING`	Actual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_dstToken	in_srcToken	block_number	in_dstReceiver	in_spentAmount	block_timestamp	in_returnAmount	transaction_hash
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0x005a97c7a3b3ff0e10d2debf38d0daa9a605782c	173	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x88d7e9b65dc24cf54f5edef929225fc3e1580c25	24425691	0x005a97c7a3b3ff0e10d2debf38d0daa9a605782c	669784493174214900	2023-01-02T02:59:04.000Z	6396310144660656	0x7d5792837e121c34a4e2f68cabd8af684e7063fd31f4ff1d65fbe99f5de2c68d
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0x03ffdb95d3ee7f7b796069867e55cf6fdb65472c	86	0x3ee2200efb3400fabb9aacf31297cbdd1d435d47	0x55d398326f99059ff775485246999027b3197955	24446230	0x03ffdb95d3ee7f7b796069867e55cf6fdb65472c	50000000000000000000	2023-01-02T20:19:30.000Z	196079840258931049759	0xe64f32aeb2aab508ee7655e559a46403c048ec22cd9019eaa72c780127aa7674
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0x03ffdb95d3ee7f7b796069867e55cf6fdb65472c	167	0x3ee2200efb3400fabb9aacf31297cbdd1d435d47	0x55d398326f99059ff775485246999027b3197955	24446077	0x03ffdb95d3ee7f7b796069867e55cf6fdb65472c	100000000008546153281	2023-01-02T20:11:51.000Z	392601435843754237782	0xbafbb4747a22e20841528896583be1513bdfc05876d75bd6e0d37cb2cd3d6155

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_bsc.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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_token`	`STRING`	Token address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_totalAmount`	`STRING`	Total amount involved in the transaction or operation. String-encoded integer representing the amount in the token’s smallest unit.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_recipients`	`ARRAY<STRING>`	Array of recipient addresses for fee distribution. Hex-encoded, 0x-prefixed, 42-character strings.
`in_amounts`	`ARRAY<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_isBps`	`BOOL`	Boolean flag indicating whether fee amounts are denominated in basis points (BPS) rather than absolute token units.

Sample Data

address	removed	in_isBps	in_token	log_index	in_amounts	in_totalFee	block_number	in_recipients	in_totalAmount	block_timestamp	transaction_hash
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	258	[“100”]	1144782800000000	25892277	[“0x1009289d12d2a8b19289de49f952559063c0e8ee”]	114478280000000000	2023-02-22T16:22:03.000Z	0x5e8cb72f573c7fd7bf6ac88ef0ce638e3a9eb0c5a604cae257bc2810dadaaca7
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0x55d398326f99059ff775485246999027b3197955	226	[“100”]	334786260125623983	25892312	[“0x1009289d12d2a8b19289de49f952559063c0e8ee”]	33478626012562398312	2023-02-22T16:23:48.000Z	0xc8e8da5401a9823b0271b708be94a0a96568ce47f0716599547ddd4722d1aa61
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0x392645c0224ce11167a710d7e1484da2daf299b6	139	[“50”]	85299454	25894279	[“0x720c9244473dfc596547c1f7b6261c7112a3dad4”]	17059890849	2023-02-22T18:02:47.000Z	0x70fe1f5e38286598099c1f5a3a30aa239d01936bce6e8f370c61dbc343e76a83

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_bsc.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.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_sender`	`STRING`	Address that initiated the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_srcToken`	`STRING`	Contract address of the source token being swapped. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstToken`	`STRING`	Contract address of the destination token being received from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_dstReceiver`	`STRING`	Address that receives the destination tokens from the swap. Hex-encoded, 0x-prefixed, 42-character string.
`in_spentAmount`	`STRING`	Actual amount of source tokens spent in the swap. Numeric string representation of token quantity in smallest denomination.
`in_returnAmount`	`STRING`	Actual amount of destination tokens received from the swap. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_sender	log_index	in_dstToken	in_srcToken	block_number	in_dstReceiver	in_spentAmount	block_timestamp	in_returnAmount	transaction_hash
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x05608b9b9987fd56403ac049451021e89bba9db8	125	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	0x55d398326f99059ff775485246999027b3197955	25626761	0x05608b9b9987fd56403ac049451021e89bba9db8	100000000000000000000	2023-02-13T08:25:24.000Z	332242921350796737	0x1d40fb503d2c54769aa4367ee17dee5827a28f5326a55d70e5c788413b2248fb
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x06b634432825fc80ec78c5fa4aa85007ec3bf3b8	198	0xc9457161320210d22f0d0d5fc1309acb383d4609	0x55d398326f99059ff775485246999027b3197955	25644488	0x06b634432825fc80ec78c5fa4aa85007ec3bf3b8	549877387077440753735	2023-02-13T23:17:07.000Z	52718958949578885221322	0xe09c690c819d4fe23db7f201ddec97b8a501ecd0c7942c38584e2b6162f62c4b
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x0c7e83e258bbd8893362e836060b12b132840ad6	318	0x3203c9e46ca618c8c1ce5dc67e7e9d75f5da2377	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	25638185	0x0c7e83e258bbd8893362e836060b12b132840ad6	1342000000000000000	2023-02-13T18:00:20.000Z	803882474747735945262	0x8dd8a0bbc1d9c6ebb8c56f2e5d9382292aa466e336b40118c75f8d5e30d3ae5c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_bsc.MetaAggregationRouterV2_Swapped_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

MetaAggregationRouter_Swapped_event

MetaAggregationRouterV2_Fee_event

MetaAggregationRouterV2_Swapped_event

​Tables

​MetaAggregationRouter_Swapped_event

​MetaAggregationRouterV2_Fee_event

​MetaAggregationRouterV2_Swapped_event

Tables

MetaAggregationRouter_Swapped_event

MetaAggregationRouterV2_Fee_event

MetaAggregationRouterV2_Swapped_event