radiant_v2_bsc

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
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x016d13e3e6e5704cfd472266f790c6d534c28dd8	false	200000000000000000	127	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	26850954	87220597226440464904081792	0x016d13e3e6e5704cfd472266f790c6d534c28dd8	2023-03-28T07:42:30.000Z	0x56dc470aa094df03518cf6682496d8c5ceb0d78367b67ca003f8eb5bf7397683	2
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x016d13e3e6e5704cfd472266f790c6d534c28dd8	false	150000000000000000	305	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	26850973	87287990416848834177438790	0x016d13e3e6e5704cfd472266f790c6d534c28dd8	2023-03-28T07:43:27.000Z	0xc0caa449bdc37e601c7aa89ea129afd8cdfd40d96cc2bc23006497dbca0b9447	2
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x016d13e3e6e5704cfd472266f790c6d534c28dd8	false	250000000000000000	93	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	26850686	95880766671265450421669068	0x016d13e3e6e5704cfd472266f790c6d534c28dd8	2023-03-28T07:29:06.000Z	0xcef99249a754ff88e6fa229a7cd12b08b36cd18aa2695063e9e6a668f9b1f8a4	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x59a2c1690a85cffd261e7b45b3e1320af5f6f293	false	5495600000000000235	65	0x2170ed0880ac9a755fd29b2688956bd959f933f8	27320936	0x59a2c1690a85cffd261e7b45b3e1320af5f6f293	2023-04-13T19:53:39.000Z	0xd702d29475bddcab44df8eee3f4e145d33b1380be36c8e6698b3d55e27ea3269
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0xe10ed9a4d29c1e00a85cf0043ed680cdc1f40d0f	false	2350100000000000000	39	0x2170ed0880ac9a755fd29b2688956bd959f933f8	27319264	0xe10ed9a4d29c1e00a85cf0043ed680cdc1f40d0f	2023-04-13T18:30:01.000Z	0x4c12071a33b48b61fdf658bc7db85b7a5a523496314173ff8b224c51b4fc2802
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x2761a13570cb78dea547298ff53b21e2ee79d528	false	4521016130000000000	166	0x2170ed0880ac9a755fd29b2688956bd959f933f8	27320826	0x2761a13570cb78dea547298ff53b21e2ee79d528	2023-04-13T19:48:09.000Z	0xcb7a9f05f1313563ee12bf22756efeaa3193cfa4d44886890e6bf079a6c6f62e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	false	0x55d398326f99059ff775485246999027b3197955	21589339618089824570331	0xc1be2a2290dbb51ddf97869becfeb758d6c00230	536	19430405656280842113	27694256	0xc1be2a2290dbb51ddf97869becfeb758d6c00230	2023-04-26T19:48:03.000Z	0xd338820c483d3843d727ec71d45b5de4e5fe400d537369f4fb74007a6b85dae4
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	false	0x55d398326f99059ff775485246999027b3197955	3000000000000000000000000	0x55252a6d50bfad0e5f1009541284c783686f7f25	57	2700000000000000000000	30248638	0x55252a6d50bfad0e5f1009541284c783686f7f25	2023-07-24T17:23:38.000Z	0x62dba55054fa628845fecded658ff5b1ec1c5823f1a5e0118601aa455a30eac9
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	false	0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c	223137960785976902	0xc1be2a2290dbb51ddf97869becfeb758d6c00230	107	200824164707379	27400059	0xc1be2a2290dbb51ddf97869becfeb758d6c00230	2023-04-16T14:05:43.000Z	0x90aee5d7379688e39555bdc4906766e8aad8f7095ebf6ba98b9c664a1617fa4d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x000d774f5fe948c3294f3c09c08e2c0d603374c8	false	951337281095091795	331	0x000d774f5fe948c3294f3c09c08e2c0d603374c8	0x2170ed0880ac9a755fd29b2688956bd959f933f8	28840572	2023-06-05T16:38:25.000Z	0x3a8d148631c6d20d132afd587eae8c79c7d66e4b4da631325e678b1eda93453f
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x000d774f5fe948c3294f3c09c08e2c0d603374c8	false	5009861649999981966	529	0x000d774f5fe948c3294f3c09c08e2c0d603374c8	0x2170ed0880ac9a755fd29b2688956bd959f933f8	28840554	2023-06-05T16:37:31.000Z	0x7bc699af2a28b6bd2ec462b47539509461c0e7312a7672f2951551358018e28b
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x4cc25e0366c564847546f2feda3d7f0d9155b9ac	false	829560726579451063	143	0x4cc25e0366c564847546f2feda3d7f0d9155b9ac	0x2170ed0880ac9a755fd29b2688956bd959f933f8	28848285	2023-06-05T23:04:55.000Z	0x580aae85c60ab64ad2847160f92c7c64bf3eecf52706725f8b278fb7286dee90

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	false	331	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	27958132	2023-05-06T00:00:32.000Z	12451039717348829498891522	0xdb20f283b526ceec1b2b7a927391c8754d381bdf85a805c7540f31332090ddc3	1001229676099158374434207831	109804876227857447899443140	91775607662036065084359610	1009736873019470951858868514
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	false	262	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	27959697	2023-05-06T01:18:51.000Z	12452137162472384710349123	0xf8d28c797b086a2e1fda7731d6e12c76e48e563ebf53a72f3b874d16c28f27fe	1001231533639138937652388917	109808393184852574563011955	91779652162580460747463747	1009750681226552846960591683
0xd50cf00b6e600dd036ba8ef475677d816d6c4281	false	53	0x7130d2a12b9bcbfae4f2634d864a1ee1ce3ead9c	27961753	2023-05-06T03:01:43.000Z	12452240651184545199984041	0x59627b6d929be24c2d8429d423de971c8180448429040443455033d9929f8712	1001233973697187759103906232	109808724824737442401621719	91780033548448058761864978	1009768819037548382909255811

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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
0x1582b06d8c4b6c5990e2ba951d88a88363dab891	0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x1582b06d8c4b6c5990e2ba951d88a88363dab891	false	4376765131902676	195	0x2170ed0880ac9a755fd29b2688956bd959f933f8	31217069	2023-08-27T11:10:56.000Z	0xe46ffea023a2cdc78c6e923fb8e331a473bfa3dfabef4010e28a81175509fe13
0x28177b138fdec353c1da1858798c52ac0be0a0a8	0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x28177b138fdec353c1da1858798c52ac0be0a0a8	false	100000000000000000000	187	0x2170ed0880ac9a755fd29b2688956bd959f933f8	31205639	2023-08-27T01:37:06.000Z	0x56713eb8800712cccdc19bfc6a2a08934c7de53c3be2c8528b6dbee3874a7dd7
0x28177b138fdec353c1da1858798c52ac0be0a0a8	0xd50cf00b6e600dd036ba8ef475677d816d6c4281	0x28177b138fdec353c1da1858798c52ac0be0a0a8	false	100000000000000000000	123	0x2170ed0880ac9a755fd29b2688956bd959f933f8	31212338	2023-08-27T07:12:52.000Z	0x3538e53fa3925884c93f59075671e48897b2660b910c80c0706255cd02007030

Example Query

Query with partition filter

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

MiddleFeeDistribution_NewTransferAdded_event

Fee distribution transfer events from Radiant V2 protocol on BNB Smart Chain tracking asset allocations to the middle fee distributor contract. Records liquidity provider USD values and asset addresses for analyzing protocol fee routing and revenue distribution across different token 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_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 token transfer in the Radiant V2 fee distribution system, represented as a string-encoded integer with 18 decimal places. Zero values indicate transfers with no USD-denominated value at the time of the event.

Sample Data

address	removed	in_asset	log_index	block_number	in_lpUsdValue	block_timestamp	transaction_hash
0xcebdff400a23e5ad1cdeb11afdd0087d5e9dfed8	false	0x89d763e8532d256a3e3e60c1c218ac71e71cf664	269	28437761	0	2023-05-22T16:20:51.000Z	0xd53eef0b1efcf804efd40c829ba50c7bee964152ea931841c9c9fb9757e97645
0xcebdff400a23e5ad1cdeb11afdd0087d5e9dfed8	false	0x58b0bb56cfdfc5192989461dd43568bcfb2797db	287	28437761	188258416783376378124	2023-05-22T16:20:51.000Z	0xd53eef0b1efcf804efd40c829ba50c7bee964152ea931841c9c9fb9757e97645
0xcebdff400a23e5ad1cdeb11afdd0087d5e9dfed8	false	0x455a281d508b4e34d55b31ac2e4579bd9b77ca8e	291	28437761	0	2023-05-22T16:20:51.000Z	0xd53eef0b1efcf804efd40c829ba50c7bee964152ea931841c9c9fb9757e97645

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.MiddleFeeDistribution_NewTransferAdded_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_rewardToken`	`STRING`	Contract address of the reward token being distributed or claimed. 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	in_rewardToken	block_timestamp	transaction_hash
0x4fd9f7c5ca0829a656561486bada018505dfcb5e	0xe10ed9a4d29c1e00a85cf0043ed680cdc1f40d0f	false	7615774683926485071	165	27596289	0x89d763e8532d256a3e3e60c1c218ac71e71cf664	2023-04-23T09:59:08.000Z	0x3a5fbda701d9bec0382011f204d7ad2001cbb383c6ef8b960f90b78ca5bb8c63
0x4fd9f7c5ca0829a656561486bada018505dfcb5e	0xe10ed9a4d29c1e00a85cf0043ed680cdc1f40d0f	false	486598434018379	161	27596289	0x34d4f4459c1b529bebe1c426f1e584151be2c1e5	2023-04-23T09:59:08.000Z	0x3a5fbda701d9bec0382011f204d7ad2001cbb383c6ef8b960f90b78ca5bb8c63
0x4fd9f7c5ca0829a656561486bada018505dfcb5e	0xe10ed9a4d29c1e00a85cf0043ed680cdc1f40d0f	false	116298890319758621	177	27596289	0x58b0bb56cfdfc5192989461dd43568bcfb2797db	2023-04-23T09:59:08.000Z	0x3a5fbda701d9bec0382011f204d7ad2001cbb383c6ef8b960f90b78ca5bb8c63

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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_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	in_lockedBalance	transaction_hash	in_receivedAmount
0x4fd9f7c5ca0829a656561486bada018505dfcb5e	true	0x153ac4007702279f55b4162ba76d3325b2c3ca3e	false	165	28343624	2023-05-19T09:46:50.000Z	0	0x1ee98fae8f9c58657d67dbbf1264ec72f1f313c640b4a9287803b60a3630d9e5	2115663000000000000000
0x4fd9f7c5ca0829a656561486bada018505dfcb5e	true	0x1855b053f08ce64257dbb48b0d19ca5f37b05f65	false	537	28333600	2023-05-19T01:23:12.000Z	0	0x02cad2ffadaa346d59df20e3b2b0bad34194752ad91480cd5ac1a6c7321a795c	1634141672444493836
0x4fd9f7c5ca0829a656561486bada018505dfcb5e	true	0x1e8ebf9e78f7217c5938e79b65600f3f62322bd1	false	409	28358423	2023-05-19T22:08:13.000Z	505495262488741699	0xa80fc88d12e22a10b59a1c67108e8d463f7e54f57ab9b8e9fcecc64b9ca92fa8	272268900642710215

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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
0x3c84437794a5515150982a6f69de5b3e017004a1	0x6e868846b2182235c16fd122fcd44739e55a58e4	false	1014650921587568404972737652	191842565379726	234	28534318	2023-05-26T00:55:53.000Z	0xf837fd5b18054ca402b2b82e046cc85422f8fc1cf4d8b1de8e4a93240ef1451d
0x3c84437794a5515150982a6f69de5b3e017004a1	0x8a7d5ca349bfd8b539e05528dcbf52eb624bb24c	false	1014742717059788063867014410	328104748015	188	28545297	2023-05-26T10:05:20.000Z	0xcbb37e6eda7feeda58cabb63e1fb0b0048d32e3160b575d37397ddb0d6cab75f
0x3c84437794a5515150982a6f69de5b3e017004a1	0xe990f34d8303e038f435455a8b85c481b41a8b0c	false	1014773906234403726101014880	2384955880000000	265	28549021	2023-05-26T13:11:49.000Z	0x8d2f7dd6104210a3828624cdb586e067b4ae1ef58b865816433d63d126fe6f34

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_bsc.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
0x81fda3be7f3ca6acdae20a8d2b4ce54b78d70ed0	0x62cf0107243d16bf47cc223f6a4647321c415d92	false	1061610963877162769536045985	2000000000000000000000	285	32398982	0x62cf0107243d16bf47cc223f6a4647321c415d92	2023-10-07T15:37:13.000Z	0x2b7b30bf09aed3c4f95ba416520e1607955a8b401f1b78732da2c3b6ba1fe1a7
0x437f3df56ecee512e407b6ec368523c911d4a283	0xe66a66792cbb1a9bc8aa684c0e14177eeabb045d	false	1069809953104721168478652792	150000000000000000000	124	32387201	0xe66a66792cbb1a9bc8aa684c0e14177eeabb045d	2023-10-07T05:42:43.000Z	0x309b4307a6d119050365c0597f3e3fda8b197e084589d56222f2e791014ab6e9
0x437f3df56ecee512e407b6ec368523c911d4a283	0xe3d1d431c76c56e0ca7218d76eada3313ce06274	false	1069827775667947321954168654	191638995093044576	216	32388719	0xe3d1d431c76c56e0ca7218d76eada3313ce06274	2023-10-07T06:58:44.000Z	0x83482029f9232275cd5c96ff407dd4806c1d3e4044ab9700ef6357b73368e834

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

MiddleFeeDistribution_NewTransferAdded_event

MultiFeeDistribution_RewardPaid_event

MultiFeeDistribution_Withdrawn_event

VariableDebtToken_Burn_event

VariableDebtToken_Mint_event

​Tables

​LendingPool_Borrow_event

​LendingPool_Deposit_event

​LendingPool_FlashLoan_event

​LendingPool_Repay_event

​LendingPool_ReserveDataUpdated_event

​LendingPool_Withdraw_event

​MiddleFeeDistribution_NewTransferAdded_event

​MultiFeeDistribution_RewardPaid_event

​MultiFeeDistribution_Withdrawn_event

​VariableDebtToken_Burn_event

​VariableDebtToken_Mint_event

Tables

LendingPool_Borrow_event

LendingPool_Deposit_event

LendingPool_FlashLoan_event

LendingPool_Repay_event

LendingPool_ReserveDataUpdated_event

LendingPool_Withdraw_event

MiddleFeeDistribution_NewTransferAdded_event

MultiFeeDistribution_RewardPaid_event

MultiFeeDistribution_Withdrawn_event

VariableDebtToken_Burn_event

VariableDebtToken_Mint_event