> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# kyber_v2_ethereum

> Tables in tt-contracts.kyber_v2_ethereum

## Tables

### DMMPool\_Swap\_event

KyberSwap Dynamic Market Maker (DMM) pool swap events capturing token exchange activity within liquidity pools. Records sender, recipient, input/output amounts for both tokens (token0/token1), and precision-scaled swap fees for DEX trading analytics.

<Accordion title="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_amount0In`      | `STRING`    | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount1In`      | `STRING`    | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount0Out`     | `STRING`    | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_amount1Out`     | `STRING`    | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_to`             | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                       |
  | `in_feeInPrecision` | `STRING`    | Swap fee amount expressed in high-precision fixed-point format. Stored as decimal string representing the fee scaled by a precision factor.           |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_amount0In | in\_amount1In | in\_amount0Out | in\_amount1Out      | block\_timestamp         | transaction\_hash                                                  | in\_feeInPrecision |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ------------- | -------------- | ------------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ |
  | 0xdfee68a9adb981cd08699891a11cabe10f25ec44 | 0x1cf68bbc2b6d3c6cfe1bd3590cf0e10b06a05f17 | false   | 0x0000000000007f150bd6f54c40a34d7c3d5e9f56 | 393        | 12721149      | 8922787       | 0             | 0              | 1547509648408629936 | 2021-06-28T07:16:36.000Z | 0xc2314710865510a5261eabf1dd9f2640793a862eccc6436a521b0dc7e80fb3d5 | 2498102465058119   |
  | 0x0000000000007f150bd6f54c40a34d7c3d5e9f56 | 0x1cf68bbc2b6d3c6cfe1bd3590cf0e10b06a05f17 | false   | 0x0000000000007f150bd6f54c40a34d7c3d5e9f56 | 330        | 12721134      | 4336507       | 0             | 0              | 754660062003533385  | 2021-06-28T07:13:30.000Z | 0xcef29a32053b1cb719cddc4428e8b1659fa876b76c0b3284e1e1b3b266d0ba3f | 2492304407025406   |
  | 0xdfee68a9adb981cd08699891a11cabe10f25ec44 | 0x1cf68bbc2b6d3c6cfe1bd3590cf0e10b06a05f17 | false   | 0x0000000000007f150bd6f54c40a34d7c3d5e9f56 | 177        | 12721220      | 8561352       | 0             | 0              | 1477672224516174187 | 2021-06-28T07:34:20.000Z | 0xed324dbc2a5c9b83cb5bddc6a7c9b4aa27ef28032216e9b4f5439261fc99ab6c | 2850792965110469   |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kyber_v2_ethereum.DMMPool_Swap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### DMMPool\_Sync\_event

Kyber Dynamic Market Maker (DMM) pool synchronization events emitted after reserve balance updates. Contains actual and virtual reserve amounts for both tokens in the pool pair, used for tracking liquidity state changes and amplified liquidity calculations.

<Accordion title="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_vReserve0`     | `STRING`    | Virtual reserve amount of the first token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.                     |
  | `in_vReserve1`     | `STRING`    | Virtual reserve amount of the second token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.                    |
  | `in_reserve0`      | `STRING`    | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.  |
  | `in_reserve1`      | `STRING`    | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_reserve0             | in\_reserve1         | block\_number | in\_vReserve0 | in\_vReserve1 | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------------ | -------------------- | ------------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x0fa8e845777e0c6d6a9f2f22c57c53a4b56a150a | false   | 92         | 83951389816430236384688  | 1935428140           | 15928923      | 0             | 0             | 2022-11-09T00:33:59.000Z | 0x839ad84c93326fcabcb4db93de0037f521d404897907d928ba8febeb00e7afe6 |
  | 0x20d6b227f4a5a2a13d520329f01bb1f8f9d2d628 | false   | 29         | 615044819409020409836    | 475762014139883535   | 15929686      | 0             | 0             | 2022-11-09T03:07:11.000Z | 0x349ad784a56a7e41a62584dc85c1877634b50da0cf969a421c23cb1618ea0bfa |
  | 0x5ba740fcc020d5b9e39760cbd2fe236586b9dc0a | false   | 216        | 126870992482872123089974 | 66027549126839285660 | 15934345      | 0             | 0             | 2022-11-09T18:46:35.000Z | 0xeb39fcc4885c1478e90f8f1a050cdcfc5ea086440972f03ef07a6dd59c857deb |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kyber_v2_ethereum.DMMPool_Sync_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### Factory\_PoolCreated\_event

Factory contract event emitted when a new liquidity pool is created, recording token pairs and pool configuration parameters. Used for tracking DEX pool deployments and liquidity market initialization.

<Accordion title="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_token0`        | `STRING`    | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                        |
  | `in_token1`        | `STRING`    | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                       |
  | `in_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                     |
  | `in_ampBps`        | `STRING`    | Amplification factor of the liquidity pool expressed in basis points (BPS). Numeric string value that defines the pool's price curve characteristics in the Kyber protocol.    |
  | `in_totalPool`     | `STRING`    | Total number of liquidity pools created by the factory contract at the time of this pool creation event. Numeric string value that increments sequentially with each new pool. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | in\_ampBps | in\_token0                                 | in\_token1                                 | log\_index | block\_number | in\_totalPool | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x833e4083b7ae46cea85695c4f7ed25cdad8886de | 0x908d4478b19759d4dd316a99016b4913be342672 | false   | 10000      | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 0xcc394f10545aeef24483d2347b32a34a44f20e6f | 213        | 12218525      | 20            | 2021-04-11T12:07:57.000Z | 0x121766aa0e3091d45b02dab0f8e21f3d6e1720cf7fbc03f05fb6c5a651166427 |
  | 0x833e4083b7ae46cea85695c4f7ed25cdad8886de | 0x5d6e3ff93142aa2fc2063465e8e75b957b310351 | false   | 13000      | 0xbcd515d6c5de70d3a31d999a7fa6a299657de294 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 129        | 12919283      | 51            | 2021-07-29T07:04:40.000Z | 0x3a79ef811f209fdaecf3c0ce82c81c7881e159adcd55fa73ed1d558b643e7f48 |
  | 0x833e4083b7ae46cea85695c4f7ed25cdad8886de | 0x898e2fef4cef5592485251fab6da7c819a2df291 | false   | 17000      | 0x656c00e1bcd96f256f224ad9112ff426ef053733 | 0xdac17f958d2ee523a2206206994597c13d831ec7 | 56         | 13599722      | 61            | 2021-11-12T06:31:03.000Z | 0x8a53478cd1fb13b3497254a85b9eee00a1e774c8e0a311b87dbfbf305bd8a3b7 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kyber_v2_ethereum.Factory_PoolCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### KSFactory\_PoolCreated\_event

Liquidity pool creation events emitted by the KyberSwap factory contract. Records token pair addresses, amplification parameters, fee configuration, and cumulative pool count for tracking DEX deployment activity.

<Accordion title="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_token0`        | `STRING`    | Contract address of the first token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                        |
  | `in_token1`        | `STRING`    | Contract address of the second token in the trading pair. Hex-encoded, 0x-prefixed, 42-character string.                                                                       |
  | `in_pool`          | `STRING`    | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                                                     |
  | `in_ampBps`        | `STRING`    | Amplification factor of the liquidity pool expressed in basis points (BPS). Numeric string value that defines the pool's price curve characteristics in the Kyber protocol.    |
  | `in_feeUnits`      | `STRING`    | Fee charged by the liquidity pool for trades. Numeric string value representing the fee in basis points or fee units defined by the Kyber protocol.                            |
  | `in_totalPool`     | `STRING`    | Total number of liquidity pools created by the factory contract at the time of this pool creation event. Numeric string value that increments sequentially with each new pool. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                   | removed | in\_ampBps | in\_token0                                 | in\_token1                                 | log\_index | in\_feeUnits | block\_number | in\_totalPool | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------------------------------------ | ---------- | ------------ | ------------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x1c758af0688502e49140230f6b0ebd376d429be5 | 0x5cd7c1efec89f0a6bcec73ec72b69e7376ed6349 | false   | 110000     | 0xbf4a2ddaa16148a9d0fa2093ffac450adb7cd4aa | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 375        | 1000         | 15228778      | 1             | 2022-07-28T04:14:03.000Z | 0xe5d9b6ae073933bffcf67f0fda4f1bb523b4b8e1aba6b447143b3d39678fc296 |
  | 0x1c758af0688502e49140230f6b0ebd376d429be5 | 0x023c2773aa71b4b1ca7d30dd11748fe32a4fa02e | false   | 100000000  | 0xa12a22395289862253f7308fdfc28d71af10a912 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 177        | 8            | 15793779      | 2             | 2022-10-21T03:25:23.000Z | 0xc1c1e0b5d8f34670987073df97cd33cae3877d134ad40b9461c718a7f1db74a5 |
  | 0x1c758af0688502e49140230f6b0ebd376d429be5 | 0x2aaf08590c5ef5fb6fe19438028cc900fa219a45 | false   | 10000      | 0xb08686f3bf55a1ea172542d161a63350baf9e219 | 0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2 | 305        | 1000         | 17757504      | 9             | 2023-07-23T18:08:59.000Z | 0xfa322aa422ff3ef7e6408b28bb79b513a60d1becc275b391902f62d0df0d6542 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kyber_v2_ethereum.KSFactory_PoolCreated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### KSPool\_Swap\_event

KyberSwap pool swap events recording token exchanges within liquidity pools. Contains input and output amounts for both token0 and token1, swap fees, initiating sender, and recipient address for tracking DEX trading activity and volume analysis.

<Accordion title="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_amount0In`      | `STRING`    | Amount of token0 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount1In`      | `STRING`    | Amount of token1 transferred into the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token.   |
  | `in_amount0Out`     | `STRING`    | Amount of token0 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_amount1Out`     | `STRING`    | Amount of token1 transferred out of the liquidity pool during a swap operation. Stored as decimal string representing the smallest unit of the token. |
  | `in_to`             | `STRING`    | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.                                       |
  | `in_feeInPrecision` | `STRING`    | Swap fee amount expressed in high-precision fixed-point format. Stored as decimal string representing the fee scaled by a precision factor.           |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | removed | in\_sender                                 | log\_index | block\_number | in\_amount0In | in\_amount1In     | in\_amount0Out | in\_amount1Out    | block\_timestamp         | transaction\_hash                                                  | in\_feeInPrecision |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------- | ----------------- | -------------- | ----------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ |
  | 0xb20f3f78253da4bd8f4a0fb5f19da23ae9cdbe69 | 0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba | false   | 0x9db7378614d8d9d7149c4ee4763f88c38f9b1517 | 189        | 17685194      | 0             | 22572063539850753 | 1349968584368  | 0                 | 2023-07-13T14:33:23.000Z | 0xefca9a005c2100cfc164a9b76f9b5245b686e7b2f49cae473629d1b513e0fc00 | 80000000000000     |
  | 0x1111111254eeb25477b68fb85ed929f73a960582 | 0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba | false   | 0x1136b25047e142fa3018184793aec68fbb173ce4 | 115        | 17071412      | 0             | 49562500000000000 | 851731093434   | 0                 | 2023-04-18T05:09:47.000Z | 0x42abf50a3bb76f92d83b29f2587bb788a01e2234a1bb1ebc5e8d013142089ff3 | 80000000000000     |
  | 0xa478c2975ab1ea89e8196811f51a7b7ade33eb11 | 0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba | false   | 0x555b6ee8fab3dfdbcca9121721c435fd4c7a1fd1 | 264        | 17072015      | 828305772000  | 0                 | 0              | 48649499081336221 | 2023-04-18T07:12:11.000Z | 0x3645310a1cddb094c5f2faf22995e85c8a303a7c15185d106c9932ca264d50ee | 80000000000000     |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kyber_v2_ethereum.KSPool_Swap_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### KSPool\_Sync\_event

KyberSwap pool synchronization events emitted when liquidity pool reserves are updated. Contains actual reserve balances (reserve0, reserve1) and virtual reserves (vReserve0, vReserve1) used in Kyber's dynamic market maker pricing mechanism.

<Accordion title="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_vReserve0`     | `STRING`    | Virtual reserve amount of the first token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.                     |
  | `in_vReserve1`     | `STRING`    | Virtual reserve amount of the second token in a Kyber liquidity pool. Stored as decimal string representing the smallest unit of the token.                    |
  | `in_reserve0`      | `STRING`    | Reserve amount of the first token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token.  |
  | `in_reserve1`      | `STRING`    | Reserve amount of the second token in a liquidity pool after a state-changing operation. Stored as decimal string representing the smallest unit of the token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_reserve0       | in\_reserve1              | block\_number | in\_vReserve0        | in\_vReserve1              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------------ | ------------------------- | ------------- | -------------------- | -------------------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x93669cfce302c9971169f8106c850181a217b72b | false   | 265        | 750000000000000000 | 1000000000000000000000000 | 17097568      | 15000000000000000000 | 20000000000000000000000000 | 2023-04-21T21:58:11.000Z | 0x6ad2291b7efdb9d1ab987a413c48da74042307ea40426f22028cc7fdbac62746 |
  | 0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba | false   | 205        | 2580499643387      | 93395960419476359         | 17858068      | 0                    | 0                          | 2023-08-06T19:42:23.000Z | 0x1f5cfea6cfeac51fb14d3bb3f9d0b56d3635ba70864ce1c29c43284133faabc5 |
  | 0x6a4d5f8385ff6e7fc4ebf6f726e12a958daa1cba | false   | 50         | 3667986524648      | 65687319792845429         | 17726348      | 0                    | 0                          | 2023-07-19T09:28:59.000Z | 0x1447bbb3bae50b99f6181593d194720931878e75073a1c8cb8a026c6c33303ae |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kyber_v2_ethereum.KSPool_Sync_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### RewardLocker\_Vested\_event

RewardLocker vesting events emitted when locked reward tokens become available for withdrawal by beneficiaries. Records the beneficiary address, token contract, vested quantity, and schedule index for tracking time-locked reward distributions in Kyber Network V2 protocols.

<Accordion title="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_beneficiary`    | `STRING`    | Address that receives the tokens, assets, or benefits from the operation. Hex-encoded, 0x-prefixed, 42-character string.                                                                    |
  | `in_vestedQuantity` | `STRING`    | Amount of tokens that have vested and become available to the beneficiary. Numeric string representation in the token's smallest unit (wei for native tokens, base units for ERC20 tokens). |
  | `in_index`          | `STRING`    | Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).                                                        |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_index | in\_token                                  | log\_index | block\_number | in\_beneficiary                            | block\_timestamp         | transaction\_hash                                                  | in\_vestedQuantity     |
  | ------------------------------------------ | ------- | --------- | ------------------------------------------ | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ---------------------- |
  | 0xfab5186a194588f5ad5074bd52659302906b4522 | false   | 5         | 0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202 | 374        | 13400673      | 0xdb68c0f5f08bbe0f4dd18c9cf409b2e46316d69e | 2021-10-12T01:05:48.000Z | 0x02289047a012f08be6fbde36c6c95dda90ad1c9fb8d52b7a0bd5b7c6fb8d9361 | 913560145696447291566  |
  | 0xfab5186a194588f5ad5074bd52659302906b4522 | false   | 6         | 0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202 | 375        | 13400673      | 0xdb68c0f5f08bbe0f4dd18c9cf409b2e46316d69e | 2021-10-12T01:05:48.000Z | 0x02289047a012f08be6fbde36c6c95dda90ad1c9fb8d52b7a0bd5b7c6fb8d9361 | 2230948390175828949852 |
  | 0xfab5186a194588f5ad5074bd52659302906b4522 | false   | 2         | 0xdefa4e8a7bcba345f687a2f1456f5edd9ce97202 | 371        | 13400673      | 0xdb68c0f5f08bbe0f4dd18c9cf409b2e46316d69e | 2021-10-12T01:05:48.000Z | 0x02289047a012f08be6fbde36c6c95dda90ad1c9fb8d52b7a0bd5b7c6fb8d9361 | 1098835925736190875933 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.kyber_v2_ethereum.RewardLocker_Vested_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***