venus_v1_ethereum - Token Terminal Docs

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
410376	true	19567	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	0x5c778605	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0x5caf2fee61b3c927228d889515ce751bb235ed48	23674074	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	1,5	2025-10-28T06:15:23.000Z	3950000000	0x85e6169e54ad196d26b08ab1e38982a34d26a99b78693b0be8e5213f16e4020e
276612	true	19567	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	0x5c778605	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xe799dcd99e9fb68c67fcedb25655401e6f7923d4	23675425	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	1,5	2025-10-28T10:47:47.000Z	4100000000	0x2209fcd4e41ed40191a22527af9aa26eef1fec44e436adafe63168e80b80b590
274962	true	19567	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	0x5c778605	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0x48a9789428f2067338d02b1ef3612df64f05feb7	23676357	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	1,5	2025-10-28T13:56:11.000Z	40000000000	0x8f5b46fac9c292d54c34e993bf12421d2ed8f48f997a01e9cf07caa183136a4d

Example Query

Query with partition filter

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

Comptroller_liquidateAccount_function

Function call records for Venus Protocol Comptroller liquidation operations containing borrower addresses and liquidation order arrays specifying vToken collateral, vToken borrowed, and repay amounts. Used for tracking undercollateralized position liquidations across Venus lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_orders`	`ARRAY<STRUCT<vTokenCollateral STRING, vTokenBorrowed STRING, repayAmount STRING>>`	Array of order or liquidation instruction structures specifying the tokens and amounts involved in the transaction.

Sample Data

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
11809	true	9511	0x47ef3b3b	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xa3429ca2d20169d5b30a4f0feb667ab49067b521	22104541	0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	0xa40f91e5c66de267e7ed41398e87661261679191	1,13	8628834	2025-03-22T19:34:35.000Z	0x3e1a1a00bb95a2514ebbc1236738d32528e175064a9204f4f3759b91351a822f	0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	158215059
238014	true	7511	0x47ef3b3b	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0x341702e899cfff867b6afee06bc59e031c1b004b	22020064	0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	0x7d6520275f03dbb389ab34080015496048d83a7a	1,3,0,3,1,13	5118365	2025-03-11T00:31:23.000Z	0x80612153d65254ee662c1b4f860d31152e8dcc4717cc2bab34136cfda1cddde8	0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	0x8716554364f20bca783cb2baa744d39361fd1d8d	3631324970
1342910	true	6707	0x47ef3b3b	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xa98e339f5a0f135792286d481b4e23d91a667d3f	23550481	0x256addbe0a387c98f487e44b85c29eb983413c5e	0xb441dea845a1a03a3e7aee81c03662fd9a1b6fda	0,2,1,1,13	391916863	2025-10-10T23:03:23.000Z	0xdcac62d401634a3572325430f87af34739d44146c679e08824e275bcd2accb36	0x256addbe0a387c98f487e44b85c29eb983413c5e	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	11242595055547855921730

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
0x687a01ecf6d3907658f7a7c714749fac32336d1b	false	0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	172	0x10b64b0470b0905b0f9d62d163489a0f3054c95b	21724645	2025-01-28T17:54:35.000Z	0x2105592aa080f1b4b2ba8e4485ba1a57d84c37b69190a30eb7f9b8b11024efba
0x687a01ecf6d3907658f7a7c714749fac32336d1b	false	0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	503	0x2b549e5e494004a86a43a826cb25b738d0d70dd0	21725598	2025-01-28T21:06:23.000Z	0xf4ef9bc3b07ee76626f44c9a36d8b1bd1dd78724e70555db00267b93b57d30be
0x687a01ecf6d3907658f7a7c714749fac32336d1b	false	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	309	0xda64a230fcaa9bf71cad1cd41a04ab4d1709e833	19714681	2024-04-23T01:02:11.000Z	0x3badfe3c1b4796d1cab62d609915930df7f90f2d933910003a1b0027af0167d6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
0x687a01ecf6d3907658f7a7c714749fac32336d1b	false	0xd8add9b41d4e1cd64edad8722ab0ba8d35536657	216	0x8bf26f6629560ba712c3f6f4616191dad477a339	20637381	2024-08-29T23:00:35.000Z	0xd186ab9d59f234445385fc63b93fc169bdbc9f1341f9b3a08db87254db670ffd
0x687a01ecf6d3907658f7a7c714749fac32336d1b	false	0xd8add9b41d4e1cd64edad8722ab0ba8d35536657	314	0x2ff6e7fc4a5ae462bfadff0bbbe18242782f8ef6	21850998	2025-02-15T09:40:47.000Z	0x0746e992ca64ad0495423b7cb06ad6f74c61613a52ff4307f2928be1a91f2fbd
0x687a01ecf6d3907658f7a7c714749fac32336d1b	false	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	334	0x2c7a1398368a38489bb6dc53b79b3e416b531636	20548413	2024-08-17T12:42:11.000Z	0x59db864c85d9d48e7012347118ac07ac173a3ba34f2da18675cb293c43383754

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
145927	true	17115	0x73b56f0dcade98e0e80b7ba2d24a6fee610f009e	0x256addbe0a387c98f487e44b85c29eb983413c5e	0x41c728b9	0x687a01ecf6d3907658f7a7c714749fac32336d1b	23605881	0x256addbe0a387c98f487e44b85c29eb983413c5e	5673317349623	1,7	2025-10-18T17:00:23.000Z	0xb90da9843579c15bd804a546bcbd038eef3f5f0bee78fe920cc136d8579df4ea	56754748423941987202544
144745	true	17115	0x8ccca92b80aecf9e330f9ab883a14bccd216c1a7	0xa836ce315b7a6bb19397ee996551659b1d92298e	0x41c728b9	0x687a01ecf6d3907658f7a7c714749fac32336d1b	23605307	0xa836ce315b7a6bb19397ee996551659b1d92298e	155325240	1,7	2025-10-18T15:05:11.000Z	0xb2ae4781a60f7123312474ef838fe4c6a66f137ea96c97bc64f2b5e7047fb70d	1553252408815590991
133657	true	17115	0x8ccca92b80aecf9e330f9ab883a14bccd216c1a7	0xa0ee2baa024cc3aa1bc9395522d07b7970ca75b3	0x41c728b9	0x687a01ecf6d3907658f7a7c714749fac32336d1b	23605332	0xa0ee2baa024cc3aa1bc9395522d07b7970ca75b3	0	1,7	2025-10-18T15:10:11.000Z	0xcc195cb0c024dd8354068f9f739d5d7e1acd9074f8277097c4d46f664767788f	8355513090

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
22347	true	19518	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	0x51dff989	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0x64c8ce646e0ec31ef0e4d0801ef2e9731a606684	21284540	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	1,6	2024-11-28T06:53:59.000Z	500000000000	47564203838870	0x84e8fec92ba457dc38bf689a8292d5647d60fd19c9424ede09edeaaf7e5a09f6
19984	true	17116	0x4fafbdc4f2a9876bd1764827b26fb8dc4fd1db95	0x51dff989	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xfb700c826c2b923748cb220db2a4a8e760e9def8	21286504	0x4fafbdc4f2a9876bd1764827b26fb8dc4fd1db95	1,9	2024-11-28T13:29:59.000Z	5477958335512224890036	528351953858	0xc32f2a62f1a156c87d0632954e5aaeb57b2844875d27c6e7513cd3acc08501ad
178715	true	17116	0x256addbe0a387c98f487e44b85c29eb983413c5e	0x51dff989	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0x98ecb04542fd22e1c8a7e7575895710f0c3cfb7f	22003373	0x256addbe0a387c98f487e44b85c29eb983413c5e	1,6	2025-03-08T16:32:59.000Z	169227274050919110312	16922726909	0x7e4b5803a3f029d71fd494fa7317c58e6c837f07d92a7135e2fc084458c2b3a4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
22467	true	19626	0xd35f0270de1d128a435d55c1b42b1171f093f29c	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	0x1ededc91	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xd35f0270de1d128a435d55c1b42b1171f093f29c	21115255	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	1,6	2024-11-04T15:42:59.000Z	1065108223469597497	0xbb968c8a0e3b800b93fc885038febe51be0bbac77236db263b39d5e68405def1	71728353260
30129	true	3920	0x044dd75b9e043acfd2d6eb56b6bb814df2a9c809	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	0x1ededc91	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0x9b8238e959d70f15cc838b06ba7c1135aa0f2381	19588214	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	3,1,4	2024-04-05T08:00:35.000Z	1002210197302122687	0x9f17edd556b1d839da2415d3bda562b65e204775a48992c5e729ce0f6ca3f81c	85003731687676499537
7006	true	3920	0xc72f3295b7fe847ec99e3a3c6dd6e90db5e1061b	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	0x1ededc91	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xc72f3295b7fe847ec99e3a3c6dd6e90db5e1061b	19589405	0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	1,6	2024-04-05T12:01:47.000Z	1009263043273689614	0xd4dedae32bec4a1fd746de178a0abe3f87f7a0cdfb9728bd60ff49c1425162a4	100081000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
221270	true	6672	0x6d35bf91	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xdb5f56c0566e5517f265358039e5b00a8ad5c594	22018382	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	0x8ce45e650ab17b6ca0dd6071f7c2b5c69b5b42b2	0,6,1,12,1,5	268736992	2025-03-10T18:53:23.000Z	0xed6b84ef97443a4ef022fbb64a7e83e35688fe7155a6f35e13f5590913e59808	0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	0x7c8ff7d2a1372433726f879bd945ffb250b94c65
200490	true	6672	0x6d35bf91	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xa98e339f5a0f135792286d481b4e23d91a667d3f	23550350	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	0xc389a2f0e3e4503d0760ec9538797eb38985b8c7	1,1,0,2,1,12,1,5	785067072	2025-10-10T22:36:59.000Z	0xc44b3c7901c6d7b262699fdf57357faa33fdcf54cbf1a2047e64b418fb6edd17	0x256addbe0a387c98f487e44b85c29eb983413c5e	0x7c8ff7d2a1372433726f879bd945ffb250b94c65
201065	true	6672	0x6d35bf91	0x687a01ecf6d3907658f7a7c714749fac32336d1b	0xa98e339f5a0f135792286d481b4e23d91a667d3f	23550346	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	0xc389a2f0e3e4503d0760ec9538797eb38985b8c7	1,1,0,2,1,12,1,5	871204411	2025-10-10T22:36:11.000Z	0x97c4d028c1e6e39ad2628042823986159101cb8a3b214bb1ac9dbd985a559e6e	0x256addbe0a387c98f487e44b85c29eb983413c5e	0x7c8ff7d2a1372433726f879bd945ffb250b94c65

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
177017	0x8cfd343cd269ed84dfbe3fed6c0f0fa8b20c0b15	0x941f6a7e74e55edc9fcb52836b2ea103d0987a10	true	19615	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	0x6a56947e	0x687a01ecf6d3907658f7a7c714749fac32336d1b	23473269	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	1,1	2025-09-30T03:57:23.000Z	0x1df4cbbfb5dab3d3782f0523a6946eda87f8a0e2f6fd0337e8abe095cf837445	1436975163
177023	0x11c0e5a358edac7646c4dfc1a3624b1e62b9eff6	0xfc7ac3221ac007024f0b760f08029ab644a2b4c4	true	19615	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	0x6a56947e	0x687a01ecf6d3907658f7a7c714749fac32336d1b	23473243	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	1,1	2025-09-30T03:52:11.000Z	0xceae77324fad5884923c756be210686947d489f177adb0fb5fe4d326ec176acf	9859427009
177017	0xc0a6a8fd1d8de03081a8e41b9a216f2823b254f5	0xc6f839c982ce5cf8b3ed9ac23523d2315e970502	true	19615	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	0x6a56947e	0x687a01ecf6d3907658f7a7c714749fac32336d1b	23468949	0x7c8ff7d2a1372433726f879bd945ffb250b94c65	1,1	2025-09-29T13:28:59.000Z	0xf2db67f6e669daa1a8143944efa0883fc15f8234d7aff503106fc3e6509569d0	1972924414

Example Query

Query with partition filter

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

ComptrollerCurve_borrowVerify_function

Venus Protocol v1 comptroller borrow verification function calls on Ethereum, capturing each borrow validation with vToken address, borrower, and borrow amount. Used for analyzing lending protocol risk management and borrow approval patterns.

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
6867	true	3796	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	0x5c778605	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xeb7712be87c541fa1a7cf647ca927a5c8da814a3	20088057	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	1,5	2024-06-14T05:48:35.000Z	240000000000000000000000	0x5c4da0353f19f2983e454f08a3dca92ded437cd38d7938964b2f7948adfa3619
6867	true	3796	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x5c778605	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0x772d986974b41a79601000e27a89cc29168fd69d	19786522	0x2d499800239c4cd3012473cb1eae33562f0a6933	1,8	2024-05-03T02:10:47.000Z	100000000000000000000000	0xbe406c66211b7c4ffde9b574c339613bc81c1e91df7edc3dfa883aff366f7e34
6867	true	3796	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x5c778605	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xd98a1b4082052b57e5688a69d07263c4b7963c5d	20003772	0x2d499800239c4cd3012473cb1eae33562f0a6933	1,8	2024-06-02T11:15:35.000Z	3700000000000000000000	0xe04806049163c6adbf3ccf0b66f43cc1647cc56f72329bba3e6535b1b2e93d0a

Example Query

Query with partition filter

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

ComptrollerCurve_liquidateAccount_function

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_orders`	`ARRAY<STRUCT<vTokenCollateral STRING, vTokenBorrowed STRING, repayAmount STRING>>`	Array of order or liquidation instruction structures specifying the tokens and amounts involved in the transaction.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

ComptrollerCurve_liquidateBorrowVerify_function

Liquidation verification events from Venus Protocol’s Comptroller contract on Ethereum, recording when the protocol validates borrow liquidations with collateral seizure amounts. Used for analyzing liquidation mechanics, including repayment amounts and vToken (Venus Protocol tokens) collateral transfers between borrowers and liquidators.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vTokenBorrowed`	`STRING`	Contract address of the vToken representing the borrowed asset in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_vTokenCollateral`	`STRING`	Contract address of the vToken representing the collateral being seized in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_actualRepayAmount`	`STRING`	Amount of tokens repaid in the transaction. Numeric string representing the quantity in the smallest unit of the underlying asset.
`in_seizeTokens`	`STRING`	Quantity of collateral tokens seized from the borrower during liquidation. Numeric string representing the amount in the smallest unit of the collateral token.

Sample Data

gas	value	status	gas_used	signature	to_address	in_borrower	block_number	from_address	in_liquidator	trace_address	in_seizeTokens	block_timestamp	transaction_hash	in_vTokenBorrowed	in_vTokenCollateral	in_actualRepayAmount
543395	0	true	1957	0x47ef3b3b	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xc7bce04163374984e6aa210b3b8e444067df2355	20237179	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x167f6e958a1a082e33c75fab66bd511016e51340	0,3,7,1,16	409262945615	2024-07-05T01:59:47.000Z	0x39352f3b0b5d62fd93d4010af59ff34052c905403a6c617b35950dd72934a9e6	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	884389952058469794122
559527	0	true	1957	0x47ef3b3b	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xc7bce04163374984e6aa210b3b8e444067df2355	20080623	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x167f6e958a1a082e33c75fab66bd511016e51340	0,3,7,1,13	704257783741	2024-06-13T04:49:11.000Z	0x83647fb049b89d021c13fa834d7d77b909424d18d4feca8ff8daee2187dc229e	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	1698151794072167221556

Example Query

Query with partition filter

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

ComptrollerCurve_MarketEntered_event

Events recording when user accounts enter new lending markets in Venus Protocol’s Curve pool comptroller on Ethereum. Tracks account-to-vToken relationships for analyzing market participation and collateral enablement patterns.

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
0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	false	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	332	0x47589353dde79ced0b97cf8f685a34657d752c19	20727433	2024-09-11T12:41:23.000Z	0x2921759dbf2435f7e486e40922f4cac0ba8d172b171ccc1ec8b232bc9482ebd6
0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	false	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	374	0xa787f09349999a61434cfb75118c6a9d0cac9406	19806139	2024-05-05T20:00:47.000Z	0x88d6a2aa778fca2fc4b29513f07a6c1d88dca0c6eebcb2cc9270131a1981add1
0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	false	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	440	0xc72f3295b7fe847ec99e3a3c6dd6e90db5e1061b	19599333	2024-04-06T21:22:59.000Z	0x4d82c8559c351b5cc09dc8c945be9cf56f5d7f19cc57d3406bb09a3f46244cea

Example Query

Query with partition filter

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

ComptrollerCurve_MarketExited_event

No description available.

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

No sample data available.

Example Query

Query with partition filter

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

ComptrollerCurve_mintVerify_function

Verification events from Venus Protocol’s ComptrollerCurve contract on Ethereum that validate vToken minting operations, recording minter addresses, token amounts, and actual mint values. Used for analyzing lending protocol mint transaction validation and supply-side activity across Venus 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_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
6886	true	3813	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x41c728b9	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	19671708	0x2d499800239c4cd3012473cb1eae33562f0a6933	1848218924841	1,7	2024-04-17T00:47:59.000Z	0xc56c51a618a325c3f71db304e5786f738adfb70e162695d493853d8bff626ed6	18500000000000000000000
6886	true	3813	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x41c728b9	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	19671692	0x2d499800239c4cd3012473cb1eae33562f0a6933	4195956788730	1,10	2024-04-17T00:44:47.000Z	0xcbae62a73128b4058448d04c28f3d8db83a501a6ca785f33bcf3afe4405b86fc	42000000000000000000000
160075	true	17182	0x15525da6cd5cf7c2afab280477850ee9709464fd	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x41c728b9	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	20518471	0x2d499800239c4cd3012473cb1eae33562f0a6933	1980183008354	1,7	2024-08-13T08:20:47.000Z	0x410b065b32e375f604816bf9218484fe3a2c252dd6889b3f4e5294bbad6156df	20000000000000000000000

Example Query

Query with partition filter

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

ComptrollerCurve_redeemVerify_function

Redemption verification function calls from Venus Protocol’s Curve Comptroller contract on Ethereum, tracking vToken redemptions with amounts, redeemer addresses, and execution status. Used for analyzing lending market withdrawals and comptroller validation logic.

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
6822	true	3747	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	0x51dff989	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0x772d986974b41a79601000e27a89cc29168fd69d	20252927	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	1,6	2024-07-07T06:44:47.000Z	8246179588949913277521	821385010965	0x3ccaa70895e7585fdcebb44762df81782f8c2e51f4653495af1e116abc0a31f4
6822	true	3747	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	0x51dff989	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0x772d986974b41a79601000e27a89cc29168fd69d	20252863	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	1,9	2024-07-07T06:31:59.000Z	130000000000006693472930	12949036184666	0xc5ae9d630d9ffa7e7bb387f67f5fbce7c8e671fc7db444dc063fde7819f97186
6822	true	3747	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	0x51dff989	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0x772d986974b41a79601000e27a89cc29168fd69d	20252878	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	1,6	2024-07-07T06:34:59.000Z	120000000000004733219861	11952955460082	0x5f2ffc74c0f3d80797965dad13ab352def6d967c59844bf60ec4f726f426a988

Example Query

Query with partition filter

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

ComptrollerCurve_repayBorrowVerify_function

Borrow repayment verification events from Venus Protocol’s Curve Comptroller on Ethereum, capturing payer, borrower, vToken addresses, repayment amounts, and borrower index values. Used for tracking loan repayment validations and analyzing lending protocol activity.

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
20172	true	17290	0xeb7712be87c541fa1a7cf647ca927a5c8da814a3	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	0x1ededc91	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xeb7712be87c541fa1a7cf647ca927a5c8da814a3	20518434	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	1,6	2024-08-13T08:13:23.000Z	1030356084162085938	0xd426c57ee2076993a92459f2a977283ba8276efbf3762f0c3c820343042ddc70	201447506908169860333756
20168	true	17290	0xeb7712be87c541fa1a7cf647ca927a5c8da814a3	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x1ededc91	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xeb7712be87c541fa1a7cf647ca927a5c8da814a3	20518350	0x2d499800239c4cd3012473cb1eae33562f0a6933	1,6	2024-08-13T07:55:59.000Z	1021987884263112122	0x3ce358c2a36a2806ac881a53d2f7e0040445e79d4b25ddd5f9375d79b68cea45	35131128772437064747815
7007	true	3920	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x1ededc91	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	19671725	0x2d499800239c4cd3012473cb1eae33562f0a6933	1,6	2024-04-17T00:51:23.000Z	1001872474855632588	0x8070e43dbb0bb42fe2cb33f0525cc7ed687a47f831861e757dac4b9e5ece9878	8279998091818417708450

Example Query

Query with partition filter

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

ComptrollerCurve_seizeVerify_function

Liquidation verification function calls from Venus Protocol’s ComptrollerCurve contract on Ethereum, recording when the protocol validates seizure of collateral tokens during liquidations. Tracks borrower addresses, liquidator addresses, vToken pairs, and seized token amounts for analyzing liquidation mechanics and collateral transfers.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`FLOAT64`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vTokenCollateral`	`STRING`	Contract address of the vToken representing the collateral being seized in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_vTokenBorrowed`	`STRING`	Contract address of the vToken representing the borrowed asset in the liquidation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidator`	`STRING`	Address of the account executing the liquidation operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_seizeTokens`	`STRING`	Quantity of collateral tokens seized from the borrower during liquidation. Numeric string representing the amount in the smallest unit of the collateral token.

Sample Data

gas	value	status	gas_used	signature	to_address	in_borrower	block_number	from_address	in_liquidator	trace_address	in_seizeTokens	block_timestamp	transaction_hash	in_vTokenBorrowed	in_vTokenCollateral
539598	0	true	1944	0x6d35bf91	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xc7bce04163374984e6aa210b3b8e444067df2355	20080623	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	0x167f6e958a1a082e33c75fab66bd511016e51340	0,3,7,1,12,1,5	704257783741	2024-06-13T04:49:11.000Z	0x83647fb049b89d021c13fa834d7d77b909424d18d4feca8ff8daee2187dc229e	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda
527028	0	true	1944	0x6d35bf91	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	0xc7bce04163374984e6aa210b3b8e444067df2355	20237179	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	0x167f6e958a1a082e33c75fab66bd511016e51340	0,3,7,1,15,1,5	409262945615	2024-07-05T01:59:47.000Z	0x39352f3b0b5d62fd93d4010af59ff34052c905403a6c617b35950dd72934a9e6	0x2d499800239c4cd3012473cb1eae33562f0a6933	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda

Example Query

Query with partition filter

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

ComptrollerCurve_transferVerify_function

No description available.

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.ComptrollerCurve_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
0x61caff113ccaf05ffc6540302c37adcf077c5179	false	199	21372419	0x687a01ecf6d3907658f7a7c714749fac32336d1b	2024-12-10T13:32:11.000Z	0x25c20e6e110a1ce3febacc8b7e48368c7b2f0c91	0x288d16d8b0e1d2b1dddd0196ce1bf78cad8a5bf1a09859f76b059bf078f37c8b
0x61caff113ccaf05ffc6540302c37adcf077c5179	false	305	20133439	0xf522cd0360ef8c2ff48b648d53ea1717ec0f3ac3	2024-06-20T14:08:47.000Z	0xdb6c345f864883a8f4cae87852ac342589e76d1b	0x00210ccb700b0c32ec140c005e03f3e24a755d7778f1d1bc9bbbac63056d6b5b
0x61caff113ccaf05ffc6540302c37adcf077c5179	false	120	20413675	0xf522cd0360ef8c2ff48b648d53ea1717ec0f3ac3	2024-07-29T17:20:11.000Z	0xa854d35664c658280fff27b6edc6c4195c3229b3	0xe48ce59d08305c27e3ecfc71f6ce0b087277dcf72e640a4f16235ddb88d5e16e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
0x61caff113ccaf05ffc6540302c37adcf077c5179	{“name”:“Liquid Staked ETH”,“creator”:“0x285960c5b22fd66a736c7136967a3eb15e93cc67”,“blockPosted”:“19368106”,“comptroller”:“0xf522cd0360ef8c2ff48b648d53ea1717ec0f3ac3”,“timestampPosted”:“1709631359”}	false	480	19368106	0xf522cd0360ef8c2ff48b648d53ea1717ec0f3ac3	2024-03-05T09:35:59.000Z	0x6aab7c9472b72b0eae785d452a68806cb93f23105491a6099d6d4fc63ee76ca3
0x61caff113ccaf05ffc6540302c37adcf077c5179	{“name”:“Curve”,“creator”:“0x285960c5b22fd66a736c7136967a3eb15e93cc67”,“blockPosted”:“19113140”,“comptroller”:“0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796”,“timestampPosted”:“1706542883”}	false	271	19113140	0x67aa3ecc5831a65a5ba7be76bed3b5dc7db60796	2024-01-29T15:41:23.000Z	0xb1514dde68baaeabc582e364d482dfe205c366c41c7e36e88e11601e2489d27b
0x61caff113ccaf05ffc6540302c37adcf077c5179	{“name”:“Core”,“creator”:“0x285960c5b22fd66a736c7136967a3eb15e93cc67”,“blockPosted”:“19113140”,“comptroller”:“0x687a01ecf6d3907658f7a7c714749fac32336d1b”,“timestampPosted”:“1706542883”}	false	265	19113140	0x687a01ecf6d3907658f7a7c714749fac32336d1b	2024-01-29T15:41:23.000Z	0xb1514dde68baaeabc582e364d482dfe205c366c41c7e36e88e11601e2489d27b

Example Query

Query with partition filter

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

vcrvUSDCore_AccrueInterest_event

Interest accrual events from Venus Protocol’s crvUSD Core market on Ethereum, capturing periodic updates to borrow indices, outstanding borrows, available cash, and accumulated interest. Used for tracking lending pool state changes and calculating historical interest rates.

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
0x8716554364f20bca783cb2baa744d39361fd1d8d	false	471	19448655	29818818	1000000000000000000	2024-03-16T16:31:59.000Z	0	0x545abcae10ef94d07e5fe7d21e89017a3c4f5b494fe73e128489f8281cbf2d38	0
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	517	19446868	10000000000	1000000000000000000	2024-03-16T10:28:59.000Z	0	0x3e601e7b290f8b9a43b724a09172de8a98a4465c1b5c82d0249948102805ec5d	0
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	332	19449595	15194489589896658433	1001705364467835056	2024-03-16T19:42:11.000Z	1002558542735632645	0x7dfb5abc9d5cea56ec1b8275453c38cb0486d076cd60373e81bb31ed34c69be7	352783759478

Example Query

Query with partition filter

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

vcrvUSDCore_Borrow_event

Borrow event records from Venus Protocol’s crvUSD Core market on Ethereum, capturing when users borrow crvUSD against collateral. Tracks individual borrow amounts, cumulative account borrows, and protocol-wide total borrows for lending activity 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_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
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	625	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	19113393	2024-01-29T16:32:35.000Z	500000000000000000	500000000000000000	0xfc5f5a463be2effb0e65c0ba91cd76fad6b8b05cc194ff59e0f522a09cf5d07e	500000000000000000
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	161	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	19113434	2024-01-29T16:40:47.000Z	14000	400000000024642984	0x4dd87152c7fe8b25775d7a48ebc28100be5e80878b9ee9be703f30b5f9b3da15	400000000024642984
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	520	0x3a7b003c06df82ba4b34d9ffd3b7c2856bbab6d1	19446868	2024-03-16T10:28:59.000Z	6000000000	6000000000	0x3e601e7b290f8b9a43b724a09172de8a98a4465c1b5c82d0249948102805ec5d	6000000000

Example Query

Query with partition filter

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

vcrvUSDCore_Mint_event

Mint events from Venus Protocol vToken markets on Ethereum where users deposit crvUSD collateral and receive vTokens in return. Tracks depositor addresses, underlying asset amounts, minted vToken quantities, and resulting account balances for analyzing Venus lending market supply activity.

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
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0x22203e23c0ecec265b19a7173b095f91a9b0ab10	252	19465421	1700000000000000000	169958919	2024-03-19T01:05:47.000Z	0x18812c228960a3702a9d0f0f0f7e633bcd80578624b2c13b4203e5a502b96ada	169958919
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0xb81d163e3e03aa9a06cd5fc7d1434ef7b26d185c	391	19304736	4993999999999999999	499298869	2024-02-25T12:56:23.000Z	0xad23a7d83a264d8fd4788b0596b5faa15346ee71f86e90c7512ef7b1292a912d	499298869
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	301	19128989	2800000000000000000	280000000	2024-01-31T20:57:47.000Z	0xcc88354b91d2bc125ddb5b53c85c5ad7408be36c8c03ea7b7bd6c36a5ac8ae00	280000000

Example Query

Query with partition filter

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

vcrvUSDCore_NewReserveFactor_event

Reserve factor configuration changes for Venus Protocol crvUSD market on Ethereum. Tracks updates to the protocol’s reserve percentage (portion of interest allocated to reserves) with old and new mantissa values for analyzing protocol parameter governance.

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
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	98	18968064	2024-01-09T07:56:59.000Z	0x125b63fe4d108c83c50813b5497da59a5630fd6a9a9e49f5cfedb0c2f1d0b40b	100000000000000000
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	183	18968062	2024-01-09T07:56:35.000Z	0x3810d5a8f9dc816ad76b5f2ef9f0714f36544a9af7200b541c5f157a10e26825	100000000000000000
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	96	18968058	2024-01-09T07:55:47.000Z	0x113646138998da6fa9651654fd6f3a8cbe3393804de3933d9bc780f34fb077b8	200000000000000000

Example Query

Query with partition filter

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

vcrvUSDCore_Redeem_event

Redemption events from Venus Protocol’s crvUSD Core market (vToken) on Ethereum, tracking withdrawals where users exchange vTokens for underlying crvUSD assets. Contains redeemer addresses, token amounts withdrawn, and remaining account balances for analyzing market liquidity and user withdrawal patterns.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.
`in_accountBalance`	`STRING`	Account balance of interest-bearing VTokens held by the minter or redeemer after the mint or redeem operation. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash	in_accountBalance
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	335	0x8a2d4e906d55c1a7ff043dd2a0335b722b1271e9	19449595	2024-03-16T19:42:11.000Z	1000000012304559076	99976025	0x7dfb5abc9d5cea56ec1b8275453c38cb0486d076cd60373e81bb31ed34c69be7	0
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	449	0x4c9253f44723f0d4f4180c82f3d7657474736a32	19404639	2024-03-10T12:17:47.000Z	84999998972766081	8498031	0xf385b3c334859c4a90a2706bf164c91b8539281e00ca9dd8cf1504bc30e4f1b9	0
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	365	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	19348332	2024-03-02T15:19:11.000Z	600000001088770882	59986727	0x8c10f147d9a43063f9b99e74ae3f5b78b7ae4ff20a0fe391b9b38bac32df5d08	220013273

Example Query

Query with partition filter

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

vcrvUSDCore_RepayBorrow_event

Borrow repayment events from Venus Protocol’s crvUSD Core market on Ethereum, tracking when users pay down debt positions. Records include repayment amounts, remaining account borrows, and updated protocol-wide total borrows for analyzing deleveraging activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0x4c9253f44723f0d4f4180c82f3d7657474736a32	433	0x4c9253f44723f0d4f4180c82f3d7657474736a32	19404606	40000007789918372	2024-03-10T12:11:11.000Z	1002433223050098849	0x3e11d218ba28873ad438d26689a785e02de992221618324f7c3167006c3fc8b0	0
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	240	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	19348335	600000001088770882	2024-03-02T15:19:47.000Z	1002274499272062198	0xc32f842bda2ef01372b3e4cb4247dbad0e1aa7cd72e605369b12132464f4a037	1002274499272062198
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	210	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	19113416	100000000000000000	2024-01-29T16:37:11.000Z	400000000016409810	0x6c3e29bd7a080b4e897cb636e25d7bd47af0e6aa32efc86318f265243399cd48	400000000016409810

Example Query

Query with partition filter

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

vERC20_AccrueInterest_event

Interest accrual events from Venus Protocol (Compound fork) vToken markets on Ethereum, recording accumulated interest, total borrows, and borrow index updates for each market. Used for tracking lending pool interest rates and calculating borrower debt over time.

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
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	517	19446868	10000000000	1000000000000000000	2024-03-16T10:28:59.000Z	0	0x3e601e7b290f8b9a43b724a09172de8a98a4465c1b5c82d0249948102805ec5d	0
0x8716554364f20bca783cb2baa744d39361fd1d8d	false	471	19448655	29818818	1000000000000000000	2024-03-16T16:31:59.000Z	0	0x545abcae10ef94d07e5fe7d21e89017a3c4f5b494fe73e128489f8281cbf2d38	0
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	332	19449595	15194489589896658433	1001705364467835056	2024-03-16T19:42:11.000Z	1002558542735632645	0x7dfb5abc9d5cea56ec1b8275453c38cb0486d076cd60373e81bb31ed34c69be7	352783759478

Example Query

Query with partition filter

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

vERC20_Borrow_event

Borrow event logs from Venus Protocol (Compound fork) vToken markets on Ethereum, recording each borrow transaction with borrower address, amount borrowed, and updated total borrows per account and market. Used for tracking leverage usage, borrowing patterns, and protocol debt positions across Venus money 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_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
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	625	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	19113393	2024-01-29T16:32:35.000Z	500000000000000000	500000000000000000	0xfc5f5a463be2effb0e65c0ba91cd76fad6b8b05cc194ff59e0f522a09cf5d07e	500000000000000000
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	161	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	19113434	2024-01-29T16:40:47.000Z	14000	400000000024642984	0x4dd87152c7fe8b25775d7a48ebc28100be5e80878b9ee9be703f30b5f9b3da15	400000000024642984
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	145	0x4c9253f44723f0d4f4180c82f3d7657474736a32	19404539	2024-03-10T11:57:35.000Z	40000000000000000	1042433027828312324	0x97d67743059d6ced90e675c08a582a48bb837823cabcdc61c216b1c0aba6225b	40000000000000000

Example Query

Query with partition filter

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

vERC20_Mint_event

Mint events from Venus Protocol v1 lending markets on Ethereum, recording when users supply collateral and receive vTokens in return. Tracks minter addresses, underlying token amounts deposited, vTokens minted, and resulting account balances for analyzing supply-side activity.

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
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0x4c9253f44723f0d4f4180c82f3d7657474736a32	206	19404468	85000000000000000	8498031	2024-03-10T11:43:11.000Z	0xd6e0e05352d2b53fd4f1c5bb3816e3b2971f0c18082141af3f8d8d6711131ccf	8498031
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	477	19113383	1000000000000000	100000	2024-01-29T16:30:35.000Z	0x59470ee3db1fa6eb612d2a87b5f785365b3f1b133b90c9323d868baf41939fd9	100000
0x8716554364f20bca783cb2baa744d39361fd1d8d	false	0xfd9b071168bc27dbe16406ec3aba050ce8eb22fa	289	19113140	29818818	29818818	2024-01-29T15:41:23.000Z	0xb1514dde68baaeabc582e364d482dfe205c366c41c7e36e88e11601e2489d27b	29818818

Example Query

Query with partition filter

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

vERC20_NewReserveFactor_event

Reserve factor changes for Venus Protocol vToken markets on Ethereum, tracking the percentage of borrower interest allocated to protocol reserves. Used for analyzing protocol fee adjustments and treasury income across different 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.
`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
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	183	18968062	2024-01-09T07:56:35.000Z	0x3810d5a8f9dc816ad76b5f2ef9f0714f36544a9af7200b541c5f157a10e26825	100000000000000000
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	98	18968064	2024-01-09T07:56:59.000Z	0x125b63fe4d108c83c50813b5497da59a5630fd6a9a9e49f5cfedb0c2f1d0b40b	100000000000000000
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	96	18968058	2024-01-09T07:55:47.000Z	0x113646138998da6fa9651654fd6f3a8cbe3393804de3933d9bc780f34fb077b8	200000000000000000

Example Query

Query with partition filter

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

vERC20_Redeem_event

Redemption events from Venus Protocol vToken (interest-bearing token) contracts on Ethereum, capturing when users withdraw underlying assets by burning vTokens. Contains redemption amounts, vToken quantities burned, and resulting account balances for analyzing lending protocol withdrawals and liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.
`in_accountBalance`	`STRING`	Account balance of interest-bearing VTokens held by the minter or redeemer after the mint or redeem operation. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash	in_accountBalance
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	365	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	19348332	2024-03-02T15:19:11.000Z	600000001088770882	59986727	0x8c10f147d9a43063f9b99e74ae3f5b78b7ae4ff20a0fe391b9b38bac32df5d08	220013273
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	449	0x4c9253f44723f0d4f4180c82f3d7657474736a32	19404639	2024-03-10T12:17:47.000Z	84999998972766081	8498031	0xf385b3c334859c4a90a2706bf164c91b8539281e00ca9dd8cf1504bc30e4f1b9	0
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	335	0x8a2d4e906d55c1a7ff043dd2a0335b722b1271e9	19449595	2024-03-16T19:42:11.000Z	1000000012304559076	99976025	0x7dfb5abc9d5cea56ec1b8275453c38cb0486d076cd60373e81bb31ed34c69be7	0

Example Query

Query with partition filter

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

vERC20_RepayBorrow_event

Loan repayment events from Venus Protocol (v1) vToken markets on Ethereum, tracking borrower debt reductions with repayment amounts, remaining balances, and total market borrows. Used to analyze lending market repayment activity, liquidation patterns, and borrower debt management.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_payer`	`STRING`	Address of the account that provided the funds for the repayment or payment transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayAmount`	`STRING`	Amount of debt repaid in the transaction. Denominated in the smallest unit of the underlying token.
`in_accountBorrows`	`STRING`	Total amount currently borrowed by the individual account. Denominated in the smallest unit of the underlying token.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0x4c9253f44723f0d4f4180c82f3d7657474736a32	433	0x4c9253f44723f0d4f4180c82f3d7657474736a32	19404606	40000007789918372	2024-03-10T12:11:11.000Z	1002433223050098849	0x3e11d218ba28873ad438d26689a785e02de992221618324f7c3167006c3fc8b0	0
0x672208c10aaaa2f9a6719f449c4c8227bc0bc202	false	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	210	0x68dc394aa8afe0af3f772deecb97dc63fb5e0b77	19113416	100000000000000000	2024-01-29T16:37:11.000Z	400000000016409810	0x6c3e29bd7a080b4e897cb636e25d7bd47af0e6aa32efc86318f265243399cd48	400000000016409810
0x7c8ff7d2a1372433726f879bd945ffb250b94c65	false	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	240	0xe4f683b80e8e141313dd5f2d0066f66e454a57bf	19348335	600000001088770882	2024-03-02T15:19:47.000Z	1002274499272062198	0xc32f842bda2ef01372b3e4cb4247dbad0e1aa7cd72e605369b12132464f4a037	1002274499272062198

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.vERC20_RepayBorrow_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	transaction_hash
0x325ceb02fe1c2ff816a83a5770ea0e88e2faecf2	false	291	21311201	219666121	1000000000000000000	2024-12-02T00:19:11.000Z	0x3095a1f9941c9d343b834cb2317575c1248e2da08513233776fcb980d02e1793
0x325ceb02fe1c2ff816a83a5770ea0e88e2faecf2	false	366	21311457	360956746	1000000000000000000	2024-12-02T01:10:35.000Z	0x54a5e0bf8010611281367125a3a0beb6a1d1450bda2c26728d4f6bdc68871741
0x325ceb02fe1c2ff816a83a5770ea0e88e2faecf2	false	273	21311495	426845599	1000000000000000000	2024-12-02T01:18:11.000Z	0xa3420774f64eba1471b20dafa3aac4fad0fa5e4a7b2558ecd63348562fa9ba76

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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_ethereum.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_ethereum.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
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	684	0x43c0d84bbc4f819841387155e495a51a6779982a	21413739	2024-12-16T07:59:23.000Z	3000000000	4003722678551	0xdabf335b137ca9d73ddf26fa13bc3bfa03f020fed66bfbb715c03eaf57c0f042	35302061011
0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	false	191	0x7051d15c06d3a44396de57b933d5e74552daf9cd	19538917	2024-03-29T09:58:11.000Z	1800000000	12971131579	0xab97db1b9c71e15a9b9dd20d20cb604d777b1b899fbc57c11a8687fc76b44a0a	1800000000
0xb4933af59868986316ed37fa865c829eba2df0c7	false	249	0x073be86d6cf0a64acf4a67e302d021a2dd4bba02	19789228	2024-05-03T11:15:47.000Z	10000000000000000000	568660575832230519758	0x692c1268d2f8b1c6b05854819c3dd62057bb800313bc80e9c429b9a2e9854259	165000241707266494914

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
0x2d499800239c4cd3012473cb1eae33562f0a6933	false	51	0xc7bce04163374984e6aa210b3b8e444067df2355	20080623	0x167f6e958a1a082e33c75fab66bd511016e51340	1698151794072167221556	704257783741	2024-06-13T04:49:11.000Z	0x83647fb049b89d021c13fa834d7d77b909424d18d4feca8ff8daee2187dc229e	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda
0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	false	197	0xb81d163e3e03aa9a06cd5fc7d1434ef7b26d185c	20460822	0x167f6e958a1a082e33c75fab66bd511016e51340	4754114218	226529760	2024-08-05T07:18:11.000Z	0x0fcdb11380c9e48975bd3f7ec04284c040b06bafcb5c53f34c6610a5fe36c655	0x7c8ff7d2a1372433726f879bd945ffb250b94c65
0x2d499800239c4cd3012473cb1eae33562f0a6933	false	339	0xc7bce04163374984e6aa210b3b8e444067df2355	20237179	0x167f6e958a1a082e33c75fab66bd511016e51340	884389952058469794122	409262945615	2024-07-05T01:59:47.000Z	0x39352f3b0b5d62fd93d4010af59ff34052c905403a6c617b35950dd72934a9e6	0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	0x57a13950027a52ec31d48ad7a01675c04941e8f1	246	20048028	72062313243	7097900244704	2024-06-08T15:32:59.000Z	0x90c64e419cfaaa98e94555307ea0f0e351379ff3ee9b09a185752b9b29f0606d	25316677149690
0x30ad10bd5be62cab37863c2bfcc6e8fb4fd85bda	false	0xd98a1b4082052b57e5688a69d07263c4b7963c5d	153	20048477	127980000000000000000000	12762070731673	2024-06-08T17:03:11.000Z	0x115286033472efdf0cb2170ee9dc0091cbae7f3d60d8c8c9b67046a8489db202	14954569067566
0x4fafbdc4f2a9876bd1764827b26fb8dc4fd1db95	false	0x35e2a11f743a43f00381a0aeb6764322ef1eb788	98	20045740	1079042691000000000000	106857327915	2024-06-08T07:52:59.000Z	0x39dcda4a0818bc922168e0d9d4c77fd91aebd28b22da6f76b501a890c226f04c	1512925146224

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
0x62d9e2010cff87bae05b91d5e04605ef864abc3b	false	103	21441889	2024-12-20T06:17:35.000Z	0xb7b383398766570e8e58e12f2e7960c37802e602710a003d1f8b790dc5dbb3fa
0x0792b9c60c728c1d2fd6665b3d7a08762a9b28e0	false	179	21441891	2024-12-20T06:17:59.000Z	0x519468b2b77d51b526f8d6a2fa5a550ec347f9eb4556aa708e20a15948473bdb
0xcca202a95e8096315e3f19e46e19e1b326634889	false	233	21441890	2024-12-20T06:17:47.000Z	0x12a12886c8476188ab5cca63ea2f4de829c1993bb8cea97d48e8cd7f533cfd63

Example Query

Query with partition filter

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

VToken_Redeem_event

VToken redemption events emitted when users withdraw underlying assets from Venus Protocol lending pools by burning interest-bearing VTokens. Records redeemer address, VToken amount burned, underlying asset amount received, and resulting VToken balance for tracking lending protocol withdrawals and liquidity analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.
`in_accountBalance`	`STRING`	Account balance of interest-bearing VTokens held by the minter or redeemer after the mint or redeem operation. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash	in_accountBalance
0xc82780db1257c788f262fbbda960b3706dfdcaf2	false	433	0x87b9d6e007fac40716877101d5dd5950e7321f14	20736011	2024-09-12T17:26:11.000Z	1995152642090516022	194218340	0x9b596e41e7196107b50b27994e0eacfe36b6b419191dafbe88b7303ce26a028c	25
0xef26c64bc06a8de4ca5d31f119835f9a1d9433b9	false	300	0xedf1086b81f979354fc2ea07260eb83f5852eb15	20736311	2024-09-12T18:26:11.000Z	2127124006697630295	212712400	0xa656e9d1e55310bfc76f45d7b5e1d436ec5a6b01328964d7b4d91f1933d3a394	19141
0xc82780db1257c788f262fbbda960b3706dfdcaf2	false	449	0x5f5b5294630e44a23c3e98d02c8c14534d4de148	20736105	2024-09-12T17:44:59.000Z	1201474092269671053	116957507	0x4c017fd284030cdc7ce70c5d59fdd2db2a334123899f526ec5c42efd03d7fb6c	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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
0xc82780db1257c788f262fbbda960b3706dfdcaf2	false	0xbc1471308eb2287ebe137420eb1664a964895d21	170	0x30043ad8a03d17f2dc9077564db24820f3af2056	20296786	11146046283425143451	2024-07-13T09:47:35.000Z	10438291033144840638767	0x196cf965d0d0f8e4982e482db1ab86007bd7eb8f56a141c8597235bf1cd30ee3
0x8716554364f20bca783cb2baa744d39361fd1d8d	false	0x7852f22cefa8bd0d6a38a6dc3f76e6e88c091a7c	267	0x7852f22cefa8bd0d6a38a6dc3f76e6e88c091a7c	20297666	150110887	2024-07-13T12:44:11.000Z	6921294092	0x624d3ddc98f746bc3f4884d687fe5d3fcf0977795455be29f6e7b4d83271456b
0xf9e9fe17c00a8b96a8ac20c4e344c8688d7b947e	false	0xeafacad9810b701a77c1452ba6a162466193eb1f	353	0xeafacad9810b701a77c1452ba6a162466193eb1f	20299571	938588868318364243	2024-07-13T19:08:35.000Z	100463422162783569463	0xf6b84b099c62dce42567f9b1bcbbdd8975bcced4158d1e1401675c1f65b18adc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_ethereum.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_ethereum.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
0x17c07e0c232f2f80dfdbd7a95b942d893a4c5acb	false	162	21540001	2025-01-02T23:13:47.000Z	174151960	0xd3a403a376b053a02891989fc7d16fde7053df1879ebf4862abd9a732988a8bc	0x8c8c8530464f7d95552a11ec31adbd4dc4ac4d3e
0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	false	117	21535515	2025-01-02T08:13:11.000Z	178844271	0xa544c8733d0e37c6c74e85bd45ed49dfb4261196e69c44cf2ddff319d1150289	0x8c8c8530464f7d95552a11ec31adbd4dc4ac4d3e
0x8c3e3821259b82ffb32b2450a95d2dcbf161c24e	false	250	19465679	2024-03-19T01:58:23.000Z	2637519	0x5c794c515540fb49c5a12f10279cb0ff7295b885cef359425884b9ebffd940e4	0x8c8c8530464f7d95552a11ec31adbd4dc4ac4d3e

Example Query

Query with partition filter

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

​ComptrollerCurve_borrowVerify_function

​ComptrollerCurve_liquidateAccount_function

​ComptrollerCurve_liquidateBorrowVerify_function

​ComptrollerCurve_MarketEntered_event

​ComptrollerCurve_MarketExited_event

​ComptrollerCurve_mintVerify_function

​ComptrollerCurve_redeemVerify_function

​ComptrollerCurve_repayBorrowVerify_function

​ComptrollerCurve_seizeVerify_function

​ComptrollerCurve_transferVerify_function

​PoolRegistry_MarketAdded_event

​PoolRegistry_PoolRegistered_event

​vcrvUSDCore_AccrueInterest_event

​vcrvUSDCore_Borrow_event

​vcrvUSDCore_Mint_event

​vcrvUSDCore_NewReserveFactor_event

​vcrvUSDCore_Redeem_event

​vcrvUSDCore_RepayBorrow_event

​vERC20_AccrueInterest_event

​vERC20_Borrow_event

​vERC20_Mint_event

​vERC20_NewReserveFactor_event

​vERC20_Redeem_event

​vERC20_RepayBorrow_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

ComptrollerCurve_borrowVerify_function

ComptrollerCurve_liquidateAccount_function

ComptrollerCurve_liquidateBorrowVerify_function

ComptrollerCurve_MarketEntered_event

ComptrollerCurve_MarketExited_event

ComptrollerCurve_mintVerify_function

ComptrollerCurve_redeemVerify_function

ComptrollerCurve_repayBorrowVerify_function

ComptrollerCurve_seizeVerify_function

ComptrollerCurve_transferVerify_function

PoolRegistry_MarketAdded_event

PoolRegistry_PoolRegistered_event

vcrvUSDCore_AccrueInterest_event

vcrvUSDCore_Borrow_event

vcrvUSDCore_Mint_event

vcrvUSDCore_NewReserveFactor_event

vcrvUSDCore_Redeem_event

vcrvUSDCore_RepayBorrow_event

vERC20_AccrueInterest_event

vERC20_Borrow_event

vERC20_Mint_event

vERC20_NewReserveFactor_event

vERC20_Redeem_event

vERC20_RepayBorrow_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