> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# radiant_v2_ethereum

> Tables in tt-contracts.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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount | log\_index | in\_reserve                                | in\_referral | block\_number | in\_borrowRate              | in\_onBehalfOf                             | block\_timestamp         | transaction\_hash                                                  | in\_borrowRateMode |
  | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------------------------------------ | ------------ | ------------- | --------------------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ | ------------------ |
  | 0xa950974f64aa33f27f6c5e017eee93bf7588ed07 | 0x1967654222ec22e37c0b0c2a15583b9581d3095e | false   | 100000     | 80         | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 0            | 18470965      | 406259513734102101006864443 | 0x1967654222ec22e37c0b0c2a15583b9581d3095e | 2023-10-31T15:20:47.000Z | 0xace774da2e9b1fa7abec0ca8f9ae2f30c4b4c47ae66e6eeffbe03aa2de67505e | 2                  |
  | 0xa950974f64aa33f27f6c5e017eee93bf7588ed07 | 0x63aaa6867d0697de09cf7050c045c44dea8a5455 | false   | 24605      | 413        | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 0            | 18467184      | 801592653077206543783916162 | 0x63aaa6867d0697de09cf7050c045c44dea8a5455 | 2023-10-31T02:36:47.000Z | 0x0c1b7961e2dcdf883de358650ac2bc20889dfa0a5fb8000e4fe59447375ee13e | 2                  |
  | 0xa950974f64aa33f27f6c5e017eee93bf7588ed07 | 0x63aaa6867d0697de09cf7050c045c44dea8a5455 | false   | 4000000    | 304        | 0x2260fac5e5542a773aa44fbcfedf7c193bc2c599 | 0            | 18466735      | 797461697650257278257759993 | 0x63aaa6867d0697de09cf7050c045c44dea8a5455 | 2023-10-31T01:05:47.000Z | 0x0f94278649a92ba5919e771b3048398d0cf3d719fa230f26542ed3f85d5417ed | 2                  |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.LendingPool_Borrow_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_user                                   | removed | in\_amount           | log\_index | in\_reserve                                | in\_referral | block\_number | in\_onBehalfOf                             | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | -------------------- | ---------- | ------------------------------------------ | ------------ | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0xa950974f64aa33f27f6c5e017eee93bf7588ed07 | 0x00ba280c55643f707e23376c948be41b5468ef58 | false   | 220000000            | 302        | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0            | 18483172      | 0x00ba280c55643f707e23376c948be41b5468ef58 | 2023-11-02T08:19:47.000Z | 0xf97f81030106648de1b65e3e279a8ad86121aeb3abc4e3734ff1238e459beb87 |
  | 0xa950974f64aa33f27f6c5e017eee93bf7588ed07 | 0x0c30ed59a7d409e5f43ff46f744edd93f9e8e7e7 | false   | 47095248133          | 147        | 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48 | 0            | 18483517      | 0x0c30ed59a7d409e5f43ff46f744edd93f9e8e7e7 | 2023-11-02T09:29:23.000Z | 0xd798916aca65ae84e90cfe6110de8b7ac5ab1e83bd5116a7722f3b839d75f835 |
  | 0xa950974f64aa33f27f6c5e017eee93bf7588ed07 | 0x0f74008151040141b50d44068f9004ef71327dcd | false   | 28166982888316242134 | 171        | 0x7f39c581f595b53c5cb19bd0b3f8da6c935e2ca0 | 0            | 18484263      | 0x0f74008151040141b50d44068f9004ef71327dcd | 2023-11-02T12:01:23.000Z | 0x79f10de7a7b3076bebaecfb5156df14929f9cfdf93d2c50fdfcff2a310ea3196 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.LendingPool_Deposit_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.LendingPool_Repay_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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. |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.LendingPool_ReserveDataUpdated_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.LendingPool_Withdraw_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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. |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.MultiFeeDistribution_NewTransferAdded_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                                                                                                               |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_burn | in\_isLP | in\_user                                   | removed | log\_index | in\_penalty | block\_number | block\_timestamp         | in\_lockedBalance | transaction\_hash                                                  | in\_receivedAmount      |
  | ------------------------------------------ | -------- | -------- | ------------------------------------------ | ------- | ---------- | ----------- | ------------- | ------------------------ | ----------------- | ------------------------------------------------------------------ | ----------------------- |
  | 0x28e395a54a64284dba39652921cd99924f4e3797 | 0        | false    | 0x500bea59133e20dc63b7e88913b30348494b84ba | false   | 205        | 0           | 19631223      | 2024-04-11T08:35:11.000Z | 0                 | 0xb31b1c529779a00cf6a47bd7388ac269e383788f97ab7888426f540ffea2c7a2 | 14340517397809228278152 |
  | 0x28e395a54a64284dba39652921cd99924f4e3797 | 0        | true     | 0x5f14dd7d03ed2de199bba7b12f4684ecebdaa407 | false   | 228        | 0           | 21153806      | 2024-11-10T00:53:23.000Z | 0                 | 0x4b174fbb3ddf5a76f6bd1df8e62c35a090bd77fbfbc200b45a66c1253ca95fb1 | 14221885812658998613613 |
  | 0x28e395a54a64284dba39652921cd99924f4e3797 | 0        | true     | 0xf2eae206f22afe2b9b1c71a274a85bd0d4cdeac0 | false   | 259        | 0           | 21155578      | 2024-11-10T06:49:11.000Z | 0                 | 0x992277a2a3d742f9387831e35a1ae20c4626fa1f0514d21ba75079a114016973 | 6355750482561784203835  |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.MultiFeeDistribution_Withdrawn_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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).                 |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.VariableDebtToken_Burn_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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).                 |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.radiant_v2_ethereum.VariableDebtToken_Mint_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***