ironbank_v1_fantom - Token Terminal Docs

Tables

iAAVE_AccrueInterest_event

Interest accrual events for the AAVE lending market on Iron Bank v1 (Fantom), capturing periodic updates to accumulated interest, borrow index, total borrows, and available cash. Used for tracking lending pool interest rate mechanics and borrowing activity 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
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	15902138	4298055065934745755	1010847104294616188	2021-08-30T10:37:58.000Z	204834376165292096	0xb3885c7b4d8baa42b970addcbccb1827589527ca7443e1dd651d187ab2fecea1	2252890975169
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	15860607	4298039685103215750	1010835986393601842	2021-08-30T00:03:05.000Z	204832123274316927	0x650659cc0693042e4777d84537db67223b5466e46ff4549e98eb8b763f8c6b60	333500809922
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	15915631	1507844541548711	1010853455048192767	2021-08-30T16:14:12.000Z	10204872933375812175	0x60354b16c8ce7cd518dde684935f98f5be02de97047248b33df207f8b7ecdaca	38033743104907

Example Query

Query with partition filter

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

iAAVE_Borrow_event

Borrow event logs from Iron Bank v1’s AAVE market on Fantom, recording when users take out loans against their collateral. Tracks individual borrow transactions with amounts, running totals, and borrower addresses for analyzing lending protocol usage and credit risk.

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
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	25	0xd813155f8561566876293214275c3211e0c7612a	16068682	2021-09-01T13:25:08.000Z	130000000000000000	335254401567064004	0x810f909cea0929f510ee0f0ea4d4a703f25ffd1adfc125e136902c0894c44d68	130000000000000000
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	46	0xb9771f0b0adcdfdc1133d692ec9c351be6871b1e	31618998	2022-02-21T15:04:09.000Z	5000000000000000000	66328398641845261839	0xc4afe254b152447be8d0d8e7d4bf6e1cd7d5bd5bb6c62b0d41f2979484ee399f	50700580132330115617
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	8	0xb116dae508e2967e094967723bf010e7833e3212	61962246	2023-05-10T20:38:44.000Z	15000000000000000000	18296874366626526858	0xa98afe582db8635bc99f1c690d675fb8caf0644bd77fbc8851ec6a756c3befec	15000000000000000000

Example Query

Query with partition filter

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

iAAVE_Flashloan_event

Flash loan event records from Iron Bank’s iAAVE market on Fantom, capturing borrowed amounts, receiver addresses, and fee breakdowns (total and protocol reserve fees). Used for analyzing flash loan activity patterns, fee generation, and protocol liquidity utilization.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	86519377895511397	61	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	25955813368653	12570566	5191162673730	2021-07-21T04:34:51.000Z	0xa8c147e3fb43a0c369f62fff96fe5d27e6977fe0a06cfd1c5b9e5a2e9f9ad01b
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	66211002790633229	36	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	19863300837189	15996333	3972660167437	2021-08-31T16:42:07.000Z	0x87ac350e6df1b46b2b147e6ef94e7a83f0a3c4ad2b09371f46abb01a64eaaee9
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	136193322853388804	78	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	40857996856016	15984169	8171599371203	2021-08-31T13:08:19.000Z	0x393f8ff0e41e18724112f1701b34ec90003474e74154d29ee39e043585a498e8

Example Query

Query with partition filter

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

iAAVE_Mint_event

Mint events from Iron Bank v1’s AAVE lending pool on Fantom, recording deposits where users supply AAVE tokens in exchange for interest-bearing iAAVE tokens. Used to track lending activity, deposit volumes, and collateral positions in the Iron Bank protocol.

Columns

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

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	0x5b356d59ea36ef660173970aa97f76213ba46260	3	13757564	157213576534326018	1567387384	2021-08-04T12:50:37.000Z	0x0251d5255bb7f36f3f78ff4735687da2df089e4591d848a5ad805be08fbbe369
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	0xa5504bcb6cc0492344151ebee943c62d2b2c071f	114	24326452	271299412350630036	2694749685	2021-12-08T05:56:02.000Z	0x7ecb1f865dbd1bf780af8f2160a63ee985d2c039ef394abf1218f5579e2125dd
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	0x30194f526c6b08f8e33af1753b04322b0450c6c0	2	24379839	260015633069183	2582109	2021-12-08T18:55:06.000Z	0x2af62a342d4911ead8145404ebb14efb3561ccec6656a803104d278c8f6ae735

Example Query

Query with partition filter

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

iAAVE_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank AAVE market on Fantom. Tracks adjustments to the protocol’s reserve allocation percentage, useful for analyzing Iron Bank’s risk management and fee structure evolution.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	1	2668758	2021-03-10T07:36:15.000Z	0xde126a21c4faec4994f85ab2eb3012e0246d20c6a58ef4b17d8abe8978e55ba7	200000000000000000	50000000000000000
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	1	2386465	2021-02-23T10:37:18.000Z	0x27f0929019bceece55e3f57359174b2a09e45091990eff3de769e9081a7a1217	50000000000000000	0

Example Query

Query with partition filter

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

iAAVE_Redeem_event

AAVE token redemption events from Iron Bank v1 lending protocol on Fantom, recording when users withdraw their supplied AAVE collateral by burning interest-bearing iAAVE tokens. Useful for analyzing lending activity, liquidity withdrawals, and user deposit behavior.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	53	0x4532280a66a0c1c709f7e0c40b14b4dea83253c1	33205653	2022-03-12T06:21:37.000Z	3787289492924602	37461070	0xc33a36498fc7c81b06ea71dcce4af1158f2a4369ab5309d639be2fbcf3cb2b82
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	34	0xae15f450ffae06d90188d78cdd5dd2829e4c2eb8	33192039	2022-03-12T02:58:14.000Z	23858529364763634477	235991858997	0x63ec01e3e4927311b83cc09c332d2930136c8d1c2dcdac8e33e48b3653d3d742
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	9	0x01827a0283b2133d17e280fbdad0bada36255b95	24325357	2021-12-08T05:40:16.000Z	72322044036247032595	718360095046	0x3a9078c93c08cee325f5f8daae780afd93faa87ad04e7dea28c5b02a47c0f0b3

Example Query

Query with partition filter

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

iAAVE_RepayBorrow_event

Borrow repayment events from Iron Bank V1’s AAVE market on Fantom, tracking payer, borrower, repayment amounts, and updated borrow balances. Used for analyzing debt repayment patterns and liquidation activity in the lending protocol.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	0x9c2323b8a57da0bd3cbe325c7f4db05cbb896dbd	144	0x9c2323b8a57da0bd3cbe325c7f4db05cbb896dbd	53405889	300000429975710168	2023-01-08T00:09:19.000Z	10650572198518837294	0xf9200fccebcc2fe7df96f3452b97bce542c58da44b5649b38fd492ff24f116b3	0
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	0x0bcb30ae6a56ded3dcbfa1f735a72f466e5d2043	20	0x0bcb30ae6a56ded3dcbfa1f735a72f466e5d2043	20886742	742781936316002461	2021-11-02T23:00:01.000Z	4892321822971399597	0x85d943781a60dbd5553bab2cc378b398ff354e15582a59944d40064d86ac145a	85383808878086154
0x79ea17bee0a8dcb900737e8caa247c8358a5dfa1	false	0x96229bd2d8d33b33ddde4fc9503c9ad6e8509e40	11	0x96229bd2d8d33b33ddde4fc9503c9ad6e8509e40	65622948	171216459394	2023-07-12T03:29:58.000Z	24480701150035536374	0x98e1d0e68631a44137b4ed0689b90191f3b6913e173fdbf847cffc8d89f0af3d	0

Example Query

Query with partition filter

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

iBTC_AccrueInterest_event

Interest accrual events for the iBTC (Iron Bank Bitcoin) market on Iron Bank V1 protocol on Fantom, recording cash reserves, total borrows, borrow index updates, and accumulated interest per transaction.

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
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0	33801868	11809962840	1020806280492779693	2022-03-19T02:12:40.000Z	1594223146	0x111cd57ec2822e5648ea0ca04e21a061f1cd7d5c44019a3354f79154b5693dd2	2155
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0	33841193	11317672114	1020828993155440929	2022-03-19T12:49:05.000Z	1594258613	0x89321758e3d1fff4b80e9081e2f44747206ff58fbe92b45c1a7b82ff530bc49e	11718
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	2	33852406	11328208104	1020835802610208301	2022-03-19T15:58:58.000Z	1594269246	0xec354af39daf090a05562857407543ef6bf9470ddb8c7490db2d50ea6f76b4c4	220

Example Query

Query with partition filter

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

iBTC_Borrow_event

Borrow event logs from the Iron Bank V1 iBTC market on Fantom, capturing individual borrow transactions with amounts, borrower addresses, and running account/total borrow balances. Used for analyzing lending activity, borrower behavior, and iBTC utilization trends.

Columns

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

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	2	0x5900cf2e7dd0c6718aa19edf131f28adba035428	19005045	2021-10-13T15:48:46.000Z	16000	184584032	0xc99d6ba39846c9b46ce4f2fcbf2aec89943aaa8ef27e8c957a34aec3791faa15	613925
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	2	0x5900cf2e7dd0c6718aa19edf131f28adba035428	18999027	2021-10-13T14:03:11.000Z	9200	184564909	0x85f2065bf1c63c2f7ead98f83686c6631445a85f340dbbe2c0e610523bf1345b	594925
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	93	0x5900cf2e7dd0c6718aa19edf131f28adba035428	18999096	2021-10-13T14:04:56.000Z	3000	184567911	0x8279e029706bc93e5802ed7600cc642dc21b567c321ad532bbd9874bf670c6b7	597925

Example Query

Query with partition filter

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

iBTC_Flashloan_event

Flash loan events from Iron Bank v1’s iBTC (interest-bearing Bitcoin) market on Fantom. Records uncollateralized loan executions with borrowed amounts, fee splits between total and protocol reserves, and receiver addresses for analyzing arbitrage activity and DeFi composability.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	304342	67	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	91	14940216	10	2021-08-19T00:59:13.000Z	0xe67bcf1d75a3d13ecace790295eb0f9e339ca03d217dd455f62fcd4ded492c8d
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	462376	45	0xd499244f3d8b02e79b3fe7928ca6c3b0f1162d48	138	52333077	27	2022-12-14T14:38:34.000Z	0x9e0e64fecc1b25e970717b00b2dc6099ccd8cc93cdb638cb2361ff4f53fba976
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	316252	52	0xaca66049c88f3f0e19ea11784b79710b13939f06	94	48551927	18	2022-10-06T12:36:07.000Z	0xf95da5bea1297c8732fef8144a01206309f394148ab3eaa1c6d07705830ca4af

Example Query

Query with partition filter

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

iBTC_Mint_event

Mint events from Iron Bank v1’s iBTC (interest-bearing Bitcoin) token contract on Fantom, recording when users deposit BTC to receive iBTC tokens. Tracks minter addresses, underlying BTC amounts deposited, and corresponding iBTC tokens minted for analyzing Iron Bank 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
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0x79571bfb4e8c62d61e09989ab4ecee174e84cfc6	3	5872171	46600159	4659675440	2021-05-10T04:07:47.000Z	0xf7c4cd2eef3d6209652532fbc0149f9824bbda6181743fc7e2842a6b483c85ea
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0x12429f1842c56e2116f93cbd6cf09418e49abcd7	3	5957456	214003475	21398783404	2021-05-10T21:00:44.000Z	0xbb8a46fc8597e6ab1be96c53dbda6d428a5854b3b6e041994a8d3290fc8c6efb
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0xb9a708c67e2e13035a5feb0f1a2f9e3b625ebd62	4	5891222	250000000	24998173107	2021-05-10T07:50:21.000Z	0x99047b8f86c121518ad44c98293dbd5666a48dc221595630dfeeaf6458e55660

Example Query

Query with partition filter

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

iBTC_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank iBTC market on Fantom, tracking adjustments to the protocol’s revenue retention rate stored as mantissa values (18 decimal precision).

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	1	2667878	2021-03-10T07:01:10.000Z	0x7b491c66e66f619cf2d91a55df2bf855d99bc80f10d76d76371e874331d1e81d	120000000000000000	50000000000000000
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	16	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	200000000000000000	120000000000000000
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	1	2386254	2021-02-23T10:23:46.000Z	0x8528852c1e5b08e00af4bcbbe8babaef2f286d5252a3e020eb8eccc135aae368	50000000000000000	0

Example Query

Query with partition filter

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

iBTC_Redeem_event

Redemption events from Iron Bank’s wrapped Bitcoin (iBTC) lending market on Fantom, recording when users withdraw their underlying BTC collateral by burning iBTC tokens. Tracks redeemer addresses, token amounts burned, and underlying amounts received for analyzing lending market outflows 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
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	39	0x03d2ce8813345382896c624d826cd28b631da28c	17039920	2021-09-14T10:53:02.000Z	1361315	136002986	0xf483be1a7ebedb70a32a6516e24228176e37271bd786e83c26d69145d93c4b9e
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	63	0x03d2ce8813345382896c624d826cd28b631da28c	17039040	2021-09-14T10:23:22.000Z	6223650	621777652	0x951d57e1fa4c60a269f8dbce5f22f1d233b61b57c776c9afb1ca47c3f6b19fb3
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	81	0x03d2ce8813345382896c624d826cd28b631da28c	17035619	2021-09-14T08:27:39.000Z	946862	94596952	0x2c757ff49b7ec2e0605b826cfa561b3e766e956eea8bd1a909d6e92a8b73e5f2

Example Query

Query with partition filter

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

iBTC_RepayBorrow_event

Borrow repayment events for the iBTC (Iron Bank Bitcoin) market on Iron Bank v1 lending protocol on Fantom. Tracks individual repayment transactions with payer and borrower addresses, amounts repaid, and updated borrow balances for analyzing debt reduction activity.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0xdd4b0b419c5b92967f9e0d872a52e5cd03df2ebf	3	0xdd4b0b419c5b92967f9e0d872a52e5cd03df2ebf	13663723	2204089	2021-08-03T11:29:18.000Z	265632860	0x8dd8e32e5ee969de29fb2c03eefbde5b30d113c781a15465de4d4ffc51c29650	2587409
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0xdd4b0b419c5b92967f9e0d872a52e5cd03df2ebf	3	0xdd4b0b419c5b92967f9e0d872a52e5cd03df2ebf	13664358	38341	2021-08-03T11:39:15.000Z	265594678	0x31ee511f8b8e8a60bfcde05ec63a5ce13dfd1a0924569ad6ebc2220aaa3b969e	2549069
0x20ca53e2395fa571798623f1cfbd11fe2c114c24	false	0xdd4b0b419c5b92967f9e0d872a52e5cd03df2ebf	9	0xdd4b0b419c5b92967f9e0d872a52e5cd03df2ebf	13664418	2549069	2021-08-03T11:40:29.000Z	263045628	0x1c6dc65fc5a0475c5ec9cfc83cb5c0e75a9442729cc0961d6f8491b2b28a20fc	0

Example Query

Query with partition filter

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

iDAI_AccrueInterest_event

Interest accrual events for the iDAI (Iron Bank DAI) lending market on Fantom, capturing periodic updates to borrow index, total borrows, and accumulated interest. Used for tracking lending protocol interest rate calculations and borrower cost analysis.

Columns

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

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	38321890	1113394982444377885435786	1175713968673370384	2022-05-15T22:14:50.000Z	164376443839379304402327	0x4c458cb76d6c4048c1f1e36968d3735cdce6507c969731772c959b35cf255148	154440045195323403
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	38276872	1104385720642023569658776	1175677977616355861	2022-05-15T06:46:02.000Z	163624265281051720016760	0xa43768ef321cbc29acc4f94a89ade4d3df0acabbbc7be211b531fc91e1df182f	11492076527721303
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	38261853	1054909979685370805969668	1175666399962509933	2022-05-15T02:00:36.000Z	163657562026316366610179	0x4acad2d8a35cbf88baa6031a6626905c66f4f7c28c6900bc2f991840c0c08bb4	17780651026370913

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_fantom.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 v1) lending protocol on Fantom. Tracks each borrow transaction with borrower address, borrow amount, account-level debt, and protocol-wide total borrows for analyzing leverage and debt positions.

Columns

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

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	11	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	41890734	2022-07-03T04:06:24.000Z	17019830832418294	258531462072783533558198	0xc5cec58b48d67b8cec44af7f94f6ab41d53fe048fbf89e696325638fe9d71f8b	205889014414820292595283
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	13	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	41890734	2022-07-03T04:06:24.000Z	270000000000000000000	258801462072783533558198	0xc5cec58b48d67b8cec44af7f94f6ab41d53fe048fbf89e696325638fe9d71f8b	206159014414820292595283
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	12	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	41897191	2022-07-03T06:19:53.000Z	1180316092588396801872	250649008187658412443635	0x7d8307607f4bc5f5fc87e9ef49d00f32d32f70679f335180937a4f63496a5f8d	197675932058825249261866

Example Query

Query with partition filter

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

iDAI_Flashloan_event

Flash loan events from Iron Bank’s DAI (iDAI) market on Fantom, recording borrowed amounts, fees charged, and receiving addresses. Used for analyzing flash loan usage patterns, fee revenue, and arbitrage activity in the Iron Bank lending protocol.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	25075521646717809914	46	0xc3552fb76f3c013ecbed1a064d80bf721f6bc481	7522656494015342	25523564	752265649401534	2021-12-20T15:01:56.000Z	0xf4cd2db17acd0c5b5e9967ba184e418f26e0a3bbc3f35ae2fc7127529cfea482
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	1100000154109376407	48	0xc3552fb76f3c013ecbed1a064d80bf721f6bc481	330000046232812	25477763	33000004623281	2021-12-20T03:18:01.000Z	0x8c2c8626576b87c6993a5833982cd500cef5635442436f91a61060c96a5ecdfc
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	370272084279423071332	62	0xc3552fb76f3c013ecbed1a064d80bf721f6bc481	111081625283826921	25493661	11108162528382692	2021-12-20T07:17:14.000Z	0xa4d1712ca1ef8991100647446f19e1fd643b28712f15a5f1846035e1676c0c4a

Example Query

Query with partition filter

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

iDAI_Mint_event

Mint events for the iDAI (Iron Bank DAI) lending market on Fantom, recording deposits where users supply DAI and receive iDAI tokens in return. Tracks minter addresses, underlying DAI amounts, and corresponding iDAI tokens minted for analyzing supply-side lending 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
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	0xdf46e9c3366daeab194d5064120a2c1605fbb531	14	48865448	1081043922777131922	9529496827	2022-10-10T14:07:07.000Z	0x954c6b84ee6e811d71eba5cf28f2068458da96b170f54153597f440db6ea2761
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	0x4fc8d635c3cb1d0aa123859e2b2587d0ff2707b1	35	48871902	10734561530358334312	94625850422	2022-10-10T16:24:34.000Z	0xcebf069621cae76006530c0ad9154fa07afd00d458affd1ac3fa41f12d7c40b7
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	0x4fc8d635c3cb1d0aa123859e2b2587d0ff2707b1	10	48871904	18185609839751516667	160307320426	2022-10-10T16:24:37.000Z	0x14ddba28d311650857ebe349f5a6a4c5daa47bf17ce0aedb86ec49a289fb5cae

Example Query

Query with partition filter

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

iDAI_NewReserveFactor_event

Reserve factor adjustment events for the iDAI market on Iron Bank v1 (Fantom), tracking protocol revenue allocation changes between lenders and reserves. Used for analyzing Iron Bank’s risk management and fee structure evolution over time.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	1	2667898	2021-03-10T07:01:46.000Z	0xa2dfcfe2238399bf46f1eb3e37bcda7d085d85ad908dfbb1ae7376472d26be34	100000000000000000	50000000000000000
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	14	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	150000000000000000	100000000000000000
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	1	2386214	2021-02-23T10:20:23.000Z	0x425a0e3caf321d5ef9a81a9c25ccd42b3ba49508fde49b1245b3b06b5e50f0a7	50000000000000000	0

Example Query

Query with partition filter

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

iDAI_Redeem_event

DAI withdrawal events from Iron Bank v1 lending protocol on Fantom, tracking when users redeem iDAI tokens for underlying DAI collateral. Records include redeemer addresses, amounts of underlying DAI withdrawn, and corresponding iToken amounts burned for analyzing lending protocol 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_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
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	4	0xbac66cc27025379635cef8440b9b8db5c752021f	44355209	2022-08-06T17:25:09.000Z	4642119570184995910273	41148972809561	0xcc4a768f5f9dc65f0ab38455ebf2efa62a07e33ed41595e4c4acd770a35d08bc
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	4	0xdf46e9c3366daeab194d5064120a2c1605fbb531	44352587	2022-08-06T16:24:16.000Z	378871614627761585	3358434603	0x8bbb144c4e3f3b1c51a1d0e77fd8f3c4800a055789bcd6dd1cb3b245a474ce29
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	4	0xdf46e9c3366daeab194d5064120a2c1605fbb531	44329691	2022-08-06T08:22:57.000Z	264501817948124965	2344717371	0x4f8dcdfd082f5083dfddd558c6e32a274b4ffd14d1d55da343f8c27bd2f72311

Example Query

Query with partition filter

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

iDAI_RepayBorrow_event

Loan repayment events for DAI borrows on Iron Bank v1 (Fantom), tracking payer, borrower, repayment amounts, and updated account and total borrow balances. Used for analyzing debt repayment behavior and protocol-level DAI borrow 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_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
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	0x386a3744bdd5710569469351baabac580bb65087	22	0x386a3744bdd5710569469351baabac580bb65087	39387246	22172963629855068586	2022-05-30T10:09:52.000Z	264715907214550584025421	0x247af51aa1d458da0e8959f81073682346fb1c5c831876fa553dcb2e3b45c77a	36176942756113078824
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	0x386a3744bdd5710569469351baabac580bb65087	16	0x386a3744bdd5710569469351baabac580bb65087	39387282	16279624391912233787	2022-05-30T10:10:45.000Z	264699636926106362783074	0x05a31f388f74740435d084c239689ea2f98f0018aba7ae25221c403ce80c97a7	19897319640082029279
0x04c762a5df2fa02fe868f25359e0c259fb811cfe	false	0x386a3744bdd5710569469351baabac580bb65087	2	0x386a3744bdd5710569469351baabac580bb65087	39387388	19897321480354577363	2022-05-30T10:13:04.000Z	264679764086289073392980	0x780f57b64138269fb840a7072d2e5ff38a1edfa3a9fcc1ab5173031534780ee9	0

Example Query

Query with partition filter

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

iETH_AccrueInterest_event

Interest accrual events for the Iron Bank ETH lending market on Fantom, recording changes in borrow index, total borrows, and accumulated interest. Used for tracking interest rate dynamics 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	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	23616319	91210776803456852378	1015676436990491170	2021-11-30T22:51:00.000Z	14433315413786369280	0xd1b6963d02f5ce54df71f4d2b3c447be83e767a22ef316c838c10ef355b73d0b	160151291408918
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	23563568	110327560412715037742	1015648536000126223	2021-11-30T09:50:33.000Z	14396212115793850878	0x3e9d5eecbd54f43fc8e9ef05c1b7cbfff50d2bcee2b78d2006ea339fab41d490	790893286326
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	23523141	82851193576789683462	1015625729678069719	2021-11-30T00:05:24.000Z	16723845292320613856	0x8f368094a96b469acfd915cb77077c4cff9bd50a19b28a39184f38645352dbcc	2112620865067

Example Query

Query with partition filter

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

iETH_Borrow_event

Borrow event logs from Iron Bank’s iETH market on Fantom, recording ETH borrowing transactions with borrower addresses, borrow amounts, and updated debt balances. Useful for tracking lending protocol utilization and individual borrower 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
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	15	0x0aa2ac7f8e89aae67ab58583b1a95676db4e73f3	28488421	2022-01-19T23:48:13.000Z	9000000000000000	27118927957035686021	0x0910cab26aa65622884ef858dfc930f891ef6a35bb521f5f7f95b6e820306bf4	972121255688448084
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	2	0x0aa2ac7f8e89aae67ab58583b1a95676db4e73f3	28488202	2022-01-19T23:45:33.000Z	17000000000000000	27109923003772774960	0x29a11c7e933ae4b9658115a1f6985306bac5c3b55b7384ffc8f6fda2dd37df59	963121079716280168
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	42	0x1684469ea0ef1db1db91da9524ba6022fdbd06e5	28430283	2022-01-19T09:50:35.000Z	136178460661207231	26166227612044889496	0xdbc805008ef6e63cfdb004a7fb3c2ffc70cb821d41f3b51f307dedadf434065f	1134624432783940913

Example Query

Query with partition filter

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

iETH_Flashloan_event

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	126860622462787540	307	0x5b4a4e8512ba616f5c4a68ffc5364ff10a7b5ac7	38058186738836	41103567	7611637347767	2022-06-22T20:35:07.000Z	0x06c4c54e693bd9985aef99eabbba7b9ef2a41674d512fe4cf1c63daeaf8f9ae5
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	151894044642030180	78	0x5b4a4e8512ba616f5c4a68ffc5364ff10a7b5ac7	45568213392609	41068038	9113642678521	2022-06-22T08:42:18.000Z	0x623df9fc1cce88c02f6eaa03ae0e5806b62f41c88cdfec5fde083563430ad948
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	127303245761273410	45	0x5b4a4e8512ba616f5c4a68ffc5364ff10a7b5ac7	38190973728382	41103910	7638194745676	2022-06-22T20:42:01.000Z	0xdf21146a6bc88f9bbf0c55d943d734564d2e76b7c72b249472a3c24739b0d6ec

Example Query

Query with partition filter

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

iETH_Mint_event

Mint event logs from Iron Bank v1’s iETH market on Fantom, recording when users supply ETH collateral and receive iETH tokens in return. Tracks underlying asset amounts deposited, iTokens minted, and minter addresses for analyzing supply-side activity and interest-bearing token issuance.

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
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	0x46020205abd2cd506e135d8f36db5c48d1c0183e	2	9998998	89800000000000000000	893913960341	2021-06-18T13:00:49.000Z	0x830845e1fabfe978dea443a5056ef6cb1c980f2113f55dc01bd12d3cbd8c6fd9
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	0x46020205abd2cd506e135d8f36db5c48d1c0183e	2	10000971	9600000000000000000	95563166312	2021-06-18T13:29:39.000Z	0xc70dfbfb1d829329b595b5b4726e7562c4acaed9e02bdcbfd7f2bce945a5c3e2
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	0x46020205abd2cd506e135d8f36db5c48d1c0183e	5	10000032	210000000000000000000	2090444374550	2021-06-18T13:15:59.000Z	0xbecb99e2a627aea7feb2df4690f2617803a595e773930d1b1fa623bb744d13ea

Example Query

Query with partition filter

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

iETH_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank ETH (iETH) market on Fantom, tracking governance adjustments to protocol revenue allocation. Used for monitoring Iron Bank’s risk management and fee structure evolution over time.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	1	2386259	2021-02-23T10:24:13.000Z	0xb15442ed8396a6638048e26de054ad497476c4ef5ee10983e61a93b58123ab01	50000000000000000	0
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	1	2667821	2021-03-10T06:59:26.000Z	0xd556e7bb6828dc646ad0be0769037536fec462f0a070f2ad7684e6fa884b8686	120000000000000000	50000000000000000
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	20	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	200000000000000000	120000000000000000

Example Query

Query with partition filter

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

iETH_Redeem_event

Withdrawal events from Iron Bank v1’s Ethereum interest-bearing token (iETH) market on Fantom, recording when users redeem iETH tokens for underlying ETH. Tracks redeemer addresses, amounts withdrawn, and corresponding iToken quantities burned for analyzing lending pool 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
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	23	0xee6256f9dcb69170231220a6549916d919b72f14	66311271	2023-07-26T08:12:39.000Z	6429622614133729699	61519624672	0x04568b44b301fe3feb7ddc0886a21b2f6ac57b09c72725cfb7806841259a389a
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	3	0xf5bf3b7b7d03efd34ba1e1bcf1694080975d8a1c	11877890	2021-07-12T06:52:21.000Z	200990092	2	0x335cc9250cab349d5a182c44cce51f1cd2f71da50c52d0e7b8fff94deda62b19
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	3	0xf5bf3b7b7d03efd34ba1e1bcf1694080975d8a1c	11877812	2021-07-12T06:51:13.000Z	290821282104309800	2893886747	0x1fcf35151873a6d157fa96e4e0c41369d325eb57b6e1946ff10ae3fee370a521

Example Query

Query with partition filter

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

iETH_RepayBorrow_event

Debt repayment events from Iron Bank v1’s iETH market on Fantom, tracking ETH-denominated loan repayments with payer, borrower addresses, repayment amounts, and remaining account/total borrows. Used for analyzing borrowing activity, liquidations, and debt management behavior in Iron Bank’s isolated lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	0x308040f38ed1141c24f93b4d4a16f9f26f70a2f0	30	0x308040f38ed1141c24f93b4d4a16f9f26f70a2f0	11115321	929743700	2021-07-02T05:29:51.000Z	21992873703664392093	0xaf18161a17f0817abfd6c85592f386cb39de3a0f34710d332bb1ae30b39d52dc	0
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	0x8fcfc4d481555d9b99b114e6ef237ad1ebdc222e	2	0x8fcfc4d481555d9b99b114e6ef237ad1ebdc222e	11150130	29578356526964890	2021-07-02T15:55:55.000Z	21963512355357809992	0xa9d4cd6ae4c17e3c04a9ab87f25848ba092d0cb8d1a58e882e5e130cf85743fb	0
0xcc3e89fbc10e155f1164f8c9cf0703acde53f6fd	false	0x29228c716d254cdef752ad30e5f96c7ccec10541	2	0x29228c716d254cdef752ad30e5f96c7ccec10541	42859330	320783354604788059	2022-07-16T02:57:37.000Z	18353389703869867558	0xba84b469ce90a3676af43e98c6db7fadd15a6c50496dc5c9540a1752c4039cd5	5579361635891692493

Example Query

Query with partition filter

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

iFRAX_AccrueInterest_event

Interest accrual events from Iron Bank’s iFRAX (FRAX stablecoin) market on Fantom, recording periodic updates to borrow index, total borrows, and accumulated interest. Used for tracking lending pool performance 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
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0	30332056	76165945200526297259983	1001878783847805332	2022-02-08T04:46:46.000Z	66825293509873347151672	0xd856a49e9c9dfceb8136753edc762e0566c2c163c5076d215f960781f00fbf06	818102420631775258
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0	30323815	458820520925510331815309	1001865824691391631	2022-02-08T02:49:48.000Z	66824429134417006977796	0x486d8c723f7ea7f91924c946b2933aee51bf36edd115592aa8271078427a6a23	140562956916285959
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	3	30395423	48950220059263050249173	1002008064287214123	2022-02-08T22:01:24.000Z	66833095146492146785417	0xe6c266a8a86ae889aea59e6e1b6ddd06412cfb8578ecf50fa1f77235b5c0e8b9	1214682730494853085

Example Query

Query with partition filter

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

iFRAX_Borrow_event

Borrow event logs from Iron Bank V1’s iFRAX market on Fantom, tracking when users borrow FRAX stablecoin with amount, borrower address, and updated total/account borrow balances. Used for analyzing lending activity and debt positions in the iFRAX money market.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	15	0x1b6617959114a29d97e1ab8949ebc78ea804275e	45847684	2022-08-28T07:23:19.000Z	120000000000000000	2184138114716778511533	0x7a363f7c3e3160e5daf9f7ec476fcc3df6e2c998df33d0318be8ec1d4e52a059	120000000000000000
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	25	0x24a9bac9be61ca40f0a5fb4f7452a90ed212b893	29668278	2022-02-01T09:19:59.000Z	1000000000000000000000000	3066488744417756857664763	0x3f06a7260b8df95868434a76c0bd90efe26776ec120e4e43055e392d8386a3ff	1000000000000000000000000
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	2	0xe53ab209a541c969cd979223d347f5000b6fa3d8	29694907	2022-02-01T15:38:29.000Z	165613785296057233069	2091494250676844999878571	0x71eca5d6830366e03f08f4b7926c2f875c8bdde4d284a91a641244c801d6bbaf	3423306551986941564688

Example Query

Query with partition filter

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

iFRAX_Flashloan_event

Flash loan events from the iFRAX (Iron Bank FRAX) market on Fantom, capturing uncollateralized borrows with loan amounts, fee breakdowns (total and protocol reserves), and recipient addresses. Used for analyzing flash loan usage patterns and fee generation in Iron Bank’s FRAX lending pool.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	359400372014424000000	56	0x90491ee926576425e897e98159855d9c1c519be6	107820111604327200	39538394	16173016740649080	2022-06-01T11:20:54.000Z	0x46e28d9c906115004341f20573886edb58e926b8e67f720cb3dd86a42ac57fe3
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	448551448551448600000	80	0x90491ee926576425e897e98159855d9c1c519be6	134565434565434580	39516702	20184815184815187	2022-06-01T04:31:24.000Z	0x163890ce5b5ae54ee70b460d5f3f3e701ed0332b50579b2787ef0eb4ced1d294
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	373626373626373660000	55	0x90491ee926576425e897e98159855d9c1c519be6	112087912087912098	39508332	16813186813186814	2022-06-01T01:56:24.000Z	0x5046caaa47b3f97b75b165d3d6457420c84898b6e6291a31f66fc5aef3332a60

Example Query

Query with partition filter

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

iFRAX_Mint_event

Mint events from the iFRAX (Iron Bank FRAX) lending market on Fantom, recording when users deposit FRAX tokens to receive iFRAX interest-bearing tokens. Tracks minter addresses, underlying token amounts deposited, and corresponding iFRAX tokens minted for analyzing Iron Bank V1 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
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0xa8a693105e49489fcd0c588894079830e7288853	39	33358226	2265902983784516075990	22506548861755	2022-03-14T00:50:29.000Z	0xf866762b3af61ebb498c008346f244dcf3f6e7ac37c18f05e49fab12a2848310
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0x55f1af8f42775500a4b9355370caa562da8ede51	5	33362190	49969693658138805536269	496327689103006	2022-03-14T02:18:47.000Z	0x81985514c85cb90c9e5dec2e48fac29ffbd7d392caa84701bcd47f7e43cf5662
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0x061a9d627028fe708e1b77e591b9bdf41392d4ba	26	29128027	35112657883349260000000	351054353700992	2022-01-26T20:13:29.000Z	0x2dd910d1021dbdb34a730175cf361f0d0474688e4917d809c62598e5d309a9c1

Example Query

Query with partition filter

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

iFRAX_NewReserveFactor_event

Reserve factor parameter changes for the iFRAX (Iron Bank FRAX) lending market on Fantom. Tracks protocol fee adjustments where reserve factor mantissa represents the percentage of interest allocated to protocol reserves (e.g., 100000000000000000 = 10%).

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
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	9	28621879	2022-01-21T07:30:31.000Z	0xfca7c74def7b69fa9f4cc97c542c9c47d0a212ed8adabfee0ecf32ccaeecbd73	100000000000000000	0
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	24	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	150000000000000000	100000000000000000

Example Query

Query with partition filter

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

iFRAX_Redeem_event

FRAX token redemption events from Iron Bank V1 lending protocol on Fantom, tracking withdrawals where users burn iFRAX interest-bearing tokens to receive underlying FRAX stablecoins. Used for analyzing supply changes and user withdrawal patterns in the Iron Bank lending market.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	6	0x852e1c40a8d46a99aece0413be0964a2b0a5da56	28749214	2022-01-22T19:01:11.000Z	1000000000000000000000000	9999976333727227	0x16a057d32ad9de81b841d7e6a1befcf092ae5a13cc0471799667d1df29dcc3c1
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	6	0x44c929a028f74ffda0225207164a51a6d49a37ff	28746945	2022-01-22T18:29:26.000Z	102748973247531581387614	1027487641525660	0x76f4a57d3ceb003820d0c8ff1e8491ef5381dd10ecd056b24e03b41fcca6761f
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	6	0x0a5fb8fe3e08bfd43c67581433850271dc2648d0	28762285	2022-01-22T22:15:14.000Z	9073187278535570228670	90731584887322	0xb429a3e5a685fe45499a952dfda3a30baf3d579515972818b46c3f910a97fd89

Example Query

Query with partition filter

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

iFRAX_RepayBorrow_event

Borrow repayment events from Iron Bank’s iFRAX market on Fantom, tracking FRAX stablecoin loan payments with payer, borrower addresses, repayment amounts, and updated account balances. Used for analyzing lending protocol activity and borrower repayment behavior.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0x63712c2f30f48ff20beb3837578071b70cea9f07	184	0x63712c2f30f48ff20beb3837578071b70cea9f07	44241882	93216945961912571073	2022-08-05T01:15:55.000Z	912307387137861684935	0x261eb4b4aa492a216277145c0b1b6098d3769e44d440f9237da59d9b876483ea	0
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0x74013f2ff427df8fd23402b18a4769ab096a1ab3	3	0x74013f2ff427df8fd23402b18a4769ab096a1ab3	30722588	2518277329768258211370	2022-02-12T07:47:09.000Z	61879105302967787505505	0x6111475b316931bccd08b80ed8cc64241d38265570372f7f4f8ce3727507632b	2621064715465506833047
0x2919ec3e7b35fb0c8597a5f806fb1f59c540eab4	false	0x74013f2ff427df8fd23402b18a4769ab096a1ab3	4	0x74013f2ff427df8fd23402b18a4769ab096a1ab3	30723414	2613000000000000000000	2022-02-12T07:58:04.000Z	59266228794309502040533	0xe499cbd8700805a12db9af58fbd89e0e9899b4e4862be6c790ee09d896785277	8069946290950228460

Example Query

Query with partition filter

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

iFUSDT_AccrueInterest_event

Interest accrual events from Iron Bank’s iFUSDT (Fantom USDT) lending market, recording periodic interest calculations including borrow index updates, cash reserves, total borrows, and accumulated interest. Used for tracking lending pool performance and calculating historical borrow 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_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
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	40767444	88800801508	1081435293122055836	2022-06-18T05:27:46.000Z	81935469303	0xc96e7ed6848499174253cd73d332bcad7f77977cf96d55853c2df7b5db56ad1e	27661
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	40798320	46116235543	1081533093306135931	2022-06-18T15:55:02.000Z	81942879167	0x5df24636b01a278ba76749dc5d71b6bd45157aa80c7fc030aa4d185158d76087	1058855
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	40767329	80742173287	1081434928028472449	2022-06-18T05:25:06.000Z	81935441642	0xf3b85e2a7476579d7de3e0a7e9c7de7423000ca4785b74cf7c98f836a1035def	38412

Example Query

Query with partition filter

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

iFUSDT_Borrow_event

Borrow event logs from Iron Bank’s iFUSDT market on Fantom, tracking individual USDT borrow transactions with borrower addresses, amounts, and cumulative account/protocol borrow balances. Used for analyzing borrowing activity, individual position tracking, and protocol utilization metrics.

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
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	3	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	41731054	2022-07-01T01:37:13.000Z	6033538	113396062649	0xea189aec0d364df48ec3b1ac50180b0c9bac479f248353697fa7c3805b117fe3	86273911097
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	5	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	41731054	2022-07-01T01:37:13.000Z	155000000	113551062649	0xea189aec0d364df48ec3b1ac50180b0c9bac479f248353697fa7c3805b117fe3	86428911097
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	5	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	41731130	2022-07-01T01:38:31.000Z	768000000	114319095941	0xb1ab4a8bc82da40f66d2cf3b782f2440a6b085312c5d652b144663ca56b80e3a	87196937487

Example Query

Query with partition filter

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

iFUSDT_Flashloan_event

Flash loan events from Iron Bank’s iFUSDT (Tether) market on Fantom, recording borrowed amounts, fees charged, and recipient addresses. Used for analyzing flash loan usage patterns, fee generation, and protocol reserves accumulation.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	6640	27	0x826d0995f07148cb748fbbc8ec2d4c4cfd6b4505	1	23426831	0	2021-11-29T00:32:54.000Z	0xa22f6ad50bdbca250861357c7a5d38c91fb9add7d5cff87db09e4a51d2b1bbbf
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	18232	40	0x826d0995f07148cb748fbbc8ec2d4c4cfd6b4505	5	23482465	0	2021-11-29T14:18:46.000Z	0x2e80ee94ebf7700d803a08078675c222d31b9f7d439b00a50261e42f25c87405
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	1000000	65	0xc95010e2cd73e5f14b74b970a42eae24ffd31da5	300	23624948	30	2021-12-01T00:52:53.000Z	0xe97350e1b0ccdb93c9f6242d9f531b7a49676ba6c933399dc7df40e99fce4a92

Example Query

Query with partition filter

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

iFUSDT_Mint_event

Mint events for Iron Bank’s iFUSDT interest-bearing token on Fantom, recording when users deposit USDT collateral and receive iFUSDT in return. Tracks depositor addresses, underlying USDT amounts, and minted iToken quantities for analyzing lending market supply and user deposit behavior.

Columns

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

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	0x0db3dbd610cb235bb4858660aa1823c664661aa4	4	48596471	11645954187	108784458853779	2022-10-07T02:21:03.000Z	0x0ed322a929d9c46252f5a752fb840f21a8e291b05db64aa87632ff809e8e38f9
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	0x4fc8d635c3cb1d0aa123859e2b2587d0ff2707b1	4	48601058	500105504	4671453719345	2022-10-07T03:49:16.000Z	0x20f4d3e2953c3c344f00894bc3b50822af5e0a2a822ee71ee4d106807c18c784
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	0x4fc8d635c3cb1d0aa123859e2b2587d0ff2707b1	5	48598396	73105468	682874758962	2022-10-07T02:59:30.000Z	0x4891b7484e7d49a8d194b7a32f9b4caaea098e570b293189b72c394eeb4aef97

Example Query

Query with partition filter

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

iFUSDT_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank USDT market on Fantom, tracking protocol revenue allocation adjustments. Used for monitoring governance decisions affecting the percentage of interest reserved by the protocol versus distributed 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_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
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	16	17084056	2021-09-15T10:43:45.000Z	0xb96f1a876bb80f30c469766eab0dbb5b0f0ff8ded700a400119cf475bc9db49f	100000000000000000	0
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	18	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	150000000000000000	100000000000000000

Example Query

Query with partition filter

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

iFUSDT_Redeem_event

Redemption events from Iron Bank’s iFUSDT lending market on Fantom, tracking withdrawals of underlying USDT from the protocol in exchange for iFUSDT tokens. Used for analyzing user withdrawal behavior, liquidity flows, and interest-bearing token redemption patterns.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	132	0x0f0fa4edec62dc8b86889615d2eb97010c0e879c	49792572	2022-10-22T22:55:31.000Z	116004245	1082786708017	0xc7a53d9e04365dd9713c6b17f8caafa5b1f33cec96ce2e385a507ca201bed8d2
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	11	0x4fc8d635c3cb1d0aa123859e2b2587d0ff2707b1	49762121	2022-10-22T12:40:32.000Z	117043128	1092497455923	0xb96ffd60a7d802b4523a5ea627f8bf108ebb472428090e6ae88b8138cf357f5f
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	36	0x37953683f1699a4446d0bd0769dee74dce3aad77	43742898	2022-07-28T18:58:17.000Z	3918610	36988015147	0xace9dfefb8b6dd71a39258f41e278daec2f732f2526f21e54044897bf934e818

Example Query

Query with partition filter

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

iFUSDT_RepayBorrow_event

Borrow repayment events for the iFUSDT (Iron Bank fUSDT) market on Fantom, tracking repayment amounts, payer and borrower addresses, and updated borrow balances. Used for analyzing debt servicing patterns and liquidation avoidance behavior in Iron Bank lending markets.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	0x0afab77e0c3bccb91529eed6aff66f7cb1abbac8	23	0x0afab77e0c3bccb91529eed6aff66f7cb1abbac8	31535540	2825638460	2022-02-20T17:18:00.000Z	1496860536597	0x97139937aa72f11ab8c6211371f4e2da6292913489a138f5ffc330709dc8d513	2481630344
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	0x2383dda1c0d92a2c06254b39d5878cfaab81764b	32	0x9f903780044088e5540191c52af6e9ea2283c37d	31492086	1240480234	2022-02-20T06:18:33.000Z	1412423745537	0xb039356ab56b463bc6026188810bb142b575937aee805be7068163e655d79f7c	1240480259
0x70fac71debfd67394d1278d98a29dea79dc6e57a	false	0xe9bbedc8bde995779081130a3434de3ef3840200	2	0xe9bbedc8bde995779081130a3434de3ef3840200	31551026	12	2022-02-20T21:03:58.000Z	1496694240781	0x2d69dcc764068f06907cb49594a50f35ca4d078584ce4590b5fc42a5310ece6d	0

Example Query

Query with partition filter

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

iLINK_AccrueInterest_event

Interest accrual events for the LINK market on Iron Bank V1 (Fantom), recording periodic updates to borrow index, total borrows, and accumulated interest. Used for tracking lending protocol interest calculations and borrowing cost analysis.

Columns

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

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	16094108	15019723286712957705280	1020159676731111183	2021-09-01T20:34:20.000Z	213643604280683637584	0x3e5839c711d2a40063c0a7825cfb53fdcd87a8b4b8327295fe4b6e8f7e2b165f	221179417582568
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	16071390	13877796907111120021589	1020156837810084840	2021-09-01T14:13:02.000Z	1388643631748745796631	0x54b636a0131dee1b2f4ab009dc147371f3228d703450f243d5338b867b72eace	165828836925702
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	16074747	14587798452944210844575	1020157883420716568	2021-09-01T15:18:20.000Z	678643361666179676834	0x72136bf38e987672287bdab9abf609ff408f02d0c71cf5c1d2ef8c0da71a58a7	37501393074191

Example Query

Query with partition filter

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

iLINK_Borrow_event

Borrow event records from the iLINK market on Iron Bank v1 (Fantom), tracking Chainlink (LINK) token borrowing activity with amounts, cumulative borrows, and borrower addresses. Used for analyzing lending protocol utilization, user borrowing patterns, and LINK market dynamics on Fantom.

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
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	10	0x9b6a1051286a1cb79cc951b3d6a045c342d0a2a9	14903945	2021-08-18T14:02:55.000Z	50000000000000000000	371335777367680283630	0x393b295140dcc01819be752203a59ccb312de57fb1fe5973e0f41206a6cbb9d8	350000092706935743698
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	4	0x9b6a1051286a1cb79cc951b3d6a045c342d0a2a9	14903706	2021-08-18T13:57:38.000Z	300000000000000000000	321335678067526754308	0x66d20ef788efcb0c11ae41e6316b35b577a47baeede12d34310e9451e932b976	300000000000000000000
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	22	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	43292082	2022-07-22T06:53:34.000Z	6691779237086033	404401361196577726612	0xaea9836eea7bb7621b9eaf3ba9e45ed34f4030b96602990f335c0675ab347f8e	1578545358149308941

Example Query

Query with partition filter

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

iLINK_Flashloan_event

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	1104712612768841642	157	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	331413783830652	15850152	66282756766130	2021-08-29T21:17:55.000Z	0x23ffc1ca69f2b99e76f08d02b70c33672fd11da4821b6d7da0ccae6eb77554d2
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	9260762608114849	19	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	2778228782434	12485550	555645756486	2021-07-20T01:28:32.000Z	0x6584d81bbbde7ce7ac8ee5530d7fbbee390514a231ab80e8456703729f0f49f2
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	32403014289506051903	56	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	9720904286851815	15328386	1944180857370363	2021-08-23T16:25:08.000Z	0xc76731a83719358f3283932c395918bf5ea73c4fa459f16e9c120fc5520cb0b6

Example Query

Query with partition filter

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

iLINK_Mint_event

Mint events from the Iron Bank v1 LINK lending market on Fantom, recording when users deposit LINK tokens to receive interest-bearing iLINK tokens. Tracks minter addresses, deposited amounts, and minted iToken quantities for supply 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_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
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	0x281e14848321738fec3afcff52163d7cc1c1e7b9	37	30336595	222966896688080767758	2192451453670	2022-02-08T06:23:51.000Z	0xdce19bbc00899b6b1ed42e3ac326b763d12b0f9236321498fd462c17367c2ef0
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	0xb4e92d96bb76101c2e6d6dfa73ae6553cd2d9eff	4	30351161	82439019673110424	810609012	2022-02-08T10:40:04.000Z	0x8e8b6502b3946b41884028a6fd5d6a93a5cd2036dd4c594370ca3103af3197a2
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	0xb4e92d96bb76101c2e6d6dfa73ae6553cd2d9eff	41	30337989	12000000000000000000	117996607042	2022-02-08T06:54:37.000Z	0x748071c5bfe7fc37cb7a6b07f02494a37d2bb7883b87ab265d2e60d753d86eff

Example Query

Query with partition filter

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

iLINK_NewReserveFactor_event

Reserve factor parameter changes for the LINK market on Iron Bank v1 (Fantom), tracking protocol fee adjustments where reserve factor determines the portion of interest allocated to protocol reserves versus lenders.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	1	2386828	2021-02-23T11:06:41.000Z	0x145fa33a90f3a417e670f283cb12a182529da36c3585998138d9afdb8c507665	50000000000000000	0
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	1	2668819	2021-03-10T07:40:16.000Z	0x5f4142efe8acdbdfe1724662dd19c6561d8567626957906b72bbc5e3bd970a54	200000000000000000	50000000000000000

Example Query

Query with partition filter

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

iLINK_Redeem_event

Redemption events from the Iron Bank v1 LINK lending market (iLINK) on Fantom, tracking when users withdraw their underlying LINK tokens by burning interest-bearing iLINK tokens. Used to analyze lending market outflows 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
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	4	0x18f768455e7f5fb09fc491fd86bcc282bcdd5973	7230857	2021-05-22T04:51:12.000Z	777020814682524994876	7683539345452	0xd9617e4498fb21eb836848c36848f8a20dae5583c018d0738fa36b071eca5df8
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	50	0x4224b936b097d6b87cc5d90cf80e96c303175db2	32077093	2022-02-27T05:53:56.000Z	44369656930508069015	436022861516	0x54cd439bb9316ecda6599c69582096c49f12fd48cad50525b01d82f312805106
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	270	0xe472118b26f6e64913a121c58bfd6a3f72e68c0f	50846335	2022-11-14T04:37:12.000Z	299965811756924890	2913102088	0x7c3b2a86c4c0c623b62ec3495ed0dec6b321c739343664f83ef861f773291fd1

Example Query

Query with partition filter

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

iLINK_RepayBorrow_event

Borrow repayment events for LINK on Iron Bank V1 lending protocol on Fantom. Tracks repayment amounts, borrower/payer addresses, and updated account and total borrow balances for analyzing loan 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
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	0xca6fe0469ccb6c852b027a5965994f5cfe531c66	27	0xca6fe0469ccb6c852b027a5965994f5cfe531c66	17968531	501037873314793287308	2021-09-30T03:51:02.000Z	290536353231652284810	0x349cdba284cf2858e2dcbd4519616fd1e3644ef3bd4d3802d88f90493284a3f0	0
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	0x207ec3c3bcc212a5d672677764c0a28d5aba7ddb	9	0x207ec3c3bcc212a5d672677764c0a28d5aba7ddb	17310863	328412533560636	2021-09-19T17:27:02.000Z	988643309841928956476	0x4af9a585deb8a396fc9fec9860ae1f16c3425679b2c8c6bedb7ad3b7796c15c7	0
0x4eceddf62277ed78623f9a94995c680f8fd6c00e	false	0x207ec3c3bcc212a5d672677764c0a28d5aba7ddb	140	0x207ec3c3bcc212a5d672677764c0a28d5aba7ddb	17307309	1000038517671688638979	2021-09-19T15:59:55.000Z	988632681260553827348	0xed05190fb69c2ba54be1edb7f2099c34e8f2675a6ada7c2c3519b84a5157a75a	328408893812207

Example Query

Query with partition filter

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

iMIM_AccrueInterest_event

Interest accrual events for the iMIM (Iron Bank MIM stablecoin) market on Iron Bank v1 (Fantom), capturing periodic updates of cash reserves, total borrows, borrow index, and accumulated interest for analyzing lending pool economics and borrowing costs.

Columns

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

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	22549683	13208871661257664941090	1025046739984971184	2021-11-19T22:34:15.000Z	86393282037178233572930	0xb7925a485c2d3cfd4df10c40c8c7465e9baeb7bf438045714907d5072d0a90df	190603936046701400
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	22523949	9122757896636430252552	1024958513213630432	2021-11-19T16:13:02.000Z	87342085461873129704747	0x7011e1a68d0c10b0d505343abf21c597c8bd5c3a34ba3abf93c80c0e4ca1b485	51779045755400277
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	22487291	10574581141913507810176	1024526011798796280	2021-11-19T06:59:40.000Z	86606854167352335685782	0xf902a436683aae81fe54a9f3a9db877924a75fad7c41e9513bad0597bd91e3b3	50839204165812807

Example Query

Query with partition filter

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

iMIM_Borrow_event

Borrow event logs from the Iron Bank v1 iMIM (interest-bearing Magic Internet Money) market on Fantom, recording user borrows with amounts, account balances, and total protocol debt. Used for tracking lending activity and individual borrower positions in the iMIM lending pool.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	2	0x07759bfb542723b5a89c5a927720bb8c299cd206	19196374	2021-10-15T22:47:22.000Z	160000000000000000000	143058685973311286650799	0xd8dde540a3a3b1cfe25e7421d3c42268fb5882588f35eeb7c7ece37082c45d74	160000000000000000000
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	55	0x0ce1d4fbbd736cd3eeeb380b36ee47ab31da2d5e	19136186	2021-10-15T05:44:01.000Z	8000000000000000000000	104922100557786197023744	0x0272949bb404b6a2159d64bf692e358932adf1b16ac1faa4182f04a143926e1a	8000000000000000000000
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	4	0x0ce1d4fbbd736cd3eeeb380b36ee47ab31da2d5e	19137747	2021-10-15T06:12:50.000Z	8000000000000000000000	104922571189340177481352	0xa83deb13e574dbe409344bb19ce94e2ae8b6613c8134d2b2a8ed987c1ee926e4	8000000000000000000000

Example Query

Query with partition filter

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

iMIM_Flashloan_event

Flash loan events from Iron Bank’s MIM (Magic Internet Money) market on Fantom, capturing borrowed amounts, receiver addresses, and fee breakdowns. Used for analyzing flash loan usage patterns and protocol fee generation.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	123441426541311730000	79	0xd499244f3d8b02e79b3fe7928ca6c3b0f1162d48	37032427962393519	43212436	3703242796239351	2022-07-21T03:29:30.000Z	0x9a79dbaf0dcff32afa425cb2c97c2ff4ba2f0b87143070950442479575c5b6d5
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	103022561941065090000	75	0xd499244f3d8b02e79b3fe7928ca6c3b0f1162d48	30906768582319527	43215027	3090676858231952	2022-07-21T04:22:36.000Z	0xc4c2c06eb2dacee2c64f29c7963543959a14127f6a679c0e24504d0a33372e9a
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	115194102061974430000	42	0xd499244f3d8b02e79b3fe7928ca6c3b0f1162d48	34558230618592329	43228064	3455823061859232	2022-07-21T08:51:47.000Z	0x0ef7693da74991cec6c697d7519a2974b778cbf927130e75116641c1c2b7bc89

Example Query

Query with partition filter

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

iMIM_Mint_event

Mint events for the Iron Bank MIM (Magic Internet Money) interest-bearing token market on Fantom, recording when users deposit MIM collateral to receive iMIM tokens. Contains minter addresses, underlying deposit amounts, and iToken amounts minted for tracking supply changes and lending 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
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	0x9ed570c2665f7ca7eb48d1b87cb3f3347b64fe31	21	40973457	414351014512316779	3958414854	2022-06-21T01:20:24.000Z	0x0011cb48f2dbf73544ce7dc265296ded810913dfd8bc7a675a8cd0fdcdbf33e9
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	0xd940d9a6f3654f35d49d9f1b5213748ef0c4819e	3	55116836	18304838109643563978	169851227425	2023-02-05T06:28:00.000Z	0x2389fe7f73817b0d5f122c09cdd06892dda3bdb21683a60cbc834105e66fc85e
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	0x497831f4f242b1caf7ffdc494f731217ac658a17	54	18841730	403682202108289556106	4024928943267	2021-10-11T15:55:31.000Z	0x2e3aab2530a06b51320437ce2fcaaf72c0d44e35c7659cadd6f4e669ad27bdd2

Example Query

Query with partition filter

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

iMIM_NewReserveFactor_event

Reserve factor configuration change events for the Iron Bank MIM (Magic Internet Money) lending market on Fantom. Tracks adjustments to the protocol’s reserve percentage, which determines the portion of interest allocated to reserves versus 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_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
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	113	17790172	2021-09-27T10:54:31.000Z	0x9c894d13fe222b2a58c6f6cf679d5378edb0485a918480014c936da0939acfe8	100000000000000000	0

Example Query

Query with partition filter

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

iMIM_Redeem_event

Redeem events from Iron Bank’s iMIM (interest-bearing Magic Internet Money) lending market on Fantom, capturing withdrawals of underlying MIM tokens in exchange for iMIM tokens. Used to track lending supply reductions and calculate vault utilization rates over time.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	34	0xd251bc79f4fa7b8af45e7a6ade342b0a34ab1511	53955855	2023-01-18T00:46:13.000Z	95354571366818863	889096469	0xcfe42d1c5d0175b61242d51505c846bc3d83fba21a9d6ca1acc3c7cb6b624595
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	4	0xd251bc79f4fa7b8af45e7a6ade342b0a34ab1511	54002411	2023-01-18T20:53:51.000Z	95241598518379382	887990859	0xadf54c7b32ba6fae718dd4013905ee8515a614a6a584e9b81114f6d0e8536f1f
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	28	0xd251bc79f4fa7b8af45e7a6ade342b0a34ab1511	53975305	2023-01-18T08:50:18.000Z	95467959684641927	890132725	0x2450a533fd8c08831f2ea09151541589d75765b6a314e1cbf70cb5f0170587fb

Example Query

Query with partition filter

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

iMIM_RepayBorrow_event

Borrow repayment events for the iMIM (Iron Bank Magic Internet Money) market on Iron Bank v1 Fantom. Tracks borrower addresses, payer addresses, repayment amounts, and updated borrow balances for analyzing lending activity and liquidation prevention.

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
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	0x069f9f1fa133812171ca2653833978350e6857e1	107	0x2d1aac304f3aa27aa89a184e9e734bc9c7ca901d	38649119	612218267006517141	2022-05-20T09:17:09.000Z	125041053878323199897462	0x980742aa7a2f705615f1987603997435e143e711ce5781d02273ac22f25de327	612218269653817813
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	0x3bb5fc4aaea6df4c98afd26f1059e7232fe729d7	29	0x3bb5fc4aaea6df4c98afd26f1059e7232fe729d7	38621980	1300000000000000000000	2022-05-20T00:37:01.000Z	125036230951280450979451	0x5fc6a4a6eaa1dfa755bc762ee3f6b041febb1b8f1a646963aef443465abcd66d	8700001818504486984399
0x46f298d5bb6389ccb6c1366bb0c8a30892ca2f7c	false	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	35	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	38653054	896962386475010734989	2022-05-20T10:34:18.000Z	124144720171249499963952	0x94b697a3495fb1710da95eb36caaf5b0072d394cecd4df87c69a86c3220f8979	66493604461307219554438

Example Query

Query with partition filter

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

iSNX_AccrueInterest_event

Interest accrual events for the Iron Bank SNX (Synthetix) lending market on Fantom, recording periodic updates to borrow index, total borrows, available cash, and accumulated interest. Used for analyzing lending market dynamics and interest rate calculations for the SNX collateral market.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0	24453989	1173544798811858458720	1090380724611298923	2021-12-09T12:42:42.000Z	792577486256670915558	0xe13000f1c02530134e83b0cca0ea342864072921be2025c4347b5767c63d4784	183325088589655632
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0	24455097	1172355756984110879732	1090384999656017943	2021-12-09T12:59:04.000Z	793770150277224832732	0xd38575de830e1a17757ab3c361763631ace9a4a2d31cd3ddd69c17bb110c181f	870489960425230
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	2	24454774	991734714850147158388	1090383803882663570	2021-12-09T12:53:47.000Z	974390321921228128846	0x9fadd9142808b562dad6209208224e0548bfe643d963ad9a3dad48af36bea2ac	2751702845912956

Example Query

Query with partition filter

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

iSNX_Borrow_event

Borrow event logs from the Iron Bank V1 Synthetix (SNX) lending market on Fantom, tracking loan originations with borrower addresses, amounts, and cumulative debt positions. Used for analyzing borrowing activity, utilization rates, and individual account leverage in the SNX money market.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	8	0x6de96fe55924af3042f218845a39fdc77d6c25fe	28838716	2022-01-23T17:36:57.000Z	300000000000000000000	639907288357162292409	0x0ef22503b1605be6dc89ed5f4612f004969dec6199025bf1ef6e9a2f7300adaa	300000000000000000000
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	9	0x0ce1d4fbbd736cd3eeeb380b36ee47ab31da2d5e	19507668	2021-10-19T14:15:50.000Z	700000000000000000000	1057991819476738987877	0xc8affe57f8b34afed1b1c30801e9515e2e7b0f313ed0b21bfe8d8d8e49e2fef6	700000000000000000000
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	2	0x49e55a0edd1c8fdea2baf3851fff54c4a52f49c1	20567369	2021-10-30T17:06:28.000Z	10000000000000000000	207862280143264813060	0x899e9a4f713273b34225517f387c02440a55b21c69ca4061ca7917d418948664	17526688142096525546

Example Query

Query with partition filter

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

iSNX_Flashloan_event

Flashloan events for the SNX (Synthetix Network Token) market on Iron Bank v1 deployed on Fantom, capturing uncollateralized loan details including borrowed amounts, fees, and recipient addresses. Used for analyzing flashloan usage patterns and fee generation in the Iron Bank lending protocol.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	8651704976809301729	16	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	2595511493042790	14496886	519102298608558	2021-08-13T12:15:37.000Z	0xe87ead5d4421861fef9890d87a23d11586193e637e0bd30d5b1fa2c05f236c78

Example Query

Query with partition filter

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

iSNX_Mint_event

Mint event logs from the Iron Bank iSNX (interest-bearing Synthetix) market on Fantom, recording when users deposit SNX tokens to receive iSNX tokens. Tracks minter addresses, underlying asset amounts, and iToken quantities issued for analyzing lending market supply and user deposit behavior.

Columns

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

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0xd6288ea8531e869b9c15da603a259e04804c1b14	4	27917965	500690823807025418242	4634109999418	2022-01-14T08:44:39.000Z	0xef7e3747258154fba2fc00cbd329edd4fc81bb45c7a4d295c7c6241f31bb5288
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0xbf2d4f7bcafb6111fcdeaaa6c1fa680d084dc0c1	65	27954503	22576387151611016984	208953776658	2022-01-14T17:31:17.000Z	0x56a863fcce878362312fb029a2210105cee3d1635560fc446110cd71025b2667
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0x525b41c72c4ea3af9fbd47ac8e9f1ac87364908a	37	27892021	2000218375379532118760	18512924044257	2022-01-14T02:31:04.000Z	0x91fb5458ebbc086202c3a1951b50f18ff8baf5b2898a5df9e53cd7909fda01b8

Example Query

Query with partition filter

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

iSNX_NewReserveFactor_event

Reserve factor changes for the SNX (Synthetix) lending market on Iron Bank v1 (Fantom). Tracks protocol fee adjustments expressed in mantissa format (18 decimals) for analyzing revenue distribution between lenders and the protocol treasury.

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
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	1	2668825	2021-03-10T07:40:52.000Z	0x935b5fcae4fd1f5654d07e7ae8aff1b5ea667042a35dce45b5c76a783d074cc0	200000000000000000	50000000000000000
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	1	2386858	2021-02-23T11:08:46.000Z	0xf21f18a1b1aa65b900404917f08096d4d5fd892f5e5f9d1950edddf0d591de08	50000000000000000	0

Example Query

Query with partition filter

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

iSNX_Redeem_event

Redemption events from Iron Bank’s iSNX market on Fantom, tracking withdrawals of SNX (Synthetix Network Token) collateral in exchange for iSNX tokens. Records redeemer addresses, underlying asset amounts, and interest-bearing token quantities 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
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	72	0x87fc1313880d579039ac48db8b25428ed5f33c4a	27373508	2022-01-08T16:25:53.000Z	70272715318970496780	650872609692	0x001c79d9c66598c11aa49c7373d85525dfbefc5415a74841835381203611b679
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	13	0xc98f549c414fa73a956a8b50612b62a465bf398f	27368076	2022-01-08T14:46:33.000Z	11089628403400393738	102713999868	0x411f3b5a6961c8c5c0072813828294c81fa57cc994ed08a09c58381b4f79c723
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	3	0x586e572fd9f29627706fc55a1f0168aaaa4d8ffd	14087181	2021-08-08T09:45:23.000Z	32996843351984869047	307806512439	0x6ca3b2bccc213e441c31ff28bc60eff295dd1b0e37564d1251853d9c408c3e15

Example Query

Query with partition filter

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

iSNX_RepayBorrow_event

Borrow repayment events for the Iron Bank V1 SNX (Synthetix) market on Fantom. Tracks repayment amounts, borrower accounts, and updated total borrows for analyzing debt management and position closures.

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
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0x4c5673f10c651acc30fca5495a2e8d894047f3b4	19	0x4c5673f10c651acc30fca5495a2e8d894047f3b4	30929728	297398223166729661170	2022-02-14T09:20:22.000Z	541302374386005074225	0xd56522a49b3a1e287e14ece5dcad72d0c0bef148846069aca47840a97b706e02	0
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0x5fe3512222466041fe49e1e5bbc64fb18f28c71e	2	0x5fe3512222466041fe49e1e5bbc64fb18f28c71e	10994757	89665569047779315962	2021-06-30T16:06:39.000Z	51192354796770841596	0xcaf0933f2b510d8a26a177bdf5d8f82d57d4e0f9b39d2ea71d4fae000b506a1e	905797528757327339
0x1cc6cf8455f7783980b1ee06ecd4ed9acd94e1c7	false	0x5fe3512222466041fe49e1e5bbc64fb18f28c71e	12	0x5fe3512222466041fe49e1e5bbc64fb18f28c71e	10994907	905797722756515795	2021-06-30T16:09:49.000Z	50286568038137069000	0x616c2126af7c620d78678cb0f073c2aa5766ab13030ec43452777656cedcbdb9	0

Example Query

Query with partition filter

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

iSUSHI_AccrueInterest_event

Interest accrual events for the Iron Bank SUSHI market (iSUSHI) on Fantom, recording periodic updates to borrow index, total borrows, and accumulated interest. Used for tracking lending protocol interest calculations and borrowing costs over time.

Columns

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

Sample Data

address	removed	log_index	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	4	30388098	4937055858458226754909	1060715277137187425	2022-02-08T20:06:48.000Z	7051869190253161099105	0xe60250323395965e35ca84082e26b19fecee884aeb09acea581fef489317f2ee	743832388221503776
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	17	30365604	4929021530632848968710	1060603392705339695	2022-02-08T14:19:04.000Z	7051125357864939595329	0xd5ed7a7fa760db11040a1bde51eecd05b9b76455e3f60c4bc8ec2643bf282a43	106167792526802890
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	76	30336529	4907413672920248118352	1060449813442129102	2022-02-08T06:22:45.000Z	7050104329038599324571	0x1a216e87a302ec680ea3e036878b4d0f422d977bad316dc5be902b48ce146233	2026418725758546957

Example Query

Query with partition filter

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

iSUSHI_Borrow_event

Borrow event logs from the Iron Bank v1 SUSHI market on Fantom, tracking when users take out loans against their collateral. Records borrower addresses, borrowed amounts in wei, cumulative account borrows, and total protocol borrows for analyzing lending activity and debt positions.

Columns

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

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	2	0xdfe66b7dd823531f32e002209d6ccd5552c6c356	28791312	2022-01-23T05:27:10.000Z	271000000000000000000	5051281691450478285407	0xea8b2aee269e0a66c55d4066d7349eb0cbec281e5e19ff0684cd0a064ab047de	271000000000000000000
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	4	0xb1b823e450d5e4ddde14972ef4af2b51c2a66f9f	28840678	2022-01-23T18:02:52.000Z	1080000000000000000000	5873602313754105702041	0x95760454ab5a18d3538445d946702bd8162b12c2ede135535e2f0a6674f001e9	1080000000000000000000
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	106	0x1db3b2ac93833960ef4313fb73925f32a6a35bba	28827948	2022-01-23T14:59:19.000Z	12892971929857753064	4793500068837781142689	0x109217f97d2a030f436c7a58a226c7c286ea9337602f44914b634bc122f498f9	12892971929857753064

Example Query

Query with partition filter

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

iSUSHI_Flashloan_event

Flash loan events from Iron Bank’s SUSHI token market on Fantom, capturing uncollateralized loan executions with borrowed amounts, fees, and receiver addresses. Used for tracking flash loan activity, fee generation, and identifying arbitrage or liquidation strategies.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	2374146777959867619	43	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	712244033387960	15497469	142448806677592	2021-08-25T15:59:21.000Z	0x7f341dabc7378a4f326ec39c3ace47a83465bc9645de846e2009dd34cb57d753
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	2391958983697353756	19	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	717587695109206	13325125	143517539021841	2021-07-30T12:13:58.000Z	0x3c9730b95e052ad9f4e64e8a536a57ced315a4077cc06a8ea4aa89042ea010ec
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	1408044056541431872	24	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	422413216962429	14908656	84482643392485	2021-08-18T15:27:23.000Z	0xf264ccb3ed148570e8eaabd94fc4f46a3df7e2247ee8e511a4a97d24e6c9ee33

Example Query

Query with partition filter

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

iSUSHI_Mint_event

Mint events for the iSUSHI interest-bearing token on Iron Bank v1 (Fantom), recording deposits of SUSHI tokens and corresponding iToken issuance. Tracks minter addresses, underlying collateral amounts, and iToken shares minted for analyzing supply and lending 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
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	0x0bd723463389e2373ece8b8815fa82e429eaee42	3	24668184	44430990688998126960	437628850989	2021-12-11T17:10:03.000Z	0xa869e43172ac40cc463ffeef5dd60614f2d03fdf0056ddc20ca9e2f88623c8ed
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	0xe1a27375e1b47dac5c213f9f85dc4b1fba80d88d	255	54154771	25240589845501921723	239317206314	2023-01-21T17:07:35.000Z	0x132d0328347675062e9ae9bf91a1aebb00a8cccc6e4b3f4c4f6f7f7f1f213fb1
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	0xce08d3ccd2bd138409469f947e2bfee49e052d54	12	17198564	3003843403579445	29868527	2021-09-17T18:49:19.000Z	0xae0a842860361d16eb9047b5e6f6ca148a4592ea7d0f7c76632382a2ed04b201

Example Query

Query with partition filter

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

iSUSHI_NewReserveFactor_event

Reserve factor change events for the Iron Bank SUSHI market on Fantom, tracking protocol fee adjustments over time. Shows old and new reserve factor values in mantissa format (18 decimals) for analyzing protocol revenue parameter 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
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	1	2386443	2021-02-23T10:34:23.000Z	0x7961bbfdec708aa8efc8a721b36977f0926dec1f261874409030a6218613ab07	50000000000000000	0
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	1	2668732	2021-03-10T07:32:52.000Z	0x94f350881dc3edcecf453dbed74adc4b238f7e13cfeb86f3712ad3c9a0bedcd2	200000000000000000	50000000000000000

Example Query

Query with partition filter

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

iSUSHI_Redeem_event

Redemption events from the Iron Bank SUSHI lending market (iSUSHI) on Fantom, recording when users withdraw their underlying SUSHI tokens by burning interest-bearing iSUSHI tokens. Tracks redeemer addresses, amounts of underlying assets withdrawn, and corresponding iToken amounts burned for analyzing lending market withdrawals and liquidity flows.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	20	0x954c8952cfb768617141a2cbeb2b23faaf7b89cf	20048728	2021-10-25T10:50:59.000Z	23272102115497250546	230543370845	0xf007353210bdfcc05097e27d3561c7c01bd8a467f7d6c0cae2b133429216bacb
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	5	0xc00a6614b8030ce216302016e11c6b4140b5e499	41005560	2022-06-21T11:59:48.000Z	200000000000000000000	1920859658468	0x136635ba9665f2e7ba77aea340e6d8b9f1f22123db56c62c6ce61dc302d0c716
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	9	0x9c5d846415347062a55616758a91b1182431e365	28938821	2022-01-24T19:53:21.000Z	42754520394175621384	418803605958	0x4e8f9c333ae61ccd341c1234119320b3ab5b35547c00798214030116f6f49022

Example Query

Query with partition filter

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

iSUSHI_RepayBorrow_event

Borrow repayment events for the SUSHI token market on Iron Bank v1 (Fantom), tracking when users pay down borrowed SUSHI positions. Contains repayment amounts, updated borrow balances, and payer/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	in_accountBorrows
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	0xbc2fdd2522356a50781caf6db0ced244978c6941	4	0xbc2fdd2522356a50781caf6db0ced244978c6941	28554355	1208785396809734639864	2022-01-20T15:12:05.000Z	4731276997635130117176	0x01f64a22642e98d0bc30640468e311566e3cbd0ce5677654bc530ede0f3a1d70	1189856800630897924869
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	0x4c422130f5327fc051b9e86d7b70dec962c69874	4	0x4c422130f5327fc051b9e86d7b70dec962c69874	7626911	39805663778847279853	2021-05-25T14:21:03.000Z	5911663558139130374	0x96cdce9889e20d7bac5868b38c17d9b93785de8497dde433257fb884cfe625ea	5194459509090308246
0xb1fd648d8ca4be22445963554b85abbfc210bc83	false	0x0a602f69e4f2e05f3c6a4d0164182d6ad0262aa0	41	0x842411ae8a8b8ec37bad5e63419740a2854e6527	7630381	139429570038020590	2021-05-25T15:00:54.000Z	5772234062405497175	0x4143d114e4ef2cb2dc346c3e80a8d91dbf98a713b3b3ead312a86a1834a8e4d7	557718288914612623

Example Query

Query with partition filter

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

iTUSD_AccrueInterest_event

Interest accrual events for the iTUSD (Iron Bank TUSD) lending market on Iron Bank V1 Fantom, recording cash reserves, total borrows, accumulated interest, and borrow index updates for tracking lending pool state 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_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
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0	37350661	29832126471356105951402	1045169618178883139	2022-05-01T21:20:59.000Z	7709769718056516300881	0xd576bc4afe3a10c181cb8ccb886147f183e173780fd941035f18aa124baed410	83215321810157537
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	35	37342918	29919087894690738322744	1045158337151134767	2022-05-01T17:54:15.000Z	7709686502734706143344	0x8240715bc74b2bc3aeddcf9d3473f1e2ebf6c84c48fb4ee4b5ad3e33eaa7af4f	853061405285133365
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0	32010006	36520605490243746435	1011793945962186559	2022-02-26T10:08:07.000Z	24125768553230556126521	0x2a39e328b15b7af698bb005843b009e088e15aff53a8235502c622fe83d9aa0e	3533663544388657984

Example Query

Query with partition filter

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

iTUSD_Borrow_event

Borrow event logs from Iron Bank v1’s iTUSD (interest-bearing TrueUSD) market on Fantom, recording when users borrow TUSD against collateral with borrower address, amount, and cumulative borrows. Used for analyzing lending activity, debt positions, and protocol utilization patterns.

Columns

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

Sample Data

address	removed	log_index	in_borrower	block_number	block_timestamp	in_borrowAmount	in_totalBorrows	transaction_hash	in_accountBorrows
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	4	0x7274a097d392a564622fa8569599d04ff30825db	37350661	2022-05-01T21:20:59.000Z	174677794631729156	7709944395851148030037	0xd576bc4afe3a10c181cb8ccb886147f183e173780fd941035f18aa124baed410	174677794631729156
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	7	0x4e80baf6d4e635f5d3d4152f371b1cac39ddfda2	38884994	2022-05-23T14:23:01.000Z	13893487810162130129	1793267317527115647103	0x3db9fb39a055432a6e22a8602a14975145ecd7a2defd8e5e19e01d6a252baf89	93179881485849076819
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	2	0x2c7ef9936f13fdf41399148ccacfd76cb60bba21	36866090	2022-04-24T15:23:47.000Z	101159155577786906637	8322152908606786588804	0x3acfb695907d768a1ccbe5ea4fe45efc43969da17fbde2b8e2dd7d3d276fc111	621598228536036900278

Example Query

Query with partition filter

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

iTUSD_Flashloan_event

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	9980039920159681000	55	0x0ce14adbd9b1003f37e243ca5d8236b3ed4cb15f	2994011976047904	38737121	449101796407185	2022-05-21T13:48:58.000Z	0xc1eb6506c6b88c61460403c54b703e815bccf86cf826103afe5467e5eca0804a
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	99900099900099920000	67	0x44c25d366afdc576368f534d0fbca8e5379c34df	29970029970029976	38729776	4495504495504496	2022-05-21T11:17:29.000Z	0xf75509e3fec0676769d629a25ee21df65ac66c5f989b6424571441b4669e4d4a
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	99900099900099920000	34	0x44c25d366afdc576368f534d0fbca8e5379c34df	29970029970029976	38730900	4495504495504496	2022-05-21T11:41:11.000Z	0x74be42ab707015ad8b340f10baf09dca2c1098e23f4a570c914aea2b361153de

Example Query

Query with partition filter

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

iTUSD_Mint_event

Mint events for the iTUSD (Iron Bank TUSD) market on Fantom, recording when users deposit TUSD to receive iTUSD interest-bearing tokens. Tracks deposit amounts, minted iTUSD tokens, and minter addresses for analyzing supply growth and user lending 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
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0x081931a599c1605c69cb6e3b9da48450b744b0aa	29	33556695	9972707310000000000000	98652784171404	2022-03-16T07:09:23.000Z	0xf011df033bbcb126ad8eae98e3fac0f38cb684dcfca68f4325c03cf1eb281863
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0x232d1e1a1dc55869105f242b74b2f9a490364471	18	33575042	44317413955806372933	438130974008	2022-03-16T12:06:40.000Z	0xfbc30d22c94330159a705940b45bc62befc75d60bbf5d29a3874e0bae844fccf
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0x2574e5ee9b09d53227ca087cdb2484e4310a26f6	19	33581616	10762690495636250051	106387793880	2022-03-16T13:58:26.000Z	0x8952e65a6fcc650aed66befcad099bc393839953236ed482e9e4a7585a004eda

Example Query

Query with partition filter

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

iTUSD_NewReserveFactor_event

Reserve factor parameter changes for the iTUSD (Iron Bank TUSD) lending market on Fantom. Tracks protocol fee adjustments where reserve factor mantissa represents the percentage of interest allocated to protocol reserves in 18-decimal format.

Columns

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

Sample Data

address	removed	log_index	block_number	block_timestamp	transaction_hash	in_newReserveFactorMantissa	in_oldReserveFactorMantissa
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	12	28621879	2022-01-21T07:30:31.000Z	0xfca7c74def7b69fa9f4cc97c542c9c47d0a212ed8adabfee0ecf32ccaeecbd73	100000000000000000	0
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	26	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	150000000000000000	100000000000000000

Example Query

Query with partition filter

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

iTUSD_Redeem_event

Redemption events for Iron Bank’s iTUSD (interest-bearing TUSD) market on Fantom, recording when users withdraw underlying TUSD by burning iTUSD tokens. Contains redeemer addresses, amounts redeemed in both underlying and iToken units for analyzing lending pool liquidity 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
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	4	0x3004e7d0ba11bcd506349f1062ea57f7037f0bbd	33524230	2022-03-15T22:22:01.000Z	6601223403129360936667	65381320576020	0x3706548e156c8fb706f9a49f8b6405aeecbd572517ef9a26a977a6011181556e
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	4	0x3004e7d0ba11bcd506349f1062ea57f7037f0bbd	33524148	2022-03-15T22:20:55.000Z	14350484792106977608460	142133313853019	0x63d0459ad4fac99fbdfa917ef304fef975c4cef90c2371034c0b695132889806
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	17	0x4dfcbaf8ecb56f507fd004e624abc5b3481b5c58	29224942	2022-01-27T21:38:35.000Z	10084000000000000000000	100819411982267	0xe4533663c7779c83db9715ed6164aaedb9ec1c1f2a1d9f2510f323879316703d

Example Query

Query with partition filter

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

iTUSD_RepayBorrow_event

Borrow repayment events for the iTUSD (Iron Bank True USD) market on Iron Bank v1 deployed on Fantom. Tracks repayment transactions with amounts, borrower addresses, and updated borrow balances for analyzing loan repayment behavior and protocol debt reduction.

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
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0x95df3ef874f4524e72f0d3423a9f39264325d899	140	0x95df3ef874f4524e72f0d3423a9f39264325d899	31977023	159000000000000000000	2022-02-26T01:20:12.000Z	24144788310274642764998	0xd514333cc932284e1ebda2077b7db4b0e1638180dacc6daf651babea0e4cfddb	42952759205976964188
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0x95df3ef874f4524e72f0d3423a9f39264325d899	6	0x95df3ef874f4524e72f0d3423a9f39264325d899	31976067	100000000000000000000	2022-02-26T01:05:03.000Z	24303687427604772657482	0x17a66273a8fe678d39aa3cc9c3775eccab79626774601db2b46d373c555110cb	201951920919645786847
0x28192abdb1d6079767ab3730051c7f9ded06fe46	false	0x95df3ef874f4524e72f0d3423a9f39264325d899	64	0x95df3ef874f4524e72f0d3423a9f39264325d899	31977350	40000000000000000000	2022-02-26T01:26:11.000Z	24104894664870813829055	0x61f4dd7b69643b1c6a1b09b8e401ebf3861eeeebdc1146a9265f738ac7d960b3	2952948407195093714

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_fantom.iTUSD_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	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	55731841	240851128480	1244914118107570030	2023-02-13T22:03:07.000Z	346403149315	0x00393aa65c2d9ea9e49e89dab9ae802ee9e9525f7b6e60292093bc51efecc3bb	6330760
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	55693203	280522994693	1244791481476861195	2023-02-13T10:44:14.000Z	343372734603	0xa782b7d33becd91cd901c79b071ca0908a11b306a6245ca202a31ff3c9c29b19	814185
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	55687094	280523040776	1244771186939018885	2023-02-13T08:45:51.000Z	343367136405	0x040f82393fc2ab803029af50c66bfb24f6e874b4a6596635cf3e96d886ef7d80	13867071

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_fantom.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
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	29	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	45678988	2022-08-25T21:12:54.000Z	799080964	851381487179	0x1cf9d8cb2b0b77def9ed862dddbf5363a11931a72de0ea3ab7a096feaa130d5f	473630125588
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	27	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	45678988	2022-08-25T21:12:54.000Z	21429596	850582406215	0x1cf9d8cb2b0b77def9ed862dddbf5363a11931a72de0ea3ab7a096feaa130d5f	472831044624
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	2	0x19f0b4a541ef598059c0f3174400486e120a84d0	45677036	2022-08-25T20:35:15.000Z	2000000000	850556403086	0x615edf98450ef0f217c9abc0640631f0948f2a617b4e542767098861381bb390	4188358582

Example Query

Query with partition filter

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

iUSDC_Flashloan_event

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

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	12624684	48	0xc3552fb76f3c013ecbed1a064d80bf721f6bc481	3787	24733965	378	2021-12-12T09:24:58.000Z	0x1d41da8de09e07e793730483f84c81484680c5adaf3252b1e6cb751ccfc0351d
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	3	61	0xc3552fb76f3c013ecbed1a064d80bf721f6bc481	0	24746584	0	2021-12-12T12:33:45.000Z	0x9f93f6c101ad9775a559f73ce638ad7619c517cd2e734a3a615c4f28ce5066d6
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	15000243	55	0xc3552fb76f3c013ecbed1a064d80bf721f6bc481	4500	24751206	450	2021-12-12T13:39:19.000Z	0x5d55657b5585fe3c09e721ffa29391a36486cbd5b62cc8fc59ad6d99af180ca3

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_fantom.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
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	0x5ac24f47fda690a9fe2a7240c5d50f6030725326	7	48177174	814295144	7089095185066	2022-10-01T15:50:46.000Z	0xa0706473fce280d4a700cc9de1635975526a0d02ab3e1be907e3b5b3fa08b52a
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	0x5ac24f47fda690a9fe2a7240c5d50f6030725326	8	48176411	999354026	8700186936544	2022-10-01T15:37:07.000Z	0x534b4c9b77c291b1bc5c2cebb1547231820bdb5329fcfc9a1e99ef92f2219166
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	0x5ac24f47fda690a9fe2a7240c5d50f6030725326	4	48176793	999352410	8700170357840	2022-10-01T15:43:49.000Z	0xe3a2aab805a305096fd9170ca3bbbee80af178591f814d666c162aab9c24f3b4

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_fantom.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
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	1	2386358	2021-02-23T10:29:24.000Z	0x4e541d85a7f2c39c3898b0ab328a82b2a9da7dbcf8fc0ebd2c82ddc9652deb1d	50000000000000000	0
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	1	2668333	2021-03-10T07:17:08.000Z	0xf2ee31687bbcb7083e393621bb8e7a5d13366833cc777689837a76064eaa452e	100000000000000000	50000000000000000
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	12	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	150000000000000000	100000000000000000

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_fantom.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
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	3	0xce66c6a88bd7bec215aa04fda4cf7c81055521d0	12325768	2021-07-17T22:32:35.000Z	1000000478	9610954238001	0xc504580ae0300b0902804eceb43632c4c206bc9e371fc3d662d6a220a917d069
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	3	0xf1b648f3ec491b754f96b9a32f1f86b0e67ed485	12287131	2021-07-17T09:40:49.000Z	514082332	4941289088853	0xe2d3f70a8be6cdb1b6e4f67f4386dcc863142990f0951c101e02bd826bfebe5c
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	3	0x3a531c90e52a02817c0d31794d0ac4ea35a66602	12311860	2021-07-17T17:48:05.000Z	8000000000	76890603491976	0xbd4c6149ef72f021bf93b4913c79562f4523e6a2c01bec1e176ac17fe9f40223

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.ironbank_v1_fantom.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
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	0x0afab77e0c3bccb91529eed6aff66f7cb1abbac8	59	0x0afab77e0c3bccb91529eed6aff66f7cb1abbac8	31366119	11382425422	2022-02-18T22:52:05.000Z	10794918600961	0x197ad78982ecf1d63863fd7e67aaa9a66372641ef6bbc05d1b9bc066490bd523	112715323
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	0x2d74b358be3f14bc879f6c3207eb5e5542d69813	16	0x2d74b358be3f14bc879f6c3207eb5e5542d69813	31329983	4100239386	2022-02-18T13:19:41.000Z	10787360734849	0xdafeed1bdd16ee935529a7c1ef41d6cb5ccb24c9c22c5cb52aedb32d20d551af	0
0x328a7b4d538a2b3942653a9983fda3c12c571141	false	0x2d74b358be3f14bc879f6c3207eb5e5542d69813	11	0x2d74b358be3f14bc879f6c3207eb5e5542d69813	31353799	4000025715	2022-02-18T19:41:09.000Z	10798975202309	0x955cdd795f4e0ca78220d70f9e7b9a8888b5dc1511cb0818035c5ff66b102c3f	0

Example Query

Query with partition filter

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

iUST_AccrueInterest_event

Interest accrual events for Iron Bank’s iUST (Iron Bank UST) market on Fantom, capturing periodic updates to borrow interest, total borrows, cash reserves, and the cumulative borrow index. Used for tracking lending protocol financials and calculating borrower interest charges 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
0xf13252c1044aa83b910c77322e67387e187f64ca	false	33536128	5966513909	1014885658540602772	2022-03-16T01:34:06.000Z	820052196	0xffd02788e7e56d90a31c77a0ece56ca471c7d261fc1fa1b2978642dc00ff2873	570
0xf13252c1044aa83b910c77322e67387e187f64ca	false	33606777	6653089584	1014931318197844055	2022-03-16T20:49:19.000Z	883780526	0x65e670f51dc92cab05225f23c5a4c88ed8cae62939c15dc8b772a1d1f0319907	563
0xf13252c1044aa83b910c77322e67387e187f64ca	false	33561663	716747645	1014905339314039186	2022-03-16T08:27:21.000Z	6820101009	0x548ec741c38ebdbdd38758a7065df68ded70801b81a456b9c32a548364bcf56f	37409

Example Query

Query with partition filter

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

iUST_Borrow_event

Borrow event logs from Iron Bank’s iUST (TerraUSD) lending market on Fantom, capturing loan originations with borrowed amounts, account debt positions, and protocol-wide total borrows. Used to track UST borrowing activity and individual borrower leverage across the Iron Bank 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
0xf13252c1044aa83b910c77322e67387e187f64ca	false	53	0xc984946ea53d6d840b3696deb499f139b64aa9a2	30695827	2022-02-12T01:26:09.000Z	472531840	20031689544	0x453d442eb0b6894755dcf86548c44aa898ff9e45ee00d2ef25238ecc64d008f5	3292709124
0xf13252c1044aa83b910c77322e67387e187f64ca	false	4	0x607a01c8868da7a5ae43c08aa1e2f153e57362ea	30696696	2022-02-12T01:37:27.000Z	20000000	20051691560	0xc7005ad41c3ad1a89e4f3fe8c4a7fee9a30e264de4fe34bfd1157bdc2e21b034	20000000
0xf13252c1044aa83b910c77322e67387e187f64ca	false	7	0x607a01c8868da7a5ae43c08aa1e2f153e57362ea	30696831	2022-02-12T01:39:29.000Z	60000000	20111691923	0x4a5567f8efa332edb56fc00e43a646e99cbefb8e0a72696d93ca6255f298ff2f	80000000

Example Query

Query with partition filter

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

iUST_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_fantom.iUST_Flashloan_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

iUST_Mint_event

Mint events for Iron Bank’s iUST (interest-bearing TerraUSD) token on Fantom, recording when users deposit UST collateral and receive iUST in return. Contains minter addresses, underlying token amounts deposited, and iTokens received for tracking lending 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
0xf13252c1044aa83b910c77322e67387e187f64ca	false	0x141e74a8b4ca2fb5aecac8827e4e7797f68d8692	17	33129135	182585515	1809481232538	2022-03-11T10:18:45.000Z	0x43f48a9f00a0a103840f9347a0f492686250fc9b5308c35b9a2b62cce7df9170
0xf13252c1044aa83b910c77322e67387e187f64ca	false	0x141e74a8b4ca2fb5aecac8827e4e7797f68d8692	33	33128781	240734879	2385803703115	2022-03-11T10:13:09.000Z	0xfe600b89f8bba67929d790cb7d21db9fa650990a3b978134aa1ad526312b0f89
0xf13252c1044aa83b910c77322e67387e187f64ca	false	0x1c51f54f1784f90b56af0b16d41108f5ab745045	44	33126125	1111708	11019455170	2022-03-11T09:26:58.000Z	0x4332e08fa4c336214b06ba07594a4be01e4c86360c0f609b87cdd9e69ef85a1a

Example Query

Query with partition filter

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

iUST_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank UST (iUST) lending market on Fantom. Tracks governance updates to the protocol’s reserve allocation percentage, useful for analyzing risk parameter adjustments and protocol treasury fee 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
0xf13252c1044aa83b910c77322e67387e187f64ca	false	15	28621879	2022-01-21T07:30:31.000Z	0xfca7c74def7b69fa9f4cc97c542c9c47d0a212ed8adabfee0ecf32ccaeecbd73	100000000000000000	0

Example Query

Query with partition filter

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

iUST_Redeem_event

Redemption events from the Iron Bank V1 iUST (interest-bearing TerraUSD) market on Fantom, recording when users withdraw their underlying UST by burning iUST tokens. Contains redeemer addresses, amounts of underlying tokens received, and iTokens burned for tracking lending market liquidity and 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
0xf13252c1044aa83b910c77322e67387e187f64ca	false	21	0x611e481dc31bbc327bca7f4c979c35e8eae6dd4d	35596173	2022-04-09T02:56:44.000Z	318890534	3136113116720	0x070ce28ab6ef8fca71af44108651ffbd58aeedd554125aefc8b68ee90fbfda8f
0xf13252c1044aa83b910c77322e67387e187f64ca	false	51	0x4c2424a61282d6e67c568eafb18d4ac68c24291b	31730456	2022-02-22T20:38:03.000Z	13242981753	131999998629497	0x45dac649b031993f25da43fcce5769448ef4f04dc2990f61e3b27be5c450632f
0xf13252c1044aa83b910c77322e67387e187f64ca	false	4	0xe01523770e5d00c61ccfa1c6a7f4cbdedc3c187d	31734360	2022-02-22T21:31:48.000Z	12000011424	119597010345700	0x34e440262e85aa01c806fef01093c3ab9ff69deb5379e0f3da434d6bb311daed

Example Query

Query with partition filter

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

iUST_RepayBorrow_event

Borrow repayment events from the iUST (Iron Bank TerraUSD) lending market on Iron Bank v1 protocol deployed on Fantom. Tracks debt repayments with payer, borrower addresses, repayment amounts, and updated borrow balances for analyzing loan activity and market 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
0xf13252c1044aa83b910c77322e67387e187f64ca	false	0x9c7202354dc9949348b13ccab79084cf7919a49b	14	0x9c7202354dc9949348b13ccab79084cf7919a49b	31661692	100000000	2022-02-22T02:50:56.000Z	13653890240	0xe26982c76fd01385de70c6efa2852416c08920a4a69e0e9658ab7ddaf6937f9c	1023806
0xf13252c1044aa83b910c77322e67387e187f64ca	false	0x9c7202354dc9949348b13ccab79084cf7919a49b	13	0x9c7202354dc9949348b13ccab79084cf7919a49b	31661494	500093369	2022-02-22T02:47:12.000Z	13753881815	0xe6526cec2301726a6ab2e610508872981d786b5ce67559d00d481313f09f94b6	101023745
0xf13252c1044aa83b910c77322e67387e187f64ca	false	0xea54a7e264cd96f76bfe9d0da12625b8917c7a17	18	0xb7db55e85e9ab2b800a52c936ce4ab33adb5fe6b	31690983	5738082083	2022-02-22T10:08:58.000Z	7916783746	0xd5763c8c654dce696cebe0941c0daaaed66fdbebc39a222e84bda5406bb5aa04	5783974625

Example Query

Query with partition filter

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

iWFTM_AccrueInterest_event

Interest accrual events from Iron Bank’s wrapped FTM (Fantom) lending market, recording periodic updates to borrow index, total borrows, and accumulated interest. Used for analyzing lending protocol yield generation and borrowing costs over time.

Columns

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

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0xd528697008ac67a21818751a5e3c58c8dae54696	false	55710945	387009012055611785891066	1133835765195311564	2023-02-13T15:48:54.000Z	555042832294223176730588	0x33b5a04a9d0396649d6bd7fa4112684e6f922920177dc399ad41d55c1d0c9aeb	1948507471179610706
0xd528697008ac67a21818751a5e3c58c8dae54696	false	55665014	478162915896205026949537	1133672035791298753	2023-02-13T00:31:00.000Z	518898818935705000728606	0xcfecbbc1e9464d594cecedf4bc68ae68922115ab4e21404efa0fc44a71f41de7	996530520532695605
0xd528697008ac67a21818751a5e3c58c8dae54696	false	55665085	485713103815194818256243	1133672236671551402	2023-02-13T00:32:12.000Z	511348721624791397083008	0xc596a966f186eeaf89cf2fd24bb2607de545dbec8855a99e465a9ce73b5ba733	90608076187661108

Example Query

Query with partition filter

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

iWFTM_Borrow_event

Borrow event logs from Iron Bank’s Wrapped Fantom (WFTM) lending market on Fantom, tracking individual borrow transactions with borrower addresses, borrow amounts, and cumulative account and protocol-level borrow balances. Used for analyzing borrowing activity, user debt positions, and total 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
0xd528697008ac67a21818751a5e3c58c8dae54696	false	27	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	47252229	2022-09-19T09:43:20.000Z	244933213423812767	1710768001519904547978573	0xfa234cc5eac4310e1b3e3ecc7816f0ea4c58e458b33f19b1f2d4f3e427312715	891338180585803357658159
0xd528697008ac67a21818751a5e3c58c8dae54696	false	29	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	47252229	2022-09-19T09:43:20.000Z	19682090072157251400	1710787683609976705229973	0xfa234cc5eac4310e1b3e3ecc7816f0ea4c58e458b33f19b1f2d4f3e427312715	891357862675875514909559
0xd528697008ac67a21818751a5e3c58c8dae54696	false	29	0x060e91a44f16dfcc1e2c427a0383596e1d2e886f	47235371	2022-09-19T04:09:55.000Z	17329300629415503967490	1710190085475515805908976	0xbd3ce2cbab7a29406aad6d8e94a6d0f10000d818c40bb4bd1c39bc73681c664d	890794073659490196707914

Example Query

Query with partition filter

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

iWFTM_Flashloan_event

Flashloan execution records from Iron Bank v1’s wrapped FTM (WFTM) lending pool on Fantom, capturing loan amounts, receiver addresses, and protocol fee breakdowns. Used for analyzing flashloan arbitrage activity and protocol revenue from uncollateralized WFTM loans.

Columns

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

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0xd528697008ac67a21818751a5e3c58c8dae54696	false	2494010525831318016	6	0x827fa9827ce5344d358f1c43c638cd1adc6526fd	748203157749395	23192570	89784378929927	2021-11-26T14:22:03.000Z	0xbb258bff733e03b59581489cc0edbc9de305d932db760e24b49b010c4aa3f8cc
0xd528697008ac67a21818751a5e3c58c8dae54696	false	6413391566015441920	14	0x827fa9827ce5344d358f1c43c638cd1adc6526fd	1924017469804632	23192458	230882096376555	2021-11-26T14:20:34.000Z	0x8c9b8d50168d5c358f3b7c26aa92d5843231d218c590a53ecd5c03a8f18fc45f
0xd528697008ac67a21818751a5e3c58c8dae54696	false	6413391566015441920	19	0x827fa9827ce5344d358f1c43c638cd1adc6526fd	1924017469804632	23192464	230882096376555	2021-11-26T14:20:39.000Z	0x38fc254eb0b834ae753ec440de8c54d18fa1020bd593e12f06b9343c69ccf531

Example Query

Query with partition filter

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

iWFTM_Mint_event

Mint events from Iron Bank’s iWFTM (interest-bearing Wrapped Fantom) market on Fantom, recording when users deposit WFTM to receive iWFTM tokens. Tracks deposit amounts, minted token quantities, and exchange rates for analyzing Iron Bank 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
0xd528697008ac67a21818751a5e3c58c8dae54696	false	0x760db75eb70db9af328721f50256a207075d8bc6	4	2818374	1000000000000000000	9999993489	2021-03-20T17:27:26.000Z	0x233626a7019f4cfcf059404bfd3e5e89fba49bed6da9171cd175e25f947f7a98
0xd528697008ac67a21818751a5e3c58c8dae54696	false	0xf5ed649c2ebb92471292f7db52fab69c22dd57be	15	2821151	222222022755255	2222218	2021-03-20T21:28:29.000Z	0xd024de6c140d8e22cfcfd4cde624e34c5dc44f166be18e260f3cad46ff6a0e96
0xd528697008ac67a21818751a5e3c58c8dae54696	false	0x108d6e9c1111aed0fb9a0792c3d738c4694570d6	4	39737202	1897000000000000000000	18367686961830	2022-06-04T03:39:32.000Z	0xad6eaf11f98f838fb2db586a3b24430605f47d1ccabed7489665336f70366539

Example Query

Query with partition filter

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

iWFTM_NewReserveFactor_event

Reserve factor parameter changes for the Wrapped Fantom (WFTM) market on Iron Bank v1. Tracks adjustments to the protocol’s revenue share percentage, with mantissa values representing decimal precision (e.g., 50000000000000000 = 5%).

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
0xd528697008ac67a21818751a5e3c58c8dae54696	false	1	2386296	2021-02-23T10:25:59.000Z	0xcda25b550b2bc3cfa91921630928b89049f15c7539fe7a4d495f48ca620e4e88	50000000000000000	0
0xd528697008ac67a21818751a5e3c58c8dae54696	false	1	2667719	2021-03-10T06:51:10.000Z	0x3df6d0734fbbec6c232caf5fdffd25a5e3f3f238316955bb60c265262785ed6a	120000000000000000	50000000000000000
0xd528697008ac67a21818751a5e3c58c8dae54696	false	10	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	200000000000000000	120000000000000000

Example Query

Query with partition filter

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

iWFTM_Redeem_event

Withdrawal events from Iron Bank’s wrapped FTM (WFTM) lending market on Fantom, recording when users redeem their interest-bearing iWFTM tokens for underlying WFTM assets. Used for tracking Iron Bank supply-side activity and collateral movements.

Columns

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

Sample Data

address	removed	log_index	in_redeemer	block_number	block_timestamp	in_redeemAmount	in_redeemTokens	transaction_hash
0xd528697008ac67a21818751a5e3c58c8dae54696	false	39	0xce5ddfe41dcc1b0d4e8b996ba079f060d45adc2c	51295143	2022-11-22T15:24:48.000Z	1033454725051097538	9779534918	0x170f05654b8c12d3e5c72f5f21f84fa9584e277a82efed873e642af932767ad9
0xd528697008ac67a21818751a5e3c58c8dae54696	false	9	0x67d575d119424e33acdeb0c16dc1be0c8a9df68f	51298308	2022-11-22T16:45:34.000Z	1812342330507951369	17150062734	0xbf5155dc8bc2e876b1ba6c28ddbe458400c89756919a32b04a701d5be78eae67
0xd528697008ac67a21818751a5e3c58c8dae54696	false	25	0x67d575d119424e33acdeb0c16dc1be0c8a9df68f	51308472	2022-11-22T20:46:49.000Z	2444144945216170043	23128563009	0xf971a21cc3cfad0ae1597cb435cc28b978beb4076f84387657db860de6a7e45b

Example Query

Query with partition filter

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

iWFTM_RepayBorrow_event

Borrow repayment events for the iWFTM (Iron Bank Wrapped FTM) market on Iron Bank v1 Fantom, tracking when users repay borrowed WFTM with payer/borrower addresses, repayment amounts, and remaining account/total borrows. Used for analyzing debt repayment patterns and borrower behavior in the WFTM lending market.

Columns

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

Sample Data

address	removed	in_payer	log_index	in_borrower	block_number	in_repayAmount	block_timestamp	in_totalBorrows	transaction_hash	in_accountBorrows
0xd528697008ac67a21818751a5e3c58c8dae54696	false	0x076f649c5b0871749e1ba5850e8b114a25b34911	3	0x076f649c5b0871749e1ba5850e8b114a25b34911	13711902	170386807990186516361	2021-08-04T00:19:03.000Z	4220507613038088717278671	0xab17bd285dbef670bc55d0d47ef5d07e384388ed6093e5e9f190a3affc66f76c	0
0xd528697008ac67a21818751a5e3c58c8dae54696	false	0x0bd723463389e2373ece8b8815fa82e429eaee42	3	0x0bd723463389e2373ece8b8815fa82e429eaee42	13780977	300000000000000000000	2021-08-04T19:09:28.000Z	3819418793999921113486792	0xa51e05e09ff630ab5d09cbe96848bca623b87743347decfc8bfc29168d4736a8	1180570278263788399467
0xd528697008ac67a21818751a5e3c58c8dae54696	false	0x1c74e6e85bf53f1b6c56465e1a5f7bf56c3ebcb7	3	0x1c74e6e85bf53f1b6c56465e1a5f7bf56c3ebcb7	13766491	55712352398554379309299	2021-08-04T15:32:22.000Z	4004951570554507826664175	0xc75d561eb65be1d2d648b7287e14fa79189f9d6213a850448f8b4293e0d98a57	1327168086996534519876

Example Query

Query with partition filter

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

iYFI_AccrueInterest_event

Interest accrual events for the iYFI (Iron Bank YFI) market on Fantom, recording periodic updates to borrow index, total borrows, and accumulated interest. Used for tracking lending pool performance and calculating time-weighted borrowing costs.

Columns

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

Sample Data

address	removed	block_number	in_cashPrior	in_borrowIndex	block_timestamp	in_totalBorrows	transaction_hash	in_interestAccumulated
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	65238416	1003770385280394377	1115418803646663566	2023-07-06T22:06:10.000Z	429929358691737555	0x1feae8528c6bf01c64f8230c077a1881378d06fcc74ed5b26aade205f476b142	194822865519589
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	65243606	654188289578933094	1115438170950779204	2023-07-06T23:29:36.000Z	429936823665979339	0x70f9e2fc0c6b3ca0316120ecb8f0af0e546bdfd6f7763c0bbc79c9d2a0888efb	7464974241784
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	42180611	11176926628978461079	1070015889602135456	2022-07-06T21:48:41.000Z	3275073403455132007	0xddb69f27c270e68e566f7adf53b21bb94ea688f2330287d0378879fe46c94a57	290204849039216

Example Query

Query with partition filter

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

iYFI_Borrow_event

Borrow event logs from Iron Bank’s iYFI (yearn.finance) lending market on Fantom, tracking individual borrow transactions with borrower addresses, borrowed amounts in wei, and running total borrows. Used for analyzing borrowing activity, utilization rates, and account-level debt positions in the YFI lending pool.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_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
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	20	0x35c0578375d034b10dc73d8bb4d26f8c1bff0001	32503338	2022-03-04T05:38:49.000Z	2850000000000000000	13041719797501377847	0x87b842168f2b3a39eb5cd04f9908af18357d46eea6f71b0d86f49c8369b748c8	2850000000000000000
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	17	0x53541cc8caeeee0b5aff9d5194be6db9de23f3e1	32505716	2022-03-04T06:18:25.000Z	231030921024716453	12277429700490009471	0x727c646118bc1bd15cb10e63893d4efaf2840c17427a9f0eb9a01e2d2eccdc69	231030921024716453
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	13	0xcc98cfdc5f5480d8dd0a0d0a7f80506eb30d5159	32552532	2022-03-04T18:20:44.000Z	1000000000000000000	11448213706322276048	0x237c5faabbda2afcf3a659436665a8d7a7078b6caf6aa448289ff2773dbd0b4a	2870856132333311129

Example Query

Query with partition filter

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

iYFI_Flashloan_event

Flash loan event records from Iron Bank’s YFI (Yearn Finance) lending market on Fantom. Captures borrower addresses, loan amounts in wei, and fee breakdowns (total and protocol reserves) for analyzing flash loan usage patterns 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_receiver`	`STRING`	Address that receives tokens, assets, or rewards from the transaction. Hex-encoded, 0x-prefixed, 42-character string.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
`in_totalFee`	`STRING`	Total fee amount charged for the transaction or operation. String-encoded integer value representing the fee in the smallest denomination of the token.
`in_reservesFee`	`STRING`	Fee amount allocated to protocol reserves from a flashloan transaction. String-encoded integer value representing the reserve portion in the smallest denomination of the token.

Sample Data

address	removed	in_amount	log_index	in_receiver	in_totalFee	block_number	in_reservesFee	block_timestamp	transaction_hash
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	2398359401517490	18	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	719507820455	15407867	143901564091	2021-08-24T14:28:52.000Z	0x6cc8a9bdcd8394df9241f7b80fbffde190ceb288648cdae95887184b8ac2a976
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	307515385654238	22	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	92254615696	12324332	18450923139	2021-07-17T22:04:18.000Z	0xc05a9edd870a7e93796608926a5040c272101f4393d7fa534c21038aa0c1ca25
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	548432525403256	19	0x6f6d543f81eba0d1c4934243517f9396e0ff394e	164529757620	15217504	32905951524	2021-08-22T10:06:28.000Z	0xbc294aa67340eca3680fb26a6dbdb7361ab491c51dcc428d26083d0a00e1ef78

Example Query

Query with partition filter

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

iYFI_Mint_event

Mint events for Iron Bank’s YFI (yearn.finance) interest-bearing token market on Fantom, recording when users deposit YFI collateral and receive iYFI tokens in return. Useful for analyzing lending market supply dynamics and collateralization patterns.

Columns

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

Sample Data

address	removed	in_minter	log_index	block_number	in_mintAmount	in_mintTokens	block_timestamp	transaction_hash
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	0xa06b4805047684db0886c4932db281e91b4b8cf1	2	17198584	36794600095566	365914	2021-09-17T18:49:48.000Z	0x8dfa35cd4211ea798f0b69676127bf74ad3c304f0efc47a61956f63c72983a88
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	0x49e7a70f622bfaa30145815b3fd7df7faac747eb	3	6180270	81220337830687	810873	2021-05-12T18:39:11.000Z	0x00380092da23702fe926a5d05ff894219b3dac06855fc7beb493c85e997353bb
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	0x694208f12c6bff64c4aba19a16dd444c4e2b4ada	43	6172711	108338604040808204	1081628456	2021-05-12T17:06:48.000Z	0x4ede28bcc1fa77d905814a0dc51f9c5132bfb1eea4618f46bd59c8f7adf3a43f

Example Query

Query with partition filter

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

iYFI_NewReserveFactor_event

Reserve factor parameter changes for the Iron Bank YFI (iYFI) lending market on Fantom, tracking adjustments to the protocol’s fee structure. Records old and new reserve factor mantissa values (denominated in 18 decimals) used to calculate protocol revenue retention from interest payments.

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
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	1	2386392	2021-02-23T10:32:06.000Z	0xf9bebbd8e1da9289a9a9582c3246b236a44399304b245147fa9ceffd016dad6c	50000000000000000	0
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	22	29441360	2022-01-30T02:54:33.000Z	0xac782c1568e745663d9d6fba45303b574353f65b4a59cc3d24b15607b93b3345	250000000000000000	200000000000000000
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	1	2668349	2021-03-10T07:17:39.000Z	0x887d26b8f51f438224f369d2452bf39a32f77913ba17a301cf4e28f9c9bdae40	200000000000000000	50000000000000000

Example Query

Query with partition filter

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

iYFI_Redeem_event

Withdrawal events from the Iron Bank YFI (yearn.finance) lending market on Fantom, tracking when users redeem their iYFI tokens for underlying YFI collateral. Records redeemer addresses, token amounts withdrawn, and corresponding iToken amounts 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
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	4	0xa5504bcb6cc0492344151ebee943c62d2b2c071f	24132908	2021-12-06T06:48:16.000Z	6028094313012233	59212867	0xa6ffe9e2f7984e191c97b83770f8ca8265653a12825c72cf3fe6a3ab0abb55d3
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	29	0xebfb4d9d29312a54f2f7eb7292a2c9fed30d408c	17515495	2021-09-23T00:23:54.000Z	64231664665061913	635216827	0x7d2aa853885498241fa92cad39bbdd89f7ada5ad9b3ef638be9f42f6b07f13b5
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	18	0x07d635b3cb3f63d6ae20720748f1a3eaaf3e8903	51956330	2022-12-06T15:32:23.000Z	1007011470699766	9776474	0x02c9a5f51277efdf3728cf6b4dc29b28a5618f02f4ecb8f622568d4b0f5b663c

Example Query

Query with partition filter

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

iYFI_RepayBorrow_event

Borrow repayment events for the iYFI (Iron Bank YFI) market on Fantom, tracking when users reduce or close debt positions with repayment amounts, updated account balances, and protocol-wide borrow totals.

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
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	0xd67fcf4fd275416a19ef89b132b5b6938252beea	34	0xd67fcf4fd275416a19ef89b132b5b6938252beea	52847390	72439302582236009	2022-12-25T16:14:54.000Z	2976515591961278099	0xf26cb18b19b5ccc9ae389321720725862c789419ffafbbba2c0159f88657f3ad	0
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	0xe53ab209a541c969cd979223d347f5000b6fa3d8	29	0xe53ab209a541c969cd979223d347f5000b6fa3d8	31257256	822872946683	2022-02-17T19:05:35.000Z	3531590518554938763	0x3c595a75f296c15de8ea0e8bca9a1205eac4cd61affe5d4b1962038a33adcc23	0
0x0980f2f0d2af35ef2c4521b2342d59db575303f7	false	0x88b0ea576428da635d0fa9deb686765c90cfde2e	75	0x88b0ea576428da635d0fa9deb686765c90cfde2e	45337096	2398958008000080	2022-08-21T00:05:02.000Z	1879901795544547896	0xee2d5520e1f65692a1e88443df86599532c1d9e6c3f61790c826207286d1ed1a	16695230893116113

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​iAAVE_AccrueInterest_event

​iAAVE_Borrow_event

​iAAVE_Flashloan_event

​iAAVE_Mint_event

​iAAVE_NewReserveFactor_event

​iAAVE_Redeem_event

​iAAVE_RepayBorrow_event

​iBTC_AccrueInterest_event

​iBTC_Borrow_event

​iBTC_Flashloan_event

​iBTC_Mint_event

​iBTC_NewReserveFactor_event

​iBTC_Redeem_event

​iBTC_RepayBorrow_event

​iDAI_AccrueInterest_event

​iDAI_Borrow_event

​iDAI_Flashloan_event

​iDAI_Mint_event

​iDAI_NewReserveFactor_event

​iDAI_Redeem_event

​iDAI_RepayBorrow_event

​iETH_AccrueInterest_event

​iETH_Borrow_event

​iETH_Flashloan_event

​iETH_Mint_event

​iETH_NewReserveFactor_event

​iETH_Redeem_event

​iETH_RepayBorrow_event

​iFRAX_AccrueInterest_event

​iFRAX_Borrow_event

​iFRAX_Flashloan_event

​iFRAX_Mint_event

​iFRAX_NewReserveFactor_event

​iFRAX_Redeem_event

​iFRAX_RepayBorrow_event

​iFUSDT_AccrueInterest_event

​iFUSDT_Borrow_event

​iFUSDT_Flashloan_event

​iFUSDT_Mint_event

​iFUSDT_NewReserveFactor_event

​iFUSDT_Redeem_event

​iFUSDT_RepayBorrow_event

​iLINK_AccrueInterest_event

​iLINK_Borrow_event

​iLINK_Flashloan_event

​iLINK_Mint_event

​iLINK_NewReserveFactor_event

​iLINK_Redeem_event

​iLINK_RepayBorrow_event

​iMIM_AccrueInterest_event

​iMIM_Borrow_event

​iMIM_Flashloan_event

​iMIM_Mint_event

​iMIM_NewReserveFactor_event

​iMIM_Redeem_event

​iMIM_RepayBorrow_event

​iSNX_AccrueInterest_event

​iSNX_Borrow_event

​iSNX_Flashloan_event

​iSNX_Mint_event

​iSNX_NewReserveFactor_event

​iSNX_Redeem_event

​iSNX_RepayBorrow_event

​iSUSHI_AccrueInterest_event

​iSUSHI_Borrow_event

​iSUSHI_Flashloan_event

​iSUSHI_Mint_event

​iSUSHI_NewReserveFactor_event

​iSUSHI_Redeem_event

​iSUSHI_RepayBorrow_event

​iTUSD_AccrueInterest_event

​iTUSD_Borrow_event

​iTUSD_Flashloan_event

​iTUSD_Mint_event

​iTUSD_NewReserveFactor_event

Tables

iAAVE_AccrueInterest_event

iAAVE_Borrow_event

iAAVE_Flashloan_event

iAAVE_Mint_event

iAAVE_NewReserveFactor_event

iAAVE_Redeem_event

iAAVE_RepayBorrow_event

iBTC_AccrueInterest_event

iBTC_Borrow_event

iBTC_Flashloan_event

iBTC_Mint_event

iBTC_NewReserveFactor_event

iBTC_Redeem_event

iBTC_RepayBorrow_event

iDAI_AccrueInterest_event

iDAI_Borrow_event

iDAI_Flashloan_event

iDAI_Mint_event

iDAI_NewReserveFactor_event

iDAI_Redeem_event

iDAI_RepayBorrow_event

iETH_AccrueInterest_event

iETH_Borrow_event

iETH_Flashloan_event

iETH_Mint_event

iETH_NewReserveFactor_event

iETH_Redeem_event

iETH_RepayBorrow_event

iFRAX_AccrueInterest_event

iFRAX_Borrow_event

iFRAX_Flashloan_event

iFRAX_Mint_event

iFRAX_NewReserveFactor_event

iFRAX_Redeem_event

iFRAX_RepayBorrow_event

iFUSDT_AccrueInterest_event

iFUSDT_Borrow_event

iFUSDT_Flashloan_event

iFUSDT_Mint_event

iFUSDT_NewReserveFactor_event

iFUSDT_Redeem_event

iFUSDT_RepayBorrow_event

iLINK_AccrueInterest_event

iLINK_Borrow_event

iLINK_Flashloan_event

iLINK_Mint_event

iLINK_NewReserveFactor_event

iLINK_Redeem_event

iLINK_RepayBorrow_event

iMIM_AccrueInterest_event

iMIM_Borrow_event

iMIM_Flashloan_event

iMIM_Mint_event

iMIM_NewReserveFactor_event

iMIM_Redeem_event

iMIM_RepayBorrow_event

iSNX_AccrueInterest_event

iSNX_Borrow_event

iSNX_Flashloan_event

iSNX_Mint_event

iSNX_NewReserveFactor_event

iSNX_Redeem_event

iSNX_RepayBorrow_event

iSUSHI_AccrueInterest_event

iSUSHI_Borrow_event

iSUSHI_Flashloan_event

iSUSHI_Mint_event

iSUSHI_NewReserveFactor_event

iSUSHI_Redeem_event

iSUSHI_RepayBorrow_event

iTUSD_AccrueInterest_event

iTUSD_Borrow_event

iTUSD_Flashloan_event

iTUSD_Mint_event

iTUSD_NewReserveFactor_event

iTUSD_Redeem_event

iTUSD_RepayBorrow_event

iUSDC_AccrueInterest_event

iUSDC_Borrow_event