Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_masterContractSTRINGContract address of the master contract template used to create the clone. Hex-encoded, 0x-prefixed, 42-character string.
in_dataSTRINGEncoded input data for the contract function call. Hex-encoded byte string representing function parameters and additional call data.
in_cloneAddressSTRINGContract address of the deployed clone instance. Hex-encoded, 0x-prefixed, 42-character string.
addressin_dataremovedlog_indexblock_numberblock_timestampin_cloneAddresstransaction_hashin_masterContract
0xf5bce5077908a1b7370b9ae04adc565ebd6439660x000000000000000000000000a47c8bf37f92abed4a126bda807a7b7498661acd0000000000000000000000006b3595068778dd592e39a122f4f5a5cf09c90fe200000000000000000000000000632cfe43d8f9f8e6cd0d39ffa3d4fa7ec73cfb00000000000000000000000000000000000000000000000000000000000000800000000000000000000000000000000000000000000000000000000000000060000000000000000000000000e572cef69f43c2e488b33924af04bdace19079cf000000000000000000000000a20623070413d42a5c01db2c8111640dd7a5a03a0000000000000000000000000000000000000000000000000de0b6b3a7640000false199124291392021-05-13T23:48:59.000Z0xa1db97bb0c3642915f5d6a15434aaae570ed32c30x1a72f223a9bb7cafbb961f74c871846634e56633966c90dbc8d4b953258153a40x2cba6ab6574646badc84f0544d05059e57a5dc42
0xf5bce5077908a1b7370b9ae04adc565ebd6439660x000000000000000000000000111111111117dc0aa78b770fa6a738034120c3020000000000000000000000008290333cef9e6d528dd5618fb97a76f268f3edd400000000000000000000000000632cfe43d8f9f8e6cd0d39ffa3d4fa7ec73cfb000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000600000000000000000000000007eed379bf00005cfed29fed4009669de9bcc21ce000000000000000000000000c929ad75b72593967de83e7f7cda0493458261d90000000000000000000000000000000000000000000000000de0b6b3a7640000false379132472492021-09-18T03:20:31.000Z0x98f304483134f1cb2f682705d5c139c23d3c89410x2dbe1a81cea069183f0b634274dd456285f86f20588021a1af06386ed80fdedb0x2cba6ab6574646badc84f0544d05059e57a5dc42
0xf5bce5077908a1b7370b9ae04adc565ebd6439660x000000000000000000000000c02aaa39b223fe8d0a0e5c4f27ead9083c756cc2000000000000000000000000ff20817765cb7f73d4bde2e66e067e58d11095c200000000000000000000000000632cfe43d8f9f8e6cd0d39ffa3d4fa7ec73cfb000000000000000000000000000000000000000000000000000000000000008000000000000000000000000000000000000000000000000000000000000000600000000000000000000000008797abc4641de76342b8ace9c63e3301dc35e3d80000000000000000000000005f4ec3df9cbd43714fe2740f5e3616155c5b84190000000000000000000000000000000000000000000000000de0b6b3a7640000false182132512632021-09-18T18:17:59.000Z0xd6aece4eabe572f90e30800ed89e31e73687dcb30xf5c1ef955494bce2b3064bec5a116e51210bff6e330f05004f4c8c087cb050a30x2cba6ab6574646badc84f0544d05059e57a5dc42
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.BentoBox_LogDeploy_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_accruedAmountSTRINGAmount of interest accrued in the LogAccrue event. String-encoded integer representing the accrued value in the smallest denomination of the token.
addressremovedlog_indexblock_numberblock_timestampin_accruedAmounttransaction_hash
0xd31e19a0574dbf09310c3b06f3416661b4dc7324false364166214762023-02-13T17:58:47.000Z15193143702011918260x96f26fc806c86033a07f18fcfe90c57278b17d5d745e1951aa5c14fbccec0d5c
0xd31e19a0574dbf09310c3b06f3416661b4dc7324false244166215232023-02-13T18:08:23.000Z7358049572120229960x92391438b48f2daaec5cbed1e77fe523f7db8c01f4b6e819a657bf36b8cdb70b
0xd31e19a0574dbf09310c3b06f3416661b4dc7324false108166173812023-02-13T04:14:23.000Z4626198434909893073140xed51ad9e7ab79f966410f851900e9d2319e4ecbacd0e5463a0d9e8467740c1e1
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.Cauldron_LogAccrue_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_partSTRINGDebt portion in the lending protocol’s internal accounting units. Numeric string representation in smallest denomination.
in_toaddressin_fromin_partremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
0xfb798b154bf1af6b1cce58b6fb7d8a908b1e03650x3410297d89dcdaf4072b805efc1ef701bb3dd9bf0xfb798b154bf1af6b1cce58b6fb7d8a908b1e0365155041187038206837402false155775000000000000000151156984512022-10-07T19:59:59.000Z0x227f47317bf7cde00b0e454cd60ff0c7d34d6e020a64c63af22f22d742e3610a
0x21ad3f3d7b5770a62891bde06ca7db3d8b518dd50x3410297d89dcdaf4072b805efc1ef701bb3dd9bf0x21ad3f3d7b5770a62891bde06ca7db3d8b518dd5111457959342737022850false111985397928952839378371156980112022-10-07T18:31:35.000Z0xcfe4884315928af4133e15cd2d1eeb3a53cd0206ccf857869956baf494e84ca5
0xa7af4580cc0c9ff4a526de9866689ae1c9817b5f0x390db10e65b5ab920c19149c919d970ad9d18a410xa7af4580cc0c9ff4a526de9866689ae1c9817b5f2512500000000000000000false2512500000000000000000192156958102022-10-07T11:04:23.000Z0xdbe809cf0042b0f41fabe8ab3d8162d05a716a832fb349ef6bd5832983d1543c
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.Cauldron_LogBorrow_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_partSTRINGDebt portion in the lending protocol’s internal accounting units. Numeric string representation in smallest denomination.
in_toaddressin_fromin_partremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
0xfb3485c2e209a5cfbdc1447674256578f1a80ee30x3410297d89dcdaf4072b805efc1ef701bb3dd9bf0xfb3485c2e209a5cfbdc1447674256578f1a80ee345132500219045057262false45430816298151410312915166743162023-02-21T03:49:59.000Z0x077b09709ba29122393a7acffcf2493c8811c7cc2607b1b64c059041373fe1a0
0xc3be098f9594e57a3e71f485a53d990fe3961fe50x98a84eff6e008c5ed0289655ccdca899bcb6b99f0xc3be098f9594e57a3e71f485a53d990fe3961fe52001781030133621673253false2016807274525768371725209166801112023-02-21T23:21:35.000Z0xf281471eb66134c686063875ce6ad4abd9caac40a936a3e97adb48bb0ca22b56
0xd6cb7a7b544e24e5160a948a16c45b1096276f9d0x0bca8ebcb26502b013493bf8fe53aa2b1ed401c10xd6cb7a7b544e24e5160a948a16c45b1096276f9d29896613075541118781813false29999999999999999999998441147201752022-05-05T23:40:44.000Z0x4e5f28e137af5ba8731c876c710be54e08148671d7c808d29400b0a34ac5a8af
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.Cauldron_LogRepay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__dstChainIdSTRINGLayerZero chain identifier for the destination blockchain. String-encoded integer representing the target chain in cross-chain message transfers.
in__fromSTRINGAddress initiating the transaction or transfer. Hex-encoded, 0x-prefixed, 42-character string.
in__toAddressSTRINGDestination address for the cross-chain token transfer. 66-character hex string with 0x prefix and 24 leading zeros padding the address.
in__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
addressremovedin__fromlog_indexin__amountblock_numberin__toAddressin__dstChainIdblock_timestamptransaction_hash
0x439a5f0f5e8d149dda9a0ca367d4a8e4d6f83c10false0x86355f02119bdbc28ed6a4d5e0ca327ca7730fff156823151670000000000182816570x0000000000000000000000006ea42eb7df28c7ce9fdd64299b5e0866bfed882e1022023-10-05T03:34:11.000Z0xf53f9630892c93145af5cab3f42f57e1d727fbec82473cbe0b3e7d281f9cfa29
0x439a5f0f5e8d149dda9a0ca367d4a8e4d6f83c10false0x86355f02119bdbc28ed6a4d5e0ca327ca7730fff4139996000000000000182817750x000000000000000000000000eac78006d8c0cf378df707dd338d856e7b623f8f1022023-10-05T03:57:59.000Z0xc58af3e7884b28a878c6e189a4616827f9f942b1694bf3628be5de5b1d59a376
0x439a5f0f5e8d149dda9a0ca367d4a8e4d6f83c10false0x287176dfbec7e8cee0f876fc7b52960ee1784adc70387797944460000000000182862990x0000000000000000000000009f2cc8c4c00227cc99c2ea682ef99f80314fd2821102023-10-05T19:09:35.000Z0xab0408426c7da38d0a7e438171f48380d23a9c3912426ddc1a84316433e1be6b
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.LzProxyOFTV2_SendToChain_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pidSTRINGPool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_pidaddressin_userremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
00xf43480afe9863da4acbd4419a47d9cc7d25a647f0x1ae9938040852172f7588bbbe32cdb0867790591false32830958680025062803062159064762022-11-05T21:24:11.000Z0xcecb8cd8faea3ab3550a8436263d8adee06ad6a49be550cff676fbce04d95ceb
00xf43480afe9863da4acbd4419a47d9cc7d25a647f0x1ae9938040852172f7588bbbe32cdb0867790591false036159064762022-11-05T21:24:11.000Z0xcecb8cd8faea3ab3550a8436263d8adee06ad6a49be550cff676fbce04d95ceb
00xf43480afe9863da4acbd4419a47d9cc7d25a647f0xcd35307501ffa76afd70c839227295b35bf14fd3false283123594044053758772182159015512022-11-05T04:52:47.000Z0xc9f5505ac41a197d469d9997a480013b416bd66c413d6373d474d4ff4656adf9
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.Sorbettiere_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_pidSTRINGPool identifier referencing a specific staking or liquidity pool within the protocol. Numeric string representation of the pool ID.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
in_pidaddressin_userremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
00xf43480afe9863da4acbd4419a47d9cc7d25a647f0x6180ba55473d3da307bb637f7d1cb07daeb5c073false071128374102021-07-16T10:37:22.000Z0x1a179ef5398ee5f9d745e70d2bdf36ff020396eafaee159a06c4e40502aaf8c2
00xf43480afe9863da4acbd4419a47d9cc7d25a647f0x0716266cc5d3c443e30b0c4e9c72afa33778e1defalse0255128407792021-07-16T23:12:17.000Z0x2348d94388e32adcb7f3e7b0d4cbe496124c5aeb1a685f15d6991e040657309b
00xf43480afe9863da4acbd4419a47d9cc7d25a647f0x794b769d5c7e4d66d9a8d1da91e9cb7a94bb18e7false0249128397942021-07-16T19:37:15.000Z0x63d8b337f02db3074ce8c8b0465e6fe920fa0141c8f6535f0afa97e8edd0cd53
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.Sorbettiere_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in_userSTRINGAddress of the user account associated with the transaction or protocol operation. Hex-encoded, 0x-prefixed, 42-character string.
in_gaugeSTRINGContract address of the gauge contract. Hex-encoded, 0x-prefixed, 42-character string.
in_reward_tokenSTRINGContract 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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressin_userremovedin_gaugein_amountlog_indexblock_numberblock_timestampin_reward_tokentransaction_hash
0x03dfdbcd4056e2f92251c7b07423e1a33a7d3f6d0xa9dcf7f7e49bf36c29f1616a52fce617a0329a97false0xd8b712d29381748db89c36bca0138d7c75866ddf54410432461719825202823180167078182023-02-25T20:59:35.000Z0xa9dcf7f7e49bf36c29f1616a52fce617a0329a970x7e037f3fc945908c1a5a1ca2e4b766a31d11928b7e7fa2dfabb90840aa4ae1de
0x03dfdbcd4056e2f92251c7b07423e1a33a7d3f6d0x7af3edc58487bad40a21b93d90f14453282d8df3false0xd8b712d29381748db89c36bca0138d7c75866ddf247119581917835665304747213167045922023-02-25T10:04:35.000Z0x7af3edc58487bad40a21b93d90f14453282d8df30xbce347c73b1165bbd42fb2126e18dd98b76016d35b63855a18c756755509a431
0x03dfdbcd4056e2f92251c7b07423e1a33a7d3f6d0x6f9ac5b3fa4308620c6763d9aa5a65446e75f5b5false0xd8b712d29381748db89c36bca0138d7c75866ddf55453370537388907768411807167020752023-02-25T01:35:59.000Z0x6f9ac5b3fa4308620c6763d9aa5a65446e75f5b50x09ad1e8f8fc4ef92c7227cce87dd77d0505d43e004303cc856dc1df20af94a3b
Query with partition filter
SELECT *
FROM `tt-contracts.abracadabra_v1_ethereum.yBribe_RewardClaimed_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100