venus_v1_zksyncera

Tables

Comptroller_borrowVerify_function

Venus Protocol Comptroller borrow verification function calls recording post-borrow validation checks. Contains vToken market address, borrower address, and borrowed amount for compliance monitoring and risk management analysis.

Columns

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

Sample Data

gas	status	gas_used	in_vToken	signature	to_address	in_borrower	block_number	from_address	trace_address	block_timestamp	in_borrowAmount	transaction_hash
1007874	true	7305	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0x5c778605	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x99662b7e181e43ff18cecc166ae4766037ab47df	54402456	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0,18,0,1,16,1	2025-01-24T00:14:16.000Z	11000000000	0x00085d47025c3d5ea3b2816078f9c533d0336d6705c2a8100892459f47065c30
1025262	true	8744	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0x5c778605	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x99662b7e181e43ff18cecc166ae4766037ab47df	54402456	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0,18,0,1,16	2025-01-24T00:14:16.000Z	11000000000	0x00085d47025c3d5ea3b2816078f9c533d0336d6705c2a8100892459f47065c30
1069992	true	6774	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0x5c778605	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x3cf3d18529b81c9a7ea6294d0bf9e6eca5521f9c	54404049	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0,18,0,1,16	2025-01-24T00:46:11.000Z	43651191419	0x6efa752de913ae309b8d9bc549232242ab5281c0b881930fd15c79fe0c6f0359

Example Query

Query with partition filter

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

Comptroller_liquidateAccount_function

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

Columns

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

Sample Data

gas	status	gas_used	in_orders	signature	to_address	in_borrower	block_number	from_address	trace_address	block_timestamp	transaction_hash
1985697	false	989962	[{“repayAmount”:“45556713”,“vTokenBorrowed”:“0x69cda960e3b20dfd480866fffd377ebe40bd0a46”,“vTokenCollateral”:“0x697a70779c1a03ba2bd28b7627a902bff831b616”}]	0x2bce219c	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0xac9189e38c6f24e4e559a06e3d6b371e6f96fb6f	62333410	0x98ecb04542fd22e1c8a7e7575895710f0c3cfb7f	20,0	2025-06-30T14:56:56.000Z	0x351f4e91fb2c31ba25695df9715fb809240721969cfb9f276e26412944ef39c8
1932525	false	967172	[{“repayAmount”:“45556713”,“vTokenBorrowed”:“0x69cda960e3b20dfd480866fffd377ebe40bd0a46”,“vTokenCollateral”:“0x697a70779c1a03ba2bd28b7627a902bff831b616”}]	0x2bce219c	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0xac9189e38c6f24e4e559a06e3d6b371e6f96fb6f	62333410	0x98ecb04542fd22e1c8a7e7575895710f0c3cfb7f	20,0,1	2025-06-30T14:56:56.000Z	0x351f4e91fb2c31ba25695df9715fb809240721969cfb9f276e26412944ef39c8
888237	false	441507	[{“repayAmount”:“45655300”,“vTokenBorrowed”:“0x69cda960e3b20dfd480866fffd377ebe40bd0a46”,“vTokenCollateral”:“0x697a70779c1a03ba2bd28b7627a902bff831b616”}]	0x2bce219c	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0xac9189e38c6f24e4e559a06e3d6b371e6f96fb6f	62333075	0x98ecb04542fd22e1c8a7e7575895710f0c3cfb7f	20,0	2025-06-30T14:48:00.000Z	0xc245fa761565b01bc7dbf6c894239612f10602a66d69dbb1b01d3c8da9828777

Example Query

Query with partition filter

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

Comptroller_liquidateBorrowVerify_function

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

Columns

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

Sample Data

gas	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
1866627	true	11749	0x47ef3b3b	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x1a54f7998ed4f1bd84bf98ea34353352acd070b0	62180571	0x84064c058f2efea4ab648bb6bd7e40f83ffde39a	0x8a7eed6e1afe84265a872fe3e22c8a0458939426	20,0,8,6,11,7,6,1,38	38699576092	2025-06-26T10:07:34.000Z	0x5659ff80d2c64bb575c6252744160caa5d7f739dfce93562dde1c2647e77d8b0	0x84064c058f2efea4ab648bb6bd7e40f83ffde39a	0x697a70779c1a03ba2bd28b7627a902bff831b616	15472285
1836009	true	10214	0x47ef3b3b	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x1a54f7998ed4f1bd84bf98ea34353352acd070b0	62180571	0x84064c058f2efea4ab648bb6bd7e40f83ffde39a	0x8a7eed6e1afe84265a872fe3e22c8a0458939426	20,0,8,6,11,7,6,1,38,1	38699576092	2025-06-26T10:07:34.000Z	0x5659ff80d2c64bb575c6252744160caa5d7f739dfce93562dde1c2647e77d8b0	0x84064c058f2efea4ab648bb6bd7e40f83ffde39a	0x697a70779c1a03ba2bd28b7627a902bff831b616	15472285
1358847	true	10214	0x47ef3b3b	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0xd0a42a78296a31866b8080b3c101f28898106dbd	64408221	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x8a7eed6e1afe84265a872fe3e22c8a0458939426	20,0,6,7,2,7,6,1,31,1	249621276521	2025-09-01T22:11:41.000Z	0x91dba9adfe88b88d1f2f6bfd1c9f47d3eb41ee106cb8f09eda7676d699cf1496	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x697a70779c1a03ba2bd28b7627a902bff831b616	29212629326989626

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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
0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	false	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	3	0x2bd31cc64788ec0943d93001f58cdb01284178dd	48236156	2024-11-05T21:53:02.000Z	0x2e2bc342eb5a29864b8a54b6170c5f4fb3fbb71ce51b983da1b9df4c54538bbb
0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	false	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	3	0xa347b2862e7924ca1f28122ed9999fada818a119	48226287	2024-11-05T18:43:24.000Z	0x416e7e8bc503bf92e7b3a9a94d2902d7fc4d1c14a7ae4d2b319a7039383fa290
0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	false	0x697a70779c1a03ba2bd28b7627a902bff831b616	3	0x73fcb78aa39abb065b47ca87428769a7cc4b7656	48203685	2024-11-05T11:47:09.000Z	0x6e1ac52f9100777baf32c34454d9f593e95e70c6f9866f73d913a3b69e8277a2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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
0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	false	0x697a70779c1a03ba2bd28b7627a902bff831b616	54	0x5ee225eab0db9ac6749e93d5d984be8c23d3c898	48165800	2024-11-04T23:28:36.000Z	0xe9900ae21521d4dd9ff4297f62a18c4b6363135a6428dcb5f112a09f0db33805
0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	false	0x697a70779c1a03ba2bd28b7627a902bff831b616	14	0x8a29d4e52a23c69ecc705bce3cca0d2b42faa23c	48144361	2024-11-04T16:44:33.000Z	0x4b5b376c840f2105f9bf7725a74b95ecc7fb59edf39cce9dee7d00622b144efc
0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	false	0x697a70779c1a03ba2bd28b7627a902bff831b616	3	0x1abacd725d66b05ff71558c574b1d104b1ca5cdc	52116249	2024-12-25T05:28:08.000Z	0x5156a0eb88536f29ab920b528db8c462b4f6c65ce33953ac9b4557c2a8505d50

Example Query

Query with partition filter

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

Comptroller_mintVerify_function

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

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_actualMintAmount`	`STRING`	Actual amount of underlying asset deposited into the Venus protocol during the mint operation. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

gas	status	gas_used	in_minter	in_vToken	signature	to_address	block_number	from_address	in_mintTokens	trace_address	block_timestamp	transaction_hash	in_actualMintAmount
587097	true	7293	0x6162f80cc0234b04254bd6857c7d5179dc28a5f7	0x183de3c349fcf546aae925e1c7f364ea6fb4033c	0x41c728b9	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	55903392	0x183de3c349fcf546aae925e1c7f364ea6fb4033c	46690970443	0,18,0,1,19,1	2025-02-14T03:36:58.000Z	0x12124a16abc4294c13b3d0be5c902988157d00534e5fdaf335fd05cc41d9dbd7	467939334029564646534
597807	true	8764	0x6162f80cc0234b04254bd6857c7d5179dc28a5f7	0x183de3c349fcf546aae925e1c7f364ea6fb4033c	0x41c728b9	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	55903392	0x183de3c349fcf546aae925e1c7f364ea6fb4033c	46690970443	0,18,0,1,19	2025-02-14T03:36:58.000Z	0x12124a16abc4294c13b3d0be5c902988157d00534e5fdaf335fd05cc41d9dbd7	467939334029564646534
613116	true	8764	0xe67d301586852a665afa5ae0729b85582f94ffd5	0x183de3c349fcf546aae925e1c7f364ea6fb4033c	0x41c728b9	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	55957687	0x183de3c349fcf546aae925e1c7f364ea6fb4033c	149652686	0,18,0,1,26	2025-02-14T23:52:55.000Z	0x4cbf0ed9087c7c6027cb1309f548f72a558fc8b4f03085e78c40651bb21cd717	1500000000000000000

Example Query

Query with partition filter

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

Comptroller_redeemVerify_function

Venus protocol comptroller verification calls for redemption transactions. Records validation checks performed when users withdraw underlying assets by burning vTokens in lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`trace_address`	`STRING`	Hierarchical position of the internal call within a transaction’s execution trace. Comma-separated sequence of integers representing the call path, where each number indicates the index of the call at that nesting level, with null representing top-level calls.
`status`	`BOOL`	Transaction execution outcome indicator. Boolean value where true represents successful execution and false represents failed execution.
`from_address`	`STRING`	Address that initiated the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`to_address`	`STRING`	Address receiving the transaction or contract call. Hex-encoded, 0x-prefixed, 42-character string.
`value`	`NUMERIC`	Amount of native cryptocurrency sent with the transaction. Floating-point representation in whole units (e.g., ETH, BNB, MATIC).
`gas_used`	`INT64`	Amount of gas consumed by the transaction execution. Integer representing the actual computational steps used.
`gas`	`INT64`	Gas limit allocated for the transaction execution. Integer representing the maximum computational steps allowed.
`signature`	`STRING`	Function selector identifying which contract function was called. 10-character hex string including 0x prefix.
`in_vToken`	`STRING`	Contract address of the vToken market in the Venus lending protocol. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemer`	`STRING`	Address of the account that initiated the redemption transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_redeemAmount`	`STRING`	Amount of underlying asset tokens withdrawn from the lending pool during redemption.
`in_redeemTokens`	`STRING`	Amount of interest-bearing pool tokens burned during the redemption transaction. String-encoded integer representing the quantity of cTokens or equivalent derivative tokens exchanged for underlying assets.

Sample Data

gas	status	gas_used	in_vToken	signature	to_address	in_redeemer	block_number	from_address	trace_address	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
1949094	true	33510	0x697a70779c1a03ba2bd28b7627a902bff831b616	0x51dff989	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x7f73934f333a25b456dc9b8b62a19f211c991f1c	65365206	0x697a70779c1a03ba2bd28b7627a902bff831b616	19,0,1,0,1,21,1,18	2025-10-20T14:35:53.000Z	1027485563653820971478	102577182568	0x4e7bd0bea7c51a0602ff7dd6e9fcd587369d047a82cf0f055ad8846ece7075a4
1917279	true	32039	0x697a70779c1a03ba2bd28b7627a902bff831b616	0x51dff989	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x7f73934f333a25b456dc9b8b62a19f211c991f1c	65365206	0x697a70779c1a03ba2bd28b7627a902bff831b616	19,0,1,0,1,21,1,18,1	2025-10-20T14:35:53.000Z	1027485563653820971478	102577182568	0x4e7bd0bea7c51a0602ff7dd6e9fcd587369d047a82cf0f055ad8846ece7075a4
366975	true	33510	0x697a70779c1a03ba2bd28b7627a902bff831b616	0x51dff989	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x8d22c8cf67f51aa2004fbea3ba0bf5010244e3d9	65365892	0x697a70779c1a03ba2bd28b7627a902bff831b616	20,0,1,18	2025-10-20T15:33:38.000Z	25526387770003248787067	2548381135083	0x05dad67dab8cb6e6891af1fc6e3d987e02026a39ac0ec552baf163c90f7d111d

Example Query

Query with partition filter

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

Comptroller_repayBorrowVerify_function

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

Columns

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

Sample Data

gas	status	gas_used	in_payer	in_vToken	signature	to_address	in_borrower	block_number	from_address	trace_address	block_timestamp	in_borrowerIndex	transaction_hash	in_actualRepayAmount
366219	true	7336	0xeede4e1bdac489bd851970be3952b729c4238a68	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x1ededc91	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x93c329189b3f6fef306b98ee88dd0aa5ec1ec15e	45648013	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0,19,0,1,7,1,13,1	2024-10-02T09:56:27.000Z	1000555062390374220	0x2f882e05ec3d1f8b39f4c13676d408faa2345e42a69ae64bf5084c3de3651d9d	43000000000000000
373464	true	8839	0xeede4e1bdac489bd851970be3952b729c4238a68	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x1ededc91	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x93c329189b3f6fef306b98ee88dd0aa5ec1ec15e	45648013	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0,19,0,1,7,1,13	2024-10-02T09:56:27.000Z	1000555062390374220	0x2f882e05ec3d1f8b39f4c13676d408faa2345e42a69ae64bf5084c3de3651d9d	43000000000000000
433629	true	8839	0xeede4e1bdac489bd851970be3952b729c4238a68	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x1ededc91	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x93c329189b3f6fef306b98ee88dd0aa5ec1ec15e	45665781	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0,19,0,1,7,1,13	2024-10-02T15:21:34.000Z	1000570359422983619	0xf109d4fbe4ea96315b0710d93d6ef6d0155eca57ca6b7eed55eac0fa71c9a50c	400000000000000000

Example Query

Query with partition filter

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

Comptroller_seizeVerify_function

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

Columns

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

Sample Data

gas	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
936621	true	13903	0x6d35bf91	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0xd4a2787bf34f045e6ed6aca85c7a63bdf8aa1644	48350602	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0xa40f91e5c66de267e7ed41398e87661261679191	0,19,0,1,28,1,14	15484390050	2024-11-07T09:09:04.000Z	0x2ed59f7fb1ac1775f50e4c50de8fdaae3a7b485e62b2dba262cf8bce673c2190	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d
920556	true	12400	0x6d35bf91	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0xd4a2787bf34f045e6ed6aca85c7a63bdf8aa1644	48350602	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	0xa40f91e5c66de267e7ed41398e87661261679191	0,19,0,1,28,1,14,1	15484390050	2024-11-07T09:09:04.000Z	0x2ed59f7fb1ac1775f50e4c50de8fdaae3a7b485e62b2dba262cf8bce673c2190	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x1af23bd57c62a99c59ad48236553d0dd11e49d2d
1335663	true	13687	0x6d35bf91	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	0x810a161b6856c34d4e8c248d5c84ec32e5a07c14	63415948	0x697a70779c1a03ba2bd28b7627a902bff831b616	0x8a7eed6e1afe84265a872fe3e22c8a0458939426	20,0,6,7,2,7,6,1,28,1,14	42789783656	2025-07-27T10:39:19.000Z	0x93638b617e0457155224b0f77452b8c3503b184a39c7178d0a7e3e15a456f9e6	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0x697a70779c1a03ba2bd28b7627a902bff831b616

Example Query

Query with partition filter

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

Comptroller_transferVerify_function

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

Columns

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

Sample Data

gas	in_dst	in_src	status	gas_used	in_vToken	signature	to_address	block_number	from_address	trace_address	block_timestamp	transaction_hash	in_transferTokens
674982	0x754cabebfe6b02ff7f26176f32c7fd5ca770ed54	0x5abf780373563cd5ff16014ff99d08dbcfcbe411	true	10231	0x697a70779c1a03ba2bd28b7627a902bff831b616	0x6a56947e	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	57170142	0x697a70779c1a03ba2bd28b7627a902bff831b616	0,18,0,3,5,1,8,1	2025-03-06T12:54:59.000Z	0x91797ff2326ab800a828fc30273182d6535dab165a30f56194ce7a08c818a526	91418350386
687078	0x754cabebfe6b02ff7f26176f32c7fd5ca770ed54	0x5abf780373563cd5ff16014ff99d08dbcfcbe411	true	11702	0x697a70779c1a03ba2bd28b7627a902bff831b616	0x6a56947e	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	57170142	0x697a70779c1a03ba2bd28b7627a902bff831b616	0,18,0,3,5,1,8	2025-03-06T12:54:59.000Z	0x91797ff2326ab800a828fc30273182d6535dab165a30f56194ce7a08c818a526	91418350386
538776	0xe3666187c7fbd30ea514a00747f27bef2df27d69	0x5abf780373563cd5ff16014ff99d08dbcfcbe411	true	11702	0x697a70779c1a03ba2bd28b7627a902bff831b616	0x6a56947e	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	57176353	0x697a70779c1a03ba2bd28b7627a902bff831b616	0,18,0,3,5,1,8	2025-03-06T14:59:31.000Z	0x33be7e8be0eaa896e54ea977066715b87098de4c5999dba2e59dc5ac0bb5f191	399477930172

Example Query

Query with partition filter

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

PoolRegistry_MarketAdded_event

Venus protocol events emitted when a new lending market (vToken) is added to a pool registry. Contains the comptroller address managing the pool and the vToken address of the newly registered market.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_comptroller`	`STRING`	Contract address of the Venus protocol comptroller managing the pool. Hex-encoded, 0x-prefixed, 42-character string.
`in_vTokenAddress`	`STRING`	Contract address of the Venus protocol vToken representing the market being added. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	log_index	block_number	in_comptroller	block_timestamp	in_vTokenAddress	transaction_hash
0xfd96b926298034aed9bbe0cca4b651e41eb87bc4	false	39	54673888	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	2025-01-27T14:24:06.000Z	0x183de3c349fcf546aae925e1c7f364ea6fb4033c	0x934dbd4b7d9e44b623c531e7040b3123b6ec875b9f97e907fee37811b94ab5e6
0xfd96b926298034aed9bbe0cca4b651e41eb87bc4	false	99	44420749	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	2024-09-17T13:13:44.000Z	0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	0xb29e68c4543f8d4726a5a8e4ced3fb046439720e9f28580295bb11b36b46b5ab
0xfd96b926298034aed9bbe0cca4b651e41eb87bc4	false	159	44420749	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	2024-09-17T13:13:44.000Z	0x697a70779c1a03ba2bd28b7627a902bff831b616	0xb29e68c4543f8d4726a5a8e4ced3fb046439720e9f28580295bb11b36b46b5ab

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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
0xfd96b926298034aed9bbe0cca4b651e41eb87bc4	{“name”:“Core”,“creator”:“0x751aa759cfbb6ce71a43b48e40e1cccfc66ba4aa”,“blockPosted”:“44420749”,“comptroller”:“0xdde4d098d9995b659724ae6d5e3fb9681ac941b1”,“timestampPosted”:“1726578824”}	false	56	44420749	0xdde4d098d9995b659724ae6d5e3fb9681ac941b1	2024-09-17T13:13:44.000Z	0xb29e68c4543f8d4726a5a8e4ced3fb046439720e9f28580295bb11b36b46b5ab

Example Query

Query with partition filter

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

VToken_AccrueInterest_event

Interest accrual events from Venus Protocol lending markets recording periodic interest calculations. Contains cumulative borrow index, cash reserves, total borrows, and accumulated interest for tracking market state changes and calculating borrower obligations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xaf8fd83cfcbe963211faaf1847f0f217f80b4719	false	1	48815202	1420624257	1007344527108864957	2024-11-13T04:26:11.000Z	1315577079	0x95da0c7ec88f42baf20d5eb4d130d3a1738c92c0662b2034af1a29b8c984718f	136258
0xaf8fd83cfcbe963211faaf1847f0f217f80b4719	false	1	48861749	1422362822	1007494747386045286	2024-11-13T17:56:46.000Z	1257096597	0x427896d4f227911304b1215bf5adcea39ce8d557bc44ebabef3318c4237f3e00	8683
0xaf8fd83cfcbe963211faaf1847f0f217f80b4719	false	1	48862454	1422562884	1007496621373682299	2024-11-13T18:09:11.000Z	1256898872	0x7b0ca6c90094e7845eba427510366dd195aaf67e73b15b64ad7529350e54c714	621

Example Query

Query with partition filter

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

VToken_BadDebtIncreased_event

Venus Protocol bad debt increase events emitted when borrower positions become undercollateralized and accumulate uncollectable debt. Records borrower address, previous and new bad debt totals, and delta amount for tracking protocol insolvency risk across VToken markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_badDebtDelta`	`STRING`	Amount of bad debt added in the event. Numeric string representing the token amount in smallest denomination.
`in_badDebtOld`	`STRING`	Previous total amount of bad debt before the event. Numeric string representing the token amount in smallest denomination.
`in_badDebtNew`	`STRING`	Updated total amount of bad debt after the event. Numeric string representing the token amount in smallest denomination.

Sample Data

address	removed	log_index	in_borrower	block_number	in_badDebtNew	in_badDebtOld	block_timestamp	in_badDebtDelta	transaction_hash
0x183de3c349fcf546aae925e1c7f364ea6fb4033c	false	26	0xab4748d994e4b459d1f8e1507b7d1b1817e96e7b	58749541	57228437428726252818	0	2025-04-06T21:22:47.000Z	57228437428726252818	0x959738223b791639cefe0cda8c6987e8bf053103f0f25b01b06c04b9b04680cd
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	27	0x734d1ccd9e98966dac4f66d02d7859032331eea1	58793224	6791943	0	2025-04-07T14:31:46.000Z	6791943	0xff88d6a79b8107b102c4c2e5d3af6f78e040714d7ff3ff6c487176b96a9f63b9
0x183de3c349fcf546aae925e1c7f364ea6fb4033c	false	19	0x68c8020a052d5061760e2abf5726d59d4ebe3506	63322223	925140585674106308648009	57228437428726252818	2025-07-24T17:50:15.000Z	925083357236677582395191	0x2c0f3a5e43da4a6698437e7de45092ef3625f1e24137a7e9c2ca2fe0e5fc00ee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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_zksyncera.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
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	10	0x810319d001114edde6af23a643584bc343106e08	49170839	2024-11-17T15:27:13.000Z	3773000000	2128452006928	0x3b01a3522d6cbb1ffbece6868984e06d45eef2b4c1d3f26a3bd5420dad90daf7	9591559561
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	15	0x3a1fa5a6c92c7cf74ca6cff0a5a4fc3ef224be60	49159011	2024-11-17T11:59:52.000Z	100000000	2118822474914	0xabc938708578f28d97437ef4e391f251de8516b75b1a4a77a47f707ad63cc8ee	4423713955
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	27	0x810319d001114edde6af23a643584bc343106e08	49170331	2024-11-17T15:18:24.000Z	5818554070	2124677001858	0x6144efa220e5165ef2ccc82de0e8084e953e99c0a98b48df8fa28cc64b110d60	5818554070

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	53	0x219895b55a5b88d6a32d48ba28793cd8010d6ee6	50900845	0x735e42ff68711e665ba2c72c3999eb1454e6d9d2	1414100588	766980846192	2024-12-09T21:03:22.000Z	0x9d4ba0d8fdcdfd9ca8c3064365abe7b2dd6bbc46f2ee62876d20f0d2be24716b	0x697a70779c1a03ba2bd28b7627a902bff831b616
0x69cda960e3b20dfd480866fffd377ebe40bd0a46	false	20	0x810568f43def42f13e032ee9bdc3e7a19a9e6ea0	56568807	0x3204cbd66d3e16b4fdc94eacabc5153281c7b083	44545108	54151418822	2025-02-25T07:11:34.000Z	0x42d27ca3319449c106f4388358fadb3d2e7bf33fbbb1007d8ca6092394544123	0x697a70779c1a03ba2bd28b7627a902bff831b616
0x69cda960e3b20dfd480866fffd377ebe40bd0a46	false	36	0x8d5b4d8d09cfb9b1c4a60b6986ac1c39d3aa0682	56570050	0x3204cbd66d3e16b4fdc94eacabc5153281c7b083	57292801	71786707453	2025-02-25T07:35:29.000Z	0x54edf4a48ed843acd59296cb3cff87a6e7f272af61c856cf359575472ff2cc13	0x697a70779c1a03ba2bd28b7627a902bff831b616

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	0x0f4daa365a72c5b134d6e263f21b64de87f2392a	7	51161224	9665967254	957388783039	2024-12-13T02:07:49.000Z	0x0be0719bc7fd75ba73bdfc66d5fb6554970d5c6eba0a99cec03740c2a3eddc81	957388783039
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	0x1e1e44bd78b82a7662f881c96ed093b74aa5301b	7	51206459	60000000	5941788069	2024-12-13T15:19:21.000Z	0x6ed5bb762fbbe96fb36836384348c1dfd0c1151fad67532a29b9d0ea4462dad5	5941788069
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	0x1e489988d663dcac0f2ab2f13ad0a840c6b07a57	88	51190660	22988500650	2276681704489	2024-12-13T10:43:31.000Z	0x393737d77e39e8895469d48f19ed55aa5c4cd86c0dae831cdf46a0e187d006db	2312457220323

Example Query

Query with partition filter

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

VToken_NewReserveFactor_event

Reserve factor configuration change events from Venus Protocol VToken contracts. Captures old and new reserve factor values as 18-decimal mantissas, tracking protocol-level parameter adjustments for lending market reserves.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_oldReserveFactorMantissa`	`STRING`	Previous reserve factor for the lending market before the update. 18-decimal fixed-point integer stored as string.
`in_newReserveFactorMantissa`	`STRING`	Updated reserve factor for the lending market. 18-decimal fixed-point integer stored as string.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x84064c058f2efea4ab648bb6bd7e40f83ffde39a	false	18	48143013	2024-11-04T16:20:45.000Z	0x35144775bda7f28a50d9f58ab6ece10f8cbe99b337ff11e686875280f7d7f953	100000000000000000	0
0x183de3c349fcf546aae925e1c7f364ea6fb4033c	false	16	54673888	2025-01-27T14:24:06.000Z	0x934dbd4b7d9e44b623c531e7040b3123b6ec875b9f97e907fee37811b94ab5e6	250000000000000000	250000000000000000
0x697a70779c1a03ba2bd28b7627a902bff831b616	false	6	43552210	2024-09-06T13:04:30.000Z	0x45e1e2aea254bb86d79b17a0d9a1f2b81bfa12c9bc23237e15b625aa9fc7668d	250000000000000000	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	24	0x298e013544c56aa8cd0ca7770b8680fa3bbe0d64	47389488	2024-10-25T19:15:49.000Z	20000000000	1993457241825	0x35e830916fdf794c0653aa546810be2845caded9a5c04eff208c4526533342e2	19968687805614
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	6	0xc181408443cb88b739a8c54c047c9fcf66570e74	47386838	2024-10-25T18:29:23.000Z	50000963	4983754783	0x84e1af80317008a51f2c58c8ac183abcca3912566492bbe1fd1d035c12a08250	0
0x1af23bd57c62a99c59ad48236553d0dd11e49d2d	false	14	0x298e013544c56aa8cd0ca7770b8680fa3bbe0d64	47389441	2024-10-25T19:14:59.000Z	15000000000	1495093015360	0x6fcdedb12c366a6fb7b8bda9e5e1f852908d79bef035b125d3801aa57283de39	21962145047439

Example Query

Query with partition filter

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

VToken_RepayBorrow_event

Borrow repayment events from Venus Protocol VToken contracts recording debt reduction transactions. Contains payer and borrower addresses, repayment amount, updated account-level and market-level borrow balances for tracking loan activity and protocol solvency.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x183de3c349fcf546aae925e1c7f364ea6fb4033c	false	0x05c446f4d6c3fb71f2f2949c92e0a5ee6e59853e	17	0x05c446f4d6c3fb71f2f2949c92e0a5ee6e59853e	55736819	936748899532117061149	2025-02-11T14:55:59.000Z	1715457525927694481250475	0xbfa929d764fc5ddb8f457ab8a9e64a6d1ca5018d8759f1931f3feb8ee4c96631	818704667771283814941
0x183de3c349fcf546aae925e1c7f364ea6fb4033c	false	0x766aca685baf2edc50b586185edbebe38ba9bfc7	13	0x766aca685baf2edc50b586185edbebe38ba9bfc7	55721071	10214509245391801149945	2025-02-11T09:33:05.000Z	1616309808214579721223076	0x1d5639c5d4beefeb96d99b3f3dc21cf87385153ebbf8087fadb8de46e6e7133d	0
0x183de3c349fcf546aae925e1c7f364ea6fb4033c	false	0x766aca685baf2edc50b586185edbebe38ba9bfc7	9	0x766aca685baf2edc50b586185edbebe38ba9bfc7	55720849	50000000000007646286540	2025-02-11T09:28:19.000Z	1626522946542020413594503	0xe54a369a7f7bc099e63dedea9721b4327a25c6f9ffabf0945eec8ea917704fd3	10214500636080562494840

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_zksyncera.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_zksyncera.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
0x84064c058f2efea4ab648bb6bd7e40f83ffde39a	false	16	49127362	2024-11-17T02:38:11.000Z	238865	0xb63e898c83bcf3dfae04728203b6062350ab21035352ee39f8aa05c69d4fb93c	0xa1193e941bdf34e858f7f276221b4886efdd040b
0x1fa916c27c7c2c4602124a14c77dbb40a5ff1be8	false	9	49156679	2024-11-17T11:19:18.000Z	5699276984538202	0xa9aa6d31dd0354b95b25e8dc641ca749ed793f3fb1d9f5aff1a98c76a592ff98	0xa1193e941bdf34e858f7f276221b4886efdd040b
0x69cda960e3b20dfd480866fffd377ebe40bd0a46	false	12	49161431	2024-11-17T12:42:33.000Z	12816559	0xa99e158b05457b82727e09f9ba659758969a53695c40c91df2b49fbf631d68ca	0xa1193e941bdf34e858f7f276221b4886efdd040b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Comptroller_borrowVerify_function

Comptroller_liquidateAccount_function

Comptroller_liquidateBorrowVerify_function

Comptroller_MarketEntered_event

Comptroller_MarketExited_event

Comptroller_mintVerify_function

Comptroller_redeemVerify_function

Comptroller_repayBorrowVerify_function

Comptroller_seizeVerify_function

Comptroller_transferVerify_function

PoolRegistry_MarketAdded_event

PoolRegistry_PoolRegistered_event

VToken_AccrueInterest_event

VToken_BadDebtIncreased_event

VToken_BadDebtRecovered_event

VToken_Borrow_event

VToken_LiquidateBorrow_event

VToken_Mint_event

VToken_NewReserveFactor_event

VToken_Redeem_event

VToken_RepayBorrow_event

VToken_ReservesAdded_event

VToken_SpreadReservesReduced_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Comptroller_borrowVerify_function

​Comptroller_liquidateAccount_function

​Comptroller_liquidateBorrowVerify_function

​Comptroller_MarketEntered_event

​Comptroller_MarketExited_event

​Comptroller_mintVerify_function

​Comptroller_redeemVerify_function

​Comptroller_repayBorrowVerify_function

​Comptroller_seizeVerify_function

​Comptroller_transferVerify_function

​PoolRegistry_MarketAdded_event

​PoolRegistry_PoolRegistered_event

​VToken_AccrueInterest_event

​VToken_BadDebtIncreased_event

​VToken_BadDebtRecovered_event

​VToken_Borrow_event

​VToken_LiquidateBorrow_event

​VToken_Mint_event

​VToken_NewReserveFactor_event

​VToken_Redeem_event

​VToken_RepayBorrow_event

​VToken_ReservesAdded_event

​VToken_SpreadReservesReduced_event

Tables

Comptroller_borrowVerify_function

Comptroller_liquidateAccount_function

Comptroller_liquidateBorrowVerify_function

Comptroller_MarketEntered_event

Comptroller_MarketExited_event

Comptroller_mintVerify_function

Comptroller_redeemVerify_function

Comptroller_repayBorrowVerify_function

Comptroller_seizeVerify_function

Comptroller_transferVerify_function

PoolRegistry_MarketAdded_event

PoolRegistry_PoolRegistered_event

VToken_AccrueInterest_event

VToken_BadDebtIncreased_event

VToken_BadDebtRecovered_event

VToken_Borrow_event

VToken_LiquidateBorrow_event

VToken_Mint_event

VToken_NewReserveFactor_event

VToken_Redeem_event

VToken_RepayBorrow_event

VToken_ReservesAdded_event

VToken_SpreadReservesReduced_event