venus_v1_unichain

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
85167	true	15006	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x5c778605	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x9d5132dd45cdacd1de3a7b7f1f13da7f025ff726	20726963	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,5	2025-07-02T16:55:22.000Z	58500000000	0xa0372a28d95fe911c45195fd435e5ae3432a70c68d568803de1c92594a806244
85167	true	15006	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x5c778605	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x9d5132dd45cdacd1de3a7b7f1f13da7f025ff726	20726904	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,5	2025-07-02T16:54:23.000Z	84000000000	0xf29dba1afdc09329ba9d5b0f76eb766e6eac97397a74396588b7f2d44eca2b97
85167	true	15006	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x5c778605	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x9d5132dd45cdacd1de3a7b7f1f13da7f025ff726	20739012	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,5	2025-07-02T20:16:11.000Z	97000000000	0x5307ca5b41c5ae10394eab1e47545a162729713f697f72663d377d0e087998d2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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

gas	status	gas_used	in_orders	signature	to_address	in_borrower	block_number	from_address	trace_address	block_timestamp	transaction_hash
5224864	true	592482	[{“repayAmount”:“2523858222281899”,“vTokenBorrowed”:“0xc219bc179c7cdb37eacb03f993f9fdc2495e3374”,“vTokenCollateral”:“0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95”}]	0x2bce219c	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xa951157d7fbb3f7c323c42aa87b2a49fca1126bc	22054475	0x6d7fd08506a9be096cac69edb0b488fc9ef6f377	4,4,1,0,0,2,2,3	2025-07-18T01:40:34.000Z	0xdd8854b4abb5862501958b987d8e5e485dfadeef34a48639d68482c3251f1994
5219437	true	631390	[{“repayAmount”:“3345584859615357”,“vTokenBorrowed”:“0xc219bc179c7cdb37eacb03f993f9fdc2495e3374”,“vTokenCollateral”:“0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95”}]	0x2bce219c	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x25ff97dc48d8bd6ef1ebb92589911a2e5216f1de	24281457	0x6d7fd08506a9be096cac69edb0b488fc9ef6f377	4,4,1,0,0,2,2,3	2025-08-12T20:16:56.000Z	0xba4b970b42a2a1767fb658dc2c4597538cc2649c342d36781bb73f40784456e4
5211533	true	623258	[{“repayAmount”:“35216039”,“vTokenBorrowed”:“0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95”,“vTokenCollateral”:“0x67716d6bf76170af816f5735e14c4d44d0b05ed2”}]	0x2bce219c	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xe3eec27817759d76323cdff7091b675b23b711cf	31532826	0x6d7fd08506a9be096cac69edb0b488fc9ef6f377	4,4,1,0,0,2,2,3	2025-11-04T18:33:05.000Z	0xc64e09314474024ab72de6ac2c2dcb8b0b4f768d0772cdb3ccfdac7ac0fea0a7

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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	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
4303967	true	6389	0x47ef3b3b	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x25ff97dc48d8bd6ef1ebb92589911a2e5216f1de	24281457	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0x6d7fd08506a9be096cac69edb0b488fc9ef6f377	4,4,1,0,0,2,2,3,1,4,1,11	1648327976	2025-08-12T20:16:56.000Z	0xba4b970b42a2a1767fb658dc2c4597538cc2649c342d36781bb73f40784456e4	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	3345584859615357
4347362	true	6389	0x47ef3b3b	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xa951157d7fbb3f7c323c42aa87b2a49fca1126bc	22054475	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0x6d7fd08506a9be096cac69edb0b488fc9ef6f377	4,4,1,0,0,2,2,3,1,4,1,11	986000147	2025-07-18T01:40:34.000Z	0xdd8854b4abb5862501958b987d8e5e485dfadeef34a48639d68482c3251f1994	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	2523858222281899
4516785	true	6389	0x47ef3b3b	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x3879bc7564e762c730111a41180b4273f3473ab7	31102413	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x6d7fd08506a9be096cac69edb0b488fc9ef6f377	4,4,1,0,0,1,2,3,1,13	3364510	2025-10-30T18:59:32.000Z	0xb32a5eb855eae7c9c07bfbd4d076e3c10754ca52bb09f70eb42257da7dcd85b4	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	114779949

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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	in_account	block_number	block_timestamp	transaction_hash
0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	false	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0xdbde4e9aafb2731b0dd6ba84a0d7792ce7975f6d	10628321	2025-03-07T19:44:40.000Z	0xa55fd69f8618772909548d4f941fdb80fc1605f4416cc5473b20189fdaa8d724
0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	false	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x5bee6b4e61f53d41be7b2e0b77af06a3e54653a1	10629327	2025-03-07T20:01:26.000Z	0x8c50fb970ee21dbb788cee22088bac84db90fc6fc1796ba2466a060319104998
0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	false	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x8b4e0d3cd58f36afbd0c88c8ebb2866c796465fa	10607326	2025-03-07T13:54:45.000Z	0xbd7ea304de1ad0b2b6d8659b8155acd382f0d07fba7bf7e346819bf425a7b23a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	false	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	6	0x5580e783f4d2410cc15af4df5777eb8c13d3eb5f	13877217	2025-04-14T10:12:56.000Z	0x5e8e8a7df29161f033da1a2ca61defa37648ebfc39a79e00635d7a739ca87f88
0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	false	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	7	0x6a7a222e544d8a40d984d26e30a4a73090ae3136	13876614	2025-04-14T10:02:53.000Z	0xc0e9046db664508676299bbf9641efeb72efd1438af875bc15ebc553f954edf0
0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	false	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	4	0xb9ed49b86dd1f0ee36443758d995a0c3d7d352dc	13917151	2025-04-14T21:18:30.000Z	0xfe87708a2a26e51c232a1bd301c97e27826751fce0f9a3031fa9338211cc339c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
17854	true	14956	0xcc421580649530d4ea2a479b6d9fd0d53f71c0bb	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x41c728b9	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	30630013	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	15614763	1,10	2025-10-25T07:46:12.000Z	0xb5c9a6af8a1b0200a2d1f83ecdf4edd43afb59f882dd6dbd3ae6849c22dff629	159976
17853	true	14956	0x7dd3ca8db039a39f3f2fe9f56f21c3b6fa961cde	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x41c728b9	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	30630134	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	3110439	1,7	2025-10-25T07:48:13.000Z	0x67eebb56a5aa8f95160000d7f5583513bdbd59c748d4bff8f0419b58adc19e9c	31867
17854	true	14956	0x5995aea4401d1689406df849b849f8680df43a99	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x41c728b9	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	30627347	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1244781	1,7	2025-10-25T07:01:46.000Z	0x9542f32433971042ebae24033ff5fc8fb59cb31b2be8063bf4ae0ab5bfd62e72	12753

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
17856	true	14957	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x51dff989	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x6d34b7edddcb2e1228fa957b62dd63183d1244c1	24376521	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,6	2025-08-13T22:41:20.000Z	103	10121	0xfd8e832f0cfdad421381fcf5ca7501f5247ca014e1da415b0a3e2b4cad563a5d
17856	true	14957	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x51dff989	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xaa0167bceb98f10f8f228dd28e51e371b6ccf596	24378711	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,6	2025-08-13T23:17:50.000Z	202	19928	0x22279298bbd7e61468c3e03d58b65c403ac7ab1220b6ed0f5b7a17571b34cb5f
17856	true	14957	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x51dff989	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xdd3289a6f98158d6c0f8f95329bd4128e687a042	24377826	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,6	2025-08-13T23:03:05.000Z	1434	140873	0xad07056cd5fa85d527360aad6addc394627f2b5b93007af791910a37ac49f1f9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
17977	true	15065	0xb8e8fd03ca3b4f1f5e26e5750c4e01fc4e3fdab3	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x1ededc91	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xb8e8fd03ca3b4f1f5e26e5750c4e01fc4e3fdab3	12154038	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,6	2025-03-25T11:33:17.000Z	1006807561333421191	0xe1aafde624985abf5913cd4b17076c6719d0ec60aa7d8d2d9693a6888d95c7cc	7500
17977	true	15065	0xb8e8fd03ca3b4f1f5e26e5750c4e01fc4e3fdab3	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x1ededc91	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xb8e8fd03ca3b4f1f5e26e5750c4e01fc4e3fdab3	12154027	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,6	2025-03-25T11:33:06.000Z	1006807539744392898	0x46d3486437ad7d8f8add1ba23b4f331026032691909150ac36adbdba81a84bf2	5000
17982	true	15065	0x15c643da3ffe435f0651e3bb40913cc711a71dbe	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x1ededc91	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x15c643da3ffe435f0651e3bb40913cc711a71dbe	12180178	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	1,6	2025-03-25T18:48:57.000Z	1006858868632224235	0xeedc146c62cdfe5505b667c9d4a4fdb0df5f6a5d80898924af9d785d878a2756	4000682

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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	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
4163146	true	8354	0x6d35bf91	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0xb3b91970b2f7c338127cd6b3620970d8603d264b	31435510	0x67716d6bf76170af816f5735e14c4d44d0b05ed2	0x6d7fd08506a9be096cac69edb0b488fc9ef6f377	4,4,1,0,0,2,2,3,1,4,1,10,1,5	17722203	2025-11-03T15:31:09.000Z	0xbeee5a38c1b481cca3bd42194b94c257cd2114933959d2148c764d257c66d43f	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x67716d6bf76170af816f5735e14c4d44d0b05ed2
186310	true	6354	0x6d35bf91	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x26f7d10ae03a42618277e7c3cc946e14bc4eb726	32375433	0x68e2a6f7257fac2f5a557b9e83e1fe6d5b408ce5	0x1950de6e5729c6ffce91477b57eec99f5980e956	1,0,2,0,2,1,12,1,5	637599	2025-11-14T12:36:32.000Z	0x9ba9ea9161fb16e51679a5fec7da013c7819813d42b9ba7281afb4482b471112	0xda7ce7ba016d266645712e2e4ebc6cc75ea8e4cd	0x68e2a6f7257fac2f5a557b9e83e1fe6d5b408ce5
243126	true	6354	0x6d35bf91	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	0x941d85a3cc703dbcbddd393d4a35acfbe54fcc6a	29385454	0x67716d6bf76170af816f5735e14c4d44d0b05ed2	0x1950de6e5729c6ffce91477b57eec99f5980e956	1,1,0,1,1,12,1,5	57491231579	2025-10-10T22:03:33.000Z	0xcb1050883ff42573de4faa389f3632e8bc9de9819a20b413dbc991645e1c9928	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x67716d6bf76170af816f5735e14c4d44d0b05ed2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
117865	0x2ab4fc70ef224508c925e33d0af52865e0c2fa3c	0xc97032ce308ff6f9f3efe4376f4b8d9dedb1bf2b	true	17297	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0x6a56947e	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	10684992	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	1,1	2025-03-08T11:29:11.000Z	0x4ff3aa89967ba27e39a9dabf7bd642b43d4cbb29949cb9068eabcc94c8eaf3e6	1600000000
117865	0x2ab4fc70ef224508c925e33d0af52865e0c2fa3c	0x28272fc8d3aa0aafa247f604c82e1dbcba7523e2	true	17297	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0x6a56947e	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	10685362	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	1,1	2025-03-08T11:35:21.000Z	0xcc93001c5df25f2a3ccb87c8353d62c04f9bf433c4f7fa7b724b7886c140349c	2000000000
117865	0x2ab4fc70ef224508c925e33d0af52865e0c2fa3c	0xa8988fad092dd1812a6deaaf9aaed39ec5f56d92	true	17297	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0x6a56947e	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	10684904	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	1,1	2025-03-08T11:27:43.000Z	0x99f90e6c0e93ab6341cda6c3c99b194ec8454947d1ebb248a408138d13a2a03b	1100000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0x0c52403e16bcb8007c1e54887e1dfc1ec9765d7c	false	97	8619932	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	2025-02-12T13:51:31.000Z	0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	0x0a024133f98b3fae61d30327cae919246b56bf22a12843e0a0b218345aa5c58b
0x0c52403e16bcb8007c1e54887e1dfc1ec9765d7c	false	79	8619932	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	2025-02-12T13:51:31.000Z	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	0x0a024133f98b3fae61d30327cae919246b56bf22a12843e0a0b218345aa5c58b
0x0c52403e16bcb8007c1e54887e1dfc1ec9765d7c	false	29	11068059	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	2025-03-12T21:53:38.000Z	0x67716d6bf76170af816f5735e14c4d44d0b05ed2	0x0659ce631a2631bfa6874a35f1bab4a00e2317ffd1ed0e8feb938101daa6c10e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0x0c52403e16bcb8007c1e54887e1dfc1ec9765d7c	{“name”:“Core”,“creator”:“0x1803cf1d3495b43cc628aa1d8638a981f8cd341c”,“blockPosted”:“8619932”,“comptroller”:“0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe”,“timestampPosted”:“1739368291”}	false	58	8619932	0xe22af1e6b78318e1fe1053edbd7209b8fc62c4fe	2025-02-12T13:51:31.000Z	0x0a024133f98b3fae61d30327cae919246b56bf22a12843e0a0b218345aa5c58b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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	block_number	in_cashPrior	in_borrowIndex	block_timestamp	transaction_hash
0x67716d6bf76170af816f5735e14c4d44d0b05ed2	false	13647216	740465814258277577558	1000000000000000000	2025-04-11T18:19:35.000Z	0x51cc0866101bf4bb8cc8aaba1e72889ae9ee7ac90538586d76cab10e3222cbf4
0x67716d6bf76170af816f5735e14c4d44d0b05ed2	false	13637347	738989879692340736573	1000000000000000000	2025-04-11T15:35:06.000Z	0x0849219e75a130a77a7c55013596e194ee001d7db13e622e22af0ff948ed94f5
0x67716d6bf76170af816f5735e14c4d44d0b05ed2	false	13586610	752576846505520472437	1000000000000000000	2025-04-11T01:29:29.000Z	0xded483f0b7904cc52d92816f8a208f34ec4cededc69c9bc174b08b54293a2733

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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

address	removed	log_index	in_borrower	block_number	in_badDebtNew	in_badDebtOld	block_timestamp	in_badDebtDelta	transaction_hash
0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	false	31	0x1cc46367d9055ce7d63f772368470e4e548b3b4b	21351947	66058066989759	0	2025-07-09T22:31:46.000Z	66058066989759	0x2c8bf0ab3f01849ae779e627d769d22feb91825b925f009b169ef085c972b2c9
0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	false	38	0x1f246817cbfbca4a758f9b6e6e85b7ca92aa0e01	21850497	113870720262668	66058066989759	2025-07-15T17:00:56.000Z	47812653272909	0x34a108a2269f0b0d3bbe3a08153aa969f4f2de1402725456084198ec896e56e4
0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	false	32	0xb7873c18ae657ddbcc5b17c05ba658a7043c3d90	21850557	121293125984309	113870720262668	2025-07-15T17:01:56.000Z	7422405721641	0x08891816cdaa793e37c883e9dea05f81e15e39ee60ff0de32d6c6ce318e10db1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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_unichain.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
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	3	0x6a8bfbb720b34d279ec25c0434ee9332a64d9e9d	12420986	2025-03-28T13:42:25.000Z	0	1503541742411	0x051d0aee3096578740802cd9bff52612c072dc3245edafa2d1618f4d8e691793	0
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	6	0x2b5649ec866049cf0d35848ce240f2bde917046d	12424154	2025-03-28T14:35:13.000Z	1000	1503550826120	0x482ab47e033d42a1cdaeb7a9f9f245408b47b24849b35bc2ebc4f2d5e84b2c44	1000
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	1325	0x2b5649ec866049cf0d35848ce240f2bde917046d	12424268	2025-03-28T14:37:07.000Z	100000	1503551249357	0x4f10498e64a9c0e58f8c92ac426f36d8c807a11abac01aab204076b52df1a824	101000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	16	0xccd724b9af92a3a389150334556330efd3f59487	13249122	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	172336087	12445157	2025-04-07T03:44:41.000Z	0x7245e6fc806575b350339d0acf05702a130e0bcf52a0789f445d5e8f2c1d87d2	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	16	0x81ebf134483d5580a4e7cf52b2798d22af1e9051	13223436	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	178380308	12426340	2025-04-06T20:36:35.000Z	0xa89aa6970c9f037a7b208b4e3bbee550e9ba5b22e3af07f2faf58a154886c716	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	16	0x3879bc7564e762c730111a41180b4273f3473ab7	13215261	0x23bd42e5cc8706765a2cbb6c385a5a1350615d4f	55826298	3723471	2025-04-06T18:20:20.000Z	0x17821fec81778a49c577cae908cb2b3711a2c2ac16ae59ec2e755df6d719d772	0xc219bc179c7cdb37eacb03f993f9fdc2495e3374

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	0xb7243ac8d8ca7c174b1c78aa4a2ef3eb69ff6ce9	4	11464153	1070276	106717438	2025-03-17T11:55:12.000Z	0x09b73d2eb501b289e051f68ae9caad5c8105b1f2e92b53c60d5d7f178c5d3cfd	106717438
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	0x75e70040aa225ba61fd5df41add5ad716a85aa96	4	11472269	1892820	188732068	2025-03-17T14:10:28.000Z	0x545a7d80daebd013f57c5e5a95d869fddec0a9de0bc17f97d186b774328bae48	188732068
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	0xd137a7ab85cf9a110f2025b531c559b561368984	4	11471037	1175423	117200929	2025-03-17T13:49:56.000Z	0x70219d40a7e1304bb354e5031ef0a698f340255fd6df834811d3d6b1816729d2	117200929

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	5	8535541	2025-02-11T14:25:00.000Z	0xa2f55be1def06411a2961209431208d39a11e1410defb48ed28e1722a0d3122c	100000000000000000
0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	false	5	8535568	2025-02-11T14:25:27.000Z	0x3fd587fc97674c8e674f3398a744fb380f2236cc6430dda3f618b5a86c0dc2bc	100000000000000000
0x67716d6bf76170af816f5735e14c4d44d0b05ed2	false	10	9385713	2025-02-21T10:34:32.000Z	0x479fec4c8a7a5a90ef972a1d36955f06ac7d01e6e3fb2e68dd107903cf1636cb	250000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	false	28	0x3f747a57a9cd6b028a01050d017a8d4c2005674d	11645879	2025-03-19T14:23:58.000Z	21005750659929927	2099980	0xa602256d6597b793012f1c5526424e6f54e541fac3973b5ab60d7f43c9e2e33e
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	25	0x37626982ca1d3c4978de54a580f38d1ca85abf7a	11652340	2025-03-19T16:11:39.000Z	1172583	116898418	0x4b128e13a1f91264571377fc1994655c0e594523dd6b03f473c541dc753a9788
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	30	0x91b5d9a11dab73c9bfe8ecde11933833f8a5c82f	11652340	2025-03-19T16:11:39.000Z	1105042	110165047	0xd2a1bb7b3e277d750627b7db9a21dc98abe88f42fee8ebc4d94bdff45f148957

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	0x12924049e2d21664e35387c69429c98e9891a820	10	0x12924049e2d21664e35387c69429c98e9891a820	14229970	5020387	2025-04-18T12:12:09.000Z	1369802464306	0xa7ddc22b28863765b890f16cb08a2f641b772017635de29deab36613e5921296
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	0x1c5e7d41153bc015f6dcdf8785c049408d2e0683	6	0x1c5e7d41153bc015f6dcdf8785c049408d2e0683	14219877	500000	2025-04-18T09:23:56.000Z	1369784256662	0x9ee34a8993e139f02cf8023f4c933ee2469043f1d57957312e2a9ad2057c28c0
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	0x1c5e7d41153bc015f6dcdf8785c049408d2e0683	3	0x1c5e7d41153bc015f6dcdf8785c049408d2e0683	14219884	0	2025-04-18T09:24:03.000Z	1369784272773	0xb28174272ca0c33ebbaf6a3d04e05ef6430db41d4d5bec53fb4876aeb8737dd0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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_unichain.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
0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	false	12	9604173	2025-02-23T23:15:32.000Z	83866730752673	0x9ee5bcc41d46f633e4463705db0a2c9abe4d7822003fe692239e3dbec40ed4ef	0x0a93fbcd7b53ce6d335cab6784927082ad75b242
0xb953f92b9f759d97d2f2dec10a8a3cf75fce3a95	false	25	9550520	2025-02-23T08:21:19.000Z	5741568	0x7c636724f52ce767ff258eabe56f9ae4ea15766137b14844048dce4a34c07fa0	0x0a93fbcd7b53ce6d335cab6784927082ad75b242
0xc219bc179c7cdb37eacb03f993f9fdc2495e3374	false	6	14490015	2025-04-21T12:26:14.000Z	5443484553562312	0x30f55a0afac35dd7bcd3c0ef7272966f102e9f723d323199d4ac2d25bbe752f5	0x0a93fbcd7b53ce6d335cab6784927082ad75b242

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_unichain.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