ironbank_v1_optimism - Token Terminal Docs

Tables

iDAI_AccrueInterest_event

Interest accrual events for the Iron Bank DAI (iDAI) lending market on Optimism, capturing periodic updates to cash reserves, total borrows, borrow index, and accumulated interest. Used for tracking lending market dynamics 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
0x049e04bee77cffb055f733a138a2f204d3750283	false	2	52048046	290936596308149800690446	1022736546666560600	2022-12-19T23:35:53.000Z	291898530806779828780242	0x85da595cf660114498e2eb60a498622c98263579106ec25ac60b1914c4a5a2c9	45443053448950030
0x049e04bee77cffb055f733a138a2f204d3750283	false	2	51675983	279172705905962824330476	1022578901707834128	2022-12-19T02:57:46.000Z	291171906880826663273744	0x843abdf15f096818d7298445e4dc1aff0bb71c5c9d9c5df7675ad30131cf99da	101667408653746352
0x049e04bee77cffb055f733a138a2f204d3750283	false	2	52047202	290936496707599990312917	1022735618433120648	2022-12-19T23:28:36.000Z	291898265880315382635630	0x312fd90103d926ad2dff83c2f34d4df878d2bde7ddaed496ee9eed36280034f8	18177201614692344

Example Query

Query with partition filter

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

iDAI_Borrow_event

DAI borrow event logs from Iron Bank (Cream Finance fork) lending protocol on Optimism. Tracks individual borrow transactions with amounts, account-level borrow balances, and protocol-wide total borrows for analyzing lending activity and user leverage.

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
0x049e04bee77cffb055f733a138a2f204d3750283	false	2	0x46919f4016befb3c9a01e72a1cfc395695276a01	19322100	2022-08-16T08:47:00.000Z	219474874387269716237054	630096706137210590469337	0x051e2216b0700743526dbb91ccf62075e331e58dca3dc76d63f8594414b32752	619084565664097630808246
0x049e04bee77cffb055f733a138a2f204d3750283	false	2	0x46919f4016befb3c9a01e72a1cfc395695276a01	19321814	2022-08-16T08:46:00.000Z	399609631569279259554432	410621770397016925228800	0x1f9b77884eabcd19f281bac73e8019b440aaa321c1cd7866f1bad7cb3029a401	399609631569279259554432
0x049e04bee77cffb055f733a138a2f204d3750283	false	2	0x806388e04b7583a0148451a8ecd29a748b8fd584	19314826	2022-08-16T08:03:55.000Z	7971914739981732620696	8012110122166755313581	0x81e20aa4b8a492f3efad422f60902eb767ef8f6d28d9467a0deeb606ea911bff	7971914739981732620696

Example Query

Query with partition filter

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

iDAI_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_optimism.iDAI_Flashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

iDAI_Mint_event

Mint events from Iron Bank v1 DAI lending market (iDAI) on Optimism, recording when users deposit DAI collateral and receive interest-bearing iDAI tokens in return. Useful for analyzing lending supply growth, depositor behavior, and collateral inflows.

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
0x049e04bee77cffb055f733a138a2f204d3750283	false	0x970d6b8c1479ec2bfe5a82dc69cafe4003099bc0	4	47957787	4408165566448670541181	43700104076940	2022-12-11T11:19:30.000Z	0x724b69b883265769db7af22a0925ef01d30d319e47e09c10f24bac3f96e0b33b
0x049e04bee77cffb055f733a138a2f204d3750283	false	0xbcb8b7ce255ad6268924407342b78c065df5986d	3	74979213	272997828355597600793	2695245443748	2023-02-17T14:37:45.000Z	0x2a1f5f2345e540bd69fd9ca502b595e2b0544a0fc6f9c8c55e30d5151b472115
0x049e04bee77cffb055f733a138a2f204d3750283	false	0xbcb8b7ce255ad6268924407342b78c065df5986d	3	74899219	156878972284961009481	1548921600800	2023-02-17T05:07:09.000Z	0x6f72d29a4529104b908c98762a723f835dea47b386976720bbd2377a6ab9f27a

Example Query

Query with partition filter

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

iDAI_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank DAI market on Optimism. Tracks protocol fee adjustments with old and new reserve factor values (mantissa format) for governance and revenue 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
0x049e04bee77cffb055f733a138a2f204d3750283	false	1	12667916	2022-06-22T08:29:22.000Z	0xd36dcfc47af640b67a9919c635f28b527f05f7a03d1701db38448875189b273a	100000000000000000	0

Example Query

Query with partition filter

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

iDAI_Redeem_event

Redemption events from Iron Bank v1’s interest-bearing DAI (iDAI) market on Optimism, recording when users withdraw underlying DAI by burning iTokens. Contains redeemer addresses, underlying asset amounts redeemed, and corresponding iToken quantities burned for analyzing withdrawals and protocol liquidity flows.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x049e04bee77cffb055f733a138a2f204d3750283	false	3	0x03fe88512c3e2ce7250823d2004b2ebb04cab154	66635913	2023-01-14T15:32:58.000Z	35784168738	354	0x41be76baa8787b9f462cf7ad214a695bde8f0d1a6c9fefe44d1d8f08bdb2f7a8
0x049e04bee77cffb055f733a138a2f204d3750283	false	5	0xdeb6aa85bcd0e0869fde8cc72ab355c6bcd79e58	110301421	2023-10-01T23:06:59.000Z	53214773861229016052	518381019860	0x79116053e3fcbb71530ccd5e3eb2778ab0b2302d47260952609bbd7c207cccdc
0x049e04bee77cffb055f733a138a2f204d3750283	false	6	0xe58585b22cc2ac4270a2b92c2d2d8c5db5a3330e	110298221	2023-10-01T21:20:19.000Z	500000334532797919447	4870725762458	0x47402d7608075385a44094b13b5c8d97234acde01f61cfa404be0e2a91111b62

Example Query

Query with partition filter

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

iDAI_RepayBorrow_event

Loan repayment events for DAI (Dai Stablecoin) from Iron Bank v1 lending protocol on Optimism. Tracks repayment amounts, borrower addresses, and updated borrow balances for analyzing debt repayment patterns and protocol solvency.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x049e04bee77cffb055f733a138a2f204d3750283	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	29	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	20959242	3651718801736067600609	2022-08-29T02:06:56.000Z	2054401279878342252396955	0x122b6776fe2f3730a4b633b05f85b23cde8d29b4240f4cc6d3310bb91d5e39d5	2034777069906725565468179
0x049e04bee77cffb055f733a138a2f204d3750283	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	25	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	21035727	50025215139209626401	2022-08-29T15:52:27.000Z	2054647311559076948402675	0xe8393788ca3e10739a89d2a951a0179cdb94b9576fd6d3879f7e87a51c285a92	2035020741148315992127689
0x049e04bee77cffb055f733a138a2f204d3750283	false	0x6989d6013b08b3cf3d4d2e00bb92fa2c15ead16d	2	0x6989d6013b08b3cf3d4d2e00bb92fa2c15ead16d	74634466	1230742147187	2023-02-16T04:25:21.000Z	86719379613762787379592	0x3d3098ddc4a2712506298a260dcacc90820464623777f5adae6b616ac689d478	0

Example Query

Query with partition filter

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

iOP_AccrueInterest_event

Interest accrual events from Iron Bank (Cream Finance fork) OP token markets on Optimism, recording cash reserves, borrow index updates, total borrows, and accumulated interest per block. Used for calculating lending rates, protocol revenue, and tracking market utilization 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	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	22815864	34574930525514020390236	1004840228521565518	2022-09-12T07:02:03.000Z	156532510449306562966398	0x9982e59176815af5f501867343bb47ee132e7ce6894eafdb8bb8dfa71ef0d03b	1427720719926619116
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	22886831	31905745218304620887082	1005028861788050281	2022-09-12T20:44:14.000Z	162278954129181742671285	0x5bde014ce2b3e3b04437b96af4d77124e8f23f1558809cf0dd28e123b1295d42	503260796884238364
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	22872635	29932413814134333547987	1004975854789934174	2022-09-12T16:53:13.000Z	160809409525664970911632	0xf9a827add78f06f50fddbb581511c2bccfca80b97e5a7a7ed899f239fef6e43b	144410146715268857

Example Query

Query with partition filter

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

iOP_Borrow_event

Borrow event logs from Iron Bank V1 lending protocol on Optimism, tracking individual borrow transactions with borrowed amounts, account balances, and protocol-wide total borrows. Used for analyzing borrowing activity, leverage patterns, and protocol utilization 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
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	2	0x35ebe8ff4e3af0c741f4f839f73ce4aa01c47a79	102915910	2023-05-30T12:44:59.000Z	800000000000000000000	44043235231845550199580	0xf62dc832b5d4f16296452cfe64ffbc8c6005223ece2ddfafca5623d7f7386011	2500069322034798217411
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	2	0x35ebe8ff4e3af0c741f4f839f73ce4aa01c47a79	102992918	2023-05-30T17:40:15.000Z	900000000000000000000	47645677453306290426473	0x58bdd38ad0799deda806268bb8b905876af744b78ada9295bddc1bc438076a5a	6100291013462268788924
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	2	0x35ebe8ff4e3af0c741f4f839f73ce4aa01c47a79	102974135	2023-05-30T16:09:07.000Z	900000000000000000000	46744888127159400437297	0x91ddaf0fd5c5573e515e6219afba8de71fc5f510d4bc8906327fe697f358ffc5	5200203203724727540582

Example Query

Query with partition filter

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

iOP_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_optimism.iOP_Flashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

iOP_Mint_event

Mint event records from Iron Bank (Cream Finance) OP token market on Optimism, capturing supply deposits into the lending protocol. Tracks underlying token amounts deposited and corresponding iToken (interest-bearing token) shares minted to suppliers.

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
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	0x3405163d6aaa6a80e210a568c06210d5b1925d2d	3	29933358	13598116423520529500	134017534076	2022-10-17T19:45:50.000Z	0xc9da4cef132b3282800706b780894cc6596a8925f6671eb0ad4d75f4ef829a9e
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	0x4e80baf6d4e635f5d3d4152f371b1cac39ddfda2	3	29910452	10199036448277479964	100521734096	2022-10-17T15:31:53.000Z	0xfb15462e543b13bd85e9792973d74130f4497ace0fae117b18fea07cd6d31d04
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	0x3405163d6aaa6a80e210a568c06210d5b1925d2d	4	29913788	2390826604697168262832	23563878731366	2022-10-17T16:01:51.000Z	0x83b5ad2ed7aa1b92ed2dd78b08e8f7e1e64fa483e40d4a810d023314d662de2e

Example Query

Query with partition filter

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

iOP_NewReserveFactor_event

Reserve factor parameter change events for Iron Bank’s Optimism OP token market, tracking the protocol’s fee retention percentage adjustments. Used for monitoring governance decisions that affect protocol revenue allocation between suppliers and 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
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	5	15948823	2022-07-27T06:06:53.000Z	0x93d9c09513b39f627b8a7ec9729fc156143b9a3ee40d4e8411e13765291b2089	200000000000000000	0

Example Query

Query with partition filter

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

iOP_Redeem_event

Redemption events from Iron Bank lending protocol on Optimism, recording when users withdraw underlying assets by burning iOP tokens (Iron Bank’s interest-bearing OP token). Contains redeemer addresses, token amounts burned, and underlying asset amounts received for tracking 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
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	4	0xc19fe3d6d0a6431fc9306efbf9980acdc5b64b91	94965340	2023-04-28T09:25:53.000Z	8071997683143157532	77568397513	0x83b9cb1bb2ad580aa05e608e33078db9ba8930ae15baf88a0d1e15fdc3978bd6
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	3	0xf658305d26c8df03e9ed3ff7c7287f7233de472d	79113325	2023-03-07T18:51:26.000Z	12000000117992489579	115623929602	0xde7bc3ff9a8df62082a80d13808da3e5215654453b2d27f9fb90ea850fc92884
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	4	0xad036a7e58dfa18a6511e85d29b0341e16bcbd9b	78974568	2023-03-07T03:49:46.000Z	250105300000000000000	2409862836508	0x2d1c0c694298391304fc91b424475954a310bd5749bb46bf38e3530f69b115e2

Example Query

Query with partition filter

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

iOP_RepayBorrow_event

Loan repayment events from Iron Bank v1 lending protocol on Optimism. Tracks borrower repayments with amounts repaid, updated borrow balances, and payer addresses for analyzing debt reduction activity and protocol solvency.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	0x6255cb7a706314835a22889500c8d55130912926	2	0x6255cb7a706314835a22889500c8d55130912926	74453435	5000000000000000000000	2023-02-15T10:23:47.000Z	219836055166711784217332	0xf6f2e7860b7259e6fb71567dd7f0c401db1b1a17b8ded74ed68df3db624f2ced	50150615194327218624375
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	0x6255cb7a706314835a22889500c8d55130912926	2	0x6255cb7a706314835a22889500c8d55130912926	74453223	5000000000000000000000	2023-02-15T10:22:30.000Z	224836002783597357256897	0xa66ba870bf2bdcaff746981f75a3c05937ff1d5b43d18f317502ce22d2a015f9	55150602345138131540216
0x4645e0952678e9566fb529d9313f5730e4e1c412	false	0x6255cb7a706314835a22889500c8d55130912926	2	0x6255cb7a706314835a22889500c8d55130912926	74444296	207000000000000000000	2023-02-15T09:16:38.000Z	229805942787301629795315	0x86069813a2927a45f4b56edcbf8a33dc6b5aa8182192478c04b0fa3d49923fe7	60149867283001248894644

Example Query

Query with partition filter

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

iSNX_AccrueInterest_event

Interest accrual events for the iSNX (Iron Bank SNX) lending market on Iron Bank v1 (Optimism), recording cash reserves, total borrows, accumulated interest, and borrow index updates. Used for tracking lending pool interest rate dynamics and calculating borrower 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
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0	36525514	104408056254026217136	1029808129956898070	2022-11-09T23:18:19.000Z	424432904526920	0x2895fdefb39d55838c90101e98d63dd551dca7fd67aca155bc17dde014b9237a	164
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	2	36525410	123445769053553024308	1029808129956497758	2022-11-09T23:18:04.000Z	424432904526756	0x32fee9e74a0ba075131d12da70370a8972b867cbdd621f30ec259c864fa2aef6	921091
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0	23549551	200003269268707815920	1007966604810164568	2022-09-17T20:28:40.000Z	7104633678294670230	0xa34a8c84947c0f8af9757fd0ef2d825a25bd48365704e9c65a82a75c0111c052	199396887692

Example Query

Query with partition filter

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

iSNX_Borrow_event

Borrow event logs from Iron Bank’s SNX (Synthetix) lending market on Optimism, tracking individual borrow transactions with amounts in wei, borrower addresses, and running account/total borrow balances. Used for analyzing SNX borrowing activity, debt positions, and market 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
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	2	0x3d3d8cada4ae176801222fb6693520a5329fa9d1	32780235	2022-10-30T09:45:47.000Z	4000000000000000000	220951232822005672097	0xdd02f2a7de9ff258871ef98b5151273f9998aea4b80871046d8dbba2ee860c48	110103696094647230426
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	9	0xdd0206010ca82ff22303b58863b3a6f3006c86c4	111927445	2023-11-08T14:27:47.000Z	1000000000000000000	1000438414191812010	0xc6f40e737f158319350444923df572e2ebdc013e54f0181769e8899c5c9d3cf2	1000000000000000000
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	8	0x27b3c394c1d71cb215c83488819a37585f5fe518	111943542	2023-11-08T23:24:21.000Z	1000000000000000	1440477886195430	0x3aa5b1e2e744efcca5bcd4b4bbd2119f5dc947b89dad2573a2653e7e117e3895	1000000000000000

Example Query

Query with partition filter

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

iSNX_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_optimism.iSNX_Flashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

iSNX_Mint_event

Mint events for Iron Bank’s iSNX (interest-bearing SNX) token on Optimism, recording when users deposit SNX to receive iTokens. Tracks depositor addresses, underlying SNX amounts, and iToken quantities minted for analyzing Iron Bank lending market participation.

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
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0x88b0ea576428da635d0fa9deb686765c90cfde2e	2	23459820	553296915218423389	5519930109	2022-09-16T18:51:08.000Z	0x270e2f88b19e113044af2971c30b635a5ff689d6f73e8942508c20f9ac535b64
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0x88b0ea576428da635d0fa9deb686765c90cfde2e	2	23460950	782140724110121489	7802866292	2022-09-16T19:08:47.000Z	0x228aa7d90e52e1197557d140e27a8d61064e471f481a6c97e00ae8092bb8c75f
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0x88b0ea576428da635d0fa9deb686765c90cfde2e	2	23459915	390660580625986397	3897389045	2022-09-16T18:53:34.000Z	0xdab1f8621c0484be3467a57d247608578d0b0a936c1a4b1fc9fa909d857064f3

Example Query

Query with partition filter

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

iSNX_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank SNX (Synthetix) lending market on Optimism. Tracks administrative updates to the protocol’s reserve allocation percentage used for risk management 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_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
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	10	15948823	2022-07-27T06:06:53.000Z	0x93d9c09513b39f627b8a7ec9729fc156143b9a3ee40d4e8411e13765291b2089	200000000000000000	0

Example Query

Query with partition filter

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

iSNX_Redeem_event

Redemption events from Iron Bank’s SNX (Synthetix) lending market on Optimism, tracking withdrawals of underlying SNX tokens in exchange for iSNX interest-bearing tokens. Used for analyzing lending market outflows and 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_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
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	3	0xac408589010deee4cd3b62a4ebcf2e75d244e494	70377062	2023-01-25T16:22:17.000Z	3999811564013358781838	39283956184272	0xdbae3c7d65ea89bb33687f25b43094b5753319df1af854cf1a6366c700155624
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	5	0x970d6b8c1479ec2bfe5a82dc69cafe4003099bc0	70460312	2023-01-25T23:49:59.000Z	1000000000041022336855	9815174543460	0x39bc85fce7ce815748b60b265200734b53da13488b823d3fff61dbc2a78fa6d1
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	5	0x970d6b8c1479ec2bfe5a82dc69cafe4003099bc0	70459894	2023-01-25T23:46:25.000Z	2400000000018675949058	23556488669012	0xe908a36317c845a03ad177d028a3d05dd14ea4f21c14826be9f8bc778ef8876e

Example Query

Query with partition filter

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

iSNX_RepayBorrow_event

Borrow repayment events for the Synthetix (SNX) market on Iron Bank V1 lending protocol on Optimism. Tracks repayment amounts, remaining account and total borrows, with payer and borrower addresses 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
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0xa0f9fd2ed3d98ad3772734f766e0929bf746589d	2	0xa0f9fd2ed3d98ad3772734f766e0929bf746589d	26671905	7872266877413272941	2022-10-01T08:24:04.000Z	17144145235090233417	0x0069f8bd913d9522b0361ebe2ce044feaafb7a8639866c79c76c51eebb6e531a
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0xb44262a4b5c791ca2a425612694c5f2ae1efad26	2	0xb44262a4b5c791ca2a425612694c5f2ae1efad26	70879141	100036737213813076546	2023-01-28T03:01:14.000Z	7024609998689442580	0xe1e647f211cbcd117728c29125eed6ac48e04e0182f4370b01e5b34f2a6fbcd0
0xe724ffa5d30782499086682c8362cb3673bf69ae	false	0xb44262a4b5c791ca2a425612694c5f2ae1efad26	2	0xb44262a4b5c791ca2a425612694c5f2ae1efad26	70944475	100000012047747811199	2023-01-28T12:44:12.000Z	7024671506625223683	0x5da37a0fda7d8b53a70e64d5d4cb13684cd5d3e94053641f2d8733d7f732afa5

Example Query

Query with partition filter

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

iSUSD_AccrueInterest_event

Interest accrual events for Iron Bank’s iSUSD (synthetic USD) lending market on Optimism, tracking changes in borrow index, total borrows, accumulated interest, and available cash reserves for analyzing lending market dynamics and interest rate 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_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
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	19	111665712	372260144074373654774	1052066104700662914	2023-11-02T13:03:21.000Z	173060666988929574183	0x8466913d1f2a3e1495cdc8d8ea490f71036908fce5830ce50dc893d11a1f2657	22620705825488915
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	0	101047188	486364093297288265251	1022012664833998561	2023-05-24T12:13:40.000Z	6247720132523403198	0x435c1ce2182728e4e587bb1c3c6fc018494ecf9e6963a703bcef09b773ef540d	184978467736747
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	13	15948823	0	1000000000000000000	2022-07-27T06:06:53.000Z	0	0x93d9c09513b39f627b8a7ec9729fc156143b9a3ee40d4e8411e13765291b2089	0

Example Query

Query with partition filter

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

iSUSD_Borrow_event

Borrow events from Iron Bank’s iSUSD (synthetic USD) market on Optimism, tracking loan originations with borrowed amounts, account-level debt positions, and protocol-wide total borrows. Used for analyzing borrowing behavior, debt accumulation patterns, and market 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
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	2	0xdeb9553eed4a1e9896000071e50a19ec83301574	46122863	2022-12-06T18:01:08.000Z	40123339382668298926	213878812923244505089	0x84cf049d329f100e02b5a77b80bcb50d0ba01bdb3a8d2d2ac04bc8c973427489	181834769325415257827
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	2	0xdeb9553eed4a1e9896000071e50a19ec83301574	46061738	2022-12-06T13:42:25.000Z	22936312484257786495	54980340541588068588	0x3fc57a7d992f9f55c69358e0a19ad40d4b7c812b7b3c9b59064b13d8c4588953	22936312484257786495
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	2	0xdeb9553eed4a1e9896000071e50a19ec83301574	46118972	2022-12-06T17:40:36.000Z	34446561006270080178	89426923906599980445	0xbc872a6b73e56989e7c67753484a490f1019d84c6d68d04617391518a727d00f	57382882817990817140

Example Query

Query with partition filter

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

iSUSD_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_optimism.iSUSD_Flashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

iSUSD_Mint_event

Mint events from the Iron Bank v1 sUSD (Synth USD) lending market on Optimism, recording deposits where users supply sUSD to receive interest-bearing iSUSD tokens. Contains minter addresses, deposited amounts, and minted token quantities for analyzing lending activity and liquidity provision.

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
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	0x208f8519ef628863b3de6a33f1f22e3d921d1d57	2	47263821	120029495190528892634	1195968817192	2022-12-09T21:23:42.000Z	0xd7c5a21059f616823c69c0a8f0443599787e5349f4c61f4d605b22969bd1837f
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	0x970d6b8c1479ec2bfe5a82dc69cafe4003099bc0	4	46987620	99039388816353838124	986942317848	2022-12-09T04:17:40.000Z	0x1fba340c3a5848a4e281cc87f2804fc290ba148155b14e4a6a3a6dd8f2638578
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	0xdeb9553eed4a1e9896000071e50a19ec83301574	3	67313601	1000000000000000000	9951794470	2023-01-15T15:23:36.000Z	0x71d5953dc142f719abf57153d107c4a75dd89908616963d18c0d0d6cba3f94a2

Example Query

Query with partition filter

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

iSUSD_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank sUSD lending market on Optimism. Tracks administrative updates to the protocol’s reserve allocation percentage, useful for monitoring governance decisions and fee structure 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_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
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	14	15948823	2022-07-27T06:06:53.000Z	0x93d9c09513b39f627b8a7ec9729fc156143b9a3ee40d4e8411e13765291b2089	100000000000000000	0

Example Query

Query with partition filter

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

iSUSD_Redeem_event

Withdrawal events from Iron Bank’s iSUSD (interest-bearing sUSD) market on Optimism, recording when users redeem their iTokens for underlying sUSD stablecoin assets. Used for analyzing lending market liquidity and user withdrawal patterns.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	122	0x208f8519ef628863b3de6a33f1f22e3d921d1d57	108365157	2023-08-18T03:24:51.000Z	30000000000000000000	295244905138	0xaca7f42362e7b1bac370b7b59730923026f083cbd3b84d2571eb749e43ec0974
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	4	0xcc98cfdc5f5480d8dd0a0d0a7f80506eb30d5159	46915141	2022-12-08T22:13:03.000Z	4782407751010454388607	47667747793616	0x56a06d91e2fcda8c7156c2809c2f7682d02a52ca80966f9695b1b32f2a6c0f4d
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	4	0xf233ccb7960aaf379d19189ab403b1b4ab8bfcc1	80332400	2023-03-12T17:48:52.000Z	50022365597244634797	496760547462	0x415ba84e782ea22d27279a4bf640a14cfb610a543a6e7deeeedc4bbe143cc9e7

Example Query

Query with partition filter

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

iSUSD_RepayBorrow_event

Borrow repayment events from Iron Bank’s sUSD (Synth USD) lending market on Optimism. Tracks payer and borrower addresses, repayment amounts, and updated borrow balances for analyzing debt reduction activity and lending protocol health.

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
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	0xe1a27375e1b47dac5c213f9f85dc4b1fba80d88d	34	0xe1a27375e1b47dac5c213f9f85dc4b1fba80d88d	116624024	1315323973388873250	2024-02-25T07:40:25.000Z	256208536210235131195	0x8c33089d4828ac1f9d19a08b7ef87868e07fd3153f95f249ee39ae1e29c32706	78781963948
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	0xf497427c896263342996c181d4af8f4e60899ac3	2	0xf497427c896263342996c181d4af8f4e60899ac3	25255867	4000000000000000000	2022-09-25T07:26:48.000Z	1129236059990357375	0x68d079fc3cac3ee48056d74dc282f430aed6209a004bfdcbdd7904a67be0f2fa	1000139434243325552
0x04f0fd3cd03b17a3e5921c0170ca6dd3952841ca	false	0xf497427c896263342996c181d4af8f4e60899ac3	2	0xf497427c896263342996c181d4af8f4e60899ac3	25255588	5500000000000000000	2022-09-25T07:25:02.000Z	5129234820579958525	0x8fbb6ae8ba6e51389d6f3c3fdeff990da04dabadc8e419321d04c9ff76afe03f	5000138226027377210

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_optimism.iSUSD_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
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	14	115604322	62503607536	1061182876699329771	2024-02-01T17:10:21.000Z	23604938077	0x2bf29899b9879036752d7040d147b153d68c312f62f9a17834cc39474172286c	359996
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	4	115597572	62503607740	1061166576810103647	2024-02-01T13:25:21.000Z	23604575503	0x8706c78e915bdafebfecaf2959bd9b2800b9ed068a9f81f4b5b5e34282547f74	1158688
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	54	115575999	62503607842	1061114486853206258	2024-02-01T01:26:15.000Z	23603416815	0xaf6db6c6cb30084903236eda8fd7f411d6b3a0c8e4b937d07270580ff4814402	941257

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_optimism.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
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	4	0xedef349a881015d50409db04027ef6462eacf2b8	112715410	2023-11-26T20:13:17.000Z	180000000	9698528308	0xebb2ca693545a2cc78fd95e24e76e654e3dea3eafe3c2d5a97298d15041527c7	780311916
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	10	0xedef349a881015d50409db04027ef6462eacf2b8	112714262	2023-11-26T19:35:01.000Z	100000000	9518515052	0xdcb7bbf3207c3e19bf34818c9221494c4203e6fa3893371a06e0d92c82786fc8	600311080
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	18	0x4386a86277a03ff37188416767ad74e4381b226c	107217653	2023-07-22T13:54:43.000Z	621000000	7699852582	0x7130037e34c5f9722edaa7e77417f9b86ddcb10bece1b9c2de45058369b2e4fe	621000000

Example Query

Query with partition filter

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

No sample data available.

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_optimism.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
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	0x6e8d7b9195315189b5fcaeb21d2506e4c7493c0c	14	106630977	14427393	141709263686	2023-07-08T23:58:51.000Z	0x75fc96c75a256aecbe5589d2981ca0d0a6f05da9ef20fa4c461abaa74903a557
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	0x6e8d7b9195315189b5fcaeb21d2506e4c7493c0c	30	106630714	14427393	141709265528	2023-07-08T23:50:05.000Z	0xfc4358186bee34d4aa5b8cbeb031636bdbe01064f7722c9c3251299b263bbd7b
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	0x72ce46caf3512b3eb6c6d8fd0819ab225a925014	3	66890140	50000000	495659035550	2023-01-15T02:30:52.000Z	0xae3593c7eb10588ff1a40a2a7c777e1e63291a35b9555afc222f6194a4c9d2f0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_optimism.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
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	1	12667887	2022-06-22T08:28:50.000Z	0xba92bf3e5bff07c0cc8ac38e3eb5c352b891cd0899ba654c9f50274f33026a99	100000000000000000	0

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_optimism.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
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	12	0xcba1a275e2d858ecffaf7a87f606f74b719a8a93	108478789	2023-08-20T18:32:35.000Z	32806160	322196322701	0xa76213a2e798351ffda196a390b52611e4ef2f1add7e9b31b4b2499639801935
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	3	0xc0e7dc00d7b898c5318a402873d0dd75eb217d2e	74689154	2023-02-16T10:06:17.000Z	23260696	229964568597	0x32d8bcdcadee941d8c4f7aae3c5ab7fd121e742f24db3d9c686f76b1bbde5ef0
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	3	0xa5fe44f89706dbd9526d38771e2a9e215350fe92	74814445	2023-02-16T20:56:33.000Z	42104895	416259700231	0x22717ddff8fb65c002852bf8bed6a0c4418bfd921226801bb3ad6bbbec0ecb8d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_optimism.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
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	31	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	41766093	1578984388	2022-11-24T13:02:47.000Z	813365304348	0x19be359703f4b4ad6ee52d215115b75f5e4c477ea9e3a0404932b9b76dd9be8f	812652500099
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	32	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	41509827	3000446696	2022-11-24T02:12:36.000Z	809415377382	0x2f63f815cd94d6fee2e4f56b2f192788a2e9b3f94cae4e3fc504079b2fa64f38	808702627947
0x1d073cf59ae0c169cbc58b6fdd518822ae89173a	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	27	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	27044005	53092241672	2022-10-03T01:10:10.000Z	4208332194942	0x342958b487086978fa40608dc581e0ed2aa251f4b991a9a904394966dc80babd	4206375761688

Example Query

Query with partition filter

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

iUSDT_AccrueInterest_event

Interest accrual events for the Iron Bank USDT (iUSDT) lending market on Optimism, capturing cash reserves, total borrows, borrow index updates, and accumulated interest per transaction. Used for calculating lending rates, total value locked (TVL), and 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
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	2	40850440	7852707000	1012706567477737291	2022-11-22T09:52:06.000Z	3021826540	0x1cdf10e44703fb6bc0a7ec0655ea7ab8971885ef10634e4293752b046b910db3	71
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	2	40881263	7853671690	1012728116661527362	2022-11-22T11:32:27.000Z	3021890835	0x960f1ef15e317766d466b8afd57948d985de380945ba68d62f7a8c46eae1f9c6	71
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	2	40856999	5853871797	1012710483275086188	2022-11-22T10:10:22.000Z	3021838222	0x467afa132a601ffad545d25049d018b78fcc7d52a46fa07093cec80a3ceb942b	88

Example Query

Query with partition filter

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

iUSDT_Borrow_event

Borrow event logs from Iron Bank’s iUSDT market on Optimism, tracking when users take USDT loans with amounts shown in 6-decimal precision. Used for analyzing borrowing patterns, user leverage activity, and protocol debt accumulation 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
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	4	0xf0e984088576cf99819ed2c23e9914526b4b475e	21226465	2022-08-30T19:18:04.000Z	1000000	1764735	0xc1eee63f72a84978ab2d5fe8bccf1c93eac7744d5ce994791fdacb063e59876a	1000000
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	2	0xd1c167e2d91f759fb2125aa4a827d4e21c0eb99c	72641171	2023-02-06T22:07:08.000Z	25000000	3424186540	0x3835d9d801a2dbe14ac462642702eb1e4b71e21f36e9357a0ade1c608a8a4640	225371780
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	4	0xe1a27375e1b47dac5c213f9f85dc4b1fba80d88d	71156666	2023-01-29T22:31:43.000Z	2500000	3406147869	0x06141f61b0bffa65b948c6632caa247a394b2c6a72ceb7adfcf97c87b3d020c3	2500000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_optimism.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_optimism.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 lending pool on Optimism, recording when users deposit USDT and receive iUSDT receipt tokens. Contains minter addresses, underlying USDT amounts deposited, and corresponding iUSDT tokens minted for analyzing lending activity and collateral 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_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
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	0x2d9faebeaed066fdb8ec116f2047bbe2ead02429	2	22590496	165489547	1654839939876	2022-09-10T03:25:28.000Z	0xb0ea47bbcf31747291c2d4e39750606b7df5b5fa5f7c05f57514a601d2a05bd1
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	0x992c94cedc50cf3ea6da8092f18d69b04aa4e420	2	22673282	168144128	1681384849496	2022-09-10T23:15:12.000Z	0xa6d48ca1d1e53dc8de99840791125f53adf17df1dd3e693196afb5953f85d108
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	0xdd1305150d27aecc60c066630105db419977e367	31	105620433	1800000	17681904521	2023-06-15T14:34:03.000Z	0xef6de6911c16c7f34f8a6d381b91f26e1010fba9de8d0cec9d8733661e090eca

Example Query

Query with partition filter

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

iUSDT_NewReserveFactor_event

Reserve factor updates for the Iron Bank USDT market on Optimism, tracking changes to the protocol’s reserve percentage retained from interest payments. Used for monitoring Iron Bank protocol parameter governance and revenue allocation 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
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	1	12667905	2022-06-22T08:29:06.000Z	0xa746522b7e4d225c915c13e03d259b0a5fae021fff719a84d4703147d9a57736	100000000000000000	0

Example Query

Query with partition filter

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

iUSDT_Redeem_event

Withdrawal events from Iron Bank v1 USDT lending market on Optimism, tracking when users redeem their ibUSDT interest-bearing tokens for underlying USDT. Used for analyzing lending market liquidity, user withdrawal patterns, and interest accrual rates.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	23	0x4eda3e4f9e42a7dd5c853e8b857271fae88e7209	114471381	2024-01-06T11:45:39.000Z	109777593	1067674314088	0x53d8040c2963d85b683bbe9ecc5ca674e402ed1aafdaa4055f459bb70177554f
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	16	0x85d223f0cfef624863c1ffd5b2b73478abdfb435	108925226	2023-08-31T02:33:49.000Z	16565758	162658219842	0xcf4812c5508dc0ef03d1d1a88c9dcafb38baa931238cf2b20c736fbd178de885
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	3	0xf090cd9d129e329fc6fb874fb2e526034cc56041	61284796	2023-01-06T15:39:19.000Z	75796317	748467428152	0x31923a299b121e1318beee0a50370c1de17dd76a0e7752474b717b11a74d67a7

Example Query

Query with partition filter

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

iUSDT_RepayBorrow_event

USDT borrow repayment events from Iron Bank v1 lending protocol on Optimism. Tracks debt repayments with payer, borrower addresses, repayment amounts, and updated borrow balances for analyzing lending market activity and liquidation 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_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
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	0x6f0878b34164a9c6a400f1ffd1ecb7b27a47075c	7	0xe1a27375e1b47dac5c213f9f85dc4b1fba80d88d	77037006	16276175	2023-02-25T15:50:00.000Z	1131011104	0x10e06e48e31e85ed83fe1e85f43a81a7a61a2be5f98c8ad28573c685dda84996	16277448
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	0x0b818dc9d41732617dfc5bc8dff03dac632780e1	2	0x0b818dc9d41732617dfc5bc8dff03dac632780e1	35543193	145000000	2022-11-07T22:33:04.000Z	358777549	0xe8b164f5eeb29d60845723e42e1c1a0aa44f22aa88a8c3d29f158ca4e7654c5b	221578949
0x874c01c2d1767efa01fa54b2ac16be96fad5a742	false	0x0b818dc9d41732617dfc5bc8dff03dac632780e1	2	0x0b818dc9d41732617dfc5bc8dff03dac632780e1	35519483	175000000	2022-11-07T20:33:25.000Z	417483891	0x72875c2cb65887d19eda69153a9d5cb76867c227277d91fd97fff6c43537818a	280285880

Example Query

Query with partition filter

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

iWBTC_AccrueInterest_event

Interest accrual events for the Iron Bank v1 Wrapped Bitcoin (iWBTC) lending market on Optimism, recording periodic updates to borrow index, total borrows, available cash reserves, and accumulated interest. Used for tracking borrowing costs and market utilization 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
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	31	115480965	29264904	1003418517883870959	2024-01-29T20:38:27.000Z	8	0xdbe869e014269d152b11cb36d667a4c8d75438a7a2af28d98f52072ee292fb51
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0	28772367	11995369	1000003476291701521	2022-10-12T01:57:07.000Z	0	0x6f4aa8b47e0c65cd940ed670d5751fcf7cee9cead35b184d3b1a6d60a68f5ef0
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0	28767345	76059	1000003476291701521	2022-10-12T01:03:57.000Z	0	0xf807cec7047d2a71643b5b3db1fe4e6a208427eb392ec2f5371ccf257b7d591b

Example Query

Query with partition filter

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

iWBTC_Borrow_event

Borrow event logs from Iron Bank’s Wrapped Bitcoin (WBTC) lending market on Optimism, tracking individual borrow transactions with amounts in smallest token units (satoshis). Contains borrower addresses, individual and aggregate borrow balances for analyzing lending 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
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	10	0x0d0b44b4252bb8e6b0cef07be944eef829bdd61a	112936057	2023-12-01T22:48:11.000Z	1000	1008	0xca5a047981a539cdc339d1639b196871453036390a64697653cd350cdfcfed1b	1000
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	24	0xdeb6aa85bcd0e0869fde8cc72ab355c6bcd79e58	106059914	2023-06-25T18:43:25.000Z	10000	10008	0xd4b8b5a358e679e674cef6a4b8b1dd33534851f7089745fb9a05150d0b5d963b	10000
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	4	0x3b74d817a7a224948748d9444fabeca4aa4f24fb	33193191	2022-10-31T21:09:46.000Z	71742	71742	0x742455e6f8a0890aed3835717f035cefcaa864ebd8a144ed8caaefbad97d7a63	71742

Example Query

Query with partition filter

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

iWBTC_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_optimism.iWBTC_Flashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

iWBTC_Mint_event

Mint events from the Iron Bank V1 WBTC lending market (iWBTC) on Optimism, recording deposits of WBTC and issuance of corresponding interest-bearing iWBTC tokens. Tracks minter addresses, underlying WBTC amounts, and iToken quantities for analyzing supply-side liquidity provision.

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
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0xce5ddfe41dcc1b0d4e8b996ba079f060d45adc2c	3	13369242	287647	28764700	2022-06-28T07:49:19.000Z	0xe4d9a265c30b9998b7daef0642a1eb8973518d77bf33c24315b1145905d4de1c
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0xac408589010deee4cd3b62a4ebcf2e75d244e494	3	66804681	19993800	1999353783	2023-01-14T22:03:48.000Z	0x78243e215b781e8d5d4bf06e8e4b90a32ad2f417158b47fc5a4bc3476510645a
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0xe273e80087d838431ca6eb685f0b9bf146e5f769	35	111978381	5407927	540106722	2023-11-09T18:45:39.000Z	0xd82381ed57aafb3fea9d64554d5d9229f9fd2c628fef88237e387a02e782386a

Example Query

Query with partition filter

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

iWBTC_NewReserveFactor_event

Reserve factor parameter change events for Iron Bank’s Wrapped Bitcoin (WBTC) market on Optimism. Tracks protocol fee adjustments with old and new reserve factor values in mantissa format (18 decimals) for monitoring Iron Bank’s risk management and revenue parameters.

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
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	1	12667933	2022-06-22T08:29:37.000Z	0xed09e422396555b943020df4044bd7784e59f12d57677dce087ae0590ae501e7	100000000000000000	0

Example Query

Query with partition filter

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

iWBTC_Redeem_event

Withdrawal events from Iron Bank’s iWBTC (interest-bearing Wrapped Bitcoin) lending market on Optimism, recording when users redeem their iWBTC tokens for underlying WBTC collateral. Tracks redeemer addresses, token amounts withdrawn, and corresponding iWBTC shares burned for analyzing lending protocol 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
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	3	0xce5ddfe41dcc1b0d4e8b996ba079f060d45adc2c	20610429	2022-08-26T09:05:46.000Z	287647	28764700	0xb58622a3c9f06e4453e880467083bf189030e554e58010801babc758e56d806a
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	5	0xe273e80087d838431ca6eb685f0b9bf146e5f769	112066237	2023-11-11T19:34:11.000Z	7391536	738216100	0x6dc1fb7d1d257db2782edd08a8c130697125ded89288c65a959d7230981d58fe
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	5	0xc91ee78162424c5d1279dae6f04babea4794b34f	19397975	2022-08-16T16:42:05.000Z	100000000	10000000000	0xf21bbdd5873eed9385041ea7bc6e084df5a6acbbce97532fc4171f56bad50077

Example Query

Query with partition filter

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

iWBTC_RepayBorrow_event

Borrow repayment events from Iron Bank v1’s wrapped Bitcoin (WBTC) market on Optimism, tracking when users repay their borrowed WBTC positions with payer address, repayment amount, and updated account balances for analyzing lending protocol 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
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0x80ef4b3f87ab8ff221cb328e8286162c7f982eb1	12	0x80ef4b3f87ab8ff221cb328e8286162c7f982eb1	107589038	30101	2023-07-31T04:14:13.000Z	8	0xb410e6bec384e93ca5880333d7eeae9245911c6bc8c74a80e3cbcfde0d1bb2cb	0
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0x2d8fedb175fd645595ffd95d3432b0a1e93f82b1	3	0x2d8fedb175fd645595ffd95d3432b0a1e93f82b1	60113936	30000000	2023-01-04T14:10:48.000Z	8	0xc16af3820889f81104e1b861f31fcd915e1caba970d2249acad020c5dc9e824b	8
0xcdb9b4db65c913ab000b40204248c8a53185d14d	false	0xac408589010deee4cd3b62a4ebcf2e75d244e494	3	0xac408589010deee4cd3b62a4ebcf2e75d244e494	66809137	1000000	2023-01-14T22:18:50.000Z	8	0x7c2024284fd882b1837ea0bcf1ae0222c651f69306b6633413796d1be3f5b6e6	0

Example Query

Query with partition filter

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

iWETH_AccrueInterest_event

Interest accrual events for Iron Bank V1’s WETH (Wrapped Ether) lending market on Optimism, tracking cash reserves, total borrows, accumulated interest, and borrow index updates. Used for analyzing WETH lending pool performance and interest rate 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_cashPrior`	`STRING`	Cash balance in the market prior to the interest accrual event. Denominated in the smallest unit of the underlying token.
`in_interestAccumulated`	`STRING`	Interest accrued during the period since the last interest calculation. Denominated in the smallest unit of the underlying token.
`in_borrowIndex`	`STRING`	Cumulative borrow interest index for the market. Scaled by 1e18, representing the accumulated interest per unit borrowed since market inception.
`in_totalBorrows`	`STRING`	Total amount borrowed from the market across all borrowers. Denominated in the smallest unit of the underlying token.

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	20030939	2637571359038349859428	1000092039358647728	2022-08-21T09:35:33.000Z	289103525297213769836	0x61e9afeb417b611c806ec16e57a45e7906db1a36ee1f5f342bb159c014c80b85	6384325677032
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	20007838	2435950253013646870490	1000085868686780405	2022-08-21T06:00:26.000Z	289092984788244029677	0x4198783099217fec29d5539c55639477e7bbf1d2577330f307225d20da9cf71e	687514831015682
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	20071807	2482803616630809421038	1000110330820900808	2022-08-21T19:23:25.000Z	407398582337560379155	0xd30d42e074067e3a6ffac09dc80a95c0155ebc6b1eb501efa1e6bc78a7b31408	683683779103849

Example Query

Query with partition filter

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

iWETH_Borrow_event

Borrow event records from Iron Bank V1’s Wrapped Ether (WETH) lending market on Optimism. Tracks individual borrow transactions with amounts, borrower addresses, and running account/total borrow balances for analyzing lending protocol activity and user leverage 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
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	17	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	74973994	2023-02-17T14:10:31.000Z	2494961458385175	1674617059058494624296	0xb845412ad8f97752e86f231c5ce4d8fa3c520c3a541252589635d620a2537f17	1672787265594464930281
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	3	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	74882875	2023-02-17T02:29:55.000Z	258698421302712	1671703580713554138864	0xc9fe1f8da2369c5a02252ccef067795899b9ef373d199fce840958170ef99ca8	1669873926746405326444
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	5	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	74882875	2023-02-17T02:29:55.000Z	1518538885027846476	1673222119598581985340	0xc9fe1f8da2369c5a02252ccef067795899b9ef373d199fce840958170ef99ca8	1671392465631433172920

Example Query

Query with partition filter

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

iWETH_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_optimism.iWETH_Flashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

iWETH_Mint_event

Mint events from Iron Bank v1’s wrapped ETH (iWETH) interest-bearing token contract on Optimism, recording deposits where users supply WETH and receive iWETH tokens in return. Tracks minter addresses, underlying WETH amounts, and iToken quantities minted for analyzing lending market supply activity.

Columns

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

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	0x14bc6cf95a8befd4b07e0f824c60bc1401fe9d23	3	64124775	1000000000000000	9806424	2023-01-11T07:18:56.000Z	0x2263b3c1d00320185f0e146c55dc64e8d382c59b0b52d54ac288e3c7cb1b7b0b
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	0x970d6b8c1479ec2bfe5a82dc69cafe4003099bc0	73	64400191	477670838373198708	4684060095	2023-01-11T15:00:50.000Z	0x2850f135083a218f84c69a173faff61e7ce468af4f0970b4fa05a22b07bdcaaa
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	0x970d6b8c1479ec2bfe5a82dc69cafe4003099bc0	73	64483916	3406844994928316653	33406998556	2023-01-11T18:57:10.000Z	0x429212b5f660fd4142ef50c4a0cdbf2b78e1fe1dfeac934dffbae71219ef0c78

Example Query

Query with partition filter

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

iWETH_NewReserveFactor_event

Historical reserve factor parameter changes for the Iron Bank WETH (Wrapped Ether) market on Optimism. Tracks administrative adjustments to the protocol’s reserve ratio, which determines what percentage of interest goes 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
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	1	12666827	2022-06-22T08:14:43.000Z	0x3e47c4320da9af781243609a3e684f3c0b6ae57fce9ff074697a1dd4b174e79d	100000000000000000	0

Example Query

Query with partition filter

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

iWETH_Redeem_event

Withdrawal events from Iron Bank’s WETH (Wrapped Ether) lending market on Optimism, recording when users redeem iWETH tokens for underlying WETH assets. Tracks redeemer addresses, redemption amounts in wei, and corresponding iToken quantities burned for analyzing lending market liquidity and user withdrawal patterns.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	3	0xf8e8f48d0e72e41a21acc8897d4012126d04de78	22689183	2022-09-11T04:29:20.000Z	10000000000000000	99856025	0x2c1c8a91f4c01d96c8bd9a780608e726cd5bf03256a2a738605a78ae3dc758d1
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	5	0xc91ee78162424c5d1279dae6f04babea4794b34f	22758414	2022-09-11T19:03:55.000Z	1304983060234100560	13030030275	0xd40bc15c8418b6dd1a924eba38fff6ca93c487dbf44a260c2b3eda2332d3ed47
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	5	0xc91ee78162424c5d1279dae6f04babea4794b34f	22690883	2022-09-11T05:02:12.000Z	70093268687865133	699921578	0xf9964897a1d61e33adc67513d3909390ec09468e61ea3f77ea0a422a1ec212b2

Example Query

Query with partition filter

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

iWETH_RepayBorrow_event

Wrapped Ether (WETH) loan repayment events from Iron Bank v1 lending protocol on Optimism. Tracks borrower repayments with amounts, updated account balances, and protocol-wide borrow totals for analyzing debt management and protocol health.

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
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	25	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	40050961	7509731530706782	2022-11-20T10:29:17.000Z	2208582475841610352446	0xbdfc7f4b8a5a857bcdf1af8fb610f168c95e8e72f18cd21fdd402148e0e7ef61	2207062562400623205794
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	22	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	39890672	31053786716023520710	2022-11-20T02:05:57.000Z	2175689106398131169094	0x42c408598a26721bb2076d052559322ca804e12b885ac0908d8e1a3cbe65af17	2174169340458775949363
0x17533a1bde957979e3977ebbfbc31e6deeb25c7d	false	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	22	0xffa51a5ec855f8e38dd867ba503c454d8bbc5ab9	40247823	29954130853107383	2022-11-20T22:19:05.000Z	2212599687580212597254	0xcb23dee842d0edd7a373ec7edad545a96516639af474da3bdc215ff9292867b8	2211079565924920354837

Example Query

Query with partition filter

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

StakingRewards_RewardPaid_event

Reward distribution events from StakingRewards contracts recording when staked positions earn incentives. Contains recipient address, reward amount, and optional token or position identifiers for tracking yield distribution across protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_rewardsToken`	`STRING`	Contract address of the reward token being distributed. Hex-encoded, 0x-prefixed, 42-character string.
`in_reward`	`STRING`	Contract address of the reward token being distributed or claimed. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	in_rewardsToken	transaction_hash
0x100be116e7d934268db5dfcfad54cb221504c479	0x35a807f9dd68c7b03a992477f85cf5a08ee9a69e	false	67215213731518169106	8	40913998	2022-11-22T13:06:33.000Z	0x00a35fd824c717879bf370e70ac6868b95870dfb	0x40a5bc250fd8fe19f622803725f314c5f2f4bc0fd3dff34e6f205c5587e13e94
0xf75e85e9127039b4cf818118cc8c5b257edf6684	0x3cdfd4d0e3119edf47e293e54a1f2ccb4f319cbb	false	24789995526338839764	7	40774342	2022-11-22T06:56:04.000Z	0x00a35fd824c717879bf370e70ac6868b95870dfb	0xfb8f2347eedc7414f9f9d5093d64bbf94aaa48e8f3f447c6000298833b0dd8c5
0xd52df1ea7b51b76cc831ed68ff93e92f80271617	0x442b263a0aab7c90a822a99e49d27cc8d2af20ed	false	84105799673764607165	8	40994605	2022-11-22T17:11:43.000Z	0x00a35fd824c717879bf370e70ac6868b95870dfb	0x64438d67dfd30d61d05c223faa15c00487136d05ddaf5c3e6cb9e6c632624f4c

Example Query

Query with partition filter

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

StakingRewardsFactory_StakingRewardsCreated_event

Deployment records of new staking rewards contracts created by Iron Bank v1’s factory on Optimism, linking staking token addresses to their corresponding rewards distribution contracts. Used for tracking the initialization of liquidity mining programs and mapping stakeable assets to their reward mechanisms.

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_stakingRewards`	`STRING`	Contract address of the newly deployed staking rewards contract created by the factory. This address manages reward distribution for users who stake the associated staking token.
`in_stakingToken`	`STRING`	Contract address of the token being staked to earn rewards in this Iron Bank staking pool. Hex-encoded, 0x-prefixed 40-character string representing the ERC-20 token on Optimism.

Sample Data

address	removed	log_index	block_number	block_timestamp	in_stakingToken	transaction_hash	in_stakingRewards
0x35f70ce60f049a8c21721c53a1dfccb5bf4a1ea8	false	6	18244534	2022-08-08T03:06:05.000Z	0x4645e0952678e9566fb529d9313f5730e4e1c412	0xc7d10630d0df26584c1074eb9ea17667c0baadb1c11620eba3022a0e15ebfb70	0x553d42d966bf57a50f2d3a48a999845295309fbf
0x35f70ce60f049a8c21721c53a1dfccb5bf4a1ea8	false	3	18244534	2022-08-08T03:06:05.000Z	0xcdb9b4db65c913ab000b40204248c8a53185d14d	0xc7d10630d0df26584c1074eb9ea17667c0baadb1c11620eba3022a0e15ebfb70	0xe1360b36449af40547f46edf61253d7aa5a55396
0x35f70ce60f049a8c21721c53a1dfccb5bf4a1ea8	false	9	18244534	2022-08-08T03:06:05.000Z	0xe724ffa5d30782499086682c8362cb3673bf69ae	0xc7d10630d0df26584c1074eb9ea17667c0baadb1c11620eba3022a0e15ebfb70	0x9642aec69306d47fad7bbbf5bd7c00d87304f39c

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​iDAI_AccrueInterest_event

​iDAI_Borrow_event

​iDAI_Flashloan_event

​iDAI_Mint_event

​iDAI_NewReserveFactor_event

​iDAI_Redeem_event

​iDAI_RepayBorrow_event

​iOP_AccrueInterest_event

​iOP_Borrow_event

​iOP_Flashloan_event

​iOP_Mint_event

​iOP_NewReserveFactor_event

​iOP_Redeem_event

​iOP_RepayBorrow_event

​iSNX_AccrueInterest_event

​iSNX_Borrow_event

​iSNX_Flashloan_event

​iSNX_Mint_event

​iSNX_NewReserveFactor_event

​iSNX_Redeem_event

​iSNX_RepayBorrow_event

​iSUSD_AccrueInterest_event

​iSUSD_Borrow_event

​iSUSD_Flashloan_event

​iSUSD_Mint_event

​iSUSD_NewReserveFactor_event

​iSUSD_Redeem_event

​iSUSD_RepayBorrow_event

​iUSDC_AccrueInterest_event

​iUSDC_Borrow_event

​iUSDC_Flashloan_event

​iUSDC_Mint_event

​iUSDC_NewReserveFactor_event

​iUSDC_Redeem_event

​iUSDC_RepayBorrow_event

​iUSDT_AccrueInterest_event

​iUSDT_Borrow_event

​iUSDT_Flashloan_event

​iUSDT_Mint_event

​iUSDT_NewReserveFactor_event

​iUSDT_Redeem_event

​iUSDT_RepayBorrow_event

​iWBTC_AccrueInterest_event

​iWBTC_Borrow_event

​iWBTC_Flashloan_event

​iWBTC_Mint_event

​iWBTC_NewReserveFactor_event

​iWBTC_Redeem_event

​iWBTC_RepayBorrow_event

​iWETH_AccrueInterest_event

​iWETH_Borrow_event

​iWETH_Flashloan_event

​iWETH_Mint_event

​iWETH_NewReserveFactor_event

​iWETH_Redeem_event

​iWETH_RepayBorrow_event

​StakingRewards_RewardPaid_event

​StakingRewardsFactory_StakingRewardsCreated_event

Tables

iDAI_AccrueInterest_event

iDAI_Borrow_event

iDAI_Flashloan_event

iDAI_Mint_event

iDAI_NewReserveFactor_event

iDAI_Redeem_event

iDAI_RepayBorrow_event

iOP_AccrueInterest_event

iOP_Borrow_event

iOP_Flashloan_event

iOP_Mint_event

iOP_NewReserveFactor_event

iOP_Redeem_event

iOP_RepayBorrow_event

iSNX_AccrueInterest_event

iSNX_Borrow_event

iSNX_Flashloan_event

iSNX_Mint_event

iSNX_NewReserveFactor_event

iSNX_Redeem_event

iSNX_RepayBorrow_event

iSUSD_AccrueInterest_event

iSUSD_Borrow_event

iSUSD_Flashloan_event

iSUSD_Mint_event

iSUSD_NewReserveFactor_event

iSUSD_Redeem_event

iSUSD_RepayBorrow_event

iUSDC_AccrueInterest_event

iUSDC_Borrow_event

iUSDC_Flashloan_event

iUSDC_Mint_event

iUSDC_NewReserveFactor_event

iUSDC_Redeem_event

iUSDC_RepayBorrow_event

iUSDT_AccrueInterest_event

iUSDT_Borrow_event

iUSDT_Flashloan_event

iUSDT_Mint_event

iUSDT_NewReserveFactor_event

iUSDT_Redeem_event

iUSDT_RepayBorrow_event

iWBTC_AccrueInterest_event

iWBTC_Borrow_event

iWBTC_Flashloan_event

iWBTC_Mint_event

iWBTC_NewReserveFactor_event

iWBTC_Redeem_event

iWBTC_RepayBorrow_event

iWETH_AccrueInterest_event

iWETH_Borrow_event

iWETH_Flashloan_event

iWETH_Mint_event

iWETH_NewReserveFactor_event

iWETH_Redeem_event

iWETH_RepayBorrow_event

StakingRewards_RewardPaid_event

StakingRewardsFactory_StakingRewardsCreated_event