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

> Tables in tt-contracts.abracadabra_v1_ethereum

## 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                         |
  | ------------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------- | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ | ------------------------------------------ |
  | 0xf5bce5077908a1b7370b9ae04adc565ebd643966 | 0x000000000000000000000000a47c8bf37f92abed4a126bda807a7b7498661acd0000000000000000000000006b3595068778dd592e39a122f4f5a5cf09c90fe200000000000000000000000000632cfe43d8f9f8e6cd0d39ffa3d4fa7ec73cfb00000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000060000000000000000000000000e572cef69f43c2e488b33924af04bdace19079cf000000000000000000000000a20623070413d42a5c01db2c8111640dd7a5a03a0000000000000000000000000000000000000000000000000de0b6b3a7640000 | false   | 199        | 12429139      | 2021-05-13T23:48:59.000Z | 0xa1db97bb0c3642915f5d6a15434aaae570ed32c3 | 0x1a72f223a9bb7cafbb961f74c871846634e56633966c90dbc8d4b953258153a4 | 0x2cba6ab6574646badc84f0544d05059e57a5dc42 |
  | 0xf5bce5077908a1b7370b9ae04adc565ebd643966 | 0x000000000000000000000000111111111117dc0aa78b770fa6a738034120c3020000000000000000000000008290333cef9e6d528dd5618fb97a76f268f3edd400000000000000000000000000632cfe43d8f9f8e6cd0d39ffa3d4fa7ec73cfb000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000600000000000000000000000007eed379bf00005cfed29fed4009669de9bcc21ce000000000000000000000000c929ad75b72593967de83e7f7cda0493458261d90000000000000000000000000000000000000000000000000de0b6b3a7640000 | false   | 379        | 13247249      | 2021-09-18T03:20:31.000Z | 0x98f304483134f1cb2f682705d5c139c23d3c8941 | 0x2dbe1a81cea069183f0b634274dd456285f86f20588021a1af06386ed80fdedb | 0x2cba6ab6574646badc84f0544d05059e57a5dc42 |
  | 0xf5bce5077908a1b7370b9ae04adc565ebd643966 | 0x000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000ff20817765cb7f73d4bde2e66e067e58d11095c200000000000000000000000000632cfe43d8f9f8e6cd0d39ffa3d4fa7ec73cfb000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000600000000000000000000000008797abc4641de76342b8ace9c63e3301dc35e3d80000000000000000000000005f4ec3df9cbd43714fe2740f5e3616155c5b84190000000000000000000000000000000000000000000000000de0b6b3a7640000 | false   | 182        | 13251263      | 2021-09-18T18:17:59.000Z | 0xd6aece4eabe572f90e30800ed89e31e73687dcb3 | 0xf5c1ef955494bce2b3064bec5a116e51210bff6e330f05004f4c8c087cb050a3 | 0x2cba6ab6574646badc84f0544d05059e57a5dc42 |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.abracadabra_v1_ethereum.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                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------------------ | --------------------- | ------------------------------------------------------------------ |
  | 0xd31e19a0574dbf09310c3b06f3416661b4dc7324 | false   | 364        | 16621476      | 2023-02-13T17:58:47.000Z | 1519314370201191826   | 0x96f26fc806c86033a07f18fcfe90c57278b17d5d745e1951aa5c14fbccec0d5c |
  | 0xd31e19a0574dbf09310c3b06f3416661b4dc7324 | false   | 244        | 16621523      | 2023-02-13T18:08:23.000Z | 735804957212022996    | 0x92391438b48f2daaec5cbed1e77fe523f7db8c01f4b6e819a657bf36b8cdb70b |
  | 0xd31e19a0574dbf09310c3b06f3416661b4dc7324 | false   | 108        | 16617381      | 2023-02-13T04:14:23.000Z | 462619843490989307314 | 0xed51ad9e7ab79f966410f851900e9d2319e4ecbacd0e5463a0d9e8467740c1e1 |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.abracadabra_v1_ethereum.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                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ---------------------- | ------- | ---------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xfb798b154bf1af6b1cce58b6fb7d8a908b1e0365 | 0x3410297d89dcdaf4072b805efc1ef701bb3dd9bf | 0xfb798b154bf1af6b1cce58b6fb7d8a908b1e0365 | 155041187038206837402  | false   | 155775000000000000000  | 151        | 15698451      | 2022-10-07T19:59:59.000Z | 0x227f47317bf7cde00b0e454cd60ff0c7d34d6e020a64c63af22f22d742e3610a |
  | 0x21ad3f3d7b5770a62891bde06ca7db3d8b518dd5 | 0x3410297d89dcdaf4072b805efc1ef701bb3dd9bf | 0x21ad3f3d7b5770a62891bde06ca7db3d8b518dd5 | 111457959342737022850  | false   | 111985397928952839378  | 371        | 15698011      | 2022-10-07T18:31:35.000Z | 0xcfe4884315928af4133e15cd2d1eeb3a53cd0206ccf857869956baf494e84ca5 |
  | 0xa7af4580cc0c9ff4a526de9866689ae1c9817b5f | 0x390db10e65b5ab920c19149c919d970ad9d18a41 | 0xa7af4580cc0c9ff4a526de9866689ae1c9817b5f | 2512500000000000000000 | false   | 2512500000000000000000 | 192        | 15695810      | 2022-10-07T11:04:23.000Z | 0xdbe809cf0042b0f41fabe8ab3d8162d05a716a832fb349ef6bd5832983d1543c |
</Accordion>

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

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.abracadabra_v1_ethereum.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                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------------------------------------------ | ----------------------- | ------- | ----------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0xfb3485c2e209a5cfbdc1447674256578f1a80ee3 | 0x3410297d89dcdaf4072b805efc1ef701bb3dd9bf | 0xfb3485c2e209a5cfbdc1447674256578f1a80ee3 | 45132500219045057262    | false   | 45430816298151410312    | 915        | 16674316      | 2023-02-21T03:49:59.000Z | 0x077b09709ba29122393a7acffcf2493c8811c7cc2607b1b64c059041373fe1a0 |
  | 0xc3be098f9594e57a3e71f485a53d990fe3961fe5 | 0x98a84eff6e008c5ed0289655ccdca899bcb6b99f | 0xc3be098f9594e57a3e71f485a53d990fe3961fe5 | 2001781030133621673253  | false   | 2016807274525768371725  | 209        | 16680111      | 2023-02-21T23:21:35.000Z | 0xf281471eb66134c686063875ce6ad4abd9caac40a936a3e97adb48bb0ca22b56 |
  | 0xd6cb7a7b544e24e5160a948a16c45b1096276f9d | 0x0bca8ebcb26502b013493bf8fe53aa2b1ed401c1 | 0xd6cb7a7b544e24e5160a948a16c45b1096276f9d | 29896613075541118781813 | false   | 29999999999999999999998 | 441        | 14720175      | 2022-05-05T23:40:44.000Z | 0x4e5f28e137af5ba8731c876c710be54e08148671d7c808d29400b0a34ac5a8af |
</Accordion>

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

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

***

### LzProxyOFTV2\_SendToChain\_event

Cross-chain token transfers from Abracadabra on Ethereum using LayerZero (LZ) OFT (Omnichain Fungible Token) protocol. Tracks outbound token bridges with sender addresses, destination chain IDs, and transfer amounts for analyzing cross-chain liquidity flows.

<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                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ---------- | --------------------- | ------------- | ------------------------------------------------------------------ | ---------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x439a5f0f5e8d149dda9a0ca367d4a8e4d6f83c10 | false   | 0x86355f02119bdbc28ed6a4d5e0ca327ca7730fff | 156        | 823151670000000000    | 18281657      | 0x0000000000000000000000006ea42eb7df28c7ce9fdd64299b5e0866bfed882e | 102              | 2023-10-05T03:34:11.000Z | 0xf53f9630892c93145af5cab3f42f57e1d727fbec82473cbe0b3e7d281f9cfa29 |
  | 0x439a5f0f5e8d149dda9a0ca367d4a8e4d6f83c10 | false   | 0x86355f02119bdbc28ed6a4d5e0ca327ca7730fff | 413        | 9996000000000000      | 18281775      | 0x000000000000000000000000eac78006d8c0cf378df707dd338d856e7b623f8f | 102              | 2023-10-05T03:57:59.000Z | 0xc58af3e7884b28a878c6e189a4616827f9f942b1694bf3628be5de5b1d59a376 |
  | 0x439a5f0f5e8d149dda9a0ca367d4a8e4d6f83c10 | false   | 0x287176dfbec7e8cee0f876fc7b52960ee1784adc | 70         | 387797944460000000000 | 18286299      | 0x0000000000000000000000009f2cc8c4c00227cc99c2ea682ef99f80314fd282 | 110              | 2023-10-05T19:09:35.000Z | 0xab0408426c7da38d0a7e438171f48380d23a9c3912426ddc1a84316433e1be6b |
</Accordion>

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

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

***

### Sorbettiere\_Deposit\_event

Deposit events from Abracadabra's Sorbettiere staking contract on Ethereum, recording user stake amounts into pool ID 0. Used for tracking staking activity and analyzing depositor behavior in Abracadabra's yield farming 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_user`          | `STRING`    | Address of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.                    |
  | `in_pid`           | `STRING`    | Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.                  |
  | `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\_pid | address                                    | in\_user                                   | removed | in\_amount            | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | ------------------------------------------ | ------- | --------------------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0       | 0xf43480afe9863da4acbd4419a47d9cc7d25a647f | 0x1ae9938040852172f7588bbbe32cdb0867790591 | false   | 328309586800250628030 | 62         | 15906476      | 2022-11-05T21:24:11.000Z | 0xcecb8cd8faea3ab3550a8436263d8adee06ad6a49be550cff676fbce04d95ceb |
  | 0       | 0xf43480afe9863da4acbd4419a47d9cc7d25a647f | 0x1ae9938040852172f7588bbbe32cdb0867790591 | false   | 0                     | 36         | 15906476      | 2022-11-05T21:24:11.000Z | 0xcecb8cd8faea3ab3550a8436263d8adee06ad6a49be550cff676fbce04d95ceb |
  | 0       | 0xf43480afe9863da4acbd4419a47d9cc7d25a647f | 0xcd35307501ffa76afd70c839227295b35bf14fd3 | false   | 283123594044053758772 | 182        | 15901551      | 2022-11-05T04:52:47.000Z | 0xc9f5505ac41a197d469d9997a480013b416bd66c413d6373d474d4ff4656adf9 |
</Accordion>

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

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

***

### Sorbettiere\_Withdraw\_event

Withdrawal events from Abracadabra's Sorbettiere staking contract on Ethereum, recording when users unstake from specific pool IDs. Used for tracking staking behavior and liquidity movements across Abracadabra's yield farming pools.

<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_pid`           | `STRING`    | Pool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.                  |
  | `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\_pid | address                                    | in\_user                                   | removed | in\_amount | log\_index | block\_number | block\_timestamp         | transaction\_hash                                                  |
  | ------- | ------------------------------------------ | ------------------------------------------ | ------- | ---------- | ---------- | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0       | 0xf43480afe9863da4acbd4419a47d9cc7d25a647f | 0x6180ba55473d3da307bb637f7d1cb07daeb5c073 | false   | 0          | 71         | 12837410      | 2021-07-16T10:37:22.000Z | 0x1a179ef5398ee5f9d745e70d2bdf36ff020396eafaee159a06c4e40502aaf8c2 |
  | 0       | 0xf43480afe9863da4acbd4419a47d9cc7d25a647f | 0x0716266cc5d3c443e30b0c4e9c72afa33778e1de | false   | 0          | 255        | 12840779      | 2021-07-16T23:12:17.000Z | 0x2348d94388e32adcb7f3e7b0d4cbe496124c5aeb1a685f15d6991e040657309b |
  | 0       | 0xf43480afe9863da4acbd4419a47d9cc7d25a647f | 0x794b769d5c7e4d66d9a8d1da91e9cb7a94bb18e7 | false   | 0          | 249        | 12839794      | 2021-07-16T19:37:15.000Z | 0x63d8b337f02db3074ce8c8b0465e6fe920fa0141c8f6535f0afa97e8edd0cd53 |
</Accordion>

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

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

***

### yBribe\_RewardClaimed\_event

Bribe reward claim events from Abracadabra's yBribe gauge voting incentive system on Ethereum. Tracks user claims of governance bribe rewards from specific gauges with token addresses and amounts for analyzing vote-buying activity and incentive distribution.

<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_gauge`         | `STRING`    | Contract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.                                                                                                   |
  | `in_reward_token`  | `STRING`    | Contract address of the reward token being claimed by the user from the gauge. Hex-encoded, 0x-prefixed 40-character Ethereum address matching the token distributed as bribe incentive. |
  | `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\_gauge                                  | in\_amount               | log\_index | block\_number | block\_timestamp         | in\_reward\_token                          | transaction\_hash                                                  |
  | ------------------------------------------ | ------------------------------------------ | ------- | ------------------------------------------ | ------------------------ | ---------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0x03dfdbcd4056e2f92251c7b07423e1a33a7d3f6d | 0xa9dcf7f7e49bf36c29f1616a52fce617a0329a97 | false   | 0xd8b712d29381748db89c36bca0138d7c75866ddf | 54410432461719825202823  | 180        | 16707818      | 2023-02-25T20:59:35.000Z | 0xa9dcf7f7e49bf36c29f1616a52fce617a0329a97 | 0x7e037f3fc945908c1a5a1ca2e4b766a31d11928b7e7fa2dfabb90840aa4ae1de |
  | 0x03dfdbcd4056e2f92251c7b07423e1a33a7d3f6d | 0x7af3edc58487bad40a21b93d90f14453282d8df3 | false   | 0xd8b712d29381748db89c36bca0138d7c75866ddf | 247119581917835665304747 | 213        | 16704592      | 2023-02-25T10:04:35.000Z | 0x7af3edc58487bad40a21b93d90f14453282d8df3 | 0xbce347c73b1165bbd42fb2126e18dd98b76016d35b63855a18c756755509a431 |
  | 0x03dfdbcd4056e2f92251c7b07423e1a33a7d3f6d | 0x6f9ac5b3fa4308620c6763d9aa5a65446e75f5b5 | false   | 0xd8b712d29381748db89c36bca0138d7c75866ddf | 55453370537388907768411  | 807        | 16702075      | 2023-02-25T01:35:59.000Z | 0x6f9ac5b3fa4308620c6763d9aa5a65446e75f5b5 | 0x09ad1e8f8fc4ef92c7227cce87dd77d0505d43e004303cc856dc1df20af94a3b |
</Accordion>

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

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

***