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

# abracadabra_v1_avalanche

> Tables in tt-contracts.abracadabra_v1_avalanche

## Tables

### BentoBox\_LogDeploy\_event

Contract deployment events from BentoBox vaults recording when new clone contracts are instantiated from master contract templates. Contains the deployed clone address, master contract reference, and initialization data for tracking protocol expansion and cauldron creation.

<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_masterContract` | `STRING`    | Contract address of the master contract template used to create the clone. Hex-encoded, 0x-prefixed, 42-character string.                            |
  | `in_data`           | `STRING`    | Encoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.                |
  | `in_cloneAddress`   | `STRING`    | Contract address of the deployed clone instance. Hex-encoded, 0x-prefixed, 42-character string.                                                      |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | in\_data                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | removed | log\_index | block\_number | block\_timestamp         | in\_cloneAddress                           | transaction\_hash                                                  | in\_masterContract                         |
  | ------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
  | 0x1fc83f75499b7620d53757f0b01e2ae626aae530 | 0x00000000000000000000000057319d41f71e81f3c65f2a47ca4e001ebafd4f3300000000000000000000000059b3d5ddf93a3782f7b7a4be1214722fc6fecd4500000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000038a9a7ca0000000000000000000000000000000000000000000000000000000000019a2800000000000000000000000000000000000000000000000000000000000124f800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000 | false   | 21         | 6414426       | 2021-11-02T04:39:23.000Z | 0x3b63f81ad1fc724e44330b4cf5b5b6e355ad964b | 0xf4fe88e005e73aee8d30bd7c1b338f0a01117c8379e4680f90b12ed8c0ff128e | 0x02e07b6f27e5ec37ca6e9f846b6d48704031625a |
  | 0x1fc83f75499b7620d53757f0b01e2ae626aae530 | 0x00000000000000000000000057319d41f71e81f3c65f2a47ca4e001ebafd4f3300000000000000000000000059b3d5ddf93a3782f7b7a4be1214722fc6fecd4500000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000001c54d3e50000000000000000000000000000000000000000000000000000000000019a2800000000000000000000000000000000000000000000000000000000000124f800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000 | false   | 2          | 6414186       | 2021-11-02T04:31:23.000Z | 0xaebe668df677feeab85adfc4a6109378a1c53438 | 0xfa7fa6b7c1da4f6e65991bba1f905548bb747d1a5b4f13c0232ec8c509589b06 | 0x02e07b6f27e5ec37ca6e9f846b6d48704031625a |
  | 0x1fc83f75499b7620d53757f0b01e2ae626aae530 | 0x000000000000000000000000a389f9430876455c36478deea9769b7ca4e3ddb10000000000000000000000000e1ea2269d6e22dfeebce7b0a4c6c3d415b5bc8500000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000038a9a7ca000000000000000000000000000000000000000000000000000000000001a5e00000000000000000000000000000000000000000000000000000000000014c0800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000 | false   | 49         | 6415427       | 2021-11-02T05:13:02.000Z | 0x95cce62c3ecd9a33090bbf8a9eac50b699b54210 | 0x365ef4c8a97bfa251fc6e5d6984e14d114511efbcc971c663449f1c19b603cc0 | 0x02e07b6f27e5ec37ca6e9f846b6d48704031625a |
</Accordion>

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

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

***

### Cauldron\_LogAccrue\_event

Interest accrual events emitted by Abracadabra Cauldron lending pools. Records the amount of interest accumulated on borrowed positions, used for tracking protocol revenue and borrower debt obligations.

<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_accruedAmount` | `STRING`    | Amount of interest accrued in the LogAccrue event. String-encoded integer representing the accrued value in the smallest denomination of the token.  |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | block\_number | block\_timestamp         | in\_accruedAmount    | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | -------------------- | ------------------------------------------------------------------ |
  | 0x0a1e6a80e93e62bd0d3d3bfcf4c362c40fb1cf3d | false   | 75         | 11947506      | 2022-03-10T21:30:08.000Z | 21050162348063203331 | 0x0228c71ca8097d91fb1b5576acb5d8c35d0176f14cf51fc9f28322cf13d7f278 |
  | 0x2450bf8e625e98e14884355205af6f97e3e68d07 | false   | 64         | 11944077      | 2022-03-10T19:33:30.000Z | 3353388399495448066  | 0xd43e4fe51c31467ded0d52b984bd9b1f3b11fe2e5b2b454f687b80b696157901 |
  | 0x2450bf8e625e98e14884355205af6f97e3e68d07 | false   | 27         | 11950715      | 2022-03-10T23:25:16.000Z | 7129949134057987778  | 0x3ae65a7858cb736eb56707f904df887e4bfc20867ee736b806a5aba415b4e8fe |
</Accordion>

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

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

***

### Cauldron\_LogBorrow\_event

Borrow events emitted by Abracadabra Cauldron lending contracts, recording debt issuance with borrowed amount, debt portion in internal accounting units, and borrower address. Primary source for tracking user borrowing activity and debt positions in Abracadabra 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_from`          | `STRING`    | Address originating the transfer or 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.                      |
  | `in_part`          | `STRING`    | Debt portion in the lending protocol's internal accounting units. Numeric string representation in smallest denomination.                            |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | in\_from                                   | in\_part                | removed | in\_amount              | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ----------------------- | ------- | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x34f9321b04fa6f96d78f9fdf491dfbf1dfcb5800 | 0x2450bf8e625e98e14884355205af6f97e3e68d07 | 0x34f9321b04fa6f96d78f9fdf491dfbf1dfcb5800 | 200458757652122676025   | false   | 201000000000000000000   | 28         | 11318572      | 2022-02-24T03:25:07.000Z | 0xfd827a533964b99ab0b4fbcca27f26ec461b10d27284e4715cc702c355dc7815 |
  | 0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd | 0x2450bf8e625e98e14884355205af6f97e3e68d07 | 0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd | 3006882673960926440080  | false   | 3015000000000000000000  | 39         | 11317908      | 2022-02-24T03:02:13.000Z | 0x626b1795e95d8c90abd8ff9303017dfaf875be66ae3df807d0decfd835b694b1 |
  | 0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd | 0x2450bf8e625e98e14884355205af6f97e3e68d07 | 0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd | 10022943294642405411431 | false   | 10050000000000000000000 | 54         | 11317753      | 2022-02-24T02:56:43.000Z | 0x40dabfe1248d9027708a854295fbf50001b51e6dc14b419d7833651957374878 |
</Accordion>

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

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

***

### Cauldron\_LogRepay\_event

Debt repayment events from Abracadabra lending protocol Cauldron contracts. Tracks repayment amount, debt portion reduced, and addresses involved in the repayment transaction.

<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_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.                      |
  | `in_part`          | `STRING`    | Debt portion in the lending protocol's internal accounting units. Numeric string representation in smallest denomination.                            |
</Accordion>

<Accordion title="Sample Data">
  | in\_to                                     | address                                    | in\_from                                   | in\_part                | removed | in\_amount              | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ----------------------- | ------- | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x9e7eb17ad6868322d6655a98906a58c11285cbe5 | 0x2450bf8e625e98e14884355205af6f97e3e68d07 | 0x9e7eb17ad6868322d6655a98906a58c11285cbe5 | 1003176853773492698919  | false   | 1007739428570565399936  | 63         | 14172024      | 2022-05-02T09:37:41.000Z | 0x91a8e5999480578519b343aeae1fe3344f11c2b6e4b81135f630f9fa583e8895 |
  | 0x6fb737d1ebb73cda6cfa36fd16d9273065d1b084 | 0x3b63f81ad1fc724e44330b4cf5b5b6e355ad964b | 0x6fb737d1ebb73cda6cfa36fd16d9273065d1b084 | 20627736651943315685    | false   | 20933335795199999998    | 19         | 14187912      | 2022-05-02T18:41:48.000Z | 0x0653382b6a9a60b2843fc83d876a5c9a63229dd675e2bf66006b68d0daf7f8c8 |
  | 0x76b60dcf71da2294f8aa034432d925d1eed8cf68 | 0x3cfed0439ab822530b1ffbd19536d897ef30d2a2 | 0x76b60dcf71da2294f8aa034432d925d1eed8cf68 | 11010705271461266484241 | false   | 11082668830209042538248 | 36         | 14175370      | 2022-05-02T11:31:42.000Z | 0x13bf9b252a0b6b0f4288aa4934105ad975f9174ee36151faccfd7f2fd464fc7c |
</Accordion>

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

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

***

### LzIndirectOFTV2\_SendToChain\_event

LayerZero cross-chain token transfer events emitted when tokens are sent to a destination chain via the OFT (Omnichain Fungible Token) V2 protocol. Contains sender address, recipient address, token amount, and LayerZero chain identifier for cross-chain message tracking.

<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__dstChainId`   | `STRING`    | LayerZero chain identifier for the destination blockchain. String-encoded integer representing the target chain in cross-chain message transfers.             |
  | `in__from`         | `STRING`    | Address initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.                                                                |
  | `in__toAddress`    | `STRING`    | Destination address for the cross-chain token transfer. 66-character hex string with 0x prefix and 24 leading zeros padding the address.                      |
  | `in__amount`       | `STRING`    | Amount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens). |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | in\_\_from                                 | log\_index | in\_\_amount           | block\_number | in\_\_toAddress                                                    | in\_\_dstChainId | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | ---------------------- | ------------- | ------------------------------------------------------------------ | ---------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xb3a66127ccb143bfb01d3aecd3ce9d17381b130d | false   | 0x03351a3435af95e318aa7ba3eb17eb50a4c6c2df | 23         | 7500000000000000000000 | 32754176      | 0x00000000000000000000000003351a3435af95e318aa7ba3eb17eb50a4c6c2df | 102              | 2023-07-18T08:15:19.000Z | 0xfa332f29f9bd78f9573d74df160c6685d7c64c55db2305ad0918bc4209ea87b5 |
  | 0xb3a66127ccb143bfb01d3aecd3ce9d17381b130d | false   | 0x03351a3435af95e318aa7ba3eb17eb50a4c6c2df | 18         | 8603548804150000000000 | 32750089      | 0x00000000000000000000000003351a3435af95e318aa7ba3eb17eb50a4c6c2df | 102              | 2023-07-18T05:57:52.000Z | 0xbc90c574eed5521e3b240c89a781c326879fe3ed004699473cdf2c7ce28a678f |
  | 0xb3a66127ccb143bfb01d3aecd3ce9d17381b130d | false   | 0x03351a3435af95e318aa7ba3eb17eb50a4c6c2df | 38         | 7000000000000000000000 | 32754688      | 0x00000000000000000000000003351a3435af95e318aa7ba3eb17eb50a4c6c2df | 102              | 2023-07-18T08:32:25.000Z | 0x1c4aab171f4c20de90b8fd3907540bd8b9822c07201b3608d1f3a581d38e76e3 |
</Accordion>

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

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

***