radiant_v2_arbitrum

Tables

ChefIncentivesController_BalanceUpdated_event

Balance update events from Radiant v2’s incentive controller on Arbitrum, tracking user staking positions and total supply changes for reward-eligible tokens. Used for calculating user reward shares and analyzing liquidity provider participation across Radiant’s 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_token`	`STRING`	Token address involved in the transaction or 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_balance`	`STRING`	Token balance amount involved in the operation. Numeric string representation in smallest denomination of the token.
`in_totalSupply`	`STRING`	Total supply of the pool or vault token after the event. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	in_user	removed	in_token	log_index	in_balance	block_number	in_totalSupply	block_timestamp	transaction_hash
0xebc85d44cefb1293707b11f707bd3cec34b4d5fa	0x0000000006dd781fd4da8c2b01e71f5464a7e176	false	0xab04c0841f39596c9f18a981a2bd32f63ab7a817	23	96319571565150963067	123402719	41230105548397353198607	2023-08-21T01:56:37.000Z	0xfcf3aed3e0018dd029156f8ef754225c0bd1d12f1eb58eb95ec217b80def04e6
0xebc85d44cefb1293707b11f707bd3cec34b4d5fa	0x0000000006dd781fd4da8c2b01e71f5464a7e176	false	0xd69d402d1bdb9a2b8c3d88d98b9ceaf9e4cd72d9	21	5914697511	123402719	21321615162272	2023-08-21T01:56:37.000Z	0xfcf3aed3e0018dd029156f8ef754225c0bd1d12f1eb58eb95ec217b80def04e6
0xebc85d44cefb1293707b11f707bd3cec34b4d5fa	0x0000000006dd781fd4da8c2b01e71f5464a7e176	false	0x0df5dfd95966753f01cb80e76dc20ea958238c46	22	114468291739439711808	123402719	76193569260134444458285	2023-08-21T01:56:37.000Z	0xfcf3aed3e0018dd029156f8ef754225c0bd1d12f1eb58eb95ec217b80def04e6

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_arbitrum.ChefIncentivesController_BalanceUpdated_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
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x01270930365fdb3c834a0ea3a9599e5013ae4f37	false	22000000	18	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	84445846	85152889918484879981148431	0x01270930365fdb3c834a0ea3a9599e5013ae4f37	2023-04-26T09:44:33.000Z	0x9c5c07a9ee6269f9fddbf02f724243ed1575f04635338b1fe29b0aae0e74624e	2
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x196bf3a63c50bca1eff5a5809b72dfc58f0c2c1a	false	22245	63	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	84545388	85114465220281912658011146	0x0844a45e1827d6ebb27f33bc6cf3acfa4306d985	2023-04-26T16:37:30.000Z	0x3646552fbeb1880af1b94deed5eecaa5ed5eac21eef0a41f66367fc175667a00	2
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x196bf3a63c50bca1eff5a5809b72dfc58f0c2c1a	false	86236	33	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	84545388	85114455023312036968211923	0x0844a45e1827d6ebb27f33bc6cf3acfa4306d985	2023-04-26T16:37:30.000Z	0x3646552fbeb1880af1b94deed5eecaa5ed5eac21eef0a41f66367fc175667a00	2

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x0061e7958aa1f6bbda7ffdb4d079fa2d413263dd	false	450000000	19	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	71661930	0x0061e7958aa1f6bbda7ffdb4d079fa2d413263dd	2023-03-20T04:51:28.000Z	0xe998fa3cf00bd0eaec441f37175b987ca58e62d729557d153a777957dc1d544f
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x0061e7958aa1f6bbda7ffdb4d079fa2d413263dd	false	50000000	8	0xfd086bc7cd5c481dcc9c85ebe478a1c0b69fcbb9	71661821	0x0061e7958aa1f6bbda7ffdb4d079fa2d413263dd	2023-03-20T04:51:00.000Z	0xc14c87e4475f6ae5905385f1a2abc5bcba76f9818433a346bfc5ca162fb513c2
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x010d317f974ce2ad741c8837e86fb5c52573800e	false	2000000	8	0xff970a61a04b1ca14834a43f5de4533ebddb5cc8	71690052	0x010d317f974ce2ad741c8837e86fb5c52573800e	2023-03-20T06:50:36.000Z	0xf655f23aedc02cf68bcd7340b532bf1dfb34b4f2b5014513e37a06e86bda33c5

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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	in_referralCode	transaction_hash
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	2036731417463492698539	0x07f6654632de21356028a9648b28f5c30ed4fe0a	37	1833058275717143428	188065138	0x07f6654632de21356028a9648b28f5c30ed4fe0a	2024-03-07T17:13:04.000Z	0	0xeb3d76479a045630d1b5d31be0ab2c7d78b18f75a81a4c1065691f73647d7642
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	false	0xda10009cbd5d07dd0cecc66161fc93d7c9000da1	40725481467053410682136	0x07f6654632de21356028a9648b28f5c30ed4fe0a	144	36652933320348069613	188106334	0x07f6654632de21356028a9648b28f5c30ed4fe0a	2024-03-07T20:17:33.000Z	0	0x08d700304fcc58cdb9ad69fdf065a4cb96dd6dfa50879acbfc2ff638e5f3c5b3
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	false	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	49213	0x6bfce075a1c4f0fd4067a401da8f159354e1a916	46	44	252460280	0x527c3a106e5a2559e72042003f3aaa821a0fe989	2024-09-11T16:45:09.000Z	56	0xed243663a02770efdf748b5fb29142f87a5091722f11b07411ce6ede81fdf641

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0xeedd8515c0e2263aa4ff1966938f6a55012f989d	false	140000000000000000	6	0xeedd8515c0e2263aa4ff1966938f6a55012f989d	0x5979d7b546e38e414f7e9822514be443a4800529	228348259	2024-07-03T14:01:17.000Z	0xe7836e7d9d7fb1f1b2ae099f7aef8614de330b7a1d1490435a6a9fba8ace2954
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x6bfcac67f3c2a635c4d83c71478648c8e0db4c82	false	10000000000000000	6	0x6bfcac67f3c2a635c4d83c71478648c8e0db4c82	0x5979d7b546e38e414f7e9822514be443a4800529	228231602	2024-07-03T05:53:11.000Z	0x03575a31394be1cec12b11f6393187e98e64cdf6d4fcc2f129ec0b36dd78efe8
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x87285198e7c370b76052268b0718fb4792747c1f	false	51000000000000000	6	0x87285198e7c370b76052268b0718fb4792747c1f	0x5979d7b546e38e414f7e9822514be443a4800529	228316244	2024-07-03T11:46:59.000Z	0x3638c015ae4c00fdea8471b1e41bab3c790a6686643333b1db413b3d7cbe5819

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	false	124	0x912ce59144191c1204e64559fe8253a0e49e6548	119224848	2023-08-08T01:57:31.000Z	4222838845024785116391915	0x3d18b2481acf81a85a0b6c2544ceb9d843c34b3007054acf8287300b22fbb63d	1001668135614969471491552698	43322249069680812818308719	64983373604521219227463078	1023090061292734907588132777
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	false	148	0x912ce59144191c1204e64559fe8253a0e49e6548	119231717	2023-08-08T02:28:02.000Z	4223704908116063708715789	0xfc0075c252f3064ef3e480dad03dfa2010c833fb7af503311b7e8a561a944eac	1001668381246097440146859916	43326691327459072476181480	64990036991188608714272220	1023093921719407307048318353
0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	false	136	0x912ce59144191c1204e64559fe8253a0e49e6548	119239609	2023-08-08T03:02:37.000Z	4223628197995922417922984	0x72055ae674183b42836561c59bd242e22146239cb98f3aa322403946053fa31a	1001668659616319287215840210	43326297880134967069324477	64989446820202450603986715	1023098296654059916506860668

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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
0x0b006669ac55afe1887c6db142d59590e55b8803	0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x0b006669ac55afe1887c6db142d59590e55b8803	false	96569	7	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	202109158	2024-04-17T23:24:46.000Z	0x9149bd94a94b2eae5aeb017c504b9c7c17e2a8ce06591622d6e2c8805a931923
0xf45ded4b0c4b8ca1aa138dad69a1bc2a7a353590	0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0xf45ded4b0c4b8ca1aa138dad69a1bc2a7a353590	false	3327619	7	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	202027185	2024-04-17T17:38:58.000Z	0x2aa9e2d89e2c059afa6bb42a2a1b356575a5c3e74f13b53759f48f175124780e
0x605e6fd2aab5827fa88f8e5f640f9f76b97e3c34	0xf4b1486dd74d07706052a33d31d7c0aafd0659e1	0x605e6fd2aab5827fa88f8e5f640f9f76b97e3c34	false	1667	7	0x2f2a2543b76a4166549f7aab2e75bef0aefc5b0f	202043858	2024-04-17T18:49:16.000Z	0xa04be7d61ae1082cdeb15b1fdcb3cbcb408057d65d71de0d0cbe15a445b363b7

Example Query

Query with partition filter

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

MiddleFeeDistribution_NewTransferAdded_event

Event logs tracking new fee transfer additions in Radiant V2’s middle fee distribution contract on Arbitrum, capturing asset addresses and liquidity provider USD values for protocol revenue analysis.

Columns

Column	Type	Description
`block_timestamp`	`TIMESTAMP`	Timestamp when the block was produced. UTC timezone, millisecond precision.
`block_number`	`INT64`	Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
`transaction_hash`	`STRING`	Unique identifier for the transaction. 66-character hex string including 0x prefix.
`log_index`	`INT64`	Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
`address`	`STRING`	Contract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
`removed`	`BOOL`	Boolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
`in_asset`	`STRING`	Contract address of the asset or token. Hex-encoded, 0x-prefixed, 42-character string.
`in_lpUsdValue`	`STRING`	USD value of the liquidity pool transfer denominated in wei (18 decimals). Represents the dollar-denominated amount being added to the fee distribution contract, with zero indicating no value transfer.

Sample Data

address	removed	in_asset	log_index	block_number	in_lpUsdValue	block_timestamp	transaction_hash
0xe10997b8d5c6e8b660451f61accf4bba00bc901f	false	0xd69d402d1bdb9a2b8c3d88d98b9ceaf9e4cd72d9	13	108162304	1812307726130910000	2023-07-05T15:52:23.000Z	0xf914a6dd56a8ffa9a2c374c63f3de5bb24ce0b67b66b3e8f46cb478c8bcf8418
0xe10997b8d5c6e8b660451f61accf4bba00bc901f	false	0x48a29e756cc1c097388f3b2f3b570ed270423b3d	7	108162304	0	2023-07-05T15:52:23.000Z	0xf914a6dd56a8ffa9a2c374c63f3de5bb24ce0b67b66b3e8f46cb478c8bcf8418
0xe10997b8d5c6e8b660451f61accf4bba00bc901f	false	0x42c248d137512907048021b30d9da17f48b5b7b2	29	108162304	0	2023-07-05T15:52:23.000Z	0xf914a6dd56a8ffa9a2c374c63f3de5bb24ce0b67b66b3e8f46cb478c8bcf8418

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_arbitrum.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
0x76ba3ec5f5adbf1c58c91e86502232317eea72de	0x01b009add41b107411266248ece40b0f3f98a413	false	394665770781049	77	217343554	0xb11a56da177c5532d5e29cc8363d145bd0822c81	2024-06-01T16:43:25.000Z	0x66072031b69fa2dd68d39e93c5f50cd3eb47925e4b658b14011b485ed48742df
0x76ba3ec5f5adbf1c58c91e86502232317eea72de	0x01b009add41b107411266248ece40b0f3f98a413	false	8300	45	217343554	0x727354712bdfcd8596a3852fd2065b3c34f4f770	2024-06-01T16:43:25.000Z	0x66072031b69fa2dd68d39e93c5f50cd3eb47925e4b658b14011b485ed48742df
0x76ba3ec5f5adbf1c58c91e86502232317eea72de	0x01b009add41b107411266248ece40b0f3f98a413	false	15235194	49	217343554	0xd69d402d1bdb9a2b8c3d88d98b9ceaf9e4cd72d9	2024-06-01T16:43:25.000Z	0x66072031b69fa2dd68d39e93c5f50cd3eb47925e4b658b14011b485ed48742df

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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_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
0x76ba3ec5f5adbf1c58c91e86502232317eea72de	true	0xaf1c30f7e8ce075205714caa88203243b60b297f	false	1	120622928	2023-08-12T09:09:56.000Z	0x26feeaa34642952cc6cc90ed93d01756654326be1a8f0a536f14fdaca6d8ce4a	1241135529164646081884
0x76ba3ec5f5adbf1c58c91e86502232317eea72de	true	0x31d3243cfb54b34fc9c73e1cb1137124bd6b13e1	false	1	120589186	2023-08-12T06:44:13.000Z	0xbaf7eebbf1c74dd22866fcf9d9cfa817d0081e1dbbf76d7d8442039aa1e564f8	4817320330067344402461
0x76ba3ec5f5adbf1c58c91e86502232317eea72de	true	0xcf9df692cd650f4e3bbc8ab94bb3e2138543bb8c	false	1	120557064	2023-08-12T04:14:19.000Z	0xaa96353ba615eca16784822f51a710c67be315f0ec3555bc2e99d51ddd36dadd	64436940849803116571

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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
0x107583adaa37dfd1cc0bf577183bf91351d07413	0xd7c3dad33468cad01213b172e3361b53f49a9f4b	false	1052976466469342385198103253	932790887	1	126277324	2023-08-30T04:46:46.000Z	0x5a905ae1f3f0bbd64505eb1e2964c33e75b0590b2b8fa3453e190d63818be49d
0x107583adaa37dfd1cc0bf577183bf91351d07413	0x69dd6d4e11b8e06d86273a8b9bede1f0f6bebfa9	false	1052976466469342385198103253	957505447	1	126277323	2023-08-30T04:46:46.000Z	0x863ec9a05a460df561f4c01acf673e1664bfcbea022a635904745c8a36f48795
0x107583adaa37dfd1cc0bf577183bf91351d07413	0xcc26927325c10ac04bc432694ed2f12e2193351d	false	1052976466469342385198103253	936938362	1	126277322	2023-08-30T04:46:46.000Z	0xf679a24c9b0d9f059c6b59fffc58174c87994135bf71960bc3819e30f9125d9c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.radiant_v2_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
0x97b81aa985115953ba31d59781e2d8159a50f488	0x1241de051c6c822809e405806418c0211fd027ca	false	1003586352203719385043030813	758318738257903699	10	88780760	0x1241de051c6c822809e405806418c0211fd027ca	2023-05-09T03:20:00.000Z	0xa2fbe6a2b6a3cceeec75fcef2ebba30fb9040bc36ecd31c2207371a9a54b24c8
0x97b81aa985115953ba31d59781e2d8159a50f488	0x88961d145a94c506956839def9f4f3206708cbca	false	1003597534219352850309030787	13000000000000000000	3	88798973	0x88961d145a94c506956839def9f4f3206708cbca	2023-05-09T04:37:33.000Z	0x02577799505167ad961067467aa671d93a285a012155a5c4754c3d8ec0cb9e8c
0x97b81aa985115953ba31d59781e2d8159a50f488	0x88961d145a94c506956839def9f4f3206708cbca	false	1003597786779794200286538592	13000000000000000000	4	88799378	0x88961d145a94c506956839def9f4f3206708cbca	2023-05-09T04:39:18.000Z	0xd6343e40df80c24e892efd389509beef3ff9e814d395749fb6f05db3a479992b

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

ChefIncentivesController_BalanceUpdated_event

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​ChefIncentivesController_BalanceUpdated_event

​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

ChefIncentivesController_BalanceUpdated_event

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