> ## 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.

# venus_v1_arbitrum

> Tables in tt-contracts.venus_v1_arbitrum

## Tables

### PoolRegistry\_MarketAdded\_event

Venus protocol events emitted when a new lending market (vToken) is added to a pool registry. Contains the comptroller address managing the pool and the vToken address of the newly registered market.

<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_comptroller`   | `STRING`    | Contract address of the Venus protocol comptroller managing the pool. Hex-encoded, 0x-prefixed, 42-character string.                                 |
  | `in_vTokenAddress` | `STRING`    | Contract address of the Venus protocol vToken representing the market being added. Hex-encoded, 0x-prefixed, 42-character string.                    |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_comptroller                            | block\_timestamp         | in\_vTokenAddress                          | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0x382238f07bc4fe4aa99e561ade8a4164b5f815da | false   | 37         | 302011785     | 0x317c1a5739f39046e20b08ac9beea3f10fd43326 | 2025-02-02T23:15:49.000Z | 0x4f3a73f318c5ea67a86eaace24309f29f89900df | 0x9c9f2f2b2e7bfe027b1494fbc081aa17808b6b4d03d84d6feb4261266d55abbd |
  | 0x382238f07bc4fe4aa99e561ade8a4164b5f815da | false   | 149        | 219368002     | 0x317c1a5739f39046e20b08ac9beea3f10fd43326 | 2024-06-07T13:48:02.000Z | 0x7d8609f8da70ff9027e9bc5229af4f6727662707 | 0xad40d986b13a56c935a2284805730333ff4131ad31bb12ba00009f483340219d |
  | 0x382238f07bc4fe4aa99e561ade8a4164b5f815da | false   | 169        | 219368002     | 0x317c1a5739f39046e20b08ac9beea3f10fd43326 | 2024-06-07T13:48:02.000Z | 0xb9f9117d4200dc296f9acd1e8be1937df834a2fd | 0xad40d986b13a56c935a2284805730333ff4131ad31bb12ba00009f483340219d |
</Accordion>

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

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

***

### PoolRegistry\_PoolRegistered\_event

Venus Protocol pool registration events emitted when a new lending pool is added to the protocol registry. Contains pool metadata including name, creator address, associated comptroller contract, and registration timestamp.

<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_comptroller`   | `STRING`                                                                                              | Contract address of the Venus protocol comptroller managing the pool. Hex-encoded, 0x-prefixed, 42-character string.                                 |
  | `in_pool`          | `STRUCT<name STRING, creator STRING, comptroller STRING, blockPosted STRING, timestampPosted STRING>` | Contract address of the pool being referenced in the event. Hex-encoded, 0x-prefixed, 42-character string.                                           |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_pool                                                                                                                                                                                                | removed | log\_index | block\_number | in\_comptroller                            | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x382238f07bc4fe4aa99e561ade8a4164b5f815da | \{"name":"Liquid Staked ETH","creator":"0x14e0e151b33f9802b3e75b621c1457afc44dcaa0","blockPosted":"20728415","comptroller":"0x52bab1af7ff770551bd05b9fc2329a0bf5e23f16","timestampPosted":"1726070343"} | false   | 8          | 252449268     | 0x52bab1af7ff770551bd05b9fc2329a0bf5e23f16 | 2024-09-11T15:59:03.000Z | 0x69221be37e785cf9fc43988c6e160f2ce2d8e169fb6403d94a7b501cd01b4c1f |
  | 0x382238f07bc4fe4aa99e561ade8a4164b5f815da | \{"name":"Core","creator":"0x14e0e151b33f9802b3e75b621c1457afc44dcaa0","blockPosted":"20040344","comptroller":"0x317c1a5739f39046e20b08ac9beea3f10fd43326","timestampPosted":"1717768082"}              | false   | 87         | 219368002     | 0x317c1a5739f39046e20b08ac9beea3f10fd43326 | 2024-06-07T13:48:02.000Z | 0xad40d986b13a56c935a2284805730333ff4131ad31bb12ba00009f483340219d |
</Accordion>

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

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

***

### VToken\_AccrueInterest\_event

Interest accrual events from Venus Protocol lending markets recording periodic interest calculations. Contains cumulative borrow index, cash reserves, total borrows, and accumulated interest for tracking market state changes and calculating borrower obligations.

<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_cashPrior`           | `STRING`    | Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.                            |
  | `in_interestAccumulated` | `STRING`    | Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.                    |
  | `in_borrowIndex`         | `STRING`    | Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.     |
  | `in_totalBorrows`        | `STRING`    | Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | in\_cashPrior          | in\_borrowIndex     | block\_timestamp         | in\_totalBorrows      | transaction\_hash                                                  | in\_interestAccumulated |
  | ------------------------------------------ | ------- | ---------- | ------------- | ---------------------- | ------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ | ----------------------- |
  | 0x246a35e79a3a0618535a469adaf5091caa9f7e88 | false   | 4          | 282955549     | 1145018934089404353074 | 1003335737423548571 | 2024-12-09T11:16:38.000Z | 202722014911259806374 | 0x912f1e7d8d67b5d6edb09c7b4b508b0213fcc6bec8e065fb244d8d18efffd399 | 3470698136689277        |
  | 0x246a35e79a3a0618535a469adaf5091caa9f7e88 | false   | 8          | 282988190     | 1145025462792081363015 | 1003339263131297560 | 2024-12-09T13:33:04.000Z | 202722727273585002555 | 0x84518c25abcc16395bdd0ccfc0edb9cec9919d0d4e121706b7f528badedf3fc1 | 712362325196181         |
  | 0x246a35e79a3a0618535a469adaf5091caa9f7e88 | false   | 28         | 282796468     | 1145018918304091177660 | 1003318559834445217 | 2024-12-09T00:11:54.000Z | 202718544213123117097 | 0xf4d7d9df1582ed1860a5cc2c0b89ad4d985a94de6d023ca57e861574ce3c7d6a | 469208775567208         |
</Accordion>

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

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

***

### VToken\_BadDebtIncreased\_event

Venus Protocol bad debt increase events emitted when borrower positions become undercollateralized and accumulate uncollectable debt. Records borrower address, previous and new bad debt totals, and delta amount for tracking protocol insolvency risk across VToken markets.

<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_borrower`      | `STRING`    | Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_badDebtDelta`  | `STRING`    | Amount of bad debt added in the event. Numeric string representing the token amount in smallest denomination.                                        |
  | `in_badDebtOld`    | `STRING`    | Previous total amount of bad debt before the event. Numeric string representing the token amount in smallest denomination.                           |
  | `in_badDebtNew`    | `STRING`    | Updated total amount of bad debt after the event. Numeric string representing the token amount in smallest denomination.                             |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

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

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

***

### VToken\_BadDebtRecovered\_event

Venus Protocol bad debt recovery events tracking changes in VToken contract bad debt balances. Records the previous and updated bad debt amounts when protocol reserves are used to cover uncollateralized positions.

<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_badDebtOld`    | `STRING`    | Previous total amount of bad debt before the event. Numeric string representing the token amount in smallest denomination.                           |
  | `in_badDebtNew`    | `STRING`    | Updated total amount of bad debt after the event. Numeric string representing the token amount in smallest denomination.                             |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

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

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

***

### VToken\_Borrow\_event

Borrow events emitted by Venus Protocol VToken contracts when users borrow assets against their collateral. Records borrower address, borrowed amount, individual account debt, and aggregate market debt in smallest token units for DeFi lending 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_borrower`       | `STRING`    | Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_borrowAmount`   | `STRING`    | Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.                                                        |
  | `in_accountBorrows` | `STRING`    | Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.                                 |
  | `in_totalBorrows`   | `STRING`    | Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_borrower                               | block\_number | block\_timestamp         | in\_borrowAmount | in\_totalBorrows | transaction\_hash                                                  | in\_accountBorrows |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ---------------- | ---------------- | ------------------------------------------------------------------ | ------------------ |
  | 0x7d8609f8da70ff9027e9bc5229af4f6727662707 | false   | 5          | 0x68cfbc52c6e57662644d801e278b6d01d1788643 | 231664654     | 2024-07-13T05:03:09.000Z | 120000000        | 950617209520     | 0xff203c07ad77949ac86147d5bf65f610a002d540664b5640cf7a6d4b83b8a0ec | 120000000          |
  | 0x7d8609f8da70ff9027e9bc5229af4f6727662707 | false   | 4          | 0x4813762f078cd5d279df1e275147b73df8bb715c | 231900284     | 2024-07-13T21:26:00.000Z | 200000000        | 959685697772     | 0xddd986b785d79de4186822011458f8fe5f7b64701ccd6e4efd3c948e20b6bc61 | 1204219337         |
  | 0x7d8609f8da70ff9027e9bc5229af4f6727662707 | false   | 15         | 0x03ec773a93e9bb5fd47c5f5ff68dba7ba4ef2091 | 231651873     | 2024-07-13T04:09:52.000Z | 250000000        | 950490831646     | 0xb2ec369d9658faf9461610215d48aacdf33819993c4b9066d0e21a22dae78f42 | 1158201548         |
</Accordion>

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

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

***

### VToken\_LiquidateBorrow\_event

Liquidation events emitted when undercollateralized borrowers have their debt repaid by liquidators in exchange for seized vToken collateral. Records borrower address, liquidator address, repayment amount, seized collateral quantity, and vToken collateral contract address for risk monitoring and liquidation 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_liquidator`       | `STRING`    | Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.                                                      |
  | `in_borrower`         | `STRING`    | Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                      |
  | `in_repayAmount`      | `STRING`    | Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.                                                             |
  | `in_vTokenCollateral` | `STRING`    | Contract address of the vToken representing the collateral being seized in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.                      |
  | `in_seizeTokens`      | `STRING`    | Quantity of collateral tokens seized from the borrower during liquidation. Numeric string representing the amount in the smallest unit of the collateral token. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_borrower                               | block\_number | in\_liquidator                             | in\_repayAmount | in\_seizeTokens | block\_timestamp         | transaction\_hash                                                  | in\_vTokenCollateral                       |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------------------------ | --------------- | --------------- | ------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
  | 0xb9f9117d4200dc296f9acd1e8be1937df834a2fd | false   | 39         | 0xa0f75a1b90a9f39f8d0a3a8881ba766a36cc295c | 290208114     | 0x3b994b48922450e6cf0f415bdf337d1df7183ffa | 837140195       | 125872604756    | 2024-12-30T14:35:28.000Z | 0x779273c318ac423087df92736596e9333cfa71ea761aca2c9b69d179ddd89622 | 0xaeb0fed69354f34831fe1d16475d9a83ddacada6 |
  | 0xb9f9117d4200dc296f9acd1e8be1937df834a2fd | false   | 25         | 0xe78c74b9b1acaed335159b9826e8d567874113ba | 286498730     | 0x83b2570ea359f11e9851b8be3aac1fe66a73f307 | 67847518        | 9659799986      | 2024-12-19T20:04:34.000Z | 0xe9ff89b11b2960874f53a42fe0beed52c13e6e01b7d7db90c462d49849c9f370 | 0xaeb0fed69354f34831fe1d16475d9a83ddacada6 |
  | 0xb9f9117d4200dc296f9acd1e8be1937df834a2fd | false   | 28         | 0x79bced41b1ade18bcf2fb849b0f9f5219f4eae28 | 302010743     | 0x3b994b48922450e6cf0f415bdf337d1df7183ffa | 358770828       | 82256785372     | 2025-02-02T23:11:27.000Z | 0x3e8b678821671f9bd03df2a6dceb454d3429cb3afda512a180ee444eb21b33cc | 0xaeb0fed69354f34831fe1d16475d9a83ddacada6 |
</Accordion>

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

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

***

### VToken\_Mint\_event

Variable rate debt token mint events from lending protocols. Records debt token issuance with borrower address, borrowed amount, interest rate index, and accrued interest at the time of minting.

<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_minter`         | `STRING`    | Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.                              |
  | `in_mintAmount`     | `STRING`    | Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.                                              |
  | `in_mintTokens`     | `STRING`    | Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.                                 |
  | `in_accountBalance` | `STRING`    | Account balance of interest-bearing VTokens held by the minter or redeemer after the mint or redeem operation. Numeric string representing token amount in smallest denomination. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_minter                                 | log\_index | block\_number | in\_mintAmount      | in\_mintTokens | block\_timestamp         | transaction\_hash                                                  | in\_accountBalance |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------- | ------------------- | -------------- | ------------------------ | ------------------------------------------------------------------ | ------------------ |
  | 0xb9f9117d4200dc296f9acd1e8be1937df834a2fd | false   | 0x069fec82dd93d84d1b7d35d791683c2db9f94046 | 11         | 282989962     | 1000                | 97046          | 2024-12-09T13:40:33.000Z | 0xac24485de055dfb9f3fa7aaee5eea1c278bad2d4c1bdea05076d66a7bf26e252 | 97046              |
  | 0x7d8609f8da70ff9027e9bc5229af4f6727662707 | false   | 0x125c697e92484f0016c114eebca98ec5f9d71ec4 | 8          | 282956928     | 1930230             | 187587814      | 2024-12-09T11:22:22.000Z | 0x323f6d3f70cd74fd1d1d2f9ac65909407435ad84f9482eb43349085dfc2dbc8b | 3994290947         |
  | 0xaeb0fed69354f34831fe1d16475d9a83ddacada6 | false   | 0x125c697e92484f0016c114eebca98ec5f9d71ec4 | 9          | 282956985     | 1806166956158643232 | 179155737      | 2024-12-09T11:22:36.000Z | 0x73cbc1d19d2d5796252351cc5fbb1163cfa5bb18ec851a78954a4998599a5b2e | 2532915102         |
</Accordion>

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

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

***

### VToken\_NewReserveFactor\_event

Reserve factor configuration change events from Venus Protocol VToken contracts. Captures old and new reserve factor values as 18-decimal mantissas, tracking protocol-level parameter adjustments for lending market reserves.

<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_oldReserveFactorMantissa` | `STRING`    | Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.                                   |
  | `in_newReserveFactorMantissa` | `STRING`    | Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.                                                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  | in\_newReserveFactorMantissa | in\_oldReserveFactorMantissa |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ | ---------------------------- | ---------------------------- |
  | 0x39d6d13ea59548637104e40e729e4aabe27fe106 | false   | 5          | 245908529     | 2024-08-23T15:03:13.000Z | 0x0e6619b061a95bff645a9308c30e704d8c39c97c6dc4cb0760e0cabdf853edd9 | 200000000000000000           | 0                            |
  | 0x246a35e79a3a0618535a469adaf5091caa9f7e88 | false   | 9          | 245908467     | 2024-08-23T15:02:57.000Z | 0x3003ffe081edf951e020c78f791875839d43f31a8ba4cb65dcc4337ed6e23144 | 250000000000000000           | 0                            |
  | 0x9df6b5132135f14719696bbae3c54bab272fdb16 | false   | 12         | 245908423     | 2024-08-23T15:02:46.000Z | 0x7cf8e03bf05dd89ddb94f46c4864b82d0b50aa5a69a542077fd02d2459c583b0 | 250000000000000000           | 0                            |
</Accordion>

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

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

***

### VToken\_Redeem\_event

VToken redemption events emitted when users withdraw underlying assets from Venus Protocol lending pools by burning interest-bearing VTokens. Records redeemer address, VToken amount burned, underlying asset amount received, and resulting VToken balance for tracking lending protocol withdrawals and liquidity 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_redeemer`       | `STRING`    | Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.                                                                                              |
  | `in_redeemAmount`   | `STRING`    | Amount of underlying asset tokens withdrawn from the lending pool during redemption.                                                                                                                          |
  | `in_redeemTokens`   | `STRING`    | Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets. |
  | `in_accountBalance` | `STRING`    | Account balance of interest-bearing VTokens held by the minter or redeemer after the mint or redeem operation. Numeric string representing token amount in smallest denomination.                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_redeemer                               | block\_number | block\_timestamp         | in\_redeemAmount     | in\_redeemTokens | transaction\_hash                                                  | in\_accountBalance |
  | ------------------------------------------ | ------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | -------------------- | ---------------- | ------------------------------------------------------------------ | ------------------ |
  | 0x68a34332983f4bf866768dd6d6e638b02ef5e1f0 | false   | 28         | 0x9a7477aa0c89e33147ffcf6f0b2b78ab1313af5a | 240393230     | 2024-08-07T13:49:32.000Z | 31918953166011417531 | 3187462599       | 0xd42183482e204ec056d6c11c6c7092a61424090507038411c9d02164dcfc4c6a | 5156               |
  | 0x68a34332983f4bf866768dd6d6e638b02ef5e1f0 | false   | 37         | 0xd9f80cb81164163a90745477ce1b2befb246a33f | 240486480     | 2024-08-07T20:21:36.000Z | 2100000150614460918  | 209707486        | 0x5ac9e0529ecf4b74fbd6b0e12c0a49311cb91b17213414a2de222d64a9813175 | 1                  |
  | 0x7d8609f8da70ff9027e9bc5229af4f6727662707 | false   | 51         | 0xa9ca2e36abd617f3062110802b499bd45fa1574a | 240521383     | 2024-08-07T22:47:49.000Z | 70318266             | 6969474569       | 0x7052cb0d7d869d68fffcc767fd25033c51c1f32e658b833cd4526c3882a54818 | 337                |
</Accordion>

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

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

***

### VToken\_RepayBorrow\_event

Borrow repayment events from Venus Protocol VToken contracts recording debt reduction transactions. Contains payer and borrower addresses, repayment amount, updated account-level and market-level borrow balances for tracking loan activity and protocol solvency.

<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_payer`          | `STRING`    | Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.              |
  | `in_borrower`       | `STRING`    | Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.                                           |
  | `in_repayAmount`    | `STRING`    | Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.                                                  |
  | `in_accountBorrows` | `STRING`    | Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.                                 |
  | `in_totalBorrows`   | `STRING`    | Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.                                |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_payer                                  | log\_index | in\_borrower                               | block\_number | in\_repayAmount      | block\_timestamp         | in\_totalBorrows      | transaction\_hash                                                  | in\_accountBorrows   |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ------------------------------------------ | ------------- | -------------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ | -------------------- |
  | 0x68a34332983f4bf866768dd6d6e638b02ef5e1f0 | false   | 0x35e2a11f743a43f00381a0aeb6764322ef1eb788 | 5          | 0x35e2a11f743a43f00381a0aeb6764322ef1eb788 | 227024877     | 36757575299551073    | 2024-06-29T17:57:06.000Z | 202675432787051741888 | 0x2f5aea6a5ec20935e67ef7e0d5eef0c2a6103157be8a0ab84922c5d43aaf9f0c | 19981741377562336636 |
  | 0x68a34332983f4bf866768dd6d6e638b02ef5e1f0 | false   | 0x35e2a11f743a43f00381a0aeb6764322ef1eb788 | 13         | 0x35e2a11f743a43f00381a0aeb6764322ef1eb788 | 227020824     | 10700000000000000000 | 2024-06-29T17:40:15.000Z | 191712059398916764341 | 0x06586f669da8939f5f9ba0de4835adab4336b6e67a5e23cada6c127e00d71ef6 | 9018490979929192594  |
  | 0x68a34332983f4bf866768dd6d6e638b02ef5e1f0 | false   | 0x9eea8f1796e23386edd37a1ec45393a93a975296 | 6          | 0x9eea8f1796e23386edd37a1ec45393a93a975296 | 226851455     | 1400312789704780977  | 2024-06-29T05:54:24.000Z | 201606117280378487978 | 0x74c04083bc43c5329c49c96a0cbda28444870b1ec6aec350071288e9798d2345 | 0                    |
</Accordion>

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

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

***

### VToken\_ReservesAdded\_event

Reserve addition events from Venus Protocol VToken contracts recording when protocol reserves are increased. Tracks the benefactor address, amount added, and resulting total reserves for lending market 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_benefactor`       | `STRING`    | Address of the account that provided or contributed the reserves being added to the lending market contract. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_addAmount`        | `STRING`    | Amount of reserves added to the lending market contract. String-encoded integer representing the token amount in smallest denomination.                                        |
  | `in_newTotalReserves` | `STRING`    | Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination. |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

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

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

***

### VToken\_SpreadReservesReduced\_event

Event emitted when protocol reserves are withdrawn from a Venus Protocol lending market (vToken contract) and transferred to the protocol share reserve address. Records the reduction amount and updated reserve balances for protocol treasury management tracking.

<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_protocolShareReserve` | `STRING`    | Contract address of the protocol share reserve that receives the reduced reserves. Hex-encoded, 0x-prefixed, 42-character string.                                              |
  | `in_reduceAmount`         | `STRING`    | Amount of reserves withdrawn from the lending market contract. String-encoded integer representing the token amount in smallest denomination.                                  |
  | `in_newTotalReserves`     | `STRING`    | Updated total reserves held by the lending market contract after reserves are added or reduced. String-encoded integer representing the token amount in smallest denomination. |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | in\_reduceAmount     | transaction\_hash                                                  | in\_newTotalReserves | in\_protocolShareReserve                   |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | -------------------- | ------------------------------------------------------------------ | -------------------- | ------------------------------------------ |
  | 0x7d8609f8da70ff9027e9bc5229af4f6727662707 | false   | 2          | 254246792     | 2024-09-16T21:51:50.000Z | 21829160             | 0xa714cb2ce4c8f67b417bacc2bdcf5fe111586dace9ea9f2d6e4af609f1227fa6 | 0                    | 0xf9263eaf7eb50815194f26accab6765820b13d41 |
  | 0xaeb0fed69354f34831fe1d16475d9a83ddacada6 | false   | 2          | 254179671     | 2024-09-16T17:07:50.000Z | 14742356665189811578 | 0x2a251611ac50b775021a598cfafd121fb01e2daa27b4b5106151b58c85a085ed | 0                    | 0xf9263eaf7eb50815194f26accab6765820b13d41 |
  | 0xb9f9117d4200dc296f9acd1e8be1937df834a2fd | false   | 2          | 254274152     | 2024-09-16T23:47:31.000Z | 19993583             | 0x0ad8c6f5f9082d0eb8bbc58ca88543058ff05af3c6e7f9ff0a600360acb2d461 | 0                    | 0xf9263eaf7eb50815194f26accab6765820b13d41 |
</Accordion>

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

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

***