kyber_v1_avalanche

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	0xb5c7e650c274e93855c8a8b2486d7530203a0017	23	0x0da67235dd5787d67955420c84ca1cecd4e5bb3b	0x130966628846bfd36ff31a822705796e8cb8c18d	20546251	0xb5c7e650c274e93855c8a8b2486d7530203a0017	1911252350930685296183	2022-10-02T09:28:08.000Z	69634015200396744	0x6fb1b9952b0b0e33c687b86157158955843156b0a564ad920da56d764a150e1d
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0xab97544118197a133b74ad5751f0bff5c4a1d744	13	0x0da67235dd5787d67955420c84ca1cecd4e5bb3b	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	20565806	0xab97544118197a133b74ad5751f0bff5c4a1d744	2000000000000000000	2022-10-02T20:41:48.000Z	1238528336249229	0xcaa59368d6a0a75d04b3c38a5605253acbbe061a2c77e8b46acb52412b3cb176
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0x0a068302f104977af7e24ea9eccfc434e8014a97	19	0x0da67235dd5787d67955420c84ca1cecd4e5bb3b	0x63682bdc5f875e9bf69e201550658492c9763f89	20554296	0x0a068302f104977af7e24ea9eccfc434e8014a97	12297449099564598139321	2022-10-02T14:05:11.000Z	674907951327801	0x0c65776deddd892d60192f26b9bf1f60ca777e5c109e68e893dbd3149d995222

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_avalanche.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	27	[“30”]	2400377605838200	25692290	[“0x96c195f6643a3d797cb90cb6ba0ae2776d51b5f3”]	800125868612733616	2023-02-01T11:54:33.000Z	0xf7ab6ab1cb7ec335d1cb9febbc5bb2d59da72288c56bb47cbdf786cc2d2d0bfc
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0	[“30”]	11250000000000000	25693631	[“0x96c195f6643a3d797cb90cb6ba0ae2776d51b5f3”]	3750000000000000000	2023-02-01T12:39:27.000Z	0x8dfdc3ead054017fbf01d7600322c53865f757fd9c2eff9cf54a458595badfa4
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	8	[“50”]	24354424023604479	27755489	[“0x720c9244473dfc596547c1f7b6261c7112a3dad4”]	4870884804720895926	2023-03-22T05:02:10.000Z	0xd3d7968842d38b43711293a7960ff8afe3666937c81d207b489f9c186612e894

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_avalanche.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	0x27b7aee0cf2281b4308747bd98dbfc2f0f54f41d	35	0xec3492a2508ddf4fdc0cd76f31f340b30d1793e6	0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4	28791266	0x27b7aee0cf2281b4308747bd98dbfc2f0f54f41d	9758000000000000000	2023-04-15T19:53:36.000Z	65151790043070856335	0x05e89be912376d50daa50e4b00b2c8cd1ebf9549b5617321e1c6b8a18e8d7085
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x8122a38f73e214c9f642baf6dfe70badf1e1475d	68	0xb54f16fb19478766a268f172c9480f8da1a7c9c3	0x0da67235dd5787d67955420c84ca1cecd4e5bb3b	28787717	0x8122a38f73e214c9f642baf6dfe70badf1e1475d	3895911652571446	2023-04-15T17:54:21.000Z	9144291482	0xab94122c723f8e208f83eb371b4831fa97a94db09b7429473e2b3f5d33c5d734
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x7d387fc292e1b9fba07e9e14343f732d5eecd936	44	0xd1c3f94de7e5b45fa4edbba472491a9f4b166fc4	0x62edc0692bd897d2295872a9ffcac5425011c661	28767116	0x7d387fc292e1b9fba07e9e14343f732d5eecd936	142279417411150151	2023-04-15T06:22:19.000Z	32027044121474337425	0xcf6a03f98e5fbeedccbb3fa89b7a44a2c3162b7496b89bea89f90e399b138001

Example Query

Query with partition filter

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