venus_v1_optimism

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.

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.

Sample Data

address	removed	log_index	block_number	in_comptroller	block_timestamp	in_vTokenAddress	transaction_hash
0x147780799840d541c1d7c998f0cba996d11d62bb	false	259	126660792	0x5593ff68be84c966821eef5f0a988c285d5b7cec	2024-10-14T15:39:21.000Z	0x6b846e3418455804c1920fa4cc7a31a51c659a2d	0xadae76aa6cbd6fd4e330b1225e6349a7bb22e75ae08df081269f90384e1ef115
0x147780799840d541c1d7c998f0cba996d11d62bb	false	219	126660792	0x5593ff68be84c966821eef5f0a988c285d5b7cec	2024-10-14T15:39:21.000Z	0x66d5ae25731ce99d46770745385e662c8e0b4025	0xadae76aa6cbd6fd4e330b1225e6349a7bb22e75ae08df081269f90384e1ef115
0x147780799840d541c1d7c998f0cba996d11d62bb	false	277	126660792	0x5593ff68be84c966821eef5f0a988c285d5b7cec	2024-10-14T15:39:21.000Z	0x1c9406ee95b7af55f005996947b19f91b6d55b15	0xadae76aa6cbd6fd4e330b1225e6349a7bb22e75ae08df081269f90384e1ef115

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	in_pool	removed	log_index	block_number	in_comptroller	block_timestamp	transaction_hash
0x147780799840d541c1d7c998f0cba996d11d62bb	{“name”:“Core”,“creator”:“0x2e94dd14e81999cdbf5dede31938bed7308354b3”,“blockPosted”:“126660792”,“comptroller”:“0x5593ff68be84c966821eef5f0a988c285d5b7cec”,“timestampPosted”:“1728920361”}	false	178	126660792	0x5593ff68be84c966821eef5f0a988c285d5b7cec	2024-10-14T15:39:21.000Z	0xadae76aa6cbd6fd4e330b1225e6349a7bb22e75ae08df081269f90384e1ef115

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	64	129594527	2554921718	1007568300384573847	2024-12-21T13:30:31.000Z	2493670206	0x877ddbc8d38b1ecbef3ebdafa43c204b6537e5107dfdf77a6b21d20ca63b2d0d	66364
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	63	129601960	2553921718	1007584435726098406	2024-12-21T17:38:17.000Z	2494710156	0xdf4d1711f0359628ac67659a2b2a6f7d27096ba4a87c59943157efddab857b41	39950
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	66	129582169	2655954962	1007541485858955612	2024-12-21T06:38:35.000Z	2392603842	0xbf4c962b631391a4a2476d1673340f60ba95a481c6b19471eaf73cc49bc67227	156247

Example Query

Query with partition filter

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

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.

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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

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.

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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x37ac9731b0b02df54975cd0c7240e0977a051721	false	50	0x557f1f3b1e658b01d35294d79f6d9fa76259218f	131993848	2025-02-15T02:27:53.000Z	200000	3801900801	0x2648e4f1c390b678b27db32e0aa685afaff6f338838d0933223a7e41e79c3601	200000
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	67	0x557f1f3b1e658b01d35294d79f6d9fa76259218f	131993819	2025-02-15T02:26:55.000Z	200000	3978888971	0x7e18c784dcdb865393d7cf318ba6cc33118d66c1c686b0fa1e6c7ec250d82fbb	200000
0x6b846e3418455804c1920fa4cc7a31a51c659a2d	false	46	0x557f1f3b1e658b01d35294d79f6d9fa76259218f	131993873	2025-02-15T02:28:43.000Z	100000000000000000	19396057953723898344	0x6c55f9077b50252500e1eb8273e56f648cab1dac1625551e7c3de46db97107c8	100000000000000000

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	log_index	in_borrower	block_number	in_liquidator	in_repayAmount	in_seizeTokens	block_timestamp	transaction_hash	in_vTokenCollateral
0x37ac9731b0b02df54975cd0c7240e0977a051721	false	34	0xe78c74b9b1acaed335159b9826e8d567874113ba	130062250	0x6af964c6a71be2ee0c3fdecf5fc82ec97e9b87f9	60311464	3818484828	2025-01-01T09:21:17.000Z	0xce5e1543e4ff68c388305093675ba69b51b53a65074d8554c8949cb27904b624	0x6b846e3418455804c1920fa4cc7a31a51c659a2d
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	46	0xbd5678481143b4f757d240deef122a954f480a05	130584931	0x6af964c6a71be2ee0c3fdecf5fc82ec97e9b87f9	623755721	42661598196	2025-01-13T11:43:59.000Z	0x8e4704edc6038546d7475a1a5638ac5bafd25e3200f937bdb48ce8ec78082fd1	0x6b846e3418455804c1920fa4cc7a31a51c659a2d
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	10	0xbd5678481143b4f757d240deef122a954f480a05	131181811	0xc1d089c79deb39975246579f8303d9c6fb5ffab7	345469578	27937921952	2025-01-27T07:19:59.000Z	0x03de87cacff6a02f515e2629041b1fd2ec9f94ad109a1dd865fba9de2bd2d916	0x6b846e3418455804c1920fa4cc7a31a51c659a2d

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash	in_accountBalance
0x6b846e3418455804c1920fa4cc7a31a51c659a2d	false	0x51470836d210d34f2e3a3d8cddb30e2291196655	12	129400642	4019250983988008410	401925090	2024-12-17T01:47:41.000Z	0xea2ce0fff7c1a46218dacab4970550787a1c3f28226a1d518057964ed2cc7ab8	1268142958
0x66d5ae25731ce99d46770745385e662c8e0b4025	false	0x3e39cbb33396979158a346fc1b19609064099ecd	4	132227584	122999999997	12	2025-02-20T12:19:05.000Z	0x46be6dce8ec68ff8adbde71411c6448cf5f0a324aa658ffa2854929324bd28f5	12
0x66d5ae25731ce99d46770745385e662c8e0b4025	false	0xb58b24e1929489855693f02bce2b7d6707c20300	26	132218030	102000000000000000	10197631	2025-02-20T07:00:37.000Z	0x17ba1010ee521ef23aaa7898db20a96d69d536890f07624e524fb5647a2546b3	10197631

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	153	126173388	2024-10-03T08:52:33.000Z	0xe494f3f036b970f65ac2105a7f3b1f6533f76b02a166796ec647daf8879ea03a	100000000000000000
0x37ac9731b0b02df54975cd0c7240e0977a051721	false	25	126052055	2024-09-30T13:28:07.000Z	0x8db04859be55d26e8dbb3c95f1d1640978ba0d14eb320c7fad79e704b98a484c	100000000000000000
0x6b846e3418455804c1920fa4cc7a31a51c659a2d	false	30	126052059	2024-09-30T13:28:15.000Z	0xec33378223dc15ad5a6dcc604fc8a91c14055cc4ee601fe45bb3730d9d70840b	200000000000000000

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash	in_accountBalance
0x66d5ae25731ce99d46770745385e662c8e0b4025	false	80	0x00951c1d1241f9be0ef5a55a1755fa49c5629ebd	127873796	2024-11-11T17:32:49.000Z	390000003382253785	38995401	0xafc520adf880bf5c14e03fb41cfb1a9a49c34c44e69e0ec08005bfa680ce5b89	20997555
0x66d5ae25731ce99d46770745385e662c8e0b4025	false	19	0x00951c1d1241f9be0ef5a55a1755fa49c5629ebd	127877723	2024-11-11T19:43:43.000Z	210000404155739445	20997555	0xa616b687fc10a035e63ca27eb1fe671c47edd3b02bdfd0e2791d1f8ffff6bd40	0
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	89	0x88ffd53ace567767b7719b0e5ea7b823bc34687f	131175760	2025-01-27T03:58:17.000Z	500948414	49549172666	0x9ef71d4424ad972f416b448eaa750b0ee946965039ce4dc60b8a47b2953f529f	0

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	0x02d10f41f3a88614c63f718272c60da7bf37a53e	87	0x02d10f41f3a88614c63f718272c60da7bf37a53e	128381361	2071	2024-11-23T11:31:39.000Z	3462878518	0x5d10c0eea2ab0b4fda8e62a3bdf3541c93f83c70f27c1db7f6db49e1fb756443	0
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	0x02d10f41f3a88614c63f718272c60da7bf37a53e	74	0x02d10f41f3a88614c63f718272c60da7bf37a53e	128363563	1600000000	2024-11-23T01:38:23.000Z	3462700618	0x3adc874268a2f16ac95be2fbdb8a1331e262e05a446ee652f63a72204edd66a2	2071
0x37ac9731b0b02df54975cd0c7240e0977a051721	false	0x02d10f41f3a88614c63f718272c60da7bf37a53e	38	0x02d10f41f3a88614c63f718272c60da7bf37a53e	128381382	1650	2024-11-23T11:32:21.000Z	4595987448	0x71037e5b30d84e5dcaab3c73dbd94d4e80d274ce919b4d2f39cf7264466235cc	0

Example Query

Query with partition filter

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

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.

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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

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.

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.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_reduceAmount	transaction_hash	in_protocolShareReserve
0x6b846e3418455804c1920fa4cc7a31a51c659a2d	false	492	127971060	2024-11-13T23:34:57.000Z	141618209	0xec278218fe68f94086d4b52da42fab2798738c374442501b9c86c8279226b544	0x735ed037cb0dacf90b133370c33c08764f88140a
0x66d5ae25731ce99d46770745385e662c8e0b4025	false	49	131630596	2025-02-06T16:39:29.000Z	9506325304	0x043a01bd38913740c797cab6d2f59ef83948fe65d34be866e5ea4e4d3b8b3afa	0x735ed037cb0dacf90b133370c33c08764f88140a
0x1c9406ee95b7af55f005996947b19f91b6d55b15	false	6	127171088	2024-10-26T11:09:13.000Z	7921	0x7bbd73078ebfa8ceb31ebc4a5031619f167e525935b17d5b07ee0f00ef6d4d1b	0x735ed037cb0dacf90b133370c33c08764f88140a

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

PoolRegistry_MarketAdded_event

PoolRegistry_PoolRegistered_event

VToken_AccrueInterest_event

VToken_BadDebtIncreased_event

VToken_BadDebtRecovered_event

VToken_Borrow_event

VToken_LiquidateBorrow_event

VToken_Mint_event

VToken_NewReserveFactor_event

VToken_Redeem_event

VToken_RepayBorrow_event

VToken_ReservesAdded_event

VToken_SpreadReservesReduced_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​PoolRegistry_MarketAdded_event

​PoolRegistry_PoolRegistered_event

​VToken_AccrueInterest_event

​VToken_BadDebtIncreased_event

​VToken_BadDebtRecovered_event

​VToken_Borrow_event

​VToken_LiquidateBorrow_event

​VToken_Mint_event

​VToken_NewReserveFactor_event

​VToken_Redeem_event

​VToken_RepayBorrow_event

​VToken_ReservesAdded_event

​VToken_SpreadReservesReduced_event

Tables

PoolRegistry_MarketAdded_event

PoolRegistry_PoolRegistered_event

VToken_AccrueInterest_event

VToken_BadDebtIncreased_event

VToken_BadDebtRecovered_event

VToken_Borrow_event

VToken_LiquidateBorrow_event

VToken_Mint_event

VToken_NewReserveFactor_event

VToken_Redeem_event

VToken_RepayBorrow_event

VToken_ReservesAdded_event

VToken_SpreadReservesReduced_event