venus_v1_arbitrum

Tables

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
0x382238f07bc4fe4aa99e561ade8a4164b5f815da	false	37	302011785	0x317c1a5739f39046e20b08ac9beea3f10fd43326	2025-02-02T23:15:49.000Z	0x4f3a73f318c5ea67a86eaace24309f29f89900df	0x9c9f2f2b2e7bfe027b1494fbc081aa17808b6b4d03d84d6feb4261266d55abbd
0x382238f07bc4fe4aa99e561ade8a4164b5f815da	false	149	219368002	0x317c1a5739f39046e20b08ac9beea3f10fd43326	2024-06-07T13:48:02.000Z	0x7d8609f8da70ff9027e9bc5229af4f6727662707	0xad40d986b13a56c935a2284805730333ff4131ad31bb12ba00009f483340219d
0x382238f07bc4fe4aa99e561ade8a4164b5f815da	false	169	219368002	0x317c1a5739f39046e20b08ac9beea3f10fd43326	2024-06-07T13:48:02.000Z	0xb9f9117d4200dc296f9acd1e8be1937df834a2fd	0xad40d986b13a56c935a2284805730333ff4131ad31bb12ba00009f483340219d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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
0x382238f07bc4fe4aa99e561ade8a4164b5f815da	{“name”:“Liquid Staked ETH”,“creator”:“0x14e0e151b33f9802b3e75b621c1457afc44dcaa0”,“blockPosted”:“20728415”,“comptroller”:“0x52bab1af7ff770551bd05b9fc2329a0bf5e23f16”,“timestampPosted”:“1726070343”}	false	8	252449268	0x52bab1af7ff770551bd05b9fc2329a0bf5e23f16	2024-09-11T15:59:03.000Z	0x69221be37e785cf9fc43988c6e160f2ce2d8e169fb6403d94a7b501cd01b4c1f
0x382238f07bc4fe4aa99e561ade8a4164b5f815da	{“name”:“Core”,“creator”:“0x14e0e151b33f9802b3e75b621c1457afc44dcaa0”,“blockPosted”:“20040344”,“comptroller”:“0x317c1a5739f39046e20b08ac9beea3f10fd43326”,“timestampPosted”:“1717768082”}	false	87	219368002	0x317c1a5739f39046e20b08ac9beea3f10fd43326	2024-06-07T13:48:02.000Z	0xad40d986b13a56c935a2284805730333ff4131ad31bb12ba00009f483340219d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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
0x246a35e79a3a0618535a469adaf5091caa9f7e88	false	4	282955549	1145018934089404353074	1003335737423548571	2024-12-09T11:16:38.000Z	202722014911259806374	0x912f1e7d8d67b5d6edb09c7b4b508b0213fcc6bec8e065fb244d8d18efffd399	3470698136689277
0x246a35e79a3a0618535a469adaf5091caa9f7e88	false	8	282988190	1145025462792081363015	1003339263131297560	2024-12-09T13:33:04.000Z	202722727273585002555	0x84518c25abcc16395bdd0ccfc0edb9cec9919d0d4e121706b7f528badedf3fc1	712362325196181
0x246a35e79a3a0618535a469adaf5091caa9f7e88	false	28	282796468	1145018918304091177660	1003318559834445217	2024-12-09T00:11:54.000Z	202718544213123117097	0xf4d7d9df1582ed1860a5cc2c0b89ad4d985a94de6d023ca57e861574ce3c7d6a	469208775567208

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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_arbitrum.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_arbitrum.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
0x7d8609f8da70ff9027e9bc5229af4f6727662707	false	5	0x68cfbc52c6e57662644d801e278b6d01d1788643	231664654	2024-07-13T05:03:09.000Z	120000000	950617209520	0xff203c07ad77949ac86147d5bf65f610a002d540664b5640cf7a6d4b83b8a0ec	120000000
0x7d8609f8da70ff9027e9bc5229af4f6727662707	false	4	0x4813762f078cd5d279df1e275147b73df8bb715c	231900284	2024-07-13T21:26:00.000Z	200000000	959685697772	0xddd986b785d79de4186822011458f8fe5f7b64701ccd6e4efd3c948e20b6bc61	1204219337
0x7d8609f8da70ff9027e9bc5229af4f6727662707	false	15	0x03ec773a93e9bb5fd47c5f5ff68dba7ba4ef2091	231651873	2024-07-13T04:09:52.000Z	250000000	950490831646	0xb2ec369d9658faf9461610215d48aacdf33819993c4b9066d0e21a22dae78f42	1158201548

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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
0xb9f9117d4200dc296f9acd1e8be1937df834a2fd	false	39	0xa0f75a1b90a9f39f8d0a3a8881ba766a36cc295c	290208114	0x3b994b48922450e6cf0f415bdf337d1df7183ffa	837140195	125872604756	2024-12-30T14:35:28.000Z	0x779273c318ac423087df92736596e9333cfa71ea761aca2c9b69d179ddd89622	0xaeb0fed69354f34831fe1d16475d9a83ddacada6
0xb9f9117d4200dc296f9acd1e8be1937df834a2fd	false	25	0xe78c74b9b1acaed335159b9826e8d567874113ba	286498730	0x83b2570ea359f11e9851b8be3aac1fe66a73f307	67847518	9659799986	2024-12-19T20:04:34.000Z	0xe9ff89b11b2960874f53a42fe0beed52c13e6e01b7d7db90c462d49849c9f370	0xaeb0fed69354f34831fe1d16475d9a83ddacada6
0xb9f9117d4200dc296f9acd1e8be1937df834a2fd	false	28	0x79bced41b1ade18bcf2fb849b0f9f5219f4eae28	302010743	0x3b994b48922450e6cf0f415bdf337d1df7183ffa	358770828	82256785372	2025-02-02T23:11:27.000Z	0x3e8b678821671f9bd03df2a6dceb454d3429cb3afda512a180ee444eb21b33cc	0xaeb0fed69354f34831fe1d16475d9a83ddacada6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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
0xb9f9117d4200dc296f9acd1e8be1937df834a2fd	false	0x069fec82dd93d84d1b7d35d791683c2db9f94046	11	282989962	1000	97046	2024-12-09T13:40:33.000Z	0xac24485de055dfb9f3fa7aaee5eea1c278bad2d4c1bdea05076d66a7bf26e252	97046
0x7d8609f8da70ff9027e9bc5229af4f6727662707	false	0x125c697e92484f0016c114eebca98ec5f9d71ec4	8	282956928	1930230	187587814	2024-12-09T11:22:22.000Z	0x323f6d3f70cd74fd1d1d2f9ac65909407435ad84f9482eb43349085dfc2dbc8b	3994290947
0xaeb0fed69354f34831fe1d16475d9a83ddacada6	false	0x125c697e92484f0016c114eebca98ec5f9d71ec4	9	282956985	1806166956158643232	179155737	2024-12-09T11:22:36.000Z	0x73cbc1d19d2d5796252351cc5fbb1163cfa5bb18ec851a78954a4998599a5b2e	2532915102

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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
0x39d6d13ea59548637104e40e729e4aabe27fe106	false	5	245908529	2024-08-23T15:03:13.000Z	0x0e6619b061a95bff645a9308c30e704d8c39c97c6dc4cb0760e0cabdf853edd9	200000000000000000
0x246a35e79a3a0618535a469adaf5091caa9f7e88	false	9	245908467	2024-08-23T15:02:57.000Z	0x3003ffe081edf951e020c78f791875839d43f31a8ba4cb65dcc4337ed6e23144	250000000000000000
0x9df6b5132135f14719696bbae3c54bab272fdb16	false	12	245908423	2024-08-23T15:02:46.000Z	0x7cf8e03bf05dd89ddb94f46c4864b82d0b50aa5a69a542077fd02d2459c583b0	250000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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
0x68a34332983f4bf866768dd6d6e638b02ef5e1f0	false	28	0x9a7477aa0c89e33147ffcf6f0b2b78ab1313af5a	240393230	2024-08-07T13:49:32.000Z	31918953166011417531	3187462599	0xd42183482e204ec056d6c11c6c7092a61424090507038411c9d02164dcfc4c6a	5156
0x68a34332983f4bf866768dd6d6e638b02ef5e1f0	false	37	0xd9f80cb81164163a90745477ce1b2befb246a33f	240486480	2024-08-07T20:21:36.000Z	2100000150614460918	209707486	0x5ac9e0529ecf4b74fbd6b0e12c0a49311cb91b17213414a2de222d64a9813175	1
0x7d8609f8da70ff9027e9bc5229af4f6727662707	false	51	0xa9ca2e36abd617f3062110802b499bd45fa1574a	240521383	2024-08-07T22:47:49.000Z	70318266	6969474569	0x7052cb0d7d869d68fffcc767fd25033c51c1f32e658b833cd4526c3882a54818	337

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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
0x68a34332983f4bf866768dd6d6e638b02ef5e1f0	false	0x35e2a11f743a43f00381a0aeb6764322ef1eb788	5	0x35e2a11f743a43f00381a0aeb6764322ef1eb788	227024877	36757575299551073	2024-06-29T17:57:06.000Z	202675432787051741888	0x2f5aea6a5ec20935e67ef7e0d5eef0c2a6103157be8a0ab84922c5d43aaf9f0c	19981741377562336636
0x68a34332983f4bf866768dd6d6e638b02ef5e1f0	false	0x35e2a11f743a43f00381a0aeb6764322ef1eb788	13	0x35e2a11f743a43f00381a0aeb6764322ef1eb788	227020824	10700000000000000000	2024-06-29T17:40:15.000Z	191712059398916764341	0x06586f669da8939f5f9ba0de4835adab4336b6e67a5e23cada6c127e00d71ef6	9018490979929192594
0x68a34332983f4bf866768dd6d6e638b02ef5e1f0	false	0x9eea8f1796e23386edd37a1ec45393a93a975296	6	0x9eea8f1796e23386edd37a1ec45393a93a975296	226851455	1400312789704780977	2024-06-29T05:54:24.000Z	201606117280378487978	0x74c04083bc43c5329c49c96a0cbda28444870b1ec6aec350071288e9798d2345	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.venus_v1_arbitrum.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_arbitrum.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
0x7d8609f8da70ff9027e9bc5229af4f6727662707	false	2	254246792	2024-09-16T21:51:50.000Z	21829160	0xa714cb2ce4c8f67b417bacc2bdcf5fe111586dace9ea9f2d6e4af609f1227fa6	0xf9263eaf7eb50815194f26accab6765820b13d41
0xaeb0fed69354f34831fe1d16475d9a83ddacada6	false	2	254179671	2024-09-16T17:07:50.000Z	14742356665189811578	0x2a251611ac50b775021a598cfafd121fb01e2daa27b4b5106151b58c85a085ed	0xf9263eaf7eb50815194f26accab6765820b13d41
0xb9f9117d4200dc296f9acd1e8be1937df834a2fd	false	2	254274152	2024-09-16T23:47:31.000Z	19993583	0x0ad8c6f5f9082d0eb8bbc58ca88543058ff05af3c6e7f9ff0a600360acb2d461	0xf9263eaf7eb50815194f26accab6765820b13d41

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

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

​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

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