radiant_v2_ethereum

Tables

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
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x1967654222ec22e37c0b0c2a15583b9581d3095e	false	100000	80	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18470965	406259513734102101006864443	0x1967654222ec22e37c0b0c2a15583b9581d3095e	2023-10-31T15:20:47.000Z	0xace774da2e9b1fa7abec0ca8f9ae2f30c4b4c47ae66e6eeffbe03aa2de67505e	2
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x63aaa6867d0697de09cf7050c045c44dea8a5455	false	24605	413	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18467184	801592653077206543783916162	0x63aaa6867d0697de09cf7050c045c44dea8a5455	2023-10-31T02:36:47.000Z	0x0c1b7961e2dcdf883de358650ac2bc20889dfa0a5fb8000e4fe59447375ee13e	2
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x63aaa6867d0697de09cf7050c045c44dea8a5455	false	4000000	304	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18466735	797461697650257278257759993	0x63aaa6867d0697de09cf7050c045c44dea8a5455	2023-10-31T01:05:47.000Z	0x0f94278649a92ba5919e771b3048398d0cf3d719fa230f26542ed3f85d5417ed	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_ethereum.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
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x00ba280c55643f707e23376c948be41b5468ef58	false	220000000	302	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	18483172	0x00ba280c55643f707e23376c948be41b5468ef58	2023-11-02T08:19:47.000Z	0xf97f81030106648de1b65e3e279a8ad86121aeb3abc4e3734ff1238e459beb87
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x0c30ed59a7d409e5f43ff46f744edd93f9e8e7e7	false	47095248133	147	0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48	18483517	0x0c30ed59a7d409e5f43ff46f744edd93f9e8e7e7	2023-11-02T09:29:23.000Z	0xd798916aca65ae84e90cfe6110de8b7ac5ab1e83bd5116a7722f3b839d75f835
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x0f74008151040141b50d44068f9004ef71327dcd	false	28166982888316242134	171	0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0	18484263	0x0f74008151040141b50d44068f9004ef71327dcd	2023-11-02T12:01:23.000Z	0x79f10de7a7b3076bebaecfb5156df14929f9cfdf93d2c50fdfcff2a310ea3196

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_ethereum.LendingPool_Deposit_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
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x6fb2775c1424b5b10bd810be11f68274264a7e48	false	30000000	322	0x6fb2775c1424b5b10bd810be11f68274264a7e48	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18491724	2023-11-03T13:06:59.000Z	0x6c4ea42d1a1fc1a2b7ad018d13cb332ed19d523afd5c25eab1fff143a6656715
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x16255e63103423aeb5bd22146e0e3d406c1b5ea0	false	1000000000000000000000	395	0x16255e63103423aeb5bd22146e0e3d406c1b5ea0	0x83f20f44975d03b1b09e64809b757c47f942beea	18490493	2023-11-03T08:58:47.000Z	0x0d2228bcd0ffe8c972d99c5277eff54446b3cf159e5ff43cde24d3d06bd8d980
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0xa8d7f201936eae4d51095ed70d36f06fdc91dc4d	false	100000000000000000000000	101	0xa8d7f201936eae4d51095ed70d36f06fdc91dc4d	0x83f20f44975d03b1b09e64809b757c47f942beea	18490590	2023-11-03T09:18:23.000Z	0x08ac715bac4ab25dcee620747ca8d65440485bb1a1d57b11deac50d15f72616a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_ethereum.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
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	false	282	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18480937	2023-11-02T00:49:11.000Z	479670163266116816618624	0xdd0c5390a985be7606d7a4f025a49cbe93a660867e256da62d7a7806f48d1afd	1000065996593282486891168974	175204692695960109967509228	20328656977434415395451292	1000537817644382703908186115
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	false	121	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18481354	2023-11-02T02:13:11.000Z	443542339948247870332641	0x3364bd4ddaa0c5d807ff8c7202f9cd29042cc8705a06bfffd9bad96b97460f64	1000066073257956894186635692	169629390140943370998224643	19548114619732071939751451	1000541068269082511218435485
0xa950974f64aa33f27f6c5e017eee93bf7588ed07	false	115	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18481375	2023-11-02T02:17:23.000Z	229429023919199362043225	0xd44d79ad8ed8b950ef0d4a2b4bec4e8529ad8bfdd3ca1b3ba02dcb7aa1fcad75	1000066076802479181458131728	130423066375134089138818029	14059229292518772479434525	1000541224560008356713399347

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_ethereum.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
0xf748879edbe8cca140940788163d7be4d2a2e46a	0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0xf748879edbe8cca140940788163d7be4d2a2e46a	false	300000000	238	0x2260fac5e5542a773aa44fbcfedf7c193bc2c599	18490567	2023-11-03T09:13:35.000Z	0xb17e20827d19f130ca76c1e6a5f8860e0726035204f1d48ebe6af6f6f0d93d3e
0x28177b138fdec353c1da1858798c52ac0be0a0a8	0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0x28177b138fdec353c1da1858798c52ac0be0a0a8	false	9606585951575804000000	738	0x83f20f44975d03b1b09e64809b757c47f942beea	18488617	2023-11-03T02:40:11.000Z	0xeb57665b7f3587e58297b34008fab8f8cc7bc14c454a9a5c680f6d109667390e
0xffab14b181409170378471b13ff2bff5be012c64	0xa950974f64aa33f27f6c5e017eee93bf7588ed07	0xffab14b181409170378471b13ff2bff5be012c64	false	177955927908773024426910	277	0x83f20f44975d03b1b09e64809b757c47f942beea	18487971	2023-11-03T00:29:47.000Z	0xaae5d60cd61c467be0a5a568796e9f82a77ba7ae7ca60995a0949a7f3ebc7188

Example Query

Query with partition filter

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

MultiFeeDistribution_NewTransferAdded_event

Event logs tracking new asset transfers added to Radiant V2’s fee distribution contract on Ethereum, capturing liquidity provider (LP) token USD values for various collateral assets. Used for analyzing fee distribution flows and asset composition in the lending protocol’s reward system.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-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_lpUsdValue`	`STRING`	USD value of the liquidity provider (LP) token transfer denominated in wei-equivalent precision (18 decimals). Represents the dollar-denominated value of the asset being added to the Radiant V2 fee distribution contract.

Sample Data

address	removed	in_asset	log_index	block_number	in_lpUsdValue	block_timestamp	transaction_hash
0x28e395a54a64284dba39652921cd99924f4e3797	false	0x473693ecdad05f5002ff5f63880cfa5901fb50e8	157	18495817	86799592450281902295	2023-11-04T02:51:11.000Z	0xa610ce932768308130f5fc840a2c503868f767541d5f40f42828b4ea15fefcee
0x28e395a54a64284dba39652921cd99924f4e3797	false	0x83b3896ec36cb20cfb430fcfe8da23d450dd09b5	150	18495817	681787986757236959977	2023-11-04T02:51:11.000Z	0xa610ce932768308130f5fc840a2c503868f767541d5f40f42828b4ea15fefcee
0x28e395a54a64284dba39652921cd99924f4e3797	false	0x9e85df2b42b2ae5e666d7263ed81a744a534bf1f	177	18495817	3529500617373080400000	2023-11-04T02:51:11.000Z	0xa610ce932768308130f5fc840a2c503868f767541d5f40f42828b4ea15fefcee

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_ethereum.MultiFeeDistribution_NewTransferAdded_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_lockedBalance`	`STRING`	Remaining locked balance of the user after the withdrawal operation. String-encoded integer representing token units in smallest denomination.
`in_penalty`	`STRING`	Penalty amount assessed in the operation. Numeric string representation of token quantity in smallest denomination.
`in_burn`	`STRING`	Amount of tokens burned in the withdrawal operation. String-encoded integer representing token units in smallest denomination.
`in_isLP`	`BOOL`	Boolean flag indicating whether the withdrawn tokens are liquidity provider (LP) tokens.

Sample Data

address	in_isLP	in_user	removed	log_index	block_number	block_timestamp	transaction_hash	in_receivedAmount
0x28e395a54a64284dba39652921cd99924f4e3797	false	0x500bea59133e20dc63b7e88913b30348494b84ba	false	205	19631223	2024-04-11T08:35:11.000Z	0xb31b1c529779a00cf6a47bd7388ac269e383788f97ab7888426f540ffea2c7a2	14340517397809228278152
0x28e395a54a64284dba39652921cd99924f4e3797	true	0x5f14dd7d03ed2de199bba7b12f4684ecebdaa407	false	228	21153806	2024-11-10T00:53:23.000Z	0x4b174fbb3ddf5a76f6bd1df8e62c35a090bd77fbfbc200b45a66c1253ca95fb1	14221885812658998613613
0x28e395a54a64284dba39652921cd99924f4e3797	true	0xf2eae206f22afe2b9b1c71a274a85bd0d4cdeac0	false	259	21155578	2024-11-10T06:49:11.000Z	0x992277a2a3d742f9387831e35a1ae20c4626fa1f0514d21ba75079a114016973	6355750482561784203835

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_ethereum.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
0x0184eb8a4d86ff250cb2f7f3146aecc14ccb73a4	0x1ca8d8c18e836d1783c858c0e8cfeac061f33a51	false	1000551255134642225989426164	14000000	234	18482037	2023-11-02T04:30:35.000Z	0x0c8c62fa41ae1ee5d659ddef091cd0aac129f12c35ef13e4aa32da56de895927
0x0184eb8a4d86ff250cb2f7f3146aecc14ccb73a4	0x5998fff8b8a51af65f2983f7f09ef563a2753428	false	1000589645103566896833210909	25000000	183	18483312	2023-11-02T08:47:59.000Z	0xaa0be3917c0b10381aa7da51217b5c271a2a9e78d8f75993f57036a89397484f
0x0184eb8a4d86ff250cb2f7f3146aecc14ccb73a4	0x5998fff8b8a51af65f2983f7f09ef563a2753428	false	1000590038969703534758235742	9748821	643	18483324	2023-11-02T08:50:23.000Z	0x806c2e413fe93e837a75d5e520ed869e0902077313ec75a83c3fbf1fa5bdbfe5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_ethereum.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
0x490726291f6434646feb2ec96d2cc566b18a122f	0x06dd52564b68dde77b4e9d4e0e5d325f9a86746d	false	1001855167184903050991073022	845544060	215	18494996	0x06dd52564b68dde77b4e9d4e0e5d325f9a86746d	2023-11-04T00:06:35.000Z	0xd4cdec0a03ad0b7702f8500a3bae1b28f59e0e17233a08d4c94db707ff9ab249
0x490726291f6434646feb2ec96d2cc566b18a122f	0x0d4416d186c594df8363447f9ff57ccc604fcba9	false	1001961907845140869365859959	322000000000	267	18495941	0x0d4416d186c594df8363447f9ff57ccc604fcba9	2023-11-04T03:15:59.000Z	0x6eaf95967b82d5f0b14abaf2e07a665826750d3898816774007896401294f3f3
0x490726291f6434646feb2ec96d2cc566b18a122f	0x0d4416d186c594df8363447f9ff57ccc604fcba9	false	1001962693899235863704401476	280000000000	282	18495950	0x0d4416d186c594df8363447f9ff57ccc604fcba9	2023-11-04T03:17:47.000Z	0x67911a7f2c50fc2fd343624c3bc6b748116e2e026d833d43cfff70c57c367cae

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

MultiFeeDistribution_NewTransferAdded_event

MultiFeeDistribution_Withdrawn_event

VariableDebtToken_Burn_event

VariableDebtToken_Mint_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​LendingPool_Borrow_event

​LendingPool_Deposit_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Withdraw_event

​MultiFeeDistribution_NewTransferAdded_event

​MultiFeeDistribution_Withdrawn_event

​VariableDebtToken_Burn_event

​VariableDebtToken_Mint_event

Tables

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

MultiFeeDistribution_NewTransferAdded_event

MultiFeeDistribution_Withdrawn_event

VariableDebtToken_Burn_event

VariableDebtToken_Mint_event