kyber_v1_arbitrum

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	0x5ee0f1bbb3f69c4350bccc2f32f3b19dca0a3cbb	19	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x0d8dbacccf13e9101838c701f2715320e145688f	24828126	0x5ee0f1bbb3f69c4350bccc2f32f3b19dca0a3cbb	153678085626520225	2022-09-16T02:23:41.000Z	8595936092785080	0xb55c6434c22d73c82c46d5df289b4d3e66202af1ff9bccedb194b36a0dd6c49e
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0xef5f928ccd3cdbbd04addd0e87cac2ef48e69468	15	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	24831965	0xef5f928ccd3cdbbd04addd0e87cac2ef48e69468	3719	2022-09-16T03:09:43.000Z	501695576503882	0xaa6c3aee815c302213b299cddd44e39115787effbcdb995cbd184bbfbf92b4a5
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0xd3f85ade70adf48ed17c8cb182b8b1aff542e51f	19	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	0x3f56e0c36d275367b8c502090edf38289b3dea0d	24885397	0xd3f85ade70adf48ed17c8cb182b8b1aff542e51f	2300000000000000000000	2022-09-16T13:39:37.000Z	2299780138	0xcefdeca548983ebe9d91077587df63ba85c1c349f0334abcc0074df9a01bf7a7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_arbitrum.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	22	[“50”]	70843632324012	119175744	[“0x720c9244473dfc596547c1f7b6261c7112a3dad4”]	14168726464802523	2023-08-07T22:00:22.000Z	0x32b2fc2725247fea8e4912036b6f23a5c21401b0ef556407326b280053803259
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	1	[“20”]	140371540000000000	119121628	[“0x8d61d7fe817efc69a2169f0d5f39b41ed5c89409”]	70185770000000000000	2023-08-07T17:59:01.000Z	0xe82d71c0548ff82940906bec196a6b0669f3de4e4cd8d7b4cbe6c1e45133cd41
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0	[“20”]	32460000000000	119075528	[“0x8d61d7fe817efc69a2169f0d5f39b41ed5c89409”]	16230000000000000	2023-08-07T14:41:46.000Z	0x383c651237c46e5314fe7a11e632b5d26ed473314e5fa8f65cf8ca1ce545720b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_arbitrum.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	0x07314f7ae386a4596bfcdbff0b95241d40e9fd37	78	0xf763fa322dc58dee588252fafee5f448e863b633	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	60895215	0x07314f7ae386a4596bfcdbff0b95241d40e9fd37	200000000	2023-02-14T15:46:06.000Z	2496545907873	0xa065e53bc2f11efc05841deaee5677d5fbda9ac49757d642734538bad103c9fa
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x07314f7ae386a4596bfcdbff0b95241d40e9fd37	29	0xf763fa322dc58dee588252fafee5f448e863b633	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	60814607	0x07314f7ae386a4596bfcdbff0b95241d40e9fd37	500000000	2023-02-14T09:55:05.000Z	6107286026881	0xd90e3e261e97f76e0e7f18f0926aa386bfcebf5b0dca1c1b1756a730b21cfd5e
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x098dee2f74df806d73002790eea003d77a48ebea	42	0xa02763eb59d9f79782464f83369d77d22a5b0eaa	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	60762819	0x098dee2f74df806d73002790eea003d77a48ebea	199400000	2023-02-14T06:02:44.000Z	13541856774723010	0x4f263d25d333ef5678f94bad8220a0443c14e398b8d0ba89a3cd72d7659c9f16

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

MetaAggregationRouter_Swapped_event

MetaAggregationRouterV2_Fee_event

MetaAggregationRouterV2_Swapped_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​MetaAggregationRouter_Swapped_event

​MetaAggregationRouterV2_Fee_event

​MetaAggregationRouterV2_Swapped_event

Tables

MetaAggregationRouter_Swapped_event

MetaAggregationRouterV2_Fee_event

MetaAggregationRouterV2_Swapped_event