radiant_v1_arbitrum

Tables

AToken_Burn_event

Burn events for Aave interest-bearing tokens (aTokens) emitted when users withdraw or repay underlying assets. Records the amount burned, the user’s address, the interest accrual index at burn time, and optional balance increase from accrued interest in V3 implementations.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	in_target	log_index	block_number	block_timestamp	transaction_hash
0x15b53d277af860f51c3e6843f8075007026bbb3a	0xebf9746af2c757a20db467b007f4fa6317385e9a	false	1018556585077004024919757553	30120000000000000	0xebf9746af2c757a20db467b007f4fa6317385e9a	14	130756025	2023-09-13T15:34:26.000Z	0x9685983b3b5a786c431ed5e936bd4370a645278a48a1f0d2df717750162ebbca
0x15b53d277af860f51c3e6843f8075007026bbb3a	0xebf9746af2c757a20db467b007f4fa6317385e9a	false	1018554974832811497115477810	20500000000000000	0xebf9746af2c757a20db467b007f4fa6317385e9a	14	130695567	2023-09-13T11:05:21.000Z	0x4f79d1b1797fd239e20dd73ba20e11746296a8ed9833ab2657053f3fa8608b2e
0x15b53d277af860f51c3e6843f8075007026bbb3a	0xebf9746af2c757a20db467b007f4fa6317385e9a	false	1018557050663102617050456802	35000000000000000	0xebf9746af2c757a20db467b007f4fa6317385e9a	14	130773259	2023-09-13T16:52:21.000Z	0x0d546ce7558d930441319992f12afdf77ce75840aae419d6f1d307c61ae36a4c

Example Query

Query with partition filter

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

AToken_Mint_event

Aave Protocol interest-bearing token (aToken) mint events emitted when users deposit underlying assets into lending pools. Records deposit transactions including depositor address, recipient address, minted token amount, liquidity index, and accrued interest balance increases for lending position tracking.

Columns

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

Sample Data

address	in_from	removed	in_index	in_value	log_index	block_number	block_timestamp	transaction_hash
0x15b53d277af860f51c3e6843f8075007026bbb3a	0x63ee2b61d68220c2606d277c0ab02713a7c84cc6	false	1013643678794875643780097960	110000000000000000	9	53577831	2023-01-17T00:22:15.000Z	0xd3d64ac8046cc39e3f2400e35fffa7b4dee613631124d6cf1c6d6721d2c15ec7
0x15b53d277af860f51c3e6843f8075007026bbb3a	0xc2054a8c33bfce28de8af4af548c48915c455c13	false	1013643678794875643780097960	8963077489862280	3	53577831	2023-01-17T00:22:15.000Z	0xd3d64ac8046cc39e3f2400e35fffa7b4dee613631124d6cf1c6d6721d2c15ec7
0x15b53d277af860f51c3e6843f8075007026bbb3a	0xc2054a8c33bfce28de8af4af548c48915c455c13	false	1013643686882972747331330799	51154370887649	13	53577864	2023-01-17T00:22:29.000Z	0x1b12101008f44f3b5318f678dfe80c473544fcb81de253028a6a7b457c7332b9

Example Query

Query with partition filter

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

LendingPool_Borrow_event

Borrow events emitted by Aave lending pool contracts capturing loan originations with borrower address, reserve asset, loan amount, interest rate, and rate mode (stable or variable). Used for tracking DeFi lending activity and calculating protocol borrowing 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. 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_borrowRateMode`	`STRING`	Interest rate mode selected for the borrow operation. Numeric string value where ‘1’ represents stable rate and ‘2’ represents variable rate.
`in_borrowRate`	`STRING`	Annual interest rate applied to the borrowed amount in the lending pool. Numeric string representation expressed in ray units (27 decimal places).
`in_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_borrowRate	in_onBehalfOf	block_timestamp	transaction_hash	in_borrowRateMode
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x5682a39078edce41a65f1bd8733bf9ca2bbe3b1b	false	1087346641025063914025	70	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	19829246	70553584868613836059261345	0x0999033a70b936bd10582437040550eab875ca95	2022-08-09T15:51:56.000Z	0xf03cb7f807a145afc2b8f1c2db1266af58a339fa4e9499135e2b31aa533021ec	2
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x5682a39078edce41a65f1bd8733bf9ca2bbe3b1b	false	145143255854602952878	161	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	19829246	70545292665929597662652459	0x0999033a70b936bd10582437040550eab875ca95	2022-08-09T15:51:56.000Z	0xf03cb7f807a145afc2b8f1c2db1266af58a339fa4e9499135e2b31aa533021ec	2
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x5682a39078edce41a65f1bd8733bf9ca2bbe3b1b	false	458724364182448838728	109	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	19829246	70548052369035589285280481	0x0999033a70b936bd10582437040550eab875ca95	2022-08-09T15:51:56.000Z	0xf03cb7f807a145afc2b8f1c2db1266af58a339fa4e9499135e2b31aa533021ec	2

Example Query

Query with partition filter

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

LendingPool_Deposit_event

Deposit events from lending pool contracts recording user supply transactions. Contains depositor address, reserve asset, deposit amount, beneficiary account, and optional referral code for tracking protocol liquidity provisioning.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. 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_referral`	`STRING`	Referral code identifier associated with the transaction. Numeric string representation, often ‘0’ when no referral is present.

Sample Data

address	in_user	removed	in_amount	log_index	in_reserve	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x00067c68c96f8bf2d2258630badf8e4379234179	false	10000	10	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	27054948	0x00067c68c96f8bf2d2258630badf8e4379234179	2022-09-27T20:02:32.000Z	0x5ccf375ffeebcb30087539766c9ef442736e0938d6dc0bab5432b7ef2d3b0b6a
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x001be549fa377710b9e59d57bbdf593ce1e379ca	false	1000	10	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	27070019	0x001be549fa377710b9e59d57bbdf593ce1e379ca	2022-09-27T22:51:16.000Z	0xf99fa376b09c1489b2ede632fffe33aa2a1527392584cd65fa1552917e4ae63b
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x0064f043786e8c597d6565fcbf4f0989bdd0f9a3	false	100000	10	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	27062912	0x0064f043786e8c597d6565fcbf4f0989bdd0f9a3	2022-09-27T21:26:39.000Z	0xcf4612c9003c0e7ec6ee19df4964a95b6f4160807f1d7a4e53126c8aa1e672f9

Example Query

Query with partition filter

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

LendingPool_FlashLoan_event

Flash loan events from Aave and Aave-forked lending protocols containing borrowed asset, amount, initiator, recipient, and premium fee charged. Used for tracking uncollateralized borrowing activity and arbitrage transactions.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_target`	`STRING`	Address of the recipient contract or account receiving tokens or funds. Hex-encoded, 0x-prefixed, 42-character string.
`in_initiator`	`STRING`	Address of the account that initiated the flash loan operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_asset`	`STRING`	Contract address of the asset or token. 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_premium`	`STRING`	Fee charged for the flash loan operation. Numeric string representation of the fee amount in smallest denomination of the borrowed asset.
`in_referralCode`	`STRING`	Referral code identifier associated with the operation. Numeric string representation of the code used to track referral-based incentives.

Sample Data

address	removed	in_asset	in_amount	in_target	log_index	in_premium	block_number	in_initiator	block_timestamp	transaction_hash
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	false	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	3001703497320	0xbbec108cd432ffb1634dfcd05dd554dae5b057c6	28	2701533147	27399196	0xbbec108cd432ffb1634dfcd05dd554dae5b057c6	2022-09-29T10:55:27.000Z	0x8836a7698e2fb2ca9c4685f883211a235366cffe0472d04504fd321b79b025cd
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	3001823471651	0xbbec108cd432ffb1634dfcd05dd554dae5b057c6	28	2701641124	27398993	0xbbec108cd432ffb1634dfcd05dd554dae5b057c6	2022-09-29T10:54:22.000Z	0x1c0e7000ff2f5d06d57e526f10d156bf427e1e6949c8834e61a8bd9c5999ef43
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	76247585394907077	0x4e6b5a2ef01f0de8973b1cf57a2a9ceeb80df26e	34	68622826855416	32518876	0x4e6b5a2ef01f0de8973b1cf57a2a9ceeb80df26e	2022-10-25T17:01:33.000Z	0x93ec35c72269b2703f35a7a35d6126c1646042145f4d79794446913329a1073a

Example Query

Query with partition filter

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

LendingPool_Repay_event

Loan repayment events from Aave-based lending protocols containing borrower address, repayer address, reserve asset, and repayment amount. Used for tracking debt reduction and loan lifecycle analysis across DeFi 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_repayer`	`STRING`	Address of the account that executed the repayment 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.

Sample Data

address	in_user	removed	in_amount	log_index	in_repayer	in_reserve	block_number	block_timestamp	transaction_hash
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x982458536d6b3c00cb6e9dd0a8d0dc9ed0387855	false	379935	6	0x982458536d6b3c00cb6e9dd0a8d0dc9ed0387855	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	32262833	2022-10-24T17:45:36.000Z	0x64f40fc6429ff24d0642e1b358d866bd44bfc4bf059a5768d2c57fcde80d7a3e
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x095a7fd3014ee22b7c6e33847776d7f0e1e64733	false	800066701560909132	8	0x095a7fd3014ee22b7c6e33847776d7f0e1e64733	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	32286118	2022-10-24T19:54:36.000Z	0x82c2612cbfe7002c595d9237451a27aadd2061a72dc74335121b389122e187c6
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x9a44ca4fcd041062477360b77da67401252f1752	false	2500000116578448542	8	0x9a44ca4fcd041062477360b77da67401252f1752	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	32188772	2022-10-24T11:38:19.000Z	0xd40bc0b4dea47a26efa049cf9035af3dfe867cd9c0d75a6fd94b963f9a91588a

Example Query

Query with partition filter

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

LendingPool_ReserveDataUpdated_event

Aave V2/V3 protocol events emitted when lending pool reserve parameters are updated, including liquidity and borrow indices, interest rates for stable and variable borrowing. Used for tracking interest accrual and reserve state changes across 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_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_liquidityRate`	`STRING`	Current liquidity interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage yield earned by liquidity providers.
`in_stableBorrowRate`	`STRING`	Current stable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a stable rate loan.
`in_variableBorrowRate`	`STRING`	Current variable borrow interest rate for the reserve in ray units (27 decimal precision). Stored as a numeric string representing the annual percentage rate charged to borrowers who choose a variable rate loan.
`in_liquidityIndex`	`STRING`	Cumulative liquidity index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor since the reserve’s inception, stored as a numeric string.
`in_variableBorrowIndex`	`STRING`	Cumulative variable borrow index for the reserve in ray units (27 decimal precision). Represents the accumulated interest growth factor for variable rate borrowers since the reserve’s inception, stored as a numeric string.

Sample Data

address	removed	log_index	in_reserve	block_number	block_timestamp	in_liquidityRate	transaction_hash	in_liquidityIndex	in_stableBorrowRate	in_variableBorrowRate	in_variableBorrowIndex
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	false	3	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	91436698	2023-05-17T00:03:02.000Z	128358433649931753722539	0x49574760b8bfeda64642bc7ec5b5d01859f2bb5f665c756f46c4575d7fe98edd	1014155269206622284521597400	36284497009428642133931174	6284497009428642133931174	1058096245181132255934484928
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	false	3	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	91444740	2023-05-17T00:41:15.000Z	128359698564931041773232	0x37c9c8303d9be1a31be84053450daa322ebe84f94ae1caa69cb82eb7f62e4358	1014155278671746287042448713	36284527974807084163847321	6284527974807084163847322	1058096728677531512413433720
0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	false	3	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	91649830	2023-05-17T15:10:33.000Z	128365345745098365689107	0x8492892097141c808743ac2e08776eafae99f3d7c39e95a67788d1b0fe515324	1014155493973450319285763589	36284666217073916633908210	6284666217073916633908209	1058107726700327811086873482

Example Query

Query with partition filter

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

LendingPool_Withdraw_event

Aave LendingPool withdrawal events recording asset removals from lending positions. Contains user address, reserve token address, withdrawal amount, and recipient address for tracking collateral and liquidity movements across Aave V2 and V3 deployments.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_reserve`	`STRING`	Contract address of the reserve asset in the lending pool operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_to`	`STRING`	Destination address receiving tokens or assets in the operation. 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.

Sample Data

in_to	address	in_user	removed	in_amount	log_index	in_reserve	block_number	block_timestamp	transaction_hash
0x19eb478ae9d013313659d8e333cddd8a0590c5f6	0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x19eb478ae9d013313659d8e333cddd8a0590c5f6	false	8202	33	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	219762431	2024-06-08T17:16:00.000Z	0x7ec38e4821f46a7ad9279828bde56356b7fa7e45f4295ea4aeac43cdbb7dd64e
0x1a21aff0aa7c7b18711e626d1bdd063515796016	0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0x1a21aff0aa7c7b18711e626d1bdd063515796016	false	402	17	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	219599168	2024-06-08T05:55:03.000Z	0x0478ad6dd06084cbd58784694d2d4e231c1e13526841e6e09c6fb2d5f143f992
0xebf9746af2c757a20db467b007f4fa6317385e9a	0x2032b9a8e9f7e76768ca9271003d3e43e1616b1f	0xebf9746af2c757a20db467b007f4fa6317385e9a	false	1002838282870931	21	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	219580681	2024-06-08T04:38:00.000Z	0x6386e0780e2cae792186d633c249515345d1b63feab25abd8d998c1a75944c52

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveFactorChanged_event

Events emitted when the reserve factor parameter is modified for a lending pool asset, capturing the asset address, old factor, and new factor values. Used to track protocol fee adjustments in Aave-based lending protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_factor`	`STRING`	Reserve factor for the asset in basis points. String-encoded integer where 10000 equals 100%.

Sample Data

address	removed	in_asset	in_factor	log_index	block_number	block_timestamp	transaction_hash
0x7130b521c0e361626eceb353455bcddcbebdb121	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	5000	2	18465597	2022-07-24T18:56:50.000Z	0x495d4961294916cce54f32f27dd42fd450489e521470a6837eda7fe99de6e295
0x7130b521c0e361626eceb353455bcddcbebdb121	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	5000	14	18465597	2022-07-24T18:56:50.000Z	0x495d4961294916cce54f32f27dd42fd450489e521470a6837eda7fe99de6e295
0x7130b521c0e361626eceb353455bcddcbebdb121	false	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	5000	8	18465597	2022-07-24T18:56:50.000Z	0x495d4961294916cce54f32f27dd42fd450489e521470a6837eda7fe99de6e295

Example Query

Query with partition filter

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

LendingPoolConfigurator_ReserveInitialized_event

Aave protocol events emitted when new lending reserves are initialized in the LendingPoolConfigurator contract, recording the deployed aToken, stable debt token, variable debt token, and interest rate strategy addresses for each asset.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_aToken`	`STRING`	Contract address of the aToken associated with the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_stableDebtToken`	`STRING`	Contract address of the stable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_variableDebtToken`	`STRING`	Contract address of the variable debt token for the reserve. Hex-encoded, 0x-prefixed, 42-character string.
`in_interestRateStrategyAddress`	`STRING`	Contract address of the interest rate strategy contract for the reserve. Hex-encoded, 0x-prefixed, 42-character string.

Sample Data

address	removed	in_asset	in_aToken	log_index	block_number	block_timestamp	transaction_hash	in_stableDebtToken	in_variableDebtToken	in_interestRateStrategyAddress
0x7130b521c0e361626eceb353455bcddcbebdb121	false	0xa130a97c841ffa12cfb5e3aea503fd5825a39ba6	0x8de8b6865c65f91314695a8eac64c2d006087141	3	28740383	2022-10-06T17:59:03.000Z	0xc3732a84b3d88057762d4638c43df9e3e499c818ec8c326661e0c314560371d7	0x5733378990e7abcba334fa6ee2704c4045eea897	0x105bb93a2028ba26548fd998a82e8f2d2d06166e	0x82f65d71067cc78604b30d279ba047c43608a77e
0x7130b521c0e361626eceb353455bcddcbebdb121	false	0x82af49447d8a07e3bd95bd0d56f35241523fbab1	0x15b53d277af860f51c3e6843f8075007026bbb3a	19	18465590	2022-07-24T18:56:11.000Z	0x3261451ba770db1457bf1ec2c902433df6e321bfdd578459b69757ee0b677096	0x65f9493bdbfa5720c2b26d47c36cf820ce877c64	0x4e75d4bc81d9ad1a1abc972a3dd53d581e1ce16b	0xb8eb3ae665200ae5c850abdbf92357f1334d6745
0x7130b521c0e361626eceb353455bcddcbebdb121	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	0x4cd44e6fcfa68bf797c65889c74b26b8c2e5d4d3	3	18465590	2022-07-24T18:56:11.000Z	0x3261451ba770db1457bf1ec2c902433df6e321bfdd578459b69757ee0b677096	0xbffd1a69d9d9897845dba910b590c4be641fa865	0x0e16bae17c61789d8a96ea6529d788b633c4c8b6	0xbffd3244feff75f29899efc391758cb6f7738bd0

Example Query

Query with partition filter

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

MultiFeeDistribution_RewardPaid_event

Event log emitted when a user claims or receives rewards from a multi-token fee distribution contract. Records the user address, reward token contract address, and reward amount paid out.

Columns

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

Sample Data

address	in_user	removed	in_reward	log_index	block_number	block_timestamp	in_rewardsToken	transaction_hash
0xc2054a8c33bfce28de8af4af548c48915c455c13	0xa8e3a303fcf17bea14f7d50a1132d5febbc7fce7	false	2083071074110	23	81875423	2023-04-18T21:38:28.000Z	0x15b53d277af860f51c3e6843f8075007026bbb3a	0xc2c3283e490be44fc0c83ffc45100fba1cb78db85c4682d10154ee155e620bd9
0xc2054a8c33bfce28de8af4af548c48915c455c13	0xa8e3a303fcf17bea14f7d50a1132d5febbc7fce7	false	14475	18	81875423	2023-04-18T21:38:28.000Z	0xef47ccc71ec8941b67dc679d1a5f78facfd0ec3c	0xc2c3283e490be44fc0c83ffc45100fba1cb78db85c4682d10154ee155e620bd9
0xc2054a8c33bfce28de8af4af548c48915c455c13	0xa8e3a303fcf17bea14f7d50a1132d5febbc7fce7	false	3	28	81875423	2023-04-18T21:38:28.000Z	0x4cd44e6fcfa68bf797c65889c74b26b8c2e5d4d3	0xc2c3283e490be44fc0c83ffc45100fba1cb78db85c4682d10154ee155e620bd9

Example Query

Query with partition filter

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

MultiFeeDistribution_Withdrawn_event

Withdrawal events from MultiFeeDistribution contracts recording token unlock operations with user addresses, received amounts, penalty fees, and locked balance details. Used for tracking vesting schedule exits and early withdrawal penalties in DeFi protocols.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_receivedAmount`	`STRING`	Actual amount of destination tokens received by the beneficiary in the swap or withdrawal operation. String-encoded integer representing token units in the destination token’s smallest denomination.
`in_penaltyPaid`	`STRING`	Penalty amount charged in wei for early withdrawal from the Radiant fee distribution contract. Value is ‘0’ when no penalty applies, otherwise represents the fee deducted from the withdrawn amount.

Sample Data

address	in_user	removed	log_index	block_number	in_penaltyPaid	block_timestamp	transaction_hash	in_receivedAmount
0xc2054a8c33bfce28de8af4af548c48915c455c13	0x2f463642fa60cb1f1fd1c57af25b34b7a9a99586	false	1	22443024	0	2022-09-02T06:51:25.000Z	0x2fb6277035b7f69194b8c61474ab58e36c64f8d8921b36083f0197a708cbb156	0
0xc2054a8c33bfce28de8af4af548c48915c455c13	0xd7a21e2b9eb8143e0ecd29869c77db33b3978c10	false	1	22516705	0	2022-09-02T16:11:01.000Z	0x56691c25e2c5d01f0e9996adaf77d60be7931d513d9ef222ed8d51c351c80224	4300800000000000000000
0xc2054a8c33bfce28de8af4af548c48915c455c13	0x15fe8337a6e23629fa09dc6e0f8b041d681ec995	false	1	22412445	725858416772211131534	2022-09-02T00:52:36.000Z	0xa693e83d30e96cbe43758f338ac9e73544afbafb3f00f5d3bb85931c887d8fc0	725858416772211131535

Example Query

Query with partition filter

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

VariableDebtToken_Burn_event

Variable rate debt token burn events emitted when users repay borrowed assets in lending protocols. Records the debt amount repaid, accumulated interest, and liquidity index at the time of repayment for tracking variable-rate loan lifecycle and interest 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_user`	`STRING`	Address of the user account associated with the transaction or protocol operation. 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_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_user	removed	in_index	in_amount	log_index	block_number	block_timestamp	transaction_hash
0xf92d501e74bd1e4308e6676c38ab4d84389d7bf3	0xd97c114f661675c6ccbf815b05706f1b6a40c90d	false	1025814160601950419824934879	4308264	5	49525551	2022-12-29T04:16:38.000Z	0x579229eda7cc28f86a3b036afb350abaa45d4a704831f76a587710ce7a5ecdb2
0xf92d501e74bd1e4308e6676c38ab4d84389d7bf3	0xcdeb7a633def670b7e410d502e99a9c63ce0c800	false	1025824229086764235118804003	50000000	5	49536749	2022-12-29T05:46:00.000Z	0x4bcf07babeb131968f267b6b3397087c70e705f45ade1a5735bcbcd3b93028e6
0xf92d501e74bd1e4308e6676c38ab4d84389d7bf3	0xde10fba915d507027a95eb451aec7b9e635a46d0	false	1025832622355118409906465007	30000088	5	49547907	2022-12-29T07:00:30.000Z	0x7d80b5fbfa0b902aa679722b7d479083608c1d52e0f3be109bcf22e1e65ecc7d

Example Query

Query with partition filter

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

VariableDebtToken_Mint_event

Variable debt token minting events from lending protocols recording debt issuance to borrowers. Contains borrower address, delegated beneficiary, debt amount, and liquidity index in ray units (1e27) for tracking compounding interest on variable-rate 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_from`	`STRING`	Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_onBehalfOf`	`STRING`	Address of the account receiving the benefit of the operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_value`	`STRING`	Amount of tokens transferred, minted, or burned in the operation. Numeric string representation preserving precision for large integer values.
`in_index`	`STRING`	Liquidity index at the time of the event. Numeric string representation of the scaled interest rate accumulator in ray units (1e27).

Sample Data

address	in_from	removed	in_index	in_value	log_index	block_number	in_onBehalfOf	block_timestamp	transaction_hash
0xf92d501e74bd1e4308e6676c38ab4d84389d7bf3	0xdec036e967c40fd9093711379b52ef0784fc08a2	false	1080475342340856036822576573	2925550	5	175202655	0xdec036e967c40fd9093711379b52ef0784fc08a2	2024-01-28T23:53:24.000Z	0x298e55d1496a231ec32e69bf1c50f92110c8b27bda6733034b327dc8306a8658
0xf92d501e74bd1e4308e6676c38ab4d84389d7bf3	0x0255b2bf607fbf869c31edbbf158a16cf7f6950b	false	1024146205716034611468392988	21404200	5	47168184	0x0255b2bf607fbf869c31edbbf158a16cf7f6950b	2022-12-18T19:07:47.000Z	0xc1716c6f3e3fa155502076d78e5996be630f7365c5c02605ec0572bafda0bcad
0xf92d501e74bd1e4308e6676c38ab4d84389d7bf3	0x0577e7949ec36e43004cde21c69a8dca3e8f62fa	false	1024068594822466358994430632	56000000	6	47043037	0x0577e7949ec36e43004cde21c69a8dca3e8f62fa	2022-12-18T07:13:10.000Z	0x5efeb462b823004d104a0ee0731035d4466b864df7a6beb39183eedd93de03ff

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

AToken_Burn_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

MultiFeeDistribution_RewardPaid_event

MultiFeeDistribution_Withdrawn_event

VariableDebtToken_Burn_event

VariableDebtToken_Mint_event

​Tables

​AToken_Burn_event

​AToken_Mint_event

​LendingPool_Borrow_event

​LendingPool_Deposit_event

​LendingPool_FlashLoan_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Withdraw_event

​LendingPoolConfigurator_ReserveFactorChanged_event

​LendingPoolConfigurator_ReserveInitialized_event

​MultiFeeDistribution_RewardPaid_event

​MultiFeeDistribution_Withdrawn_event

​VariableDebtToken_Burn_event

​VariableDebtToken_Mint_event

Tables

AToken_Burn_event

AToken_Mint_event

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

LendingPoolConfigurator_ReserveFactorChanged_event

LendingPoolConfigurator_ReserveInitialized_event

MultiFeeDistribution_RewardPaid_event

MultiFeeDistribution_Withdrawn_event

VariableDebtToken_Burn_event

VariableDebtToken_Mint_event