ironbank_v1_avalanche - Token Terminal Docs

Tables

iALPHAE_AccrueInterest_event

Interest accrual events from the Iron Bank V1 ALPHAΕ market on Avalanche, tracking accumulated interest, borrow index updates, and total borrows at each accrual checkpoint. Used for analyzing lending market dynamics and interest rate calculations for the ALPHAΕ asset.

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
0x02c9133627a14214879175a7a222d0a7f7404efb	false	50	11953044	428829950311988506789724	1000971011730098135	2022-03-11T00:49:48.000Z	213947143062263435528640	0xdfa4874046411962e059861fbcb63d04dba803f2b5445580e3756869c189ec20	153561694818784099
0x02c9133627a14214879175a7a222d0a7f7404efb	false	65	11953159	458829950311988506789724	1000971525824849941	2022-03-11T00:54:04.000Z	223947254026403389809072	0xab09b4523f885bf32b82cde661488861888ecc37f8d28f9166e408a1cbceea55	24225125369118878
0x02c9133627a14214879175a7a222d0a7f7404efb	false	148	11953137	468829950311988506789724	1000971417546403709	2022-03-11T00:53:12.000Z	213947229801278020690194	0x342211dc9696c9f2e3842a9b6265d97b1e3996a3fe0d5a0e70f244dd2c2e6fac	86739014585161554

Example Query

Query with partition filter

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

iALPHAE_Borrow_event

Borrow event logs from Iron Bank v1’s iALPHAE (ALPHA token) market on Avalanche, capturing individual borrow transactions with borrowed amounts, borrower addresses, and cumulative account and protocol-level borrow balances. Used for tracking lending protocol utilization and borrower activity analysis.

Columns

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

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x02c9133627a14214879175a7a222d0a7f7404efb	false	10	0x376d16c7de138b01455a51da79ad65806e9cd694	11532973	2022-03-01T05:00:50.000Z	1	296007567961744558982	0x10ca06a9b9ed9f00b36e0a2dc7751db695bb4180ae0b9fb4abcbe6dd04febf53	296007567961744542898
0x02c9133627a14214879175a7a222d0a7f7404efb	false	8	0x376d16c7de138b01455a51da79ad65806e9cd694	11532973	2022-03-01T05:00:50.000Z	997899355868892	296007567961744558981	0x10ca06a9b9ed9f00b36e0a2dc7751db695bb4180ae0b9fb4abcbe6dd04febf53	296007567961744542897
0x02c9133627a14214879175a7a222d0a7f7404efb	false	20	0x376d16c7de138b01455a51da79ad65806e9cd694	11330245	2022-02-24T10:03:56.000Z	737422	100000004424532	0x48ff5e7f45f69769b72dc7689756f8ec466ba5a41c141c59a46a3331ab64c1c9	100000004424533

Example Query

Query with partition filter

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

iALPHAE_Flashloan_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

iALPHAE_Mint_event

Mint events from Iron Bank V1’s iALPHAE (interest-bearing ALPHAE) token contract on Avalanche, recording deposits where users supply ALPHAE and receive iALPHAE tokens representing their lending position. Used for tracking supply-side lending activity and calculating total value locked in the ALPHAE 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_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
0x02c9133627a14214879175a7a222d0a7f7404efb	false	0x79ef2ae6027feb0342dc9956814c300666705eb3	29	14785137	47254324321965853492961	232039181813363	2022-05-16T20:30:17.000Z	0x8224a4148055da41b5919e5f2c8732eb7e8af2eabe434945b4b504539b7bb7bf
0x02c9133627a14214879175a7a222d0a7f7404efb	false	0x79ef2ae6027feb0342dc9956814c300666705eb3	90	14780895	12350771896357969831	60655891890	2022-05-16T18:08:03.000Z	0x8fa7410ba1affa5f34cb76657bcf753fd10ad86e49ade59d889fba60cac385c8
0x02c9133627a14214879175a7a222d0a7f7404efb	false	0x79ef2ae6027feb0342dc9956814c300666705eb3	7	14755197	151042883703305598764	742421196020	2022-05-16T03:53:43.000Z	0x34d9ff432b6c26b3a8e8d878cb21914039b2b9c662ff1bb28d8af3627209a1e3

Example Query

Query with partition filter

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

iALPHAE_NewReserveFactor_event

Reserve factor parameter change events for the iALPHAE (ALPHA) market on Iron Bank Avalanche, tracking adjustments to the protocol’s fee retention percentage. Used for monitoring governance decisions affecting protocol revenue allocation and reserve accumulation.

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
0x02c9133627a14214879175a7a222d0a7f7404efb	false	155	10689973	2022-02-09T10:26:36.000Z	0x0cc3c72f60bf3082c2fbbe4dcb747f7c8846385ce16243a52791ebe1314b150c	400000000000000000	0

Example Query

Query with partition filter

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

iALPHAE_Redeem_event

Redemption events from Iron Bank V1’s iALPHAE market on Avalanche, recording when users withdraw underlying ALPHAE tokens by burning their interest-bearing iALPHAE tokens. Tracks redeemer addresses, token amounts redeemed, and underlying asset amounts received for analyzing lending market withdrawals.

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
0x02c9133627a14214879175a7a222d0a7f7404efb	false	7	0x79ef2ae6027feb0342dc9956814c300666705eb3	11918312	2022-03-10T05:01:24.000Z	713945020365467915730656	3569347975993174	0xaa92366df85805b435be042cbe9db3d81bfe5a1abba15872869f6cb36c906094
0x02c9133627a14214879175a7a222d0a7f7404efb	false	23	0x79ef2ae6027feb0342dc9956814c300666705eb3	11928170	2022-03-10T10:34:36.000Z	8453389554859672446931	42262272404870	0xa4f9eeee1ca9adfb174db6a476155157feb933fb3e84a55848c77bb348c06828
0x02c9133627a14214879175a7a222d0a7f7404efb	false	14	0x79ef2ae6027feb0342dc9956814c300666705eb3	11939977	2022-03-10T17:14:13.000Z	21947773375557841759	109726056393	0x2d5c872099d6a0ca3dba973181d175a45c7a6c45c8d9aad97aa8a5b3a02ef624

Example Query

Query with partition filter

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

iALPHAE_RepayBorrow_event

Loan repayment events for the ALPHAE market on Iron Bank V1 (Avalanche), tracking borrower repayments with updated borrow balances. Used for analyzing debt reduction activity and borrower repayment patterns in this Compound-fork lending 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_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
0x02c9133627a14214879175a7a222d0a7f7404efb	false	0x376d16c7de138b01455a51da79ad65806e9cd694	45	0x376d16c7de138b01455a51da79ad65806e9cd694	13971421	70515103870814036424951	2022-04-27T15:12:53.000Z	195234071545784921234680	0xf4f0cc976263a25e5c5f9471ca99ba3d961f53e11183d52c459e2b052a03ac6d	195233997978658184246070
0x02c9133627a14214879175a7a222d0a7f7404efb	false	0x376d16c7de138b01455a51da79ad65806e9cd694	41	0x376d16c7de138b01455a51da79ad65806e9cd694	15675224	417136646132660363167	2022-06-06T12:47:34.000Z	95794678956861069546298	0x1bc65bb85e08ab0b6d34a2329e75207f25acb390190a2b9bcda18e98fb4d7c6c	95794603092583917871540
0x02c9133627a14214879175a7a222d0a7f7404efb	false	0x376d16c7de138b01455a51da79ad65806e9cd694	40	0x376d16c7de138b01455a51da79ad65806e9cd694	13584765	9845525721433231136660	2022-04-18T14:49:12.000Z	259184877858734198430763	0xb3a3b9a718f9750cea58bc1f58f0260ef1e42e25562f502f9e9638281e954157	259184804741129074493749

Example Query

Query with partition filter

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

iDAIE_AccrueInterest_event

Interest accrual events from Iron Bank’s DAI.e (bridged DAI) lending market on Avalanche, capturing periodic updates to accumulated interest, total borrows, cash reserves, and the borrow index. Used for tracking lending protocol economics and calculating time-weighted borrowing costs.

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
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	8	28040294	3799262172547784711439	1184249744779296354	2023-03-29T07:10:58.000Z	22556384752063454213364	0x3730cd19477905a7f69b7d6125630278cad9d2c32f7f52e1c984b4795ee05b36	7518953021318269714
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	44	28053218	3811263340458665542058	1184479572989264813	2023-03-29T14:36:58.000Z	22560762286070770155351	0x9f37dbc129ebab81ef2325a5aa3a45dc77df9d7185d7e203ffff188e8589c106	4377534007315941987
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	64	28053354	6642606938458665542058	1184481452772168753	2023-03-29T14:41:30.000Z	22560798090263778060404	0x7e59d08ccb198c30a514c528dfec4a3e8650e85bd9af65df1d68b6b500955922	35804193007905053

Example Query

Query with partition filter

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

iDAIE_Borrow_event

Borrow events from Iron Bank v1 DAI.e (Dai Stablecoin bridged) market on Avalanche, capturing individual borrow transactions with amounts, cumulative account borrows, and total protocol borrows. Used for tracking leverage positions and DAI.e utilization in Iron Bank’s lending protocol.

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
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	12	0xfaa41900848b7f68f4859676432811e6fc46a15c	17400061	2022-07-16T11:46:29.000Z	250000000000000000000	137924690549936741334395	0xb26e2ce81f9f3e09b0057bd77e192385f102d38f45e521b3ba2a83009e2c8deb	250000000000000000000
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	27	0x376d16c7de138b01455a51da79ad65806e9cd694	11129597	2022-02-19T16:25:56.000Z	25117094650081922916116	2647501461527712746100223	0x3ebfecbbcf605d7e25959fa14fb7b454edc60f1bc7198b085f4076c69b8fe70d	2647095013553921002597520
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	25	0x376d16c7de138b01455a51da79ad65806e9cd694	11129597	2022-02-19T16:25:56.000Z	55116612219741765851	2622384366877630823184107	0x3ebfecbbcf605d7e25959fa14fb7b454edc60f1bc7198b085f4076c69b8fe70d	2621977918903839079681404

Example Query

Query with partition filter

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

iDAIE_Flashloan_event

Flash loan events from Iron Bank’s DAI.e (DAI bridged to Avalanche) lending market. Records borrower addresses, loan amounts, and fee breakdowns for analyzing flash loan usage patterns and protocol revenue on Avalanche.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	68178488645679623739843	68	0xfb518413f8a8454ad9ccbb55e468d909ad0fd7fa	20453546593703887121	19723335	3068031989055583068	2022-09-10T03:16:45.000Z	0x532a6fd1df1687e7ca85e4fb23cbf9959074240ae77579aaf873b8e8604e470d
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	67311302908514532975084	37	0x3c58950acdf5778ba30c0b3eac52a4b475668a93	20193390872554359892	15966611	3029008630883153983	2022-06-13T07:06:35.000Z	0x228aa3770f076b1797833bda8ab491a5737032137ea2c84da45ef960feb70507
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	118331334090258310995890	37	0x3c58950acdf5778ba30c0b3eac52a4b475668a93	35499400227077493298	15993226	5324910034061623994	2022-06-13T21:21:46.000Z	0xc95d7dcc086b27d05732be4541bb4005a5996ee8cb751b99ced71d70afd908f8

Example Query

Query with partition filter

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

iDAIE_Mint_event

Mint events from Iron Bank’s iDAI.e (DAI) lending market on Avalanche, recording when users deposit DAI to receive interest-bearing iDAI.e tokens. Used for tracking lending activity, supply growth, and individual depositor behavior.

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
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	0x69491fd9a6d9e32f32113cc076b1b69d8b9ebd3f	5	9950956	10423326015391788173579	50880278783199	2022-01-23T13:24:04.000Z	0xeea49094bace9d7c262dae854e003cc9507c16156543cad7504f3d45ed0949ae
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	0x69491fd9a6d9e32f32113cc076b1b69d8b9ebd3f	11	9940377	500000000000000000000	2440839408147	2022-01-23T07:29:34.000Z	0xfb8814712ef883f1ce46018037edcac3bd9c57f6abee6c2d6ea9acd64ff88f08
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	0x69491fd9a6d9e32f32113cc076b1b69d8b9ebd3f	8	9933447	104256013051141501618837	508964599133013	2022-01-23T03:37:49.000Z	0xba97153c12dfab9cf653f7072cc7825bf07e0388781fa527d0f7aed876382624

Example Query

Query with partition filter

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

iDAIE_NewReserveFactor_event

Reserve factor parameter changes for Iron Bank’s DAI.e market on Avalanche, tracking protocol fee adjustments where reserve factor represents the percentage of borrower interest allocated to protocol 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
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	1	5533842	2021-10-12T07:53:27.000Z	0x719f2ef5638dc491a23eccefda8b9898294ad4f9997ea063582eaaf8f66b86b4	150000000000000000	0

Example Query

Query with partition filter

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

iDAIE_Redeem_event

Withdrawal events from Iron Bank V1’s DAI.e (Bridged DAI) lending market on Avalanche, recording when users redeem iDAI.e tokens for underlying DAI.e with amounts and exchange rates. Used for analyzing lending market 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
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	32	0x69491fd9a6d9e32f32113cc076b1b69d8b9ebd3f	24886123	2023-01-13T12:00:53.000Z	1803793767745652383	8442060747	0xcbb9008a73f84067bd3460593642f749e74a0cc8d978099702495c2bf1152df3
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	23	0x69491fd9a6d9e32f32113cc076b1b69d8b9ebd3f	18575502	2022-08-13T04:35:13.000Z	2527773423002180390504	12000000000000	0x4da596dde47c88a2b6fc31c868cc65f0fddd2a43fcfc341ef56b016d312a00f2
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	9	0x69491fd9a6d9e32f32113cc076b1b69d8b9ebd3f	26497699	2023-02-20T10:00:53.000Z	919512081690396660020	4300751222855	0x3e00ba9bc757f6960db1aa5d72e22059359e2e3d3862e732b1a226e633a8215d

Example Query

Query with partition filter

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

iDAIE_RepayBorrow_event

Debt repayment events for the DAI.e market on Iron Bank v1 (Avalanche). Tracks borrower loan repayments with amounts paid, remaining debt balances, and payer addresses for analyzing lending protocol debt management and liquidation activity.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	0x376d16c7de138b01455a51da79ad65806e9cd694	48	0x376d16c7de138b01455a51da79ad65806e9cd694	19081119	246139058182252207659	2022-08-25T01:14:32.000Z	98853564987920333377432	0x19a6496cb57401ae2b3ab441fce69c496358b85d7e2d62a9b58cbbe0285b1096	98804436791451214873545
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	0x376d16c7de138b01455a51da79ad65806e9cd694	38	0x376d16c7de138b01455a51da79ad65806e9cd694	19101006	1539179604167360942385	2022-08-25T12:26:05.000Z	97329544954370955775102	0x31077c78cd2ad16c18ebd49860aa49f5886d7838cdd2dbdf89cb4aec1144ce38	97280410479051756373742
0x085682716f61a72bf8c573fbaf88cca68c60e99b	false	0x376d16c7de138b01455a51da79ad65806e9cd694	42	0x376d16c7de138b01455a51da79ad65806e9cd694	13644227	89770959321254041309	2022-04-20T00:11:22.000Z	1003185243201323553372033	0x927c7d76455c540f3255d61f27fe325617ed6bb052fb2d50472f22c62f3e4ddb	1003108787137479651527476

Example Query

Query with partition filter

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

iLINKE_AccrueInterest_event

Interest accrual events for the iLINK.e (Chainlink wrapped) lending market on Iron Bank V1 (Avalanche), recording accumulated interest, borrow index updates, cash reserves, and total borrows for analyzing lending pool economics and utilization.

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
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	1	21818096	33593110450186486556	1031771642496166520	2022-11-01T13:32:50.000Z	7340146665604166468	0x47328911b947a3fdd31b6405a424c110df29041d9856168dfc8bc377d73bb3be	666993593542089
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	4	18036692	147741240055486726010	1026060004205980242	2022-07-31T13:37:00.000Z	1208	0xfa24f81880456e79e48f3346f0bc51d796803aae14d8dd4683e46ceedd4a9079	0
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	5	23970899	40992785857767060616	1034739546199348966	2022-12-22T16:36:29.000Z	14730173546191	0x4a31f4648a1aa46e14d858596b6ac3f7e52663c1652a29d52d2feab3f94f449f	8798

Example Query

Query with partition filter

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

iLINKE_Borrow_event

Borrow events from the Iron Bank V1 LINK.e (Chainlink bridged) lending market on Avalanche. Tracks individual borrow transactions with amounts, borrower addresses, and running totals for analyzing lending market utilization and borrower behavior.

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
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	6	0x92f225a26a82441876f27d2dbebf45335469d107	31959790	2023-06-29T15:36:23.000Z	10000000000000000000	12512064217892840539	0x73e38baf9313e8d316ef7979ce5c8b747a676ba609fa2fe85b0ec0a310013220	12509078734511981056
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	5	0x376d16c7de138b01455a51da79ad65806e9cd694	25320532	2023-01-23T17:54:45.000Z	4562874225502192074	4562890105888014841	0x2b3e23f941d4e7cbb8e80a6da4f233b027fde221820cdd8071083f4769199eb8	4562874225502192074
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	61	0x88b0ea576428da635d0fa9deb686765c90cfde2e	14052077	2022-04-29T13:08:49.000Z	13212628662167287400	77265733485302343682	0x27e9adabf637339642145ceba1c4c4df4be5583788083ab3927675f50bc8ea17	13212628662167287400

Example Query

Query with partition filter

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

iLINKE_Flashloan_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

iLINKE_Mint_event

Mint events from Iron Bank’s iLINK.e market on Avalanche, recording when users deposit LINK.e tokens to receive interest-bearing iLINK.e tokens in return. Useful for analyzing lending protocol supply activity and tracking minter behavior across LINK.e deposits.

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
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	0x197939c1ca20c2b506d6811d8b6cdb3394471074	19	6507995	100000000000000000	500000000	2021-11-04T09:38:28.000Z	0xcdf498f1a9a1c9af3677c45b65379e2aa189fc32ab4efa0de6a6452a0bd79fe9
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	0xaafa80367975dad6f5243382f26d2eab978973fe	56	12244843	2184585229477631977097	10922926147388	2022-03-18T01:31:55.000Z	0xedf675fde5ff15fbcf6c401b18b4f4d2def3bc5a910812356b0233495c3a553b
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	0x92f225a26a82441876f27d2dbebf45335469d107	32	31887605	15000000000000000000	74094185240	2023-06-27T22:51:38.000Z	0x753e94595cedfa9dff6db99ae8f328e459a0a20e9e73d0fb850ca8168b1cd1fe

Example Query

Query with partition filter

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

iLINKE_NewReserveFactor_event

Reserve factor parameter change events for the iLINK.e (LINK on Avalanche) market in Iron Bank V1, tracking when protocol revenue allocation percentages are updated. Used for monitoring governance changes to the reserve factor mantissa values that determine what portion of interest payments are retained by the protocol.

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
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	22	5537165	2021-10-12T09:49:48.000Z	0xba9b8a86abb73b28064bdb34e375cff8ca4f11e401dd3903c180cdb272988678	400000000000000000	0

Example Query

Query with partition filter

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

iLINKE_Redeem_event

Redemption events from the iLINKE (Iron Bank LINK) lending market on Avalanche, tracking when users withdraw underlying LINK tokens by burning iLINKE tokens. Used to analyze lending market withdrawals, liquidity flows, and iToken exchange rate movements.

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
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	16	0xaafa80367975dad6f5243382f26d2eab978973fe	28999293	2023-04-20T16:53:59.000Z	16862990281677513040	83298242607	0x1a4a6fb49b1d32a45b935b4a87904ce38b118643547d2d6ff8d494fa95473195
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	14	0x92f225a26a82441876f27d2dbebf45335469d107	30954708	2023-06-05T20:35:05.000Z	18502301455739853755	91394211316	0xbbaa30c38b8b78ecc771b85eb1c0860c24a02daff4528132f5d2e00979d0d080
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	21	0x92f225a26a82441876f27d2dbebf45335469d107	30954014	2023-06-05T20:11:06.000Z	70000000000000000000	345772919545	0x9a35eafcac4546bc1245af6886e11deeef481f64a9854f2457098130cd877e0b

Example Query

Query with partition filter

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

iLINKE_RepayBorrow_event

Loan repayment events for the LINK.e (Chainlink bridged) market on Iron Bank v1 lending protocol on Avalanche. Tracks repayment amounts, borrower addresses, and updated borrow balances for analyzing debt management and protocol utilization.

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
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	0x376d16c7de138b01455a51da79ad65806e9cd694	35	0x376d16c7de138b01455a51da79ad65806e9cd694	25704604	17286068995613066130	2023-02-01T18:46:09.000Z	15894860851188	0x71b741ed3314ce975a95cf92c6ef7f8dc1a60f0a70a43f05532800a150d00405	0
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	0x376d16c7de138b01455a51da79ad65806e9cd694	35	0x376d16c7de138b01455a51da79ad65806e9cd694	23797768	21137261220563135670	2022-12-18T14:39:42.000Z	14712959617694	0x08d21703e350044be5a410e6bfe74aaa35b7ea593478471190f03b86261895c5	0
0x18931772adb90e7f214b6cbc78ddd6e0f090d4b1	false	0x92f225a26a82441876f27d2dbebf45335469d107	40	0x92f225a26a82441876f27d2dbebf45335469d107	31929709	18000000000000000000	2023-06-28T22:40:43.000Z	2512044842730296161	0x4dbc44a1d91953c728ec063caf6f0c09ae4fa787c6dd4ccdcc4c5ad3ca593c9a	2509059382376007962

Example Query

Query with partition filter

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

iMIM_AccrueInterest_event

Interest accrual events for the iMIM (Iron Bank MIM) lending market on Avalanche, recording accumulated interest, borrow index updates, cash reserves, and total borrows per block for analyzing borrowing costs and protocol revenue.

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
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	1	11254278	591745665571773017683	1006114238665239954	2022-02-22T14:49:59.000Z	154730654498259860321	0x45747debe5c840ccb1b63e5c6d373cf769fff7ad4e7abd5316e03278f6b6fe3b	1180561018656810
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	25	11251794	645868649359919806930	1006106562233867417	2022-02-22T13:25:54.000Z	100606490149094414264	0x533bdce8201d47d9a998a1587eee0d7576ae9180f47cbf98a625791da627bcf7	3124360350169048
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	15	11232278	746959226553941415146	1006075316333161184	2022-02-22T02:28:17.000Z	12959163572560339	0x6b4701976ee2f2677a83cbb9354bcb40860f103ad0b259603d870d1867b08dae	40522402

Example Query

Query with partition filter

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

iMIM_Borrow_event

Borrow event logs from Iron Bank’s MIM (Magic Internet Money) market on Avalanche. Tracks each borrow transaction with borrowed amount, cumulative account borrows, and protocol-wide total borrows for analyzing lending activity and debt 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_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
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	43	0x376d16c7de138b01455a51da79ad65806e9cd694	13665021	2022-04-20T11:51:17.000Z	472485092528913958	226062727119435331890913	0xd68316c316a3aab1271609c6196f5040f0bc9efb5337820ce5b6004baa838f08	226062727119435304309319
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	23	0x376d16c7de138b01455a51da79ad65806e9cd694	13663814	2022-04-20T11:10:31.000Z	16222397659623896049	229567862285609103915850	0xae1c02caed273740e7616cd79bd6f1325919c149de8118c7b5d3a761ab518499	229567862285609076512594
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	20	0x376d16c7de138b01455a51da79ad65806e9cd694	16168630	2022-06-17T21:43:54.000Z	19285354160283594967	96218872495410127439942	0x4e8fc71d5460550561519ed10741b0a1d7facb8699ceb985387769e85813993a	96218872495410091335796

Example Query

Query with partition filter

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

iMIM_Flashloan_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

iMIM_Mint_event

Minting events for Iron Bank’s iMIM market on Avalanche, recording when users deposit MIM (Magic Internet Money) collateral to receive iMIM tokens. Used for tracking supply changes and user deposit activity in the lending protocol.

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
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	0x4edba7aa78dd15de5093af95c35f24f04ec93558	29	25789707	2411574501774307834	11577613372	2023-02-03T18:03:47.000Z	0xa2d787b1cff965d6f8db80cfa52445b5fb435620e5fd7cb5b05329fde3688c3f
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	0x4edba7aa78dd15de5093af95c35f24f04ec93558	13	25789598	301550489419982869	1447700708	2023-02-03T18:00:07.000Z	0x5888032921b92e3478783f29caa3e5b16fbb9443ee8d99ac940db3036dca72b0
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	0x377da1791e2225740599a3c447c50861f7b27f49	7	13729416	11669043121162696396103	57728713116248	2022-04-21T23:53:32.000Z	0x61dac86adcd075078504e354a75d2225f243e1e16a439e21a62989dea7536159

Example Query

Query with partition filter

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

iMIM_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank MIM (Magic Internet Money) lending market on Avalanche. Tracks protocol fee adjustments where reserve factor mantissa represents the percentage of interest allocated to protocol reserves (18 decimal precision).

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
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	3	10073830	2022-01-26T09:02:41.000Z	0x3488fe4c6ae2761ebbab2354a6781c84569f14dc2bb91163b669fdf972515a05	150000000000000000	0

Example Query

Query with partition filter

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

iMIM_Redeem_event

Redemption events from the Iron Bank V1 MIM (Magic Internet Money) market on Avalanche, tracking when users withdraw underlying assets by burning ibTokens. Contains redeemer addresses, amounts of underlying tokens withdrawn, and corresponding ibToken quantities burned for analyzing lending market withdrawals.

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
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	71	0x37cd17512cb0386556e00255cbfef37f85ee8353	10102822	2022-01-27T00:52:14.000Z	17621101415685194382010	88105507078425	0x712a60247ca1ee81c2303fe8e495cdc69aa853922f0ed7f331ac7d8132acb7db
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	4	0x377da1791e2225740599a3c447c50861f7b27f49	12552058	2022-03-25T08:54:45.000Z	240132952182981110575	1194691535205	0x859a36e72bd05d2b8042e3aac184f34978735e91fae93e81826b9c87a6a043f7
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	34	0x377da1791e2225740599a3c447c50861f7b27f49	12538903	2022-03-25T01:30:39.000Z	70642367914206417921734	351459819454499	0xa15df8f7f6bc96bb78c74444d45c011d47946ee4969c5d7a9ff41b7f9179b612

Example Query

Query with partition filter

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

iMIM_RepayBorrow_event

Loan repayment events for the iMIM (Iron Bank Magic Internet Money) market on Iron Bank v1 on Avalanche, tracking borrower addresses, repayment amounts, and updated borrow balances. Used for analyzing debt reduction activity and borrower repayment behavior in the MIM lending pool.

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
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	0x376d16c7de138b01455a51da79ad65806e9cd694	55	0x376d16c7de138b01455a51da79ad65806e9cd694	14512592	10267274279437534067464	2022-05-10T13:11:57.000Z	159153031472484297345218	0x6921feab1bf5b756e380d24678fb6992ce578fa9b004ec2559b9db7654be8236	159153031472484264949974
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	0x376d16c7de138b01455a51da79ad65806e9cd694	110	0x376d16c7de138b01455a51da79ad65806e9cd694	12953773	50646110907664538324853	2022-04-03T19:49:29.000Z	362938909888590109480569	0x9c8cc42adf9abaac4ecae5c9e487890776caaab725a4bb5dc907a878d99c5443	362938909888590090872242
0xbf1430d9ec170b7e97223c7f321782471c587b29	false	0x376d16c7de138b01455a51da79ad65806e9cd694	43	0x376d16c7de138b01455a51da79ad65806e9cd694	19707794	959866258551064714705	2022-09-09T12:38:38.000Z	50543272852474688800008	0x8c5fee650eeadf06182d897b1c3a773b49b996571cc2f616db68921af27a6e45	50543272852474647523095

Example Query

Query with partition filter

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

iUSDC_AccrueInterest_event

Interest accrual event emitted by Iron Bank USDC lending markets when borrowing costs are calculated and applied. Records the borrow index progression, total outstanding borrows, accumulated interest for the period, and cash reserves prior to 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_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
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	0	18907981	352509036681	1051131068314690186	2022-08-20T23:53:38.000Z	839899990836	0xcf29392bd6d90ce74a2c52fead5247bb76581f23e5de3caa1c5c397639124e1f	8071259
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	1	18874440	163570256062	1050766244475002244	2022-08-20T05:07:10.000Z	710669435344	0xc5d208ee593a72a235d4a0ffcfd0c5e4cd321e4bd0a124ad35c19453a5e79c07	11522861
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	1	18873068	136872475831	1050749207250986972	2022-08-20T04:20:51.000Z	710657912483	0x984d8535d56fbdf48622940fe340f3087d0e3eb5db32028bd23043d9228bf0ab	55010254

Example Query

Query with partition filter

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

iUSDC_Borrow_event

USDC borrow events from Iron Bank lending markets recording loan originations with borrower address, borrowed amount, and updated account and market-wide borrow balances. Used for tracking lending protocol utilization and debt positions across chains.

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
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	2	0x92f225a26a82441876f27d2dbebf45335469d107	29816933	2023-05-10T00:19:02.000Z	1000000000	67125771640	0x50e37170197b7befa271cd849b4dac0b9117a3c0bdacae14684ed0e84933c186	1000000000
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	2	0x92f225a26a82441876f27d2dbebf45335469d107	29858114	2023-05-10T23:32:52.000Z	350000000	67454151807	0x6e431129f5ef3edbc5f289e4eecab4b58434e7b2b66df117da2da72d538a122f	1325050341
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	62	0x92f225a26a82441876f27d2dbebf45335469d107	29858119	2023-05-10T23:33:01.000Z	350000000	67804152175	0xec4a4f29974dcb579af83070e1310c1b49beae5350af4bb53cfc86a7814d6c04	1675050348

Example Query

Query with partition filter

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

iUSDC_Flashloan_event

Flashloan events for the iUSDC (Iron Bank USDC) market containing loan amount, receiver address, total fee charged, and reserves fee allocation. Emitted when uncollateralized instant loans are executed and repaid within a single transaction on Iron Bank lending protocol.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	14242695	24	0x9905cc33133bf8d014660bcce5c2d654b253ba21	4272	20651919	640	2022-10-04T22:14:42.000Z	0x57625d9b0174fcdff06eb854f61629a13b90bb5c1c4a84451e8ea5e904849bcb
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	17565800	24	0x9905cc33133bf8d014660bcce5c2d654b253ba21	5269	20646342	790	2022-10-04T19:01:54.000Z	0x6b8c7799caeb66b9a1a5ce32816f37cedbba7d6c717baa291b2874dee244f5d8
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	69019476	25	0x9905cc33133bf8d014660bcce5c2d654b253ba21	20705	20652757	3105	2022-10-04T22:44:02.000Z	0x1ddbf5b5732261d1290b17193d5a6176b0d1fedc5f5aade4a2abf011913f88f2

Example Query

Query with partition filter

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

iUSDC_Mint_event

Iron Bank USDC deposit events recording when users supply USDC collateral to mint interest-bearing iUSDC tokens. Contains depositor address, underlying USDC amount, and corresponding iUSDC tokens received.

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
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	0xa0b8adc61e76e2b3961eb66e2e37840e02053591	20	17029399	10000000000	49245473784355	2022-07-07T20:18:16.000Z	0x060739ea709af215c4bccbddaf501d301b5418a18b4a4fc4ab4129fb76cae957
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	0xa0b8adc61e76e2b3961eb66e2e37840e02053591	3	17008854	1100000	5417320825	2022-07-07T08:49:43.000Z	0x89e227b50c9e4f24789e3c5d0a147a5f324b97fe0deac89957b833228af5b91c
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	0x22e798f9440f563b92aae24e94c75dfa499e3d3e	29	29098043	6000000000	28737954109273	2023-04-23T00:34:04.000Z	0x1bbb73c7cf8562c8177a29de6c9a80ba4496a2a603afa979dd99af0d5716ee46

Example Query

Query with partition filter

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

iUSDC_NewReserveFactor_event

Iron Bank reserve factor updates for USDC lending markets. Records previous and new reserve factor values as 18-decimal mantissas, tracking protocol fee allocation changes for USDC collateral 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_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
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	137	8566162	2021-12-22T10:59:36.000Z	0x399be32f2f91b65f7e6dbda9bbddf8bd00a7fb87f2c6e2795b20299585135e1a	150000000000000000	0

Example Query

Query with partition filter

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

iUSDC_Redeem_event

Redemption events from Iron Bank USDC lending pools recording withdrawals of underlying USDC assets in exchange for burned interest-bearing iUSDC tokens. Contains redeemer address, underlying asset amount withdrawn, and derivative token amount burned for tracking lending pool outflows.

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
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	4	0xa0b8adc61e76e2b3961eb66e2e37840e02053591	18503417	2022-08-11T12:18:11.000Z	145009747605	710719852668509	0xf238885363d4a435f0efb0f3cdc46a2199f70be5b2092a10f030c646ec04ec8a
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	29	0xa0b8adc61e76e2b3961eb66e2e37840e02053591	12665987	2022-03-28T01:15:47.000Z	2448793726	12214572129954	0x8b63ffddfbd22364f43fe1be5bbdb25f1454a45e96548149c1d113a32150d086
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	14	0xa0b8adc61e76e2b3961eb66e2e37840e02053591	25958103	2023-02-07T16:41:03.000Z	8051470	38754538288	0xbb65b2116c015bd7cffd3df9190d15362bf589de9ffcf7dac50ae7b85d7a4c51

Example Query

Query with partition filter

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

iUSDC_RepayBorrow_event

Borrow repayment events from Iron Bank USDC lending markets, recording payer address, borrower address, repayment amount, and updated account and total borrow balances. Used for tracking debt reduction and loan servicing activity in Iron Bank protocol across multiple chains.

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
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	0x376d16c7de138b01455a51da79ad65806e9cd694	38	0x376d16c7de138b01455a51da79ad65806e9cd694	26282438	4951787420	2023-02-15T08:56:02.000Z	1208816617107	0xce1dc566a2bada803e99d1ce2545f05bd58ba5d5c4f3e53fbf389bc1a052a92a	1208687854405
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	0x376d16c7de138b01455a51da79ad65806e9cd694	48	0x376d16c7de138b01455a51da79ad65806e9cd694	26309099	1852631	2023-02-15T23:52:55.000Z	1225371775587	0x856d8fa20b486fd365e5d6976078ca9fe62a7f8cb89bb80579acd1ac397fce68	1225242994080
0xec5aa19566aa442c8c50f3c6734b6bb23ff21cd7	false	0x376d16c7de138b01455a51da79ad65806e9cd694	33	0x376d16c7de138b01455a51da79ad65806e9cd694	26299505	53980292	2023-02-15T18:33:38.000Z	1209256106131	0x2b082f8845a00f748f5318ce34262e665c34d5b72ada8de9aac3690db64db434	1209127331430

Example Query

Query with partition filter

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

iUSDCE_AccrueInterest_event

Interest accrual events for the Iron Bank USDC.e market on Avalanche, recording borrowing costs accumulation with cash reserves, total borrows, and borrow index updates. Used for tracking lending protocol interest rate mechanics and borrower cost 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_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
0xe28965073c49a02923882b8329d3e8c1d805e832	false	19	29385608	425504707886	1180238880800783047	2023-04-29T19:53:22.000Z	120950514774	0xc5bc7c1b65940e67a457686b8c0d74042f3696722fccc2a4c8038237a49ef854	57542144
0xe28965073c49a02923882b8329d3e8c1d805e832	false	1	27163246	1352538713512	1176263618189975045	2023-03-08T08:03:54.000Z	323376802002	0x72aa57ac57f397fd08e4987d17f36bfab232fd98226953b1202819ac5f6eac4f	26430
0xe28965073c49a02923882b8329d3e8c1d805e832	false	1	27173195	1176296977243	1176285369578789973	2023-03-08T13:50:55.000Z	323382781862	0xda5f4634071ccde38d83dc02925dedce5dd40d7203c944759c2c0875da44178b	2857577

Example Query

Query with partition filter

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

iUSDCE_Borrow_event

Borrow event logs from the Iron Bank V1 USDC.e (Bridged USDC) lending market on Avalanche. Tracks individual borrow transactions with amounts, cumulative borrows per account, and protocol-wide borrow totals for analyzing leverage usage and debt 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_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
0xe28965073c49a02923882b8329d3e8c1d805e832	false	26	0x376d16c7de138b01455a51da79ad65806e9cd694	25062615	2023-01-17T15:28:04.000Z	55851380	1415446646616	0x2460c7c6ae6b46e8aa343d370154dfad8fb06b5a07fd07bc8f993bb7daffbbb3	1413035560292
0xe28965073c49a02923882b8329d3e8c1d805e832	false	25	0x376d16c7de138b01455a51da79ad65806e9cd694	9710408	2022-01-17T23:44:56.000Z	58357127	24876489088194	0x12d3a44f284be35632672bc8d2ab30133b0d8164fddf59e54b9783d6aa874e41	24847394386270
0xe28965073c49a02923882b8329d3e8c1d805e832	false	7	0x376d16c7de138b01455a51da79ad65806e9cd694	9669031	2022-01-17T00:51:11.000Z	8727911	23381880248307	0x1be0f64717d9f98f88760de4f6c5d1b13baa33c3cf900100f00dcd844c239710	23352801899350

Example Query

Query with partition filter

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

iUSDCE_Flashloan_event

Flash loan events from Iron Bank’s USDC.e (bridged USDC) lending pool on Avalanche. Records borrowed amounts, fees charged, and receiver addresses for analyzing arbitrage activity and protocol fee 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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0xe28965073c49a02923882b8329d3e8c1d805e832	false	145232027803	21	0x3c58950acdf5778ba30c0b3eac52a4b475668a93	43569608	14590469	6535441	2022-05-12T08:28:32.000Z	0x0760be8002bc43f85bc61ea6e73ec9f9fe0eea27108961b124e160298bc1ed07
0xe28965073c49a02923882b8329d3e8c1d805e832	false	463001503372	21	0x3c58950acdf5778ba30c0b3eac52a4b475668a93	138900451	14597830	20835067	2022-05-12T12:27:31.000Z	0x57afc1ffc9d68e8eee1c7111cbd473e73b8d6b3d001586a64cb247727a6c0158
0xe28965073c49a02923882b8329d3e8c1d805e832	false	187199111381	22	0x3c58950acdf5778ba30c0b3eac52a4b475668a93	56159733	14603799	8423959	2022-05-12T15:44:19.000Z	0xe5f6f80d7d6608976a933d9e51817cebc643a9a728366e1ec3ac1c09673f0672

Example Query

Query with partition filter

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

iUSDCE_Mint_event

Mint event logs from Iron Bank’s iUSDC.e (Bridged USDC) lending market on Avalanche, recording when users deposit USDC.e collateral in exchange for interest-bearing iTokens. Useful for tracking lending pool liquidity changes and collateral deposit 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_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
0xe28965073c49a02923882b8329d3e8c1d805e832	false	0xd3843b60e69f958ef93bec299467e6ed301cbeeb	12	20933467	320171395	1491650309443	2022-10-11T16:10:14.000Z	0xf253b65f3334c36c2d426edf36338a82bfec74db4510ce75f3966a1014d6fd64
0xe28965073c49a02923882b8329d3e8c1d805e832	false	0xfd6d3dac0e787a8ab01f5ab5f4a1c877790f27af	3	27337104	8933237	41059727574	2023-03-12T09:35:00.000Z	0x1c286d1eab0040aa6b3efe18d48a4878c2c9324c184e6502cc2d333c30e7d56f
0xe28965073c49a02923882b8329d3e8c1d805e832	false	0xfd6d3dac0e787a8ab01f5ab5f4a1c877790f27af	3	27337220	1000000000	4596287721299	2023-03-12T09:39:02.000Z	0x0e16da5b80c7a4f5213fdc083e021f954786cb6c28e385b1e557ce1ee516f2f4

Example Query

Query with partition filter

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

iUSDCE_NewReserveFactor_event

Reserve factor change events for the USDC.e (bridged USDC) lending market on Iron Bank’s Avalanche deployment. Tracks updates to the protocol’s reserve percentage parameter, showing transitions from old to new mantissa values for 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.
`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
0xe28965073c49a02923882b8329d3e8c1d805e832	false	1	5533839	2021-10-12T07:53:20.000Z	0x6fab1d1705f2d9932a487e731336c5c3dd41b7dfb9dcbf16397101d5f510550d	150000000000000000	0

Example Query

Query with partition filter

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

iUSDCE_Redeem_event

Redemption events from Iron Bank v1 USDC.e lending market on Avalanche, tracking when users withdraw their deposited USDC.e by burning iUSDC.e tokens. Useful for analyzing lending market liquidity flows and user withdrawal patterns.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0xe28965073c49a02923882b8329d3e8c1d805e832	false	7	0x64fe6fb6661164624247ec3e653fb476612213ca	9090176	2022-01-03T17:19:13.000Z	1681624074	8132761638420	0x8cbc02d7eff05387448edee83801e04e902ade2377551f3d8f3a697fba5b1cda
0xe28965073c49a02923882b8329d3e8c1d805e832	false	7	0xd3843b60e69f958ef93bec299467e6ed301cbeeb	9085429	2022-01-03T14:39:07.000Z	2015577934	9747982965644	0xb82a71543bc12d8852e647ed7098725c7a2f04f4eb9c4e9a3947daa9f82f37d3
0xe28965073c49a02923882b8329d3e8c1d805e832	false	8	0xd3843b60e69f958ef93bec299467e6ed301cbeeb	9088672	2022-01-03T16:27:56.000Z	37218703	180000000000	0xd4644512855883ca0f665043429bfe13a6753677d3251feac2ee913e720b6443

Example Query

Query with partition filter

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

iUSDCE_RepayBorrow_event

Borrow repayment events from Iron Bank’s USDC.e (Bridged USDC) lending market on Avalanche. Tracks repayment amounts, remaining borrows, and payer/borrower relationships for analyzing debt reduction activity and loan performance.

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
0xe28965073c49a02923882b8329d3e8c1d805e832	false	0x376d16c7de138b01455a51da79ad65806e9cd694	34	0x376d16c7de138b01455a51da79ad65806e9cd694	21130368	9915734	2022-10-16T08:17:32.000Z	1818273436143	0xa6e199df82e224224cd4b1a23572e746d7d1e7acd963fffcefa79f3aeed6b7e8	1816198768101
0xe28965073c49a02923882b8329d3e8c1d805e832	false	0x376d16c7de138b01455a51da79ad65806e9cd694	28	0x376d16c7de138b01455a51da79ad65806e9cd694	21139406	13993076	2022-10-16T13:27:53.000Z	1818406644513	0xb7f1da3bcdfb7fdc62b0474c01e8999f4ac62379daee13b95c24c5b700a7216a	1816331836479
0xe28965073c49a02923882b8329d3e8c1d805e832	false	0x376d16c7de138b01455a51da79ad65806e9cd694	42	0x376d16c7de138b01455a51da79ad65806e9cd694	21129038	988928502	2022-10-16T07:31:30.000Z	1818261518100	0xca8244bb9653798bf2529135088334ee434f7d74038a580dbeb58e77d333df15	1816186870822

Example Query

Query with partition filter

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

iUSDT_AccrueInterest_event

Interest accrual events for Iron Bank’s iUSDT market on Avalanche, tracking accumulated interest, borrow index updates, total borrows, and available cash for analyzing lending pool performance and rate calculations.

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
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	4	28186651	42491568359	1062052493336323201	2023-04-01T17:09:28.000Z	181050326012	0x69f94c6a4e07bc77b8abe83b504f0dd977e7fa04d4299c0d2e5c0a60aea566c3	24163043
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	6	28171666	49252509934	1061866464599933372	2023-04-01T08:45:35.000Z	181018613302	0x49cf93e76d1c60d7cc313956fdbb1de3c6bf9bd9548f84c59a314095cbd0eaae	50285538
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	3	28175326	52576609893	1061910751418036190	2023-04-01T10:48:11.000Z	181026162969	0x0227bd39e8f328bc412bac75cdec0b2f2cea25eff2d7a6f19809af580fa9efe8	7549667

Example Query

Query with partition filter

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

iUSDT_Borrow_event

Borrow event logs for Iron Bank’s iUSDT market on Avalanche, recording each borrowing transaction with borrower address, borrowed amount, and cumulative account and total borrows. Used for tracking lending protocol debt positions and borrower behavior 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_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
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	15	0x376d16c7de138b01455a51da79ad65806e9cd694	23629221	2022-12-14T15:34:24.000Z	1872121	264873689538	0x2097d90b7cbe4b34df09598e2a58150066b62650d783555b1c35b70cfd7b4998	264833322518
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	46	0x376d16c7de138b01455a51da79ad65806e9cd694	23623466	2022-12-14T12:21:26.000Z	245267370	264862455382	0xe4bd71a0ca2a62aa47839cca8b11bf05bfd3d2a68c9b493d1858d61a8fbe4b82	264822089789
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	44	0x376d16c7de138b01455a51da79ad65806e9cd694	23623466	2022-12-14T12:21:26.000Z	13373614	264617188012	0xe4bd71a0ca2a62aa47839cca8b11bf05bfd3d2a68c9b493d1858d61a8fbe4b82	264576822419

Example Query

Query with partition filter

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

iUSDT_Flashloan_event

No description available.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

iUSDT_Mint_event

Mint events from Iron Bank’s iUSDT market on Avalanche, recording when users deposit USDT to receive interest-bearing iUSDT tokens. Contains deposit amounts, minted iTokens, and minter addresses for analyzing 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
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	0x825483c3e50568dc4722627e6d390c2061e2eb52	10	24894150	20855312548	102683745184632	2023-01-13T16:31:09.000Z	0x4241ce6ff0b21a91d39ea5aa2ff5ea745c69d0492aa6c4f2f9afaa144a76efc6
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	0xd25c2adcc025ddaf6c02e24dfddb779ac7a540a3	17	24898220	20000000000	98471107259533	2023-01-13T18:48:23.000Z	0xc49a3cc52994d549eae804b1223cdbed4feb21a82d08badeafe970dfe183c6a9
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	0xd25c2adcc025ddaf6c02e24dfddb779ac7a540a3	5	24878355	711473983	3503242676133	2023-01-13T07:39:50.000Z	0xad69e30cdba3c1cc8d1cc2f87f1f0cdcc9cb7b4f4a96e0d0ca442c1dfe9a9633

Example Query

Query with partition filter

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

iUSDT_NewReserveFactor_event

Reserve factor parameter change events for Iron Bank’s iUSDT market on Avalanche, tracking adjustments to the protocol’s fee allocation between reserves and suppliers. Used for monitoring governance decisions and protocol revenue distribution changes 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_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
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	27	21214441	2022-10-18T08:03:28.000Z	0x144a6530cc6849a4339baec54ebeb9dcf1d0d7f4c0035f1873870b530cf9bca9	150000000000000000	0

Example Query

Query with partition filter

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

iUSDT_Redeem_event

Redemption events from Iron Bank v1’s iUSDT market on Avalanche, recording when users withdraw underlying USDT by burning interest-bearing iUSDT tokens. Useful for analyzing lending market withdrawals and tracking collateral movements.

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
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	41	0x192aa955a7526d1a9b13f2f55b140285439ba8a8	23155836	2022-12-03T09:37:52.000Z	1500000000	7442615880571	0xf69fad9a4ca02da09502750506f19f151b21fce464784e09060dbb2cbb47fa49
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	3	0xd00d529aa7a4b85a896a1686a8ff89d5a3b98616	23175981	2022-12-03T21:03:54.000Z	398272245	1975888006490	0x32503b3f4d2efa2d9ed55c7ca0e845cb519449ef2abe236c9e9d3ffa9214f18f
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	13	0xd00d529aa7a4b85a896a1686a8ff89d5a3b98616	23149736	2022-12-03T06:08:05.000Z	2500644132	12408010665361	0xacf04ab69d5ed906eedc0c18837fbab2d83a3a698b677d5f56fa58ada657cf3e

Example Query

Query with partition filter

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

iUSDT_RepayBorrow_event

Borrow repayment events for the iUSDT market on Iron Bank V1 (Avalanche), tracking USDT loan repayments with payer, borrower, amounts repaid, and resulting account balances. Used for analyzing debt management patterns and protocol-wide USDT borrowing activity.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	0x376d16c7de138b01455a51da79ad65806e9cd694	37	0x376d16c7de138b01455a51da79ad65806e9cd694	25196215	587029014	2023-01-20T19:22:12.000Z	199224734031	0xf5953f90b62a22d3a6d7d9050a860b8dc91af60750324839ac07fb95911cd913	199183838631
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	0x376d16c7de138b01455a51da79ad65806e9cd694	27	0x376d16c7de138b01455a51da79ad65806e9cd694	24726817	223540280	2023-01-09T18:01:34.000Z	277113718315	0x7e590282f0db69500667b46af454bcc3e418d824cb701ff29cad756a625c876a	277072965046
0x3af7c11d112c1c730e5cee339ca5b48f9309acbc	false	0x92f225a26a82441876f27d2dbebf45335469d107	12	0x92f225a26a82441876f27d2dbebf45335469d107	31839446	114764800	2023-06-26T19:27:51.000Z	31156775632	0xa9622cc4f0edd959916c84180cb862d2acf56ea27effaa3fb1e2ff961bce1325	90309612

Example Query

Query with partition filter

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

iUSDTE_AccrueInterest_event

Interest accrual events for the Iron Bank USDT.e (Tether USD bridged) lending market on Avalanche, recording periodic updates to borrow index, total borrows, and accumulated interest. Used for calculating borrowing costs, APY tracking, and analyzing lending protocol revenue over time.

Columns

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

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	69	13546914	5631372702219	1084622628081054484	2022-04-17T17:33:09.000Z	5921405401302	0x042c1b0ec5b62834ff6cc155ce32e2ff6814247c396863240c3349af1ca964a4	1979061
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	15	13546373	5587300577637	1084618174154894112	2022-04-17T17:15:01.000Z	5954032409751	0x66ec0691fac46b20e1026930f98ec397bc39831513612be13a56b6574b0402e3	27478127
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	7	13534613	5515041698521	1084520984063109873	2022-04-17T10:39:28.000Z	6038878387748	0x50548c8ed899a6af649dfea3dbf62d84c36007a24356fa25441ad8dba880f69a	109356170

Example Query

Query with partition filter

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

iUSDTE_Borrow_event

Borrow event logs from Iron Bank v1’s USDT.e (Tether bridged to Avalanche) lending market. Tracks individual borrow transactions with amounts, cumulative borrower debt, and protocol-wide total borrows for analyzing lending activity and position changes.

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
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	18	0x376d16c7de138b01455a51da79ad65806e9cd694	10534881	2022-02-05T21:10:08.000Z	51167609	19603666568944	0x0a8d4d4416fe2326cff4c98f8990759c8b26b6a7fa102ffb93eaa7815e0efe0c	19597629343342
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	18	0x376d16c7de138b01455a51da79ad65806e9cd694	10519224	2022-02-05T12:36:20.000Z	10443356	19346562272504	0xe62d1910a44754a91c7e4dfbe7d0360e4548055bcb9473a376d672a56d956e6b	19340525674493
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	21	0x376d16c7de138b01455a51da79ad65806e9cd694	10499767	2022-02-05T02:01:32.000Z	54598625	19220206539153	0x6a0bf181e92a7f3e30ac1fc573139e30a8ccd9254c957ce938c63044ae627138	19202825035091

Example Query

Query with partition filter

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

iUSDTE_Mint_event

Mint events for Iron Bank’s iUSDTE (interest-bearing USDT.e) token on Avalanche, recording when users deposit USDT.e collateral and receive iUSDTE tokens in return. Tracks minter addresses, underlying asset amounts deposited, and corresponding iTokens minted for analyzing lending protocol supply dynamics.

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
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	0x858d6353a52c25c53df1869230282d22b41f5790	5	16945911	996	4704246	2022-07-05T21:44:36.000Z	0x014a64a3f2271408fc0c4cee653887aeb9bb93c52aa0665c0fad05549106456d
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	0xd0db9c1fe8bb556dcea6cc26ddfbe9cd999e2d9e	26	16947876	990000	4675884757	2022-07-05T22:49:35.000Z	0xb6cd2e760f56b0be6ba913f273d240f4888338ebd982de3c88e8ca07ae9651cb
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	0x34e040ae65e8cbfde0b8e2f8bbda396f8f05e46c	24	29029066	599830276	2715528121149	2023-04-21T09:38:42.000Z	0xe3f5d6527ffcb440ee8c305817d6e9f0f1775d057dfb4276d32038a3316ecd66

Example Query

Query with partition filter

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

iUSDTE_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank USDT.e market on Avalanche, tracking protocol fee adjustments where reserve factor determines the portion of interest allocated to protocol reserves versus lenders.

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
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	1	5533836	2021-10-12T07:53:12.000Z	0x909ea5ddec77fb7606312d0e6454f971beed1111bccdb4e499f31841dd5efa1e	150000000000000000	0

Example Query

Query with partition filter

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

iUSDTE_Redeem_event

Redemption events from Iron Bank’s iUSDT.e market on Avalanche, recording when users withdraw USDT.e by burning interest-bearing iUSDT.e tokens. Tracks redeemer addresses, underlying token amounts withdrawn, and iToken amounts burned for analyzing lending protocol withdrawals and liquidity changes.

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
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	19	0x858d6353a52c25c53df1869230282d22b41f5790	12807203	2022-03-31T08:54:27.000Z	1619267758048	7731780577314931	0x742427d73081320eb142ef1faf0c27ff419a9efd823c3b9fd239964775f17fdc
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	13	0x858d6353a52c25c53df1869230282d22b41f5790	12800261	2022-03-31T05:00:09.000Z	2850494054440	13611036907365087	0x26e91b4f4f0667c000f502832fbf1727cb64f5e124740fd359b444f7ed20093b
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	19	0x92f225a26a82441876f27d2dbebf45335469d107	31933833	2023-06-29T00:59:47.000Z	500000000	2243834840611	0xfc8c4b03c0d10faefcd0a14ce834c16a3d47ea7dd5b6562bd9b3670f8178d40f

Example Query

Query with partition filter

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

iUSDTE_RepayBorrow_event

Loan repayment events from Iron Bank V1’s USDT.e (Tether USD bridged) market on Avalanche, tracking each borrow repayment with payer, borrower, repayment amount, and updated account borrow balances. Used for analyzing lending protocol debt management and borrower behavior.

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
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	0x376d16c7de138b01455a51da79ad65806e9cd694	39	0x376d16c7de138b01455a51da79ad65806e9cd694	21072793	419237	2022-10-14T23:33:12.000Z	945760009118	0x288a9fa8068c2630b831c887eef0e927934906bc7eda5722c938516cfe166a02	945714569381
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	0x376d16c7de138b01455a51da79ad65806e9cd694	44	0x376d16c7de138b01455a51da79ad65806e9cd694	21065726	543723	2022-10-14T19:34:05.000Z	945701752851	0xdd22dc301cc0746448f420ade52487447973fd0f7159eb26467a768d3b6ba71f	945656315463
0xceb1ce674f38398432d20bc8f90345e91ef46fd3	false	0x376d16c7de138b01455a51da79ad65806e9cd694	31	0x376d16c7de138b01455a51da79ad65806e9cd694	27458934	84787	2023-03-15T06:22:34.000Z	157890544257	0xbd3a6fee906e550ee41fa2b35052bc616d3a0e475ea0660a458fc7a0085732c5	157869900894

Example Query

Query with partition filter

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

iWAVAX_AccrueInterest_event

Interest accrual events for the Iron Bank WAVAX (Wrapped AVAX) lending market on Avalanche, capturing cash reserves, total borrows, borrow index updates, and accumulated interest at each accrual block. Used for tracking lending pool health and calculating borrower interest obligations over time.

Columns

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

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	1	23408679	68212427304210954783476	1172233042684157357	2022-12-09T10:24:15.000Z	166578701147192935675987	0xdaf46a06712dffba135838c1eea286dbe9e9921faed32bf17c6e398b08cc54ef	2532254764871172279
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	1	23426531	71577754292080996433595	1172372588620046569	2022-12-09T20:26:10.000Z	166654685856927487548191	0xf2a40aac9a0b2e9eb8dc870d615724d5147e7475f289708a3ce0edd96c4491b0	578960889042730517
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	2	23432368	71547848891238843560791	1172418827192377452	2022-12-09T23:42:57.000Z	166566492439241924673437	0x534fbe1601015447a6de22a491d3e3117d833faab6e670f6f599cd8ba3607f97	1129452905895693804

Example Query

Query with partition filter

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

iWAVAX_Borrow_event

Borrow event logs from Iron Bank’s Wrapped AVAX (WAVAX) lending market on Avalanche, capturing borrower addresses, individual borrow amounts, total outstanding borrows, and account-level debt positions. Used for tracking lending activity, debt accumulation patterns, and individual borrower exposure in the protocol.

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_totalBorrows	transaction_hash	in_accountBorrows
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	17	0x376d16c7de138b01455a51da79ad65806e9cd694	29469647	2023-05-01T19:55:11.000Z	14522799843346957483552	0xd6fcbc73272f732f6f181b784f1baa3a18926c481fa5feaecb42c55f6217117d	14175501127622662320908
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	17	0x376d16c7de138b01455a51da79ad65806e9cd694	29469837	2023-05-01T20:01:46.000Z	14516634500792333242244	0xa93ab278e9dce799ad8de4635bb64d143e5a79c8a27110c38dfd908eb2aa48f6	14169335502125525868247
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	24	0x376d16c7de138b01455a51da79ad65806e9cd694	29469338	2023-05-01T19:44:36.000Z	14538768562079484604342	0xbb72dd455c8c329f1258bd7f0428e75c14d45ecd3564803246a959cb8da1929e	14191470301530460725154

Example Query

Query with partition filter

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

iWAVAX_Flashloan_event

Flash loan event records from Iron Bank’s Wrapped AVAX (iWAVAX) market on Avalanche, capturing borrowed amounts, fees charged, and receiver addresses. Useful for analyzing flash loan arbitrage activity and protocol fee 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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	2519593214279794906015	25	0xfb518413f8a8454ad9ccbb55e468d909ad0fd7fa	755877964283938471	27291533	113381694642590770	2023-03-11T08:05:10.000Z	0x46b4996c2d12834408daa389c2eb60cf33205894453e89c671733d0ea360fbde
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	1415430854579737600033	31	0xfb518413f8a8454ad9ccbb55e468d909ad0fd7fa	424629256373921280	26687350	63694388456088192	2023-02-24T20:03:12.000Z	0x45a09a8f60bd84786bab422f3cccf3edb5f20449614384eba287c767db066f3f
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	3722269857993274230002	21	0xfb518413f8a8454ad9ccbb55e468d909ad0fd7fa	1116680957397982269	25413798	167502143609697340	2023-01-25T22:48:13.000Z	0x7725041be4f379211bc7b5f1166f8f321883b3e37b79c13d04d0f334ed875722

Example Query

Query with partition filter

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

iWAVAX_Mint_event

Mint events for Iron Bank’s iWAVAX lending market on Avalanche, recording deposits of WAVAX (Wrapped AVAX) in exchange for interest-bearing iWAVAX tokens. Useful for tracking lending supply activity and calculating deposit-to-share token 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_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
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	0x183a48331b4ee0d2253d7d23a4b1cbc10075b5ae	26	8982413	106835733095814979	519591956	2022-01-01T04:56:53.000Z	0x099e19938a51b5fa9eab6fc4db242c3cbc265b333b70ce95fe4da5cd9376b567
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	0x21c630b7824d15bcdfeefa73cbd4e49cafe9f836	3	9001375	7200000000000000000000	35013292655926	2022-01-01T15:34:05.000Z	0x052288ca770e882f2624fedb6ef41c6405793ce688544ccebc13b8a9329a8a80
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	0x21c630b7824d15bcdfeefa73cbd4e49cafe9f836	3	8989768	100000000000000000000	486326940600	2022-01-01T09:03:53.000Z	0xae7022ffc9e633926a22056800fdf930c034ccaf0dd9515926e0b338d00e509f

Example Query

Query with partition filter

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

iWAVAX_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank wrapped AVAX (iWAVAX) lending market on Avalanche, tracking protocol fee adjustments where reserve factor represents the percentage of interest allocated to reserves. Used for monitoring Iron Bank governance decisions and fee structure evolution.

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
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	1	5365611	2021-10-08T08:29:54.000Z	0x0566fcab0eaaa04e9aba5c04aaafc2f008c391c882b4f5966f08a1a5e0106444	150000000000000000	0

Example Query

Query with partition filter

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

iWAVAX_Redeem_event

Redemption events from Iron Bank’s Wrapped AVAX (iWAVAX) lending market on Avalanche, recording when users withdraw underlying WAVAX by burning interest-bearing tokens. Tracks redeemer addresses, token amounts burned, and underlying assets received for analyzing lending protocol withdrawals.

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
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	4	0x21c630b7824d15bcdfeefa73cbd4e49cafe9f836	23110551	2022-12-02T07:54:24.000Z	146379825056845558194	654803539628	0x19d5780571ece5ea7d38a51b53b40dad5f5d5eda32f2e1cfee6ad66076c35207
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	5	0x21c630b7824d15bcdfeefa73cbd4e49cafe9f836	23122797	2022-12-02T14:52:06.000Z	2000357674613223478376	8947562764604	0xa35f35973060818c4a5d92ab3d81ba6424784a5d678badefa3e6a779820ed76a
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	5	0xfd597233eadaa30a6391f2f0bb72b069c9bc03e5	23134413	2022-12-02T21:22:59.000Z	8786832148423996	39300682	0x31eb38aeedd25b9b7e357c2d7128ddebe82a8346864e2432bb162d6707288950

Example Query

Query with partition filter

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

iWAVAX_RepayBorrow_event

Borrow repayment events from Iron Bank’s WAVAX (Wrapped AVAX) lending market on Avalanche, tracking when users pay down debt positions. Contains payer and borrower addresses, repayment amounts, and updated account/total borrow balances for analyzing debt management and liquidation activity.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	0x376d16c7de138b01455a51da79ad65806e9cd694	71	0x376d16c7de138b01455a51da79ad65806e9cd694	28776506	3053817162418040523	2023-04-15T11:38:08.000Z	16373163554439465855473	0x71b5b02e643ac2f2644be07cb706e84b4254c9b0e516a1f96c017df3375a045d	16367944113586256528538
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	0x376d16c7de138b01455a51da79ad65806e9cd694	5	0x376d16c7de138b01455a51da79ad65806e9cd694	8544765	66084563353708782893	2021-12-21T22:50:31.000Z	783096440782573056422983	0x4726b27d09aa00a56db53d0cd9fa95d7a5dbc8b6ebcaba42c20a1f4a0c21af2d	783082331519008337896984
0xb3c68d69e95b095ab4b33b4cb67dbc0fbf3edf56	false	0x376d16c7de138b01455a51da79ad65806e9cd694	5	0x376d16c7de138b01455a51da79ad65806e9cd694	8544946	16652224641517889046	2021-12-21T22:56:39.000Z	791946275173806573789533	0x296867244b1b6d8b68207dc8e28f1332a873e80ba2f4e63ce1e5da20933ec38d	791932165890484579779392

Example Query

Query with partition filter

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

iWBTCE_AccrueInterest_event

Interest accrual events for the Iron Bank WBTC.e (Wrapped Bitcoin bridged) lending market on Avalanche. Tracks accumulated interest, borrow index changes, and outstanding borrows for analyzing yield generation and borrowing costs over time.

Columns

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

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	15	27295163	427574843	1073259545357164848	2023-03-11T10:01:02.000Z	192264938	0x14d16f55876ee3a82aac0e3526767f05215a3d48be86cf64cb41f90fd8232bd7	15993
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	2	17380801	839245551	1033157955882658608	2022-07-16T00:54:33.000Z	489251905	0x166c5204f4614c84a3604638413a677417e2928d36be3763d32b96ff9228ec74	48938
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	5	20880777	1148231887	1046777180245889190	2022-10-10T10:06:38.000Z	400302735	0xc7ee64c1b53d847db8689f7f7b4a51c67ca6bd09263385d3c90aec9406754565	8460

Example Query

Query with partition filter

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

iWBTCE_Borrow_event

Borrow event logs from Iron Bank’s Wrapped Bitcoin (WBTC.e) lending market on Avalanche, capturing each borrow transaction with amounts in satoshis, individual account borrow balances, and protocol-wide total borrows. Used for analyzing borrowing activity, debt positions, and market utilization trends.

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
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	19	0x376d16c7de138b01455a51da79ad65806e9cd694	27295163	2023-03-11T10:01:02.000Z	5376851	197641789	0x14d16f55876ee3a82aac0e3526767f05215a3d48be86cf64cb41f90fd8232bd7	197391687
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	17	0x376d16c7de138b01455a51da79ad65806e9cd694	27295163	2023-03-11T10:01:02.000Z	0	192264938	0x14d16f55876ee3a82aac0e3526767f05215a3d48be86cf64cb41f90fd8232bd7	192014836
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	21	0xeb6296f2b61c9832d98bbab64f35fa157c96541e	31103045	2023-06-09T09:17:29.000Z	20000000	82398896	0xf34c84e30616fc8583962ad15d318473c79ebe2dbe0948ed46342d2487b8fcc5	55000014

Example Query

Query with partition filter

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

iWBTCE_Flashloan_event

Flash loan events from Iron Bank v1’s Wrapped Bitcoin (WBTC.e) market on Avalanche. Records borrowed amounts, fees charged (total and protocol reserves), and recipient addresses for analyzing flash loan usage patterns and 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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	400939897	31	0xfb518413f8a8454ad9ccbb55e468d909ad0fd7fa	120281	25599297	24056	2023-01-30T07:33:26.000Z	0xf2a48f1cad44fb68c8bd53aa31ed65aba916733aefa5d244177f8ad278395e5f
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	204378984	25	0xfb518413f8a8454ad9ccbb55e468d909ad0fd7fa	61313	25605925	12262	2023-01-30T11:13:38.000Z	0x62955edb46c7b252d288fce99872c10ca6b0d05719a1ff15c4a45402b63aa7bc
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	129642259	27	0xfb518413f8a8454ad9ccbb55e468d909ad0fd7fa	38892	25896281	7778	2023-02-06T06:02:51.000Z	0x89d02d4d2885e01a9ec1f154289ac673a779f7daebd95d74ed8d863fe6a8bbe5

Example Query

Query with partition filter

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

iWBTCE_Mint_event

Mint events from Iron Bank v1’s iWBTC.e (Wrapped Bitcoin bridged) market on Avalanche, recording when users deposit WBTC.e collateral to receive interest-bearing iWBTC.e tokens. Tracks depositor addresses, underlying deposit amounts, and minted iToken quantities for analyzing lending protocol TVL and user deposit behavior.

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
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	0x1de90c0ce3d940412c3ba7322a257f7bdcc00ceb	6	9059226	2000000000	99600313522	2022-01-02T23:56:57.000Z	0xa094ac4e555d0aacbeadb8d462ea79514a82629b15352d7b333dec87009eac68
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	0x1de90c0ce3d940412c3ba7322a257f7bdcc00ceb	10	9052145	23316849	1161188093	2022-01-02T19:58:50.000Z	0x645003e26a1139b5bb997fb548fedf7bbf7ab0b6a27413fce5139788fae39a4b
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	0x88b0ea576428da635d0fa9deb686765c90cfde2e	37	11305557	352096	17511073	2022-02-23T20:06:49.000Z	0x400e974546f9b6357ef86821d6c3fc589feed7a785bbe91af2b4af8a7f44655e

Example Query

Query with partition filter

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

iWBTCE_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank WBTC.e (Wrapped Bitcoin Avalanche) lending market on Avalanche. Tracks adjustments to the protocol’s revenue retention rate, with mantissa values representing percentages in 18-decimal format.

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
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	1	5533845	2021-10-12T07:53:36.000Z	0x9fb76dc6b559f8c4ba9a6a51553557a143675683b3a97c35868e35c441034e79	200000000000000000	0

Example Query

Query with partition filter

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

iWBTCE_Redeem_event

Redemption events from Iron Bank’s wrapped Bitcoin (WBTC.e) lending market on Avalanche, capturing when users withdraw underlying WBTC.e by burning iWBTC.e tokens. Records include redeemer address, underlying token amount withdrawn, and corresponding iToken amount burned for analyzing lending market withdrawals and liquidity flows.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	6	0x1de90c0ce3d940412c3ba7322a257f7bdcc00ceb	20625617	2022-10-04T07:06:39.000Z	6741	332370	0x697a4190c353f764b8a059c2f9d93d2a89453d7725c61ffb670ea1356f37e3a2
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	7	0x1de90c0ce3d940412c3ba7322a257f7bdcc00ceb	17615797	2022-07-21T12:06:38.000Z	6169	305261	0x0712de6b86ad4d849a4bb4906fa4dab5b072c87d323c74bb3b7005792aa5e679
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	12	0x1de90c0ce3d940412c3ba7322a257f7bdcc00ceb	17615797	2022-07-21T12:06:38.000Z	10002454	494932362	0x0712de6b86ad4d849a4bb4906fa4dab5b072c87d323c74bb3b7005792aa5e679

Example Query

Query with partition filter

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

iWBTCE_RepayBorrow_event

Loan repayment events for Wrapped Bitcoin (WBTC.e) on Iron Bank v1 lending protocol on Avalanche. Tracks borrower repayments with amounts repaid, updated total borrows, and account-level debt balances for analyzing lending activity and debt management.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	0x376d16c7de138b01455a51da79ad65806e9cd694	39	0x376d16c7de138b01455a51da79ad65806e9cd694	26933327	140301195	2023-03-02T17:24:49.000Z	211979229	0x2c1115d0ad67548d450ab79e52bd5c669627176a0c7b3d4662c0934fdb815ddf	211729355
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	0x376d16c7de138b01455a51da79ad65806e9cd694	28	0x376d16c7de138b01455a51da79ad65806e9cd694	26931829	652085	2023-03-02T16:33:58.000Z	352277848	0x45896ad15fd76cfcb6ca85a8ccac92b89920123a0b4307941ea4aa0f9ae4aed4	352027975
0xb09b75916c5f4097c8b5812e63e216fef97661fc	false	0x376d16c7de138b01455a51da79ad65806e9cd694	31	0x376d16c7de138b01455a51da79ad65806e9cd694	26935692	15858753	2023-03-02T18:45:15.000Z	196121951	0xfa179ebfaf36a63ff34c29f6909911bbe0e3ebdff2bed675ba038181e503a217	195872075

Example Query

Query with partition filter

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

iWETHE_AccrueInterest_event

Interest accrual events for Iron Bank’s Wrapped Ether (WETH.e) lending market on Avalanche, capturing cash reserves, total borrows, borrow index updates, and accumulated interest per block for tracking lending protocol state changes and yield calculations.

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
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	5	19350613	48386115467303442630	1057244380997953341	2022-08-31T08:27:10.000Z	77224743860877054082	0x458d3a05153de591d7a9d164ace9f21df3af01bdd65a763452cbd80afad34050	8608740955500502
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	2	30838570	61598353800658247788	1126831468380883811	2023-06-03T02:58:53.000Z	36266917024562166717	0xe288c442f07676b81c50c2c7a53fbd1abd86c1e96215ca332ccb6b64dc5294d5	2562656901206
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	13	30866333	61648353800658247788	1126943416813712414	2023-06-03T18:36:41.000Z	36270520069594498390	0xff29676f3e439051f76cd4ac95f59ef64e9f1c011b210d644c4b14f31052021e	3603045032331673

Example Query

Query with partition filter

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

iWETHE_Borrow_event

Borrow events from Iron Bank V1’s Wrapped Ether (WETH) market on Avalanche, tracking loan amounts, borrower addresses, and cumulative borrow balances. Used for analyzing lending activity, debt positions, and protocol utilization 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_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
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	48	0x376d16c7de138b01455a51da79ad65806e9cd694	12272722	2022-03-18T17:34:35.000Z	34814660984339803	2583096194684102139666	0x1355776b25c6207529d1f731c08c6719c192ae290dad402caa5aeabfe7bd576f	2582902314664846366898
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	50	0x376d16c7de138b01455a51da79ad65806e9cd694	12272722	2022-03-18T17:34:35.000Z	59288746735506560721	2642384941419608700387	0x1355776b25c6207529d1f731c08c6719c192ae290dad402caa5aeabfe7bd576f	2642191061400352927619
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	6	0x376d16c7de138b01455a51da79ad65806e9cd694	12255545	2022-03-18T07:42:01.000Z	20834237528710764	2582860585118172492522	0x488099c6e306aa606337ef9a09f0eeba8468d7ebe260dd263167262f3d368342	2582666718476900644386

Example Query

Query with partition filter

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

iWETHE_Flashloan_event

Flash loan events from Iron Bank’s Wrapped Ether (WETH) market on Avalanche, capturing borrowed amounts, recipient addresses, and fee breakdowns. Used for tracking flash loan activity, analyzing fee generation, and monitoring sophisticated DeFi trading strategies.

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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	16126111807687211707	28	0x3c58950acdf5778ba30c0b3eac52a4b475668a93	4837833542306163	13611780	967566708461232	2022-04-19T06:00:22.000Z	0xc0865977b84d386f9d988dc7dbc65f2711b373506eb292759960e7d127c6dcec
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	84267297235917220	41	0x746c5f3f59ec519497f86daffe1d04c509922c7a	25280189170775	32257983	5056037834155	2023-07-06T16:01:46.000Z	0x57c19e2c54a7ff798c5584f6f7814c8e687e1089b4593190cfc27cbc817ef050
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	1329549386647060939	68	0x3c58950acdf5778ba30c0b3eac52a4b475668a93	398864815994118	12389534	79772963198823	2022-03-21T12:23:15.000Z	0x53a6443acfac5a9d8305cb30d028164a4ddf4a1e63065f70d1420cdaad831859

Example Query

Query with partition filter

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

iWETHE_Mint_event

Mint events from Iron Bank v1’s wrapped ETH (WETH) market on Avalanche, recording when users deposit WETH collateral to receive ibWETH tokens. Tracks depositor addresses, underlying WETH amounts, and minted ibToken quantities for analyzing 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
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	0x53541cc8caeeee0b5aff9d5194be6db9de23f3e1	59	12239668	84632185333345355	418014054	2022-03-17T22:24:16.000Z	0x1e35c6464574ba7f6d2912504abc8d5c0d0f6450027c44a63ee06986414f59ab
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	0x53541cc8caeeee0b5aff9d5194be6db9de23f3e1	14	12239346	1100000000000000000	5433106006	2022-03-17T22:13:09.000Z	0xd91c4441188932541ec1d52474cf169d90af2cf922c8edccb345e865275f532c
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	0xf9eb24b83b51fbc0bcb1204221c8c9f1cef33994	55	20093151	991627539036714786	4838404445	2022-09-21T07:10:52.000Z	0x30b037605c5194061e623ea90ba6ad8297f2a3efceb58900aa7432a93c2a1892

Example Query

Query with partition filter

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

iWETHE_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank WETH market on Avalanche. Tracks updates to the protocol’s reserve requirements with old and new mantissa values for analyzing risk parameter adjustments.

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
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	1	5533832	2021-10-12T07:53:06.000Z	0xdbcb185c1c75034abefa748de8255379ea82802c6bd6dfce6e156a6a57a0cfa3	200000000000000000	0

Example Query

Query with partition filter

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

iWETHE_Redeem_event

Withdrawal events from Iron Bank’s Wrapped ETH (WETH) market on Avalanche, recording when users redeem iWETH tokens for underlying WETH collateral. Useful for analyzing lending market liquidity flows and user withdrawal patterns.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	23	0xe699e8334d901986d9ff6bc5ae4b44ae5122f1ee	25923645	2023-02-06T21:20:22.000Z	1483114405725369153	7144291657	0x63f7e53809beabb43b349035aedcd642bdc1dd6ec2e10b46e5753e793ecdd7f4
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	12	0xf9eb24b83b51fbc0bcb1204221c8c9f1cef33994	10551773	2022-02-06T06:25:01.000Z	3479245548239635367	17218917068	0x60084b1cfa11b5aaf81d11c9887f3768418f38f2d59e69416bb34639a0a1a147
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	70	0xf9eb24b83b51fbc0bcb1204221c8c9f1cef33994	14121818	2022-05-01T05:03:29.000Z	3986704017705699	19646556	0x166cf06fdc49a17dfccfd24ccb14d63ceb3ec291f98fb11fa664e0953b0fa89a

Example Query

Query with partition filter

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

iWETHE_RepayBorrow_event

Borrow repayment events for Wrapped ETH (WETH.E) in Iron Bank V1 on Avalanche, tracking repayment amounts, updated account balances, and protocol-wide debt positions. Useful for analyzing loan paydown activity and individual borrower debt management.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	0x376d16c7de138b01455a51da79ad65806e9cd694	49	0x376d16c7de138b01455a51da79ad65806e9cd694	29206950	300929212026645141	2023-04-25T14:17:12.000Z	36256932953164841357	0x54f5db3e331a13b32b4be898a3b8c01c2876109284b3a71869360a1099354b8d	35842424217341246508
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	0x376d16c7de138b01455a51da79ad65806e9cd694	48	0x376d16c7de138b01455a51da79ad65806e9cd694	29206912	1971885694437594582	2023-04-25T14:15:57.000Z	36557853987679551336	0x8502938cb666ff6dbec44851791c02fb104fddf1f699d1107e2bfe7b589b8293	36143345344576097497
0x338eee1f7b89ce6272f302bdc4b952c13b221f1d	false	0x376d16c7de138b01455a51da79ad65806e9cd694	52	0x376d16c7de138b01455a51da79ad65806e9cd694	9658104	4622088708908506445	2022-01-16T18:50:39.000Z	2000385605570182082940	0x11d1ca67cce008fdd3531f934a232aa1d9971cd8c31c5883e20a5790b6e9d389	2000269690596543556645

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​iALPHAE_AccrueInterest_event

​iALPHAE_Borrow_event

​iALPHAE_Flashloan_event

​iALPHAE_Mint_event

​iALPHAE_NewReserveFactor_event

​iALPHAE_Redeem_event

​iALPHAE_RepayBorrow_event

​iDAIE_AccrueInterest_event

​iDAIE_Borrow_event

​iDAIE_Flashloan_event

​iDAIE_Mint_event

​iDAIE_NewReserveFactor_event

​iDAIE_Redeem_event

​iDAIE_RepayBorrow_event

​iLINKE_AccrueInterest_event

​iLINKE_Borrow_event

​iLINKE_Flashloan_event

​iLINKE_Mint_event

​iLINKE_NewReserveFactor_event

​iLINKE_Redeem_event

​iLINKE_RepayBorrow_event

​iMIM_AccrueInterest_event

​iMIM_Borrow_event

​iMIM_Flashloan_event

​iMIM_Mint_event

​iMIM_NewReserveFactor_event

​iMIM_Redeem_event

​iMIM_RepayBorrow_event

​iUSDC_AccrueInterest_event

​iUSDC_Borrow_event

​iUSDC_Flashloan_event

​iUSDC_Mint_event

​iUSDC_NewReserveFactor_event

​iUSDC_Redeem_event

​iUSDC_RepayBorrow_event

​iUSDCE_AccrueInterest_event

​iUSDCE_Borrow_event

​iUSDCE_Flashloan_event

​iUSDCE_Mint_event

​iUSDCE_NewReserveFactor_event

​iUSDCE_Redeem_event

​iUSDCE_RepayBorrow_event

​iUSDT_AccrueInterest_event

​iUSDT_Borrow_event

​iUSDT_Flashloan_event

​iUSDT_Mint_event

​iUSDT_NewReserveFactor_event

​iUSDT_Redeem_event

​iUSDT_RepayBorrow_event

​iUSDTE_AccrueInterest_event

​iUSDTE_Borrow_event

​iUSDTE_Mint_event

​iUSDTE_NewReserveFactor_event

​iUSDTE_Redeem_event

​iUSDTE_RepayBorrow_event

​iWAVAX_AccrueInterest_event

​iWAVAX_Borrow_event

​iWAVAX_Flashloan_event

​iWAVAX_Mint_event

​iWAVAX_NewReserveFactor_event

​iWAVAX_Redeem_event

​iWAVAX_RepayBorrow_event

​iWBTCE_AccrueInterest_event

​iWBTCE_Borrow_event

​iWBTCE_Flashloan_event

​iWBTCE_Mint_event

​iWBTCE_NewReserveFactor_event

​iWBTCE_Redeem_event

​iWBTCE_RepayBorrow_event

​iWETHE_AccrueInterest_event

​iWETHE_Borrow_event

​iWETHE_Flashloan_event

​iWETHE_Mint_event

​iWETHE_NewReserveFactor_event

​iWETHE_Redeem_event

Tables

iALPHAE_AccrueInterest_event

iALPHAE_Borrow_event

iALPHAE_Flashloan_event

iALPHAE_Mint_event

iALPHAE_NewReserveFactor_event

iALPHAE_Redeem_event

iALPHAE_RepayBorrow_event

iDAIE_AccrueInterest_event

iDAIE_Borrow_event

iDAIE_Flashloan_event

iDAIE_Mint_event

iDAIE_NewReserveFactor_event

iDAIE_Redeem_event

iDAIE_RepayBorrow_event

iLINKE_AccrueInterest_event

iLINKE_Borrow_event

iLINKE_Flashloan_event

iLINKE_Mint_event

iLINKE_NewReserveFactor_event

iLINKE_Redeem_event

iLINKE_RepayBorrow_event

iMIM_AccrueInterest_event

iMIM_Borrow_event

iMIM_Flashloan_event

iMIM_Mint_event

iMIM_NewReserveFactor_event

iMIM_Redeem_event

iMIM_RepayBorrow_event

iUSDC_AccrueInterest_event

iUSDC_Borrow_event

iUSDC_Flashloan_event

iUSDC_Mint_event

iUSDC_NewReserveFactor_event

iUSDC_Redeem_event

iUSDC_RepayBorrow_event

iUSDCE_AccrueInterest_event

iUSDCE_Borrow_event

iUSDCE_Flashloan_event

iUSDCE_Mint_event

iUSDCE_NewReserveFactor_event

iUSDCE_Redeem_event

iUSDCE_RepayBorrow_event

iUSDT_AccrueInterest_event

iUSDT_Borrow_event

iUSDT_Flashloan_event

iUSDT_Mint_event

iUSDT_NewReserveFactor_event

iUSDT_Redeem_event

iUSDT_RepayBorrow_event

iUSDTE_AccrueInterest_event

iUSDTE_Borrow_event

iUSDTE_Mint_event

iUSDTE_NewReserveFactor_event

iUSDTE_Redeem_event

iUSDTE_RepayBorrow_event

iWAVAX_AccrueInterest_event

iWAVAX_Borrow_event

iWAVAX_Flashloan_event

iWAVAX_Mint_event

iWAVAX_NewReserveFactor_event

iWAVAX_Redeem_event

iWAVAX_RepayBorrow_event

iWBTCE_AccrueInterest_event

iWBTCE_Borrow_event

iWBTCE_Flashloan_event

iWBTCE_Mint_event

iWBTCE_NewReserveFactor_event

iWBTCE_Redeem_event

iWBTCE_RepayBorrow_event

iWETHE_AccrueInterest_event

iWETHE_Borrow_event

iWETHE_Flashloan_event

iWETHE_Mint_event

iWETHE_NewReserveFactor_event

iWETHE_Redeem_event

iWETHE_RepayBorrow_event