venus_v1_opbnb

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`	`NUMERIC`	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
6180	true	3796	0x509e81ef638d489936fa85bc58f52df01190d26c	0x5c778605	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0xc31627cbf55f6810f8ba74127ee9b6f9e303fd6d	38361458	0x509e81ef638d489936fa85bc58f52df01190d26c	1,5	2024-10-28T11:33:01.000Z	379689726000000000	0xbfe93955b64e2cdfba75169704691928961aa32e17b9580c844a0b2d26dba981
6867	true	3796	0x509e81ef638d489936fa85bc58f52df01190d26c	0x5c778605	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0x8e49312a7a6cc79952ae5c65fb27525667065591	38356776	0x509e81ef638d489936fa85bc58f52df01190d26c	1,5	2024-10-28T10:14:59.000Z	375546300000000000	0xe8591e1ba8ca758d0c991487e89445fd4b69ff5fce211aa2cecf1cdb4dc5476f
6180	true	3796	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x5c778605	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0xa7512d54780e6a16e6a9857e49a858c6ad51aef2	38384274	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,5	2024-10-28T17:53:17.000Z	1880000000000000000	0xd3880f809085556996bc6b460c7ffa34b4ea0e60dae2dc736eb9bef680d74f6f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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`	`NUMERIC`	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_opbnb.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`	`NUMERIC`	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
621591	0	true	1979	0x47ef3b3b	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0xa7512d54780e6a16e6a9857e49a858c6ad51aef2	42942460	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x98ecb04542fd22e1c8a7e7575895710f0c3cfb7f	1,16	972064	2024-12-20T12:03:03.000Z	0xa9cd9469fe71e33c6b70e5af25deb6d731e311ded9e5508c300548312e9f7c5a	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0xed827b80bd838192ea95002c01b5c6da8354219a	821000000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	false	0xb7a01ba126830692238521a1aa7e7a7509410b8e	23	0x0683c6ca386f498f6dca8b79274d14ea9af6d5fc	31717192	2024-08-12T13:55:15.000Z	0xceffafcccb941e12b2e1cc6acb56d57f00fe28d11abe083b2994a54f3420841e
0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	false	0x13b492b8a03d072bab5c54ac91dba5b830a50917	57	0x0683c6ca386f498f6dca8b79274d14ea9af6d5fc	31717423	2024-08-12T13:59:06.000Z	0x62f08f26363582cafd75a936234ae482b54d00e79f5e79c3b52686f2084a08e9
0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	false	0xb7a01ba126830692238521a1aa7e7a7509410b8e	19	0x00d2c498fb20d91d094b49b134088ef746d09c1f	20001342	2024-03-29T23:31:05.000Z	0x832c7729aff354c9ef8a47f02bb792e48575dc775a905203e152ad141fef6ed1

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	false	0xb7a01ba126830692238521a1aa7e7a7509410b8e	12	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	19339673	2024-03-22T07:43:16.000Z	0xc7b3df6146230a1bf32964cafe9c49d8dcca184c07133bd830b165530a342215
0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	false	0xb7a01ba126830692238521a1aa7e7a7509410b8e	7	0x31d2621184901ea3fb3b11299a40f495f8e08ed1	19381644	2024-03-22T19:22:47.000Z	0xe6ed4cc73a7c4202f4f440222427fe04e79bcca2975cf2c6e3914c21e943f557
0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	false	0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	3	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	18395894	2024-03-11T09:33:37.000Z	0x3446d2289568e259a2eb719391e3cbdb7e52d765048d54157c3667fe1bd064eb

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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`	`NUMERIC`	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
6199	true	3813	0xb4dfce5b298f826365220448f45bc0d2452fdfd5	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x41c728b9	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	27884795	0xb7a01ba126830692238521a1aa7e7a7509410b8e	48515	1,10	2024-06-29T05:21:58.000Z	0x1cf013fd3af212735bc724a6ff3fd0dcd5f6e53403a53ac84b0f53cfe7d36f71	495546728079084
6199	true	3813	0xa7512d54780e6a16e6a9857e49a858c6ad51aef2	0xed827b80bd838192ea95002c01b5c6da8354219a	0x41c728b9	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	23396359	0xed827b80bd838192ea95002c01b5c6da8354219a	24209	1,10	2024-05-08T06:34:42.000Z	0x97a35f240bbd0bd2c19d0ac3e9d253a14f3498305032bb8dd7a94bc3b65f3485	242100683724906
6199	true	3813	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x41c728b9	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	23413650	0xb7a01ba126830692238521a1aa7e7a7509410b8e	356086848	1,7	2024-05-08T11:22:53.000Z	0xfecadce88ec99e52248fce40f695288765d96df0b60df96ecd25863455977fcf	3630565490306027326

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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`	`NUMERIC`	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
6136	true	3747	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x51dff989	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0x569e1f3eecabc7d346ff55c681b6dd9427078f4f	32581708	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,6	2024-08-22T14:03:51.000Z	8000625672265077497	781598470	0xe7a5327aa9b5d76b0bb4345886d1593763bf617cd6036e5c55141915b2dbe6d0
6136	true	3747	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x51dff989	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0x9f9afad1c7aecc9d80e2208bb5a8292160f3cf17	52189876	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,6	2025-04-06T12:46:39.000Z	2000000001906798747	193113401	0x47e76efacdaa78ea92bb9aed6ae3dc3208b07bb78e0d96a1f979c5ded46d5e39
6136	true	3747	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x51dff989	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0x9f9afad1c7aecc9d80e2208bb5a8292160f3cf17	52189917	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,6	2025-04-06T12:47:20.000Z	1081212890548233956	104398348	0x9daeb71051f58c443c3eb149c916db87d19c56ec1cae1d40d9b63ab5bf02cebe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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`	`NUMERIC`	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
90900	true	3854	0x59abe1e264f657d70c3ab5109d424f7f01a8729c	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x1ededc91	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0x59abe1e264f657d70c3ab5109d424f7f01a8729c	61907685	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,9	2025-06-09T01:35:04.000Z	1071520906229247578	0x20a7073075502bfbfe54273cba461f271d496818d7e7db8d7c07db13df6e2d4f	100021821524343832704
6299	true	3898	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x1ededc91	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	18393793	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,6	2024-03-11T08:58:36.000Z	1000724985341641254	0x79752907028048e994ba41af57d92e299da6c9533c854ef156660c0a7ad69e59	9453171138994435
6299	true	3898	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x1ededc91	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	18364294	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,6	2024-03-11T00:46:57.000Z	1000701654538094813	0x68784451b4fe377d7e88b8d02cb1abf7c04b09d58f3914e4eca54374a6a68c06	18050878659755848

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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`	`NUMERIC`	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
603943	0	true	1944	0x6d35bf91	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	0xa7512d54780e6a16e6a9857e49a858c6ad51aef2	42942460	0xed827b80bd838192ea95002c01b5c6da8354219a	0x98ecb04542fd22e1c8a7e7575895710f0c3cfb7f	1,15,1,5	972064	2024-12-20T12:03:03.000Z	0xa9cd9469fe71e33c6b70e5af25deb6d731e311ded9e5508c300548312e9f7c5a	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0xed827b80bd838192ea95002c01b5c6da8354219a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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`	`NUMERIC`	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
221552	0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	0xac8bab9bd8b86f62cda485f7b2df0e19f70afb3c	true	3888	0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	0x6a56947e	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	75634822	0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	1,1	2025-08-27T12:07:52.000Z	0x34a241f330b1ba3dd8c23879dbd016159ae7a1bc98456a8d7167b473c2f1414c	1
221446	0x000000000000000000000000000000000000dead	0xac8bab9bd8b86f62cda485f7b2df0e19f70afb3c	true	3888	0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	0x6a56947e	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	75634702	0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	1,1	2025-08-27T12:06:52.000Z	0x715ae075f307fc29f16da0f2b18f85e76ac4b53a60dca10a2b75aaf5ac3721cc	1
345315	0x1858b5a967ce1b57767e5e8a2edf7a4bda8ae108	0x9e250ee8ad4a8eef6eb03452813879f086d61441	true	3888	0xb7a01ba126830692238521a1aa7e7a7509410b8e	0x6a56947e	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	30589235	0xb7a01ba126830692238521a1aa7e7a7509410b8e	1,1	2024-07-30T12:35:58.000Z	0xe99b9bf99fba7b91f6b1ee1f8c8fb789485f0cc4bce25f76d31d052de5e25281	3000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0x345a030ad22e2317ac52811ac41c1a63cfa13aee	false	175	17298794	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	2024-02-27T16:48:37.000Z	0x13b492b8a03d072bab5c54ac91dba5b830a50917	0xc3182273ea5aead5bce4190b53c8569fa7c77525684d7f517c740d45d4aefbbc
0x345a030ad22e2317ac52811ac41c1a63cfa13aee	false	117	17298794	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	2024-02-27T16:48:37.000Z	0x509e81ef638d489936fa85bc58f52df01190d26c	0xc3182273ea5aead5bce4190b53c8569fa7c77525684d7f517c740d45d4aefbbc
0x345a030ad22e2317ac52811ac41c1a63cfa13aee	false	97	17298794	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	2024-02-27T16:48:37.000Z	0xed827b80bd838192ea95002c01b5c6da8354219a	0xc3182273ea5aead5bce4190b53c8569fa7c77525684d7f517c740d45d4aefbbc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0x345a030ad22e2317ac52811ac41c1a63cfa13aee	{“name”:“Core”,“creator”:“0xc46796a21a3a9fab6546af3434f2ebffd0604207”,“blockPosted”:“17298794”,“comptroller”:“0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd”,“timestampPosted”:“1709052517”}	false	74	17298794	0xd6e3e2a1d8d95cae355d15b3b9f8e5c2511874dd	2024-02-27T16:48:37.000Z	0xc3182273ea5aead5bce4190b53c8569fa7c77525684d7f517c740d45d4aefbbc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0xb7a01ba126830692238521a1aa7e7a7509410b8e	false	19	24893602	5090803741011204901059	1026862768320390854	2024-05-25T14:28:45.000Z	682740511823116449417	0x525252ab306038205d08c7fb578f8311ade8df7145dba8b41863669408173422	22459601608515445
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	35	24885044	26744787186508149816	1030778862318483213	2024-05-25T12:06:07.000Z	50021759106826485	0x49ba591def100005e5c7a85f264ef613140f1ad2211e5b69f62619bcdf67ab2c	72966258994
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	8	20496309	34194922186037425718	1006281891853248686	2024-04-04T17:00:32.000Z	125466981436565	0x721924be022eb83a02eed6b33b678c802c943a965455b0c78ca1c6a859c991c0	481889

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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_opbnb.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_opbnb.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
0x13b492b8a03d072bab5c54ac91dba5b830a50917	false	16	0xe7051bd65ec206dc3263d3e0925d1d01d91413ed	18602505	2024-03-13T18:57:08.000Z	1050000000000000000000	5053902906686148151255	0x1ab7ce7d81e46f200bc709a174fad1f5e9497af186ff0d32651077d135fc9d3a	1050000000000000000000
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	44	0x9f9afad1c7aecc9d80e2208bb5a8292160f3cf17	18592146	2024-03-13T16:04:29.000Z	1029483516452129	15048419020059405283	0x9e0116c1953c237fa39f043b2a9f6ae082a937faee87ddf07f1768714d67e4f8	1029483516452129
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	24	0x9f9afad1c7aecc9d80e2208bb5a8292160f3cf17	18593175	2024-03-13T16:21:38.000Z	1388174976720840536	16436627225758094444	0xd826e8ceef1128ab7a40412f44d4414d63e8892767a09577d42ad5245dfbaef3	1389204462510533788

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0xb7a01ba126830692238521a1aa7e7a7509410b8e	false	238	0xa7512d54780e6a16e6a9857e49a858c6ad51aef2	42942460	0x98ecb04542fd22e1c8a7e7575895710f0c3cfb7f	821000000000000000000	972064	2024-12-20T12:03:03.000Z	0xa9cd9469fe71e33c6b70e5af25deb6d731e311ded9e5508c300548312e9f7c5a	0xed827b80bd838192ea95002c01b5c6da8354219a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0xb7a01ba126830692238521a1aa7e7a7509410b8e	false	0xc31627cbf55f6810f8ba74127ee9b6f9e303fd6d	65	38095992	2002380000000000000000	195108603538	2024-10-25T09:48:35.000Z	0x5e97b95430ce3005f6b65c311f4dcaaea640f2c4591e7b463f2af9522c4e9e22	195108603538
0xb7a01ba126830692238521a1aa7e7a7509410b8e	false	0x569e1f3eecabc7d346ff55c681b6dd9427078f4f	108	34972880	39000000000000000000	3807083910	2024-09-19T06:16:43.000Z	0x615cbc61a844996dae4291f2742602d4cc1331256bd82eaed1621837c701b882	6540557507
0xb7a01ba126830692238521a1aa7e7a7509410b8e	false	0x7d66a9b5c0a5b7188f38641b1d19d41cd42ee69b	443	34995929	1991510000000000000000	194404684781	2024-09-19T12:40:52.000Z	0x6a03b1caf494f36869174d1d4ebad996d8994f72adc462cb7c3a8f6125cd9e84	194404692933

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0x509e81ef638d489936fa85bc58f52df01190d26c	false	31	16233373	2024-02-15T08:51:36.000Z	0x2b83764b7aa28a858f084ca357f80ab2caca64c74f244f7c197da1d1f996539f	200000000000000000
0xed827b80bd838192ea95002c01b5c6da8354219a	false	37	16233353	2024-02-15T08:51:16.000Z	0x1c45676311e224a76de47093c7cfe72ec0e7a4ed29747b9a746f6d1829efef04	200000000000000000
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	29	16233445	2024-02-15T08:52:48.000Z	0x56e7c11d2d5e7660072465a4c251694f5d2545a5f15bb87cc6641e6979a5d82e	250000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0xb7a01ba126830692238521a1aa7e7a7509410b8e	false	116	0x569e1f3eecabc7d346ff55c681b6dd9427078f4f	39904438	2024-11-15T08:09:21.000Z	157003437947940073685	15273047887	0x9494d0cc7c9777b51ff86e3c3c427d2181b502c05fe97cb2b1de682f2ac61f8b
0x509e81ef638d489936fa85bc58f52df01190d26c	false	3	0x88e57c01beba95b51006df6de835fdec38d370af	20271856	2024-04-02T02:39:39.000Z	10482224467416086134	1048222295	0xec0b6fd8b03482073d339a568aabdc52dba4e5aad71664688a594156ae66b458
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	24	0x61900c3b19b9ff4f7c6f0473a9a0abe6a6ed5278	20276233	2024-04-02T03:52:36.000Z	6720609894584956	670003	0x54b5c115a45ec1b74ed8b2c808376c31f32f96918fe8b0520d7672a6dcf67eb5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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
0xb7a01ba126830692238521a1aa7e7a7509410b8e	false	0x928941678ceffd92987581c41e9baaad43d8ffdb	55	0x928941678ceffd92987581c41e9baaad43d8ffdb	40904615	261657672324485579	2024-11-26T21:58:58.000Z	2313254815272698388859	0x9ae90c98504178d2de2a103461047fbf9209d77c456bdd1d69271271b8e8fdaa
0x509e81ef638d489936fa85bc58f52df01190d26c	false	0xde12489510fa7fede8931c00f429dee6c1fe0fc9	55	0xde12489510fa7fede8931c00f429dee6c1fe0fc9	36375496	403357323547767274	2024-10-05T11:53:39.000Z	64844216140	0x93fcf64df3b4a2a355d4f78d85db5f76e83e78ddad276a4eac2001d52f1c771d
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	0x7baf6019c90b93ad30f8ad6a2eccd2b11427b29f	30	0x914815887da32b8b6af0cb8e7549621701b9fd0d	26727467	50226330492982879	2024-06-15T19:53:10.000Z	116838525191282	0xdc1115487740fdb69ec8c8ce9e13584a1d84f1e7df7b348be991f4be45220d0b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_opbnb.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_opbnb.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
0x509e81ef638d489936fa85bc58f52df01190d26c	false	20	21536145	2024-04-16T17:51:08.000Z	50217	0x365d851d8c7bdae4da67482859e2a60a98a09273f5f18eb2d2ca2276a5fefdb2	0xa2edd515b75abd009161b15909c19959484b0c1e
0x53d11cb8a0e5320cd7229c3acc80d1a0707f2672	false	58	21479331	2024-04-16T02:04:14.000Z	6646553193676364	0x788976184a9eacb3108b906c7e4e37f521e252a59581c3bb4dc5ba12ed89f838	0xa2edd515b75abd009161b15909c19959484b0c1e
0x13b492b8a03d072bab5c54ac91dba5b830a50917	false	25	21536181	2024-04-16T17:51:44.000Z	130947009095876949	0x10ed7735fc90c8a66d8c7c2c0022e5f4e58fa97e1cbdd383dc33daed73ee56e0	0xa2edd515b75abd009161b15909c19959484b0c1e

Example Query

Query with partition filter

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