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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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). |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter
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.Columns
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. |
Sample Data
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 |
Example Query
Example Query
Query with partition filter