kyber_v1_optimism

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	0x55e55b818ef9ba639ab8fcafa772b17ec5048cf2	20	0x139283255069ea5deef6170699aaef7139526f1f	0x7f5c764cbc14f9669b88837ca1490cca17c31607	39206369	0x55e55b818ef9ba639ab8fcafa772b17ec5048cf2	257491	2022-11-18T04:07:46.000Z	4896035362915020110050344	0x8103b5b10b5bb09c5ee64638100c2d5247e452c92b6f352b96c8dca7ab75f8f0
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0x04c899245053f3fa9b46995e8e281cecfdee2a33	6	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	39176126	0x04c899245053f3fa9b46995e8e281cecfdee2a33	7000000000000000000	2022-11-18T01:47:59.000Z	6436413567230407862	0xb33ba8d7f2a1cd87ab7c4f043df3258c88fd08a46b91c1414b009229d9a3ff94
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0x092e7471a55c416f12d3340c6cce1a4bcc373089	6	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	39471551	0x092e7471a55c416f12d3340c6cce1a4bcc373089	1980000000000000000	2022-11-18T23:30:31.000Z	1826310612993000235	0x52d5efc0532ca4e4ccbfb0acc9524ea22f36ab22d2e1f9ae8a17f8f1eb430d30

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_optimism.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	0xeeeeeb57642040be42185f49c52f7e9b38f8eeee	78	[“10”]	130036769394468027	107245564	[“0xeff33ab0474f593ef9cf7e5baaccda950cdbaae7”]	130036769394468027931	2023-07-23T05:25:05.000Z	0x7c87f11cd8b648ae7e84208efe2de93878ce77b916c4571db2c183c2edfe97d7
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	57	[“10”]	6000000000000	107245663	[“0xeff33ab0474f593ef9cf7e5baaccda950cdbaae7”]	6000000000000000	2023-07-23T05:28:23.000Z	0x217cb6d8694581b09ae322f9746c8d3982c51f90e7251b45edc5d1bc9d2f4726
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	24	[“30”]	15000000000000	107275235	[“0x96c195f6643a3d797cb90cb6ba0ae2776d51b5f3”]	5000000000000000	2023-07-23T21:54:07.000Z	0x0cef20151ed7a1d6b413ae7bdabf2ab2d6315b511f70f2f729eec7ceafd0387c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_optimism.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	0xbc00eb93841dfa8f6f60f27365a636c18a7489eb	16	0x1db2466d9f5e10d7090e7152b68d62703a2245f0	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	84083956	0xbc00eb93841dfa8f6f60f27365a636c18a7489eb	1000000000000	2023-03-27T15:03:35.000Z	16579744271545060	0x739c4f30610422ec4a39dd748bee86177090aec2b4059e9f070bfb693dcc0a5e
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0xf9f367bdd8fa6a045dce59c59bc9dbe8c65d458c	7	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0x4200000000000000000000000000000000000006	84132984	0xf9f367bdd8fa6a045dce59c59bc9dbe8c65d458c	6850688345569957405	2023-03-27T19:22:50.000Z	6144661054503212650	0x6f6c2d2efc98d51a4e01c4292e9aa66488d4a59db3c1f67f05d1ebf3f1968a88
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x808212655d2f3886218e1a116883f026ab2ea5ea	7	0x1f32b1c2345538c0c6f582fcb022739c4a194ebb	0x4200000000000000000000000000000000000006	83968862	0x808212655d2f3886218e1a116883f026ab2ea5ea	2400000000000000000	2023-03-27T05:08:30.000Z	2153506191321107085	0xdd99e9c52431ae67b9280d2e8862e966f1ea04e4391cd8c4b14a0cbbaa5cdb3e

Example Query

Query with partition filter

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