kyber_v1_fantom

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
0xdf1a1b60f2d438842916c0adc43748768353ec25	false	0x9ce72293722be9d2bd15bd6f6456b3f018f4be14	62	0x00a35fd824c717879bf370e70ac6868b95870dfb	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	33480050	0x9ce72293722be9d2bd15bd6f6456b3f018f4be14	50000000000000000000	2022-03-15T10:19:14.000Z	921800466908780534	0xb5fe9b479c233eaa62a595ee6bb16fb99ef0a81df6fe87438ad5897f8c52c08d
0xdf1a1b60f2d438842916c0adc43748768353ec25	false	0x9ce72293722be9d2bd15bd6f6456b3f018f4be14	93	0x00a35fd824c717879bf370e70ac6868b95870dfb	0x8d11ec38a3eb5e956b052f67da8bdc9bef8abf3e	33480017	0x9ce72293722be9d2bd15bd6f6456b3f018f4be14	3815000000000000000000	2022-03-15T10:18:36.000Z	70010406105809317204	0x2d2cb72cf64b3049a649aa3cceaaaa5f2c40e42e3a3f1ef5790c5f41d9f7de45
0xdf1a1b60f2d438842916c0adc43748768353ec25	false	0x421a8a0c6388faa1550e2636538d8d7605a8cede	115	0x04068da6c83afcfa0e13ba15a6696662335d5b75	0x21be370d5312f44cb42ce377bc9b8a0cef1a4c83	33507872	0x421a8a0c6388faa1550e2636538d8d7605a8cede	1500000000000000000000	2022-03-15T17:39:31.000Z	1695739988	0xdf44f290dcee9147aae0b34f415e35a59d1e0ed6c9c2220046776e2d7d661f2f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_fantom.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	0x04068da6c83afcfa0e13ba15a6696662335d5b75	56	[“30”]	27253	67774760	[“0x96c195f6643a3d797cb90cb6ba0ae2776d51b5f3”]	9084501	2023-09-03T09:17:19.000Z	0xfc001ce2d1cae680117baeb0f04048af7c6d932964918608aa957d3fdf1b890b
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	18	[“10”]	200000000000000	67774377	[“0xeff33ab0474f593ef9cf7e5baaccda950cdbaae7”]	200000000000000000	2023-09-03T09:04:15.000Z	0x428f4ffdced8cd4efb17258c67546408fdf2702029fe09b73d2bb6b4bf59e450
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0	[“30”]	12000000000000000	67784673	[“0x96c195f6643a3d797cb90cb6ba0ae2776d51b5f3”]	4000000000000000000	2023-09-03T14:51:49.000Z	0x80ab0ccdc710dc0ec4d15ec0a720905802d387463e5f3523aec2f884a6fc4cd8

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_fantom.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	0xfdf9fa257d7028798697161abcc69a59a775275d	79	0x01e77288b38b416f972428d562454fb329350bac	0x04068da6c83afcfa0e13ba15a6696662335d5b75	57922270	0xfdf9fa257d7028798697161abcc69a59a775275d	5742750701	2023-03-19T15:08:16.000Z	786073621727430840316	0xbbfc83f061b559980591f8257518e5300d8d4719ee313d8230589875cfda730d
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0xc5f4a992f3ce1ab2a6dd373e10158de90b4685ee	44	0x01e77288b38b416f972428d562454fb329350bac	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	57913562	0xc5f4a992f3ce1ab2a6dd373e10158de90b4685ee	8000000000000000000	2023-03-19T12:16:16.000Z	556839545291932414	0xf1d712c393ef283ce0552f76e496b6f56b763daadd8e9d2f901f50f32e5884fd
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0xf2ad941ca98aedeb8981b21a3b68c42234b00aff	11	0x01e77288b38b416f972428d562454fb329350bac	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	57930251	0xf2ad941ca98aedeb8981b21a3b68c42234b00aff	500000000000000000000	2023-03-19T18:04:12.000Z	34169339261948054272	0x36ab99d990725a3f39d7d2c7125281f269a0716cfcb08514a175c54d840de0e1

Example Query

Query with partition filter

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