kyber_v1_ethereum

Tables

KyberFeeHandler_FeeDistributed_event

Fee distribution events from Kyber Network v1 on Ethereum showing how trading fees are allocated to staking rewards, token burns, rebates, and platform fees. Tracks wei-denominated amounts per token for analyzing fee economics and KNC tokenomics.

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_platformWallet`	`STRING`	Ethereum address designated to receive platform fees from the Kyber protocol. Typically set to zero address when no platform fee is collected, as shown in the sample data.
`in_platformFeeWei`	`STRING`	Platform fee amount in wei allocated to the platform wallet from this distribution. Typically zero in sample data, indicating no platform fees were charged during these transactions.
`in_rewardWei`	`STRING`	Amount of tokens in wei allocated as rewards to stakers or liquidity providers from the collected fees. Stored as a string to handle large integer values exceeding standard numeric limits.
`in_rebateWei`	`STRING`	Amount of token designated as rebate to be distributed back to users, denominated in wei. Typically zero when no rebate wallets are specified in the fee distribution event.
`in_rebateWallets`	`ARRAY<STRING>`	Array of wallet addresses receiving rebate payments from this fee distribution event. Typically empty when no rebates are distributed, as seen in sample data.
`in_rebatePercentBpsPerWallet`	`ARRAY<STRING>`	Array of rebate percentages in basis points (BPS) corresponding to each wallet in the rebate distribution. Typically empty when no rebates are distributed to wallets.
`in_burnAmtWei`	`STRING`	Token amount in wei that was burned as part of the fee distribution. Typically represents a portion of collected trading fees used for token buyback and burn mechanisms.

Sample Data

address	removed	in_token	log_index	block_number	in_rewardWei	in_burnAmtWei	block_timestamp	in_rebateWallets	transaction_hash	in_platformWallet	in_rebatePercentBpsPerWallet
0xd3d2b5643e506c6d9b7099e9116d7aaa941114fe	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	229	11984111	2958303903155811	195538211082795	2021-03-06T09:45:31.000Z	[]	0x26f30f5aa5c8599c2eb514588168e379462354e9f2808e939cbe13a165e1c17c	0x0000000000000000000000000000000000000000	[]
0xd3d2b5643e506c6d9b7099e9116d7aaa941114fe	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	12	11986296	4689484100864426	309965900057138	2021-03-06T17:37:18.000Z	[]	0xa4fbf383d2b3f64c765918ae061cba8b43e7c5f945252aca718fed8de1fa5239	0x0000000000000000000000000000000000000000	[]
0xd3d2b5643e506c6d9b7099e9116d7aaa941114fe	false	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	267	11987476	5619077339023233	371410229231814	2021-03-06T22:03:46.000Z	[]	0xe717af3b8d5ba9c7418b77a3c686ed3c0941d9a1982118a56aa8628513163905	0x0000000000000000000000000000000000000000	[]

Example Query

Query with partition filter

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

KyberNetwork_KyberTrade_event

Trade execution events from Kyber Network V1 decentralized exchange on Ethereum, capturing token swaps with source/destination tokens, exchange rates, reserve IDs, and fee breakdowns. Used for analyzing DEX liquidity routing, reserve performance, and fee structures across token-to-ETH (t2e) and ETH-to-token (e2t) trade directions.

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_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dest`	`STRING`	Destination chain identifier for cross-chain operations. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-56” for BSC, “POLKADOT-2030” for a Polkadot parachain).
`in_ethWeiValue`	`STRING`	ETH amount involved in the trade denominated in wei (1 ETH = 10^18 wei). String-encoded integer representing the total ETH value of the transaction.
`in_networkFeeWei`	`STRING`	Network fee charged by Kyber protocol for this trade, denominated in wei. Typically represents a small percentage (0.1%) of the trade value, as shown by values like 1-4 ETH wei.
`in_customPlatformFeeWei`	`STRING`	Platform fee in wei charged by the integrating dApp or interface for this trade. Typically zero, as most Kyber trades use standard protocol fees only.
`in_t2eIds`	`ARRAY<STRING>`	Array of reserve identifiers used for token-to-ETH swap legs in this Kyber trade. Hex-encoded 32-byte strings identifying specific liquidity reserves; empty when trade is ETH-to-token only.
`in_e2tIds`	`ARRAY<STRING>`	Reserve identifiers for ETH-to-token trades in the swap path, represented as 32-byte hex-encoded strings. Empty array when trade direction is token-to-ETH.
`in_t2eSrcAmounts`	`ARRAY<STRING>`	Array of source token amounts used in token-to-ETH (T2E) swaps within this Kyber trade, denominated in the smallest unit of each source token. Corresponds to the reserve IDs in `in_t2eIds` and exchange rates in `in_t2eRates`.
`in_e2tSrcAmounts`	`ARRAY<STRING>`	Array of source token amounts in wei for ETH-to-token (e2t) swap legs within this trade. Empty when trade direction is token-to-ETH.
`in_t2eRates`	`ARRAY<STRING>`	Exchange rates applied for token-to-ETH (t2e) swaps in the trade, denominated in wei per token unit. Array contains rate values corresponding to each reserve used in the token-to-ETH leg of the transaction.
`in_e2tRates`	`ARRAY<STRING>`	Exchange rate used for ETH-to-token (E2T) swaps in the trade, expressed in wei per token unit. Empty array when trade direction is token-to-ETH.

Sample Data

in_src	address	in_dest	removed	in_e2tIds	in_t2eIds	log_index	in_e2tRates	in_t2eRates	block_number	in_ethWeiValue	block_timestamp	in_e2tSrcAmounts	in_networkFeeWei	in_t2eSrcAmounts	transaction_hash
0x4a220e6096b25eadb88358cb44068a3248254675	0x7c66550c9c730b6fdd4c03bc2e73c5462c5f7acc	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	false	[]	[“0xaa514e5452657365727665000000000000000000000000000000000000000000”]	408	[]	[“47514702314465827”]	15043664	3546812474002798041	2022-06-29T06:22:11.000Z	[]	3546812474002798	[“74646631489533141497”]	0x14b710037dc1e645f9301ba692fc77f8fa1726c240ef4ba090b365b4dd674268
0x4a220e6096b25eadb88358cb44068a3248254675	0x7c66550c9c730b6fdd4c03bc2e73c5462c5f7acc	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	false	[]	[“0xaa514e5452657365727665000000000000000000000000000000000000000000”]	78	[]	[“47770301314793920”]	15043753	3281217794529775900	2022-06-29T06:45:42.000Z	[]	3281217794529775	[“68687400000000000000”]	0x3f4cffae9cadaa0b5a1187ed0700bdfaf72ad721399e16719f5f6ab6b648ba81
0x4a220e6096b25eadb88358cb44068a3248254675	0x7c66550c9c730b6fdd4c03bc2e73c5462c5f7acc	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	false	[]	[“0xaa514e5452657365727665000000000000000000000000000000000000000000”]	256	[]	[“48360449642754438”]	15045867	2756545629637002966	2022-06-29T16:27:10.000Z	[]	2756545629637002	[“57000000000000000000”]	0xb3676df089a9a4c47ef665c4074060c652e7d961760413870c48cf5392292f2b

Example Query

Query with partition filter

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

KyberNetworkProxyV1_ExecuteTrade_event

Token swap execution events from Kyber Network V1 decentralized exchange on Ethereum. Records successful trades between ERC-20 tokens (and ETH via 0xeeee address) with actual source and destination amounts for analyzing DEX liquidity and trading volumes.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dest`	`STRING`	Destination chain identifier for cross-chain operations. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-56” for BSC, “POLKADOT-2030” for a Polkadot parachain).
`in_actualSrcAmount`	`STRING`	Actual amount of source tokens transferred from the trader in the swap, denominated in the token’s smallest unit (wei for 18-decimal tokens). Values are string-encoded integers representing precise token quantities before decimal conversion.
`in_actualDestAmount`	`STRING`	Actual amount of destination tokens received by the trader after execution of the swap on Kyber Network. Stored as a string representation of the token’s smallest unit (wei for ETH, base units for ERC20 tokens).

Sample Data

in_src	address	in_dest	removed	in_trader	log_index	block_number	block_timestamp	transaction_hash	in_actualSrcAmount	in_actualDestAmount
0x0d8775f648430679a709e98d2b0cb6250d2887ef	0x818e6fecd516ecc3849daf6845e3ec868087b755	0x6b175474e89094c44da98b954eedeac495271d0f	false	0x8f337bd3b7f2b05d9a8dc8ac518584e833424893	58	9338663	2020-01-23T15:10:02.000Z	0x1cb44483ebf79ab6d0f080aea77891994b6ea0708c5fc3e9838072c62f35ad1e	120490973530000000000	24733359763814833499
0x0d8775f648430679a709e98d2b0cb6250d2887ef	0x818e6fecd516ecc3849daf6845e3ec868087b755	0x6b175474e89094c44da98b954eedeac495271d0f	false	0x8f337bd3b7f2b05d9a8dc8ac518584e833424893	27	9336757	2020-01-23T08:10:09.000Z	0xae23188027b19eb3d52531302843a0f209f7275c3da5eb5fa62d896de09c7b33	691322578000000000000	147581394987957595471
0x0d8775f648430679a709e98d2b0cb6250d2887ef	0x818e6fecd516ecc3849daf6845e3ec868087b755	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	false	0xf296a5fafff0afd6c06df68eccbf0bc0a1b294ae	123	9339767	2020-01-23T19:08:10.000Z	0x5538a5329404d2f8b42732fe6f835fd2729ac2f0c515d4c9bc5b781f389fa197	988424686486486487920	199941157

Example Query

Query with partition filter

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

KyberNetworkProxyV2_ExecuteTrade_event

Token swap execution records from Kyber Network’s V2 proxy contract on Ethereum. Captures trader addresses, source/destination tokens, executed amounts, and platform fees for analyzing DEX trading patterns and liquidity routing behavior.

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_trader`	`STRING`	Address that initiated or executed the trade transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dest`	`STRING`	Destination chain identifier for cross-chain operations. String format following the pattern “CHAINTYPE-CHAINID” (e.g., “EVM-56” for BSC, “POLKADOT-2030” for a Polkadot parachain).
`in_destAddress`	`STRING`	Ethereum address receiving the destination tokens from the trade. Typically matches in_trader but can differ when tokens are sent to a different recipient address.
`in_actualSrcAmount`	`STRING`	Actual amount of source tokens spent in the trade, denominated in the token’s smallest unit (wei for ETH). Represented as a string to preserve precision for tokens with 18 decimal places.
`in_actualDestAmount`	`STRING`	Actual amount of destination tokens received by the trader after the swap execution. Denominated in the destination token’s smallest unit (wei for ETH, base units for ERC-20 tokens).
`in_platformWallet`	`STRING`	Wallet address that receives platform fees for facilitating the trade on Kyber Network. Set to zero address (0x00…00) when no platform fee is charged.
`in_platformFeeBps`	`STRING`	Platform fee charged on the trade measured in basis points (BPS), where 100 BPS equals 1%. Commonly 0 for non-partner integrations, with non-zero values indicating referral or integration fees.

Sample Data

in_src	address	in_dest	removed	in_trader	log_index	block_number	in_destAddress	block_timestamp	transaction_hash	in_platformFeeBps	in_platformWallet	in_actualSrcAmount	in_actualDestAmount
0x514910771af9ca656af840dff83e8264ecf986ca	0x9aab3f75489902f3a48495025729a0af77d4b11e	0xd533a949740bb3306d119cc777fa900ba034cd52	false	0x4ff16eff3b6d2175a513ef4c5b95f5f4d2f05179	229	13194148	0x4ff16eff3b6d2175a513ef4c5b95f5f4d2f05179	2021-09-09T21:58:03.000Z	0x5604caa71f33d5607897342c3f50ccd8ab818b1fde9c9912dd3114fa5b6fc6ac	0	0x0000000000000000000000000000000000000000	1585699885301690530297	18918167884908129411443
0x6b175474e89094c44da98b954eedeac495271d0f	0x9aab3f75489902f3a48495025729a0af77d4b11e	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	false	0xb9c551637056d976fa8292a62b345bf59b2b4bb3	281	13190369	0xb9c551637056d976fa8292a62b345bf59b2b4bb3	2021-09-09T08:08:10.000Z	0xb1d1f5a34f79b9b94a9fd9ebd5df23b74e65395a86d7d9c1af4cc994200ef089	18	0xde63aef60307655405835da74ba02ce4db1a42fb	6000000000000000000000	1708502301278371037
0x7c5a0ce9267ed19b22f8cae653f198e3e8daf098	0x9aab3f75489902f3a48495025729a0af77d4b11e	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	false	0x27239549dd40e1d60f5b80b0c4196923745b1fd2	191	13193275	0x27239549dd40e1d60f5b80b0c4196923745b1fd2	2021-09-09T18:54:32.000Z	0x7d4a727fc639035befbbab3d50d45a9f27e4d4a29fee2380a5c2130463dedd1f	0	0x910bf2d50fa5e014fd06666f456182d4ab7c8bd2	75169193380000000000000	4900207370008389055

Example Query

Query with partition filter

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

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	0xae05fc9fc0172ab1a4ae6540de7da2647a567b99	153	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x0321016ed91c1baa0a68a75b6e4e15d6297ad9b6	15455738	0xae05fc9fc0172ab1a4ae6540de7da2647a567b99	4175560308388622	2022-09-01T23:28:58.000Z	145184636943132692	0xa9fc08ba5d0741723ca41dfc47403e54f5ebabbec3abfdfb6217a07ac7c81bb9
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0x4537cdaf67c664ce6677b49d3065670e26cd3b05	101	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x056431d11c26b04455656fac6187d57b3d248a88	15450062	0x4537cdaf67c664ce6677b49d3065670e26cd3b05	550000000000	2022-09-01T01:44:13.000Z	104289630697304885	0x5377de55a04d151b8ffef82bb51ec792dc1f43d2e70a4c8d8942c58fc80fccdb
0x617dee16b86534a5d792a4d7a62fb491b544111e	false	0xae05fc9fc0172ab1a4ae6540de7da2647a567b99	32	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x056431d11c26b04455656fac6187d57b3d248a88	15454370	0xae05fc9fc0172ab1a4ae6540de7da2647a567b99	658852605125	2022-09-01T18:16:41.000Z	204321216736251768	0x21a6841321ec79d7f78085636bb147a74899fb84faeceb4dc6d676e15360d9a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_ethereum.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	0x6bea7cfef803d1e3d5f7c0103f7ded065644e197	11	[“0”]	0	17071604	[“0x8c128f336b479b142429a5f351af225457a987fa”]	8623498944664336000000	2023-04-18T05:48:47.000Z	0x32cbb530c888a4c7037a19c390d4e25b65c3e78df409dd2c977ea136b694d5f7
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0x95b3497bbcccc46a8f45f5cf54b0878b39f8d96c	50	[“0”]	0	17070818	[“0x8c128f336b479b142429a5f351af225457a987fa”]	1000000000000000000000	2023-04-18T03:07:23.000Z	0x3b97b5b6642bd689114ff37916cd77cc67895e3b6cab4fdfa85c2673575c44e6
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	true	0x53250b5dfa8c911547afeaf18db025024c8e919a	252	[“30”]	599346364685	17071071	[“0x96c195f6643a3d797cb90cb6ba0ae2776d51b5f3”]	199782121561691	2023-04-18T03:59:11.000Z	0xedc5f63a6e28faa51ef4375eb092d1a684407cc5a8d0a54db79eb8fc65947521

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.kyber_v1_ethereum.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	0xd8524b153df3f22d94ebdf5877e49dcde35bd51f	21	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x0050df93449fbd9a3d8e2f2f6134c33aff46e1ba	16501337	0xd8524b153df3f22d94ebdf5877e49dcde35bd51f	1901086928881606767645389	2023-01-27T23:09:23.000Z	677359793672447275	0x387193ac0b41c2b8798f67481741f024c8c62698df819277a3bd72b51627a980
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0x000b75fcdc15d41277deb033c72d2c8d774ccced	316	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x005d1123878fc55fbd56b54c73963b234a64af3c	16494539	0x000b75fcdc15d41277deb033c72d2c8d774ccced	66610237209471760740995709	2023-01-27T00:20:47.000Z	203898232731986090	0x14ce496e9a76c04619fbd2969c63d9c3aac7db4c669bf3b1b6910b8f49e3f9c0
0x6131b5fae19ea4f9d964eac0408e4408b66337b5	false	0xe341d077a0cfba74f492cd0d06f6be3b7c0af1c9	93	0xeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee	0x01d8265dc271536c66ae4ec7d563c7607016a535	16500964	0xe341d077a0cfba74f492cd0d06f6be3b7c0af1c9	100000000000000	2023-01-27T21:54:47.000Z	53526397321811349	0x8579c5d35a15072298bafbb049b3c112ee883a5ec3b4d6f868c543ea163a76f2

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

KyberFeeHandler_FeeDistributed_event

KyberNetwork_KyberTrade_event

KyberNetworkProxyV1_ExecuteTrade_event

KyberNetworkProxyV2_ExecuteTrade_event

MetaAggregationRouter_Swapped_event

MetaAggregationRouterV2_Fee_event

MetaAggregationRouterV2_Swapped_event

​Tables

​KyberFeeHandler_FeeDistributed_event

​KyberNetwork_KyberTrade_event

​KyberNetworkProxyV1_ExecuteTrade_event

​KyberNetworkProxyV2_ExecuteTrade_event

​MetaAggregationRouter_Swapped_event

​MetaAggregationRouterV2_Fee_event

​MetaAggregationRouterV2_Swapped_event

Tables

KyberFeeHandler_FeeDistributed_event

KyberNetwork_KyberTrade_event

KyberNetworkProxyV1_ExecuteTrade_event

KyberNetworkProxyV2_ExecuteTrade_event

MetaAggregationRouter_Swapped_event

MetaAggregationRouterV2_Fee_event

MetaAggregationRouterV2_Swapped_event