benqi_v1_avalanche

Tables

Comptroller_DistributedBorrowerReward_event

QI token reward distributions to borrowers on Benqi lending protocol on Avalanche. Tracks reward amounts (qiDelta), qiToken markets, and borrow index values for analyzing incentive programs and borrower reward accrual.

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_tokenType`	`INT64`	Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens.
`in_qiToken`	`STRING`	Contract address of the qiToken (BENQI lending market token) for which borrower rewards were distributed. Represents the specific lending pool on Avalanche where the borrowing activity occurred.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_qiDelta`	`STRING`	Amount of QI governance tokens distributed to the borrower as rewards, denominated in wei (18 decimals). Can be zero when no new rewards have accrued since the last distribution event.
`in_qiBorrowIndex`	`STRING`	Global cumulative borrow index for QI token rewards at the time of distribution, tracked per market. Large integer value used to calculate accrued borrower rewards in BENQI’s incentive system.

Sample Data

address	removed	log_index	in_qiDelta	in_qiToken	in_borrower	block_number	block_timestamp	in_qiBorrowIndex	transaction_hash
0x486af39519b4dc9a7fccd318217352830e8ad9b4	false	55	0	0x5c0401e81bc07ca70fad469b451682c0d747ef1c	0xd9e857944a75f6ad3d2dcc157a0d214d44d022e6	9135016	2022-01-04T18:23:26.000Z	5251670387527182326368414019555154296	0x0033012ec16788f240245ce7e5a15a536f77d35e08f6d9a51bc49534ab1ba6dc
0x486af39519b4dc9a7fccd318217352830e8ad9b4	false	14	29657278186196645091	0x835866d37afb8cb8f8334dccdaf66cf01832ff5d	0xc9a6a413fbaf5029a4d4b9ca9e15efe88c8e70d4	9135580	2022-01-04T18:42:09.000Z	115952759605279676018340048418233294	0x008991fed346fff02add2316c86b929ad9eb286df10a0dd50166b19c171de23c
0x486af39519b4dc9a7fccd318217352830e8ad9b4	false	59	19348015066771613	0xbeb5d47a3f720ec0a390d04b4d41ed7d9688bc7f	0x19425f50dd540cbc8026f1efcbeca3b1429dd2b7	9128853	2022-01-04T14:55:01.000Z	109901512034457149201920048447873861263966377643	0x0098e6a780f2332630d2e9445ca6bfd5c309ca3e22977e1207672ab139cb5fdb

Example Query

Query with partition filter

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

Comptroller_DistributedSupplierReward_event

QI token reward distribution events from BENQI’s Comptroller contract on Avalanche. Records supplier incentive payouts with delta amounts, borrow indices, and token type flags for tracking liquidity mining rewards across qiToken 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_tokenType`	`INT64`	Token standard identifier indicating the type of token involved in the transaction. Integer-encoded value where 0 represents ERC-20 fungible tokens, 1 represents reward tokens, and 3 represents native blockchain tokens.
`in_qiToken`	`STRING`	Contract address of the qiToken market (BENQI’s interest-bearing token) where the supplier reward was distributed. Hex-encoded, 0x-prefixed 40-character string representing the specific lending market on Avalanche.
`in_borrower`	`STRING`	Address of the borrower in the lending or loan transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_qiDelta`	`STRING`	Amount of QI tokens distributed as a supplier or borrower reward in this event, denominated in the smallest unit (wei). This value represents the incremental reward accrued since the last distribution for the specified market and user.
`in_qiBorrowIndex`	`STRING`	Cumulative interest index for QI token rewards accrued by borrowers in the BENQI lending protocol. Large integer value that increases over time to track proportional reward distribution per market.

Sample Data

address	removed	log_index	in_qiDelta	in_qiToken	in_borrower	block_number	in_tokenType	block_timestamp	in_qiBorrowIndex	transaction_hash
0x486af39519b4dc9a7fccd318217352830e8ad9b4	false	26	48555068100531404670	0x334ad834cd4481bb02d09615e7c11a00579a7909	0x002282abedffc3463e35a6f5746b446f3b60d67d	3440533	0	2021-08-27T01:48:13.000Z	3200277880760635955497671589423841446504003610	0x1d47e30140df9e38f132bc17029e4bdb2d31d4641213fda6af795acf0913e184
0x486af39519b4dc9a7fccd318217352830e8ad9b4	false	27	50448235013203734	0x334ad834cd4481bb02d09615e7c11a00579a7909	0x002282abedffc3463e35a6f5746b446f3b60d67d	3440533	1	2021-08-27T01:48:13.000Z	3325057032190697536048351673481643481226756	0x1d47e30140df9e38f132bc17029e4bdb2d31d4641213fda6af795acf0913e184
0x486af39519b4dc9a7fccd318217352830e8ad9b4	false	2	131265024700347748495	0xe194c4c5ac32a3c9ffdb358d9bfd523a0b6d1568	0x00329e92ed6fd0a0ef76da9c476d51faeb6b26a0	3474491	0	2021-08-27T17:26:59.000Z	106260040243962649745092370287538550993936109657	0x756682d6034b40b1ac78d86c45f98c1ccdbc13d73a0395c3af939b93f8671ff9

Example Query

Query with partition filter

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

Market_AccrueInterest_event

Interest accrual events from BENQI lending markets on Avalanche, capturing changes to borrow index, accumulated interest, and market cash balances each time interest is calculated. Used for tracking lending market interest rate dynamics and protocol revenue generation.

Columns

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

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	23295364	3769285895641864755232	1049241969869097736	2022-12-06T17:45:43.000Z	109032483831148094180	0x1f70d2cfdc6d12cad8b137d22ac410ca961f1b3a1d0d793e14ac5d9ad844d366	818351249356187
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	23274504	3771231738733070817574	1049209018491154671	2022-12-06T05:50:07.000Z	109029059672864338530	0x227a5252eb91c51fbdb6fa932ff90a8fa34a390d33c8c7880d9cb55fd6998d93	2301562615389491
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	23283491	3771242479362620018114	1049223464946184089	2022-12-06T11:03:52.000Z	109030560883185356228	0x15a49f11ef75f549b805b411031476438851f8ef05510158ddcf92c5b53b029f	1501210321017698

Example Query

Query with partition filter

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

Market_Borrow_event

Borrow event logs from BENQI (QI) lending markets on Avalanche, tracking individual borrow transactions with amounts borrowed, running account balances, and total market debt. Used for analyzing borrowing behavior, debt accumulation patterns, and market utilization across BENQI pools.

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
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	54	0x37749f66f360d9de7b8b1f7928d839aa52ab2f91	29364325	2023-04-29T07:47:26.000Z	1000000000000000000	377637061066271125098	0x991e4f6dae4eea74a1797afbef7482343c59d5dfddd7efa79469be1c8a31d8c7	1778136926181358983
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	18	0x7cf664bd3525ecc200d03258122c5040f0323123	29388573	2023-04-29T21:34:54.000Z	7000000000000000000	385044136881957788918	0x3a875adac77b92f6a307c32f091ceafe093670dde2f48ceba12b8f484bc4a8f6	66501092991065983619
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	63	0x37749f66f360d9de7b8b1f7928d839aa52ab2f91	29364392	2023-04-29T07:49:38.000Z	400000000000000000	378037109627801326742	0xf8956560eb63e650ef9ab70082d868c4002c195776039bceb114a76f562db3f8	2178137154837544897

Example Query

Query with partition filter

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

Market_Mint_event

Mint events from BENQI lending markets on Avalanche, recording when users supply assets to earn interest-bearing qTokens. Contains minter address, underlying asset amount deposited, qTokens received, and market contract address for tracking lending protocol supply activity.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_minter`	`STRING`	Address authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
`in_mintAmount`	`STRING`	Quantity of underlying asset deposited into the lending protocol. Numeric string representing token amount in smallest denomination.
`in_mintTokens`	`STRING`	Quantity of protocol-specific interest-bearing tokens minted to the depositor. Numeric string representing token amount in smallest denomination.

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	0x730ad83e992ae5a328a5cceeef26b0e821acb524	91	17627826	1460707082750787	7264298	2022-07-21T18:48:25.000Z	0xcd93d9a21b8256f61aae4c8a71ca4fbb36f32b7fa8efd713bbe01aa874446c45
0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce	false	0xbf5bffbf7d94d3b29abe6eb20089b8a9e3d229f7	58	17630022	312797388600083896980	1563986943000	2022-07-21T20:01:49.000Z	0xbe8524b52da11d95cb7cbca07ae0e57b6fe5b0eb9234b5bd3b6bc33e92a654ea
0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce	false	0x9ea6f222211c2f51cf682e5fac790d2c9bb2e865	47	17610852	35586552746666666666666	177932763733327	2022-07-21T09:21:19.000Z	0xe016715fe0d43d74f017a4bd31bfc10d76ee2ea07a40e7a89154252beede27d1

Example Query

Query with partition filter

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

Market_NewReserveFactor_event

Reserve factor update events from BENQI lending markets on Avalanche, tracking protocol fee parameter changes with old and new mantissa values (18-decimal format). Used for monitoring governance decisions and protocol revenue allocation adjustments across different lending markets.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa
0x35bd6aeda81a7e5fc7a7832490e71f757b0cd9ce	false	34	4408566	2021-09-16T08:36:10.000Z	0x271106ac139a4c20662f972ed0fe5a7131887579cdd11d3100dfc5ff8e476e31	500000000000000000
0xf362fea9659cf036792c9cb02f8ff8198e21b4cb	false	71	13995170	2022-04-28T04:37:39.000Z	0xbe2b79c0a0321573cf092b0cfca42a858e9c7a00caa634492910805cc9d0c8f6	250000000000000000
0x89a415b3d20098e6a6c8f7a59001c67bd3129821	false	20	16578297	2022-06-27T08:55:45.000Z	0x41fef92f269a91f42c8b00e84693828491b85612dc3a8b2b972164578c4da056	250000000000000000

Example Query

Query with partition filter

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

Market_Redeem_event

Withdrawal events from BENQI lending markets on Avalanche, capturing when users redeem qTokens (interest-bearing tokens) for underlying assets. Includes redeemer addresses, qToken amounts burned, and underlying asset amounts received for tracking liquidity withdrawals and user redemption patterns.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0xb715808a78f6041e46d61cb123c9b4a27056ae9c	false	5	0xff3b59cfb2d2317814712766593f7b22edd85b7d	33635864	2023-08-08T02:41:31.000Z	2253721319	10970007493393	0xb0f0018ea0a9d1d5ac925c1fe0172bbae058ac0e305ce54d247216c8faff227a
0x89a415b3d20098e6a6c8f7a59001c67bd3129821	false	10	0x0e34ad56379acec7f09d815729b70c85adc1ec99	33636097	2023-08-08T02:49:18.000Z	290660428	14449200539	0xef504d0789013367c9414fb2d71fd8973f8f2ea13114db6dbeda118795f132c5
0x334ad834cd4481bb02d09615e7c11a00579a7909	false	10	0x98a97c80447bd8a5a84d487651728a98d26e85ef	33634597	2023-08-08T01:59:11.000Z	19000811658714662464	94205175509	0x55183c77963682a8d63cd789972d4830df3d5b8e1661345d82bb30bb847087f3

Example Query

Query with partition filter

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

Market_RepayBorrow_event

Borrow repayment events from BENQI lending markets on Avalanche, tracking when users repay borrowed assets with payer/borrower addresses, repayment amounts, and updated account/total borrow balances. Used for analyzing debt repayment patterns, liquidation activity, and protocol utilization across different qToken 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_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
0x835866d37afb8cb8f8334dccdaf66cf01832ff5d	false	0x00a43a60bf4276fb61110a56e5850b943e7ce493	29	0x00a43a60bf4276fb61110a56e5850b943e7ce493	7593686	20045634797428906989414	2021-11-29T19:33:29.000Z	384195553837798918840839712	0x3e634ab390884fff03e24686c9230391a3cd4a6bfd2bcc69a83c266f787b4518	45504299983533179374037
0xbeb5d47a3f720ec0a390d04b4d41ed7d9688bc7f	false	0x01f3bda033fa6076cfc02484b289a897786dfc26	106	0x01f3bda033fa6076cfc02484b289a897786dfc26	7560628	10000000000	2021-11-29T01:08:19.000Z	370913208723665	0x33d61272611062144af15a84b1774752ed07b9f765b02977886904fcb6e73235	58003819312
0x5c0401e81bc07ca70fad469b451682c0d747ef1c	false	0x038e63469c29e8637f5b3d4def52d31b400037ce	68	0x038e63469c29e8637f5b3d4def52d31b400037ce	7578871	12000000000000000000	2021-11-29T11:17:37.000Z	7231214085672432080782444	0x714e8104d5418135e69a48e2d9e4eb5d734142b3f1c54b106942f0ac6aff3b4d	1332557840207816109920

Example Query

Query with partition filter

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

StakedAvax_AccrueRewards_event

Reward accrual events from BENQI’s liquid staking protocol (sAVAX) on Avalanche, recording staking rewards distributed to token holders. Useful for calculating yield rates and tracking protocol revenue generation over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.

Sample Data

address	removed	in_value	block_number	block_timestamp	transaction_hash
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	false	1300295897000000000	17267010	2022-07-13T09:24:46.000Z	0x1193c0e7cae064c0254d30b1de35bd2edb53eacdc4839202294b6a9a8a8d0978
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	false	6332043040000000000	17275190	2022-07-13T13:55:57.000Z	0xb92bd9e5152b4c0bf5cb4abceb24eacf50e89dbe8a1a83f1c0c8489f6a97c0f5
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	false	1394685575000000000	17260998	2022-07-13T06:02:31.000Z	0x57a838f0d9ec421dc722593d955900478dcf67ac79d77dc013d2e2a442764ff7

Example Query

Query with partition filter

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

StakedAvax_Redeem_event

Redemption events from BENQI’s liquid staking protocol on Avalanche, recording when users unstake sAVAX tokens to withdraw underlying AVAX after the unlock period. Contains share-to-AVAX conversion rates and unlock timestamps for analyzing unstaking patterns and protocol liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_unlockRequestedAt`	`STRING`	Unix timestamp when the user initially requested to unlock their staked AVAX tokens. Represents the start of the cooldown period before redemption becomes available.
`in_shareAmount`	`STRING`	Quantity of shares minted or redeemed in the protocol operation. Integer value representing the share amount in smallest unit (wei).
`in_avaxAmount`	`STRING`	Amount of AVAX tokens redeemed by the user in this unstaking event, denominated in wei (18 decimals). Represents the underlying AVAX value returned when burning staked AVAX shares.

Sample Data

address	in_user	removed	block_number	in_avaxAmount	in_shareAmount	block_timestamp	transaction_hash	in_unlockRequestedAt
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0x549024e99ca254bba18c6818c3cc89cfdf457476	false	26330328	100252212409489970	94018333300064510	2023-02-16T11:52:48.000Z	0x7e56cd46c0405f7b79b30a89b208c75fdca4359ca761ca2f9b523e665b316591	1675083915
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0x75e23c03ebbcd4cb6823376e3beeef4a3db442cc	false	26323607	506217392429170955	474667358405680447	2023-02-16T08:04:01.000Z	0x641f3a33d239210d718bdfe6e4961307df991a3d45af493e0285c5f267e4e01c	1675178580
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0x315b9ae158aa8bd6960d2b2020bca24a531d8c32	false	26337057	10027387260294162	9403028454805459	2023-02-16T15:39:13.000Z	0x4fb150cac1321f3052d9cc847ee8a347eb50a5de660f1a89682c7069758effea	1675117099

Example Query

Query with partition filter

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

StakedAvax_Submitted_event

AVAX staking deposit events from BENQI liquid staking protocol on Avalanche, recording user submissions with native AVAX amounts and corresponding sAVAX (staked AVAX) share tokens received. Used for analyzing liquid staking adoption, deposit sizes, and share-to-asset exchange rates over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_avaxAmount`	`STRING`	Amount of AVAX tokens deposited by the user into BENQI’s liquid staking protocol, denominated in wei (1e18 = 1 AVAX). This value represents the native AVAX before conversion to staked AVAX shares.
`in_shareAmount`	`STRING`	Quantity of shares minted or redeemed in the protocol operation. Integer value representing the share amount in smallest unit (wei).

Sample Data

address	in_user	removed	log_index	block_number	in_avaxAmount	in_shareAmount	block_timestamp	transaction_hash
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0x414ffe4d53cbf0ef68f00c7b705efe45024abee7	false	1	12736044	5499999999999999999	5460222030330198977	2022-03-29T16:46:03.000Z	0x98ab1b35da99fa67de8e1d7506d4c465b26af09ccf014a136c3840db0fe24ed0
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0x87ac0dfcf6de4e2b99a4b2361c7a9bb4e24fca91	false	1	12733757	979999999999999999	972912830824577911	2022-03-29T15:28:52.000Z	0xf709fcee4924a9a66ba40f2bc810c871f99ddf39f32bc257fbaf87ba8a54c0e9
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	0x6c5724c65920276f22a26d1a99eaba38d2b279bf	false	2	12728649	69999999999999999999	69493927079610919823	2022-03-29T12:34:54.000Z	0x344d6d0fa5e6a1ff250a5461f4467581eaef988e2efe649174e6c45c07830880

Example Query

Query with partition filter

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

StakedAvaxV2_AccrueRewards_event

Reward distribution events from BENQI’s liquid staking protocol (sAVAX) on Avalanche, tracking staking rewards split between user accounts and protocol fees. Used for analyzing yield distribution, protocol revenue, and staking reward rates over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_userRewardAmount`	`STRING`	Total reward amount distributed to stakers for this accrual event, denominated in the smallest unit (wei) of AVAX. Values typically range from 45-55 AVAX (18 decimals) per event based on staking performance.
`in_protocolRewardAmount`	`STRING`	Reward amount allocated to the BENQI protocol from staking operations, denominated in the smallest unit (wei equivalent for AVAX). Typically represents approximately 10% of the total rewards accrued, with protocol share ranging from ~5-6 AVAX per event.

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_userRewardAmount	in_protocolRewardAmount
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	false	1	43799242	2024-04-05T03:32:52.000Z	0x1f3ffdb0367a1c039f5376e0eb053d43640e703c87b5ace3dc453d81fd53455f	45827738352450000000	5091970928050000000
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	false	1	43833496	2024-04-05T23:13:04.000Z	0x9e3255663dfc2f6661b98a4b51acb9ff5d61090c31b1c1d1f1a3489c721f2e65	49103576924400000000	5455952991600000000
0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be	false	1	43829581	2024-04-05T20:57:06.000Z	0xffcf10195a8f3464df71a1da61f84cdb17bb4470ae71aeca903c92533aa7187b	45757138191300000000	5084126465700000000

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

Comptroller_DistributedBorrowerReward_event

Comptroller_DistributedSupplierReward_event

Market_AccrueInterest_event

Market_Borrow_event

Market_Mint_event

Market_NewReserveFactor_event

Market_Redeem_event

Market_RepayBorrow_event

StakedAvax_AccrueRewards_event

StakedAvax_Redeem_event

StakedAvax_Submitted_event

StakedAvaxV2_AccrueRewards_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​Comptroller_DistributedBorrowerReward_event

​Comptroller_DistributedSupplierReward_event

​Market_AccrueInterest_event

​Market_Borrow_event

​Market_Mint_event

​Market_NewReserveFactor_event

​Market_Redeem_event

​Market_RepayBorrow_event

​StakedAvax_AccrueRewards_event

​StakedAvax_Redeem_event

​StakedAvax_Submitted_event

​StakedAvaxV2_AccrueRewards_event

Tables

Comptroller_DistributedBorrowerReward_event

Comptroller_DistributedSupplierReward_event

Market_AccrueInterest_event

Market_Borrow_event

Market_Mint_event

Market_NewReserveFactor_event

Market_Redeem_event

Market_RepayBorrow_event

StakedAvax_AccrueRewards_event

StakedAvax_Redeem_event

StakedAvax_Submitted_event

StakedAvaxV2_AccrueRewards_event