venus_v1_base

Tables

Comptroller_borrowVerify_function

Venus Protocol Comptroller borrow verification function calls recording post-borrow validation checks. Contains vToken market address, borrower address, and borrowed amount for compliance monitoring and risk management 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. 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_borrowAmount`	`STRING`	Amount borrowed in the transaction. Denominated in the smallest unit of the underlying token.

Sample Data

gas	status	gas_used	in_vToken	signature	to_address	in_borrower	block_number	from_address	trace_address	block_timestamp	in_borrowAmount	transaction_hash
221750	true	15006	0x3cb752d175740043ec463673094e06acda2f9a2e	0x5c778605	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x2fc9e865e47684fb1b4008203e6176d774a8a663	31593200	0x3cb752d175740043ec463673094e06acda2f9a2e	1,5	2025-06-15T08:22:27.000Z	23000000	0x2db978a397d1d8bac027f4ee7969be6b45369250b96575314191c53d95d7e0da
220708	true	15006	0x133d3bcd77158d125b75a17cb517ffd4b4be64c5	0x5c778605	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x6987a1f144f8d1e1275475d1fe391b8d94a68435	37041270	0x133d3bcd77158d125b75a17cb517ffd4b4be64c5	1,8	2025-10-19T11:04:47.000Z	1500000000000000	0x9b5dec56b2b682801c53ae1e70d619fad242597a3cb501a5002fd1c84ccb61ad
198150	true	15006	0x133d3bcd77158d125b75a17cb517ffd4b4be64c5	0x5c778605	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0xc172b23e30cc3a18b349226ebc0b1381599471fd	35956587	0x133d3bcd77158d125b75a17cb517ffd4b4be64c5	1,5	2025-09-24T08:28:41.000Z	16000000000000000	0xf6fd46941be6ce07baf80161a076d0097acff3486b45b16f45fb64e9ef8f4018

Example Query

Query with partition filter

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

Comptroller_liquidateAccount_function

Function call records for Venus Protocol Comptroller liquidation operations containing borrower addresses and liquidation order arrays specifying vToken collateral, vToken borrowed, and repay amounts. Used for tracking undercollateralized position liquidations across Venus lending 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_orders`	`ARRAY<STRUCT<vTokenCollateral STRING, vTokenBorrowed STRING, repayAmount STRING>>`	Array of order or liquidation instruction structures specifying the tokens and amounts involved in the transaction.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Comptroller_liquidateBorrowVerify_function

Venus protocol comptroller verification function calls for liquidation operations. Records borrower, liquidator, repayment amounts, and collateral seizure calculations during debt liquidation events.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vTokenBorrowed`	`STRING`	Contract address of the vToken representing the borrowed asset in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_vTokenCollateral`	`STRING`	Contract address of the vToken representing the collateral being seized in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`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_actualRepayAmount`	`STRING`	Amount of tokens repaid in the transaction. Numeric string representing the quantity in the smallest unit of the underlying asset.
`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

gas	value	status	gas_used	signature	to_address	in_borrower	block_number	from_address	in_liquidator	trace_address	in_seizeTokens	block_timestamp	transaction_hash	in_vTokenBorrowed	in_vTokenCollateral	in_actualRepayAmount
228921	0	true	6389	0x47ef3b3b	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0xa252bd92293b0eb9beb1c2cf72f794f8a3a54348	25879227	0x3cb752d175740043ec463673094e06acda2f9a2e	0x2e609abcdf2025fd6793433cc200cf956a9d9a42	9,0,4,3,1,11	46800573	2025-02-03T01:56:41.000Z	0x25cd9d9e6b0603d8a2ba7d2f53144a77599a3678ede4df4fa95fbfd2f60efb56	0x3cb752d175740043ec463673094e06acda2f9a2e	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	1047297421

Example Query

Query with partition filter

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

Comptroller_MarketEntered_event

Event logs emitted when an account enters a lending market in a Compound-based protocol, enabling the account to use deposited assets as collateral for borrowing. Records the account address and market token address (cToken, mToken, or vToken) for tracking collateral activation across lending protocols.

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_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_vToken	log_index	in_account	block_number	block_timestamp	transaction_hash
0x0c7973f9598aa62f9e03b94e92c967fd5437426c	false	0x3cb752d175740043ec463673094e06acda2f9a2e	127	0x5d9717b0817be823c25d56d5e66165deb802c33b	25823406	2025-02-01T18:55:59.000Z	0x49c721388cade1047e4061dcdb14cf9c17a9a230978dc619afeff791e4aa785a
0x0c7973f9598aa62f9e03b94e92c967fd5437426c	false	0x3cb752d175740043ec463673094e06acda2f9a2e	249	0xab9e62d95c93541200134d3bc5bdf4114f9e04d1	25823784	2025-02-01T19:08:35.000Z	0x7267f0f1812848e0be9c509f314d08277eea8d239d83c88a013b73070e9a3c54
0x0c7973f9598aa62f9e03b94e92c967fd5437426c	false	0x3cb752d175740043ec463673094e06acda2f9a2e	100	0x3bad626c28689fa5a4b1874a490f09335f0b84e0	25813719	2025-02-01T13:33:05.000Z	0x75f517f925b9ddd258d5d51f17b59471cee38b0ca81d9df05544c43169725ed5

Example Query

Query with partition filter

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

Comptroller_MarketExited_event

Event logs recording when an account exits a lending market in the Comptroller contract. Contains account address and corresponding token market (cToken or vToken) that was exited.

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_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_vToken	log_index	in_account	block_number	block_timestamp	transaction_hash
0x0c7973f9598aa62f9e03b94e92c967fd5437426c	false	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	62	0xffaee255f06aeea746e437f2f2ba851c117e2dbe	24216678	2024-12-26T14:18:23.000Z	0x9d84500dd9c26b3f5bb800ce2ad7368eda638cfe452e72cfc5c4d29723694a41
0x0c7973f9598aa62f9e03b94e92c967fd5437426c	false	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	147	0x2e15ad946e23f1a72e9322862c85140286f648d7	26639398	2025-02-20T16:15:43.000Z	0x6d68aa48b62d9f7c16cbf7b54a8c391f3e817c3a3f1c9c1fc08fbbe6a3f0de1e
0x0c7973f9598aa62f9e03b94e92c967fd5437426c	false	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	144	0xf614701965b67931653aa464667bc698ed4ee728	26626967	2025-02-20T09:21:21.000Z	0xd673a1ca7158d75a4db6440aab3f44bc40a67a817095e97e6f847a96738aeb71

Example Query

Query with partition filter

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

Comptroller_mintVerify_function

Venus protocol comptroller verification records for mint operations. Contains minter address, vToken market, actual deposit amount, and resulting interest-bearing tokens minted for lending position validation.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`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_actualMintAmount`	`STRING`	Actual amount of underlying asset deposited into the Venus protocol during the mint operation. 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.

Sample Data

gas	status	gas_used	in_minter	in_vToken	signature	to_address	block_number	from_address	in_mintTokens	trace_address	block_timestamp	transaction_hash	in_actualMintAmount
110437	true	14956	0x5f0828075b1a9038f4b53d75126706b119ea8260	0x3cb752d175740043ec463673094e06acda2f9a2e	0x41c728b9	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	30334205	0x3cb752d175740043ec463673094e06acda2f9a2e	11892851	1,7	2025-05-17T04:55:57.000Z	0xca6e819c74578e8397844613262136e6ee9f9ccf69f70aa44fd6fbe8d4eefe92	120000
110437	true	14956	0x4dab6da6846f82c93354ae90f8b56993efb1e5b1	0x3cb752d175740043ec463673094e06acda2f9a2e	0x41c728b9	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	30333931	0x3cb752d175740043ec463673094e06acda2f9a2e	10901782	1,7	2025-05-17T04:46:49.000Z	0x91198f5f481cce7dc52266823b5f560501c08a3a80570de8fe9b2286c06747b1	110000
94444	true	14956	0x10b64b0470b0905b0f9d62d163489a0f3054c95b	0x3cb752d175740043ec463673094e06acda2f9a2e	0x41c728b9	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	30350983	0x3cb752d175740043ec463673094e06acda2f9a2e	155526478	1,7	2025-05-17T14:15:13.000Z	0xb7706e43aad65cc3d5e3a48b9ac6581fa3baa3416586b46f3322755577a4be6d	1569299

Example Query

Query with partition filter

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

Comptroller_redeemVerify_function

Venus protocol comptroller verification calls for redemption transactions. Records validation checks performed when users withdraw underlying assets by burning vTokens in lending 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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`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.

Sample Data

gas	status	gas_used	in_vToken	signature	to_address	in_redeemer	block_number	from_address	trace_address	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
181733	false	14957	0x3cb752d175740043ec463673094e06acda2f9a2e	0x51dff989	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x8b2e3c144f617de8f1aeca62b1da4fafb527e4ef	35610761	0x3cb752d175740043ec463673094e06acda2f9a2e	0,4,1,6	2025-09-16T08:21:09.000Z	100113	9835108	0x1bf873df80a7606ec3920f84a02f5ff96a50b167c05cd5f5edc0dfadd130a7b6
186760	false	14957	0x3cb752d175740043ec463673094e06acda2f9a2e	0x51dff989	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x8b2e3c144f617de8f1aeca62b1da4fafb527e4ef	35617958	0x3cb752d175740043ec463673094e06acda2f9a2e	0,4,1,6	2025-09-16T12:21:03.000Z	100115	9835108	0x61e0cc581e11dc52347a8916fb796ae3abad09d1715cc4f516766df4cf697f35
186760	false	14957	0x3cb752d175740043ec463673094e06acda2f9a2e	0x51dff989	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x8b2e3c144f617de8f1aeca62b1da4fafb527e4ef	35605358	0x3cb752d175740043ec463673094e06acda2f9a2e	0,4,1,6	2025-09-16T05:21:03.000Z	100112	9835187	0x3aa36b496cd1c77758fb939a1b236edc8925577948e63136f065431ac50f3e65

Example Query

Query with partition filter

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

Comptroller_repayBorrowVerify_function

Post-execution verification calls for borrow repayment transactions in Venus Protocol comptroller contracts. Records validation parameters including borrower address, payer address, vToken market, actual repayment amount, and borrower index for ensuring repayment compliance with protocol rules.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`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_actualRepayAmount`	`STRING`	Amount of tokens repaid in the transaction. Numeric string representing the quantity in the smallest unit of the underlying asset.
`in_borrowerIndex`	`STRING`	Borrow index value of the borrower at the time of the repayment transaction. Numeric string representing the scaled interest accumulation factor.

Sample Data

gas	status	gas_used	in_payer	in_vToken	signature	to_address	in_borrower	block_number	from_address	trace_address	block_timestamp	in_borrowerIndex	transaction_hash	in_actualRepayAmount
115311	true	15065	0x238a646f50b34ed13f68d672410d4d101ccdfb47	0x3cb752d175740043ec463673094e06acda2f9a2e	0x1ededc91	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x238a646f50b34ed13f68d672410d4d101ccdfb47	31400906	0x3cb752d175740043ec463673094e06acda2f9a2e	1,6	2025-06-10T21:32:39.000Z	1021935439345287518	0x7ffb2b5a4e0892b122caf61fb84d7bf94e6ef04adcb3c546dfdfa94b092d3cff	704122
118792	true	15065	0x238a646f50b34ed13f68d672410d4d101ccdfb47	0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	0x1ededc91	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x238a646f50b34ed13f68d672410d4d101ccdfb47	31400542	0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	1,6	2025-06-10T21:20:31.000Z	1002626711374123675	0x23390f145e0c7c8f89d09e90278085e637bef26bee966d4faaa90fb066463c84	93809
128408	true	15065	0x238a646f50b34ed13f68d672410d4d101ccdfb47	0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	0x1ededc91	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0x238a646f50b34ed13f68d672410d4d101ccdfb47	31400425	0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	1,6	2025-06-10T21:16:37.000Z	1002626568440968869	0x425726814405d49603e9da8b551c84fc1c1b3f1734f38cb6f9f6b46a2d5e00af	4627

Example Query

Query with partition filter

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

Comptroller_seizeVerify_function

Comptroller function calls verifying collateral seizure parameters during liquidation events in Venus Protocol lending markets. Records borrower and liquidator addresses, vToken contract addresses for borrowed and collateral assets, and quantity of tokens seized for compliance validation.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vTokenCollateral`	`STRING`	Contract address of the vToken representing the collateral being seized in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_vTokenBorrowed`	`STRING`	Contract address of the vToken representing the borrowed asset in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`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_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

gas	value	status	gas_used	signature	to_address	in_borrower	block_number	from_address	in_liquidator	trace_address	in_seizeTokens	block_timestamp	transaction_hash	in_vTokenBorrowed	in_vTokenCollateral
228966	0	true	8354	0x6d35bf91	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	0xa252bd92293b0eb9beb1c2cf72f794f8a3a54348	25879227	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	0x2e609abcdf2025fd6793433cc200cf956a9d9a42	9,0,4,3,1,10,1,5	46800573	2025-02-03T01:56:41.000Z	0x25cd9d9e6b0603d8a2ba7d2f53144a77599a3678ede4df4fa95fbfd2f60efb56	0x3cb752d175740043ec463673094e06acda2f9a2e	0xeb8a79bd44cf4500943bf94a2b4434c95c008599

Example Query

Query with partition filter

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

Comptroller_transferVerify_function

Venus Protocol comptroller function call data validating vToken transfer operations. Records transfer verification checks between source and destination accounts with token amounts and vToken market addresses.

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.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_src`	`STRING`	Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
`in_dst`	`STRING`	Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_transferTokens`	`STRING`	Number of vToken units being transferred in the operation. String-encoded integer representing the token amount in the smallest denomination.

Sample Data

gas	in_dst	in_src	status	gas_used	in_vToken	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in_transferTokens
520060	0xa9b108038567f76f55219c630bb0e590b748790d	0xd0f8ee01c3655c560a4fc4bfa51ebf3270531204	true	6297	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	0x6a56947e	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	37946406	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	1,1,3,7,8,1,1	2025-11-09T09:55:59.000Z	0x6237df5c7e64b55f1e135945835ea131c84c04c9b7f6fab5b43861c6f7f1cbd2	1832764
524615	0xa9b108038567f76f55219c630bb0e590b748790d	0xd0f8ee01c3655c560a4fc4bfa51ebf3270531204	true	6297	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	0x6a56947e	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	37967970	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	1,3,6,8,1,1	2025-11-09T21:54:47.000Z	0x7f2f7fce3fbb6252b362f09c9bfa80664b3b827b6ad98abbbca99f97e4e0b320	1832775
527625	0xa9b108038567f76f55219c630bb0e590b748790d	0xd0f8ee01c3655c560a4fc4bfa51ebf3270531204	true	6297	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	0x6a56947e	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	37968238	0xeb8a79bd44cf4500943bf94a2b4434c95c008599	1,1,3,7,8,1,1	2025-11-09T22:03:43.000Z	0xfec37e043b68dadb86587923c4867caecbcf1a32c480fbb2f0d9529cba797453	1832775

Example Query

Query with partition filter

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

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
0xeef902918ddecd773d4b422aa1c6e1673eb9136f	false	120	25918600	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	2025-02-03T23:49:07.000Z	0x75201d81b3b0b9d17b179118837be37f64fc4930	0xab25167d24cc79c9935d5367b9c3b163475a77d6b47239355f83a23e278c8e80
0xeef902918ddecd773d4b422aa1c6e1673eb9136f	false	324	23911558	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	2024-12-19T12:47:43.000Z	0x3cb752d175740043ec463673094e06acda2f9a2e	0x58faf0ea7751ffbc8ffeed886e02fb121cdc061c67198e4f9134a7a9b840cf37
0xeef902918ddecd773d4b422aa1c6e1673eb9136f	false	288	23911558	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	2024-12-19T12:47:43.000Z	0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	0x58faf0ea7751ffbc8ffeed886e02fb121cdc061c67198e4f9134a7a9b840cf37

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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
0xeef902918ddecd773d4b422aa1c6e1673eb9136f	{“name”:“Core”,“creator”:“0x1803cf1d3495b43cc628aa1d8638a981f8cd341c”,“blockPosted”:“23911558”,“comptroller”:“0x0c7973f9598aa62f9e03b94e92c967fd5437426c”,“timestampPosted”:“1734612463”}	false	267	23911558	0x0c7973f9598aa62f9e03b94e92c967fd5437426c	2024-12-19T12:47:43.000Z	0x58faf0ea7751ffbc8ffeed886e02fb121cdc061c67198e4f9134a7a9b840cf37

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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
0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	false	131	26453379	6114049	1000117570745333915	2025-02-16T08:55:05.000Z	166708	0xb2157fb5e110859dc64e302f82a2b929c966268da72c09714d49cf952c70fce5	0
0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	false	86	26439511	5524049	1000114068694349534	2025-02-16T01:12:49.000Z	166708	0x03c8af8cdb17e938ea6bc2c8c7b2ce3e0e1959c07e391879638b0be62b582c71	1
0x3cb752d175740043ec463673094e06acda2f9a2e	false	290	26454289	3800788808	1008748904401414457	2025-02-16T09:25:25.000Z	2815711088	0xa23a7a18243495adc8c2c35feb5de246d66992c6357afa83f1297679db7eee09	5659

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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_base.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_base.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
0x3cb752d175740043ec463673094e06acda2f9a2e	false	145	0xa252bd92293b0eb9beb1c2cf72f794f8a3a54348	24608370	2025-01-04T15:54:47.000Z	50000000	4836281424	0xff0c5a7a4b0380fcb6f716d0407e519c2135196e0876b16a052e213a20978351	2584750427
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	252	0xa670e411899e387ed0d6eb7a6e69f155156f4b72	26339261	2025-02-13T17:31:09.000Z	10000000000000000	4067439866177777306	0x87c13bf81bf868998ee520d09db3c1f0e33ca0cf2765158b10ca383500559d18	10000000000000000
0x3cb752d175740043ec463673094e06acda2f9a2e	false	135	0xc3bc997e282d7fc8a0c2ad294c3bcc2af5dd7787	25123934	2025-01-16T14:20:15.000Z	500000000	4899057632	0x387ed480b1a5512feea903d026af36bfe4cef75cf0d1b6a9e40c10c2870e8bee	500000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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
0x3cb752d175740043ec463673094e06acda2f9a2e	false	171	0xa252bd92293b0eb9beb1c2cf72f794f8a3a54348	25879227	0x2e609abcdf2025fd6793433cc200cf956a9d9a42	1047297421	46800573	2025-02-03T01:56:41.000Z	0x25cd9d9e6b0603d8a2ba7d2f53144a77599a3678ede4df4fa95fbfd2f60efb56	0xeb8a79bd44cf4500943bf94a2b4434c95c008599

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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
0x3cb752d175740043ec463673094e06acda2f9a2e	false	0x51470836d210d34f2e3a3d8cddb30e2291196655	83	24050005	13406911	1340576509	2024-12-22T17:42:37.000Z	0xbd0d1a1ca8594e4ad2115709896eaa2ca32f0cd7d97373d0a35f8ce26925b50d	3208451710
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	0xa252bd92293b0eb9beb1c2cf72f794f8a3a54348	201	24038336	500000000000000000	49999998	2024-12-22T11:13:39.000Z	0x8bf6efda64cbbe8153cd48a5de855966244edeb6d8089f38e72590213476c166	149999995
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	0x3273dc17fecb1e8e7e7276bf936364af9af88c2d	202	24019064	5000000000000000	499999	2024-12-22T00:31:15.000Z	0xbb6e0cf60487b2c2de73ea01f26cada21c4d7ce77092163701de7fad25a34052	499999

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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	in_oldReserveFactorMantissa
0x75201d81b3b0b9d17b179118837be37f64fc4930	false	100	25918600	2025-02-03T23:49:07.000Z	0xab25167d24cc79c9935d5367b9c3b163475a77d6b47239355f83a23e278c8e80	200000000000000000	200000000000000000
0x7bbd1005bb24ec84705b04e1f2dfccad533b6d72	false	906	23345046	2024-12-06T10:03:59.000Z	0x172ea0369f6e241ccceac5e47cbafb63ef869dc85a91c16c53c6f7d0bdfd9278	200000000000000000	0
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	376	23345038	2024-12-06T10:03:43.000Z	0x640a7c09c25d8517b3f0fb5f1af953bbed40b5ff4ed6d23eed4cbd6ae38b73e9	150000000000000000	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	185	0x0d78c092a3b533ddc0000fac38538ef248c7d33b	26239399	2025-02-11T10:02:25.000Z	13104897694058112	1309924	0xb1c9f6e620a7e59c577903d3b2c0ed80d246d752f7c7c93aed38ca072e306646
0x3cb752d175740043ec463673094e06acda2f9a2e	false	589	0x40378d78b14f46c35e2f69590b733e5275ac1d3b	26239615	2025-02-11T10:09:37.000Z	44266850	4403233207	0x002d332cb4f38001f5671242362ec7a60dd762a131880117b5dfd6c89ffdfac1
0x3cb752d175740043ec463673094e06acda2f9a2e	false	400	0xf0a391658f07e65779c7370a592675106c931277	26235042	2025-02-11T07:37:11.000Z	5002702	497620763	0x1a03d485e89f26055eba84df3d155ba960cebbf9f6995bc6b2b0d1d5405a0fe5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	0x8e890ca3829c740895cdeacd4a3be36ff9343643	254	0x40378d78b14f46c35e2f69590b733e5275ac1d3b	26162213	133612306508642	2025-02-09T15:09:33.000Z	4056365811166766721	0x298fe0751ca26922cf4e32576b31f3cb667ce062eb8d6f6bdc91bd394992f690	0
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	0x8e890ca3829c740895cdeacd4a3be36ff9343643	356	0x40378d78b14f46c35e2f69590b733e5275ac1d3b	26161409	9003662182121527	2025-02-09T14:42:45.000Z	4056360883916312410	0x7223df6a3ce75af831be55d0008566c3dd30e0cf6ae7244268d384135fb8fa69	0
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	0x40378d78b14f46c35e2f69590b733e5275ac1d3b	4190	0x40378d78b14f46c35e2f69590b733e5275ac1d3b	26162200	7666395241060817	2025-02-09T15:09:07.000Z	4056499343920261270	0x63a4a41740ca9047520fefd118622cbb3664bc789f70390baccf3f1311364688	133612303888338

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_base.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_base.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
0xeb8a79bd44cf4500943bf94a2b4434c95c008599	false	199	24762740	2025-01-08T05:40:27.000Z	19047649899	0x8368400906d1491a62affc9553f34122a53564c55f0997dd170d75a64854b34a	0x3565001d57c91062367c3792b74458e3c6ed910a
0x3cb752d175740043ec463673094e06acda2f9a2e	false	175	24792277	2025-01-08T22:05:01.000Z	104950	0x8c62d6823e48e8f08cd73962588a85ccbc87e8a975475b8b7e78731d5a31ae6a	0x3565001d57c91062367c3792b74458e3c6ed910a
0x3cb752d175740043ec463673094e06acda2f9a2e	false	259	25969977	2025-02-05T04:21:41.000Z	157657	0xc1d20da84554e8533ef12c5f33da764abb4990e0899a37210865c3ad21c0e8cc	0x3565001d57c91062367c3792b74458e3c6ed910a

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Comptroller_borrowVerify_function

Comptroller_liquidateAccount_function

Comptroller_liquidateBorrowVerify_function

Comptroller_MarketEntered_event

Comptroller_MarketExited_event

Comptroller_mintVerify_function

Comptroller_redeemVerify_function

Comptroller_repayBorrowVerify_function

Comptroller_seizeVerify_function

Comptroller_transferVerify_function

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

​Comptroller_borrowVerify_function

​Comptroller_liquidateAccount_function

​Comptroller_liquidateBorrowVerify_function

​Comptroller_MarketEntered_event

​Comptroller_MarketExited_event

​Comptroller_mintVerify_function

​Comptroller_redeemVerify_function

​Comptroller_repayBorrowVerify_function

​Comptroller_seizeVerify_function

​Comptroller_transferVerify_function

​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

Comptroller_borrowVerify_function

Comptroller_liquidateAccount_function

Comptroller_liquidateBorrowVerify_function

Comptroller_MarketEntered_event

Comptroller_MarketExited_event

Comptroller_mintVerify_function

Comptroller_redeemVerify_function

Comptroller_repayBorrowVerify_function

Comptroller_seizeVerify_function

Comptroller_transferVerify_function

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