abracadabra_v1_arbitrum

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

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

address	in_data	removed	log_index	block_number	block_timestamp	in_cloneAddress	transaction_hash	in_masterContract
0x74c764d41b77dbbb4fe771dab1939b00b146894a	0x000000000000000000000000912ce59144191c1204e64559fe8253a0e49e6548000000000000000000000000ad4a51bd45ba020c0170935bf3e51579202d455e00000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000001c59cba0000000000000000000000000000000000000000000000000000000000001adb000000000000000000000000000000000000000000000000000000000000124f800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	14	168338108	2024-01-08T12:33:12.000Z	0x9dcd0a6140549f3b52fd088c763676d720d17205	0x227cb86c7a09306912202d82008f9f5e3fbdead411c966b594c9a9ab2c52bc1e	0x810961cda804cc955ce731aa7888509ab51be24f
0x74c764d41b77dbbb4fe771dab1939b00b146894a	0x	false	16	23007196	2022-09-05T18:27:59.000Z	0xfcf90eee396467d9faf8062de3b5aa76205f3827	0x3f1e482260a93239b7b21711fd2688050ece8f7ed4371228bd0cb0b9506882ae	0x1c5771e96c9d5524fb6e606f5b356d08c40eb194
0x74c764d41b77dbbb4fe771dab1939b00b146894a	0x	false	3	23007196	2022-09-05T18:27:59.000Z	0x6d705023bec40528e1322738c866f04789f3559a	0x3f1e482260a93239b7b21711fd2688050ece8f7ed4371228bd0cb0b9506882ae	0x438a2b1c6c715fb1b051c04ca65755560d8b8d43

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_arbitrum.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.

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

address	removed	block_number	block_timestamp	in_accruedAmount	transaction_hash
0xc89958b03a55b5de2221acb25b58b89a000215e6	false	3130952	2021-11-18T19:08:15.000Z	29373800081382130961	0xa779728de9f421d40846a48fa44095466bc65d575a72bcfe0c59aced03176f09
0xc89958b03a55b5de2221acb25b58b89a000215e6	false	3115198	2021-11-18T00:24:29.000Z	70507716491827866391	0x1844f0978bf261da621b86fe51501a244d3342a4c8d1726d93bbe1441173d87e
0xc89958b03a55b5de2221acb25b58b89a000215e6	false	3118719	2021-11-18T05:48:09.000Z	28576288561223074969	0x3d53cc8560cb7a504d6af0b780c4a90c2c657822930deca14645438f42b0ba09

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_arbitrum.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.

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

in_to	address	in_from	in_part	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x0a4fc1b3308e763a6a322f38138748a781d5b576	0xc89958b03a55b5de2221acb25b58b89a000215e6	0x0a4fc1b3308e763a6a322f38138748a781d5b576	876307172070878306987	false	879375000000000000000	2	13159393	2022-05-28T22:15:52.000Z	0x21b05c728a45e28dfd371b2ca8058d0620024730ec3051470913ade837900eb8
0xc0a11b1dc79b0efde895a9219660651df79d7649	0xc89958b03a55b5de2221acb25b58b89a000215e6	0xc0a11b1dc79b0efde895a9219660651df79d7649	400601947249982742468	false	402000000000000000000	2	13101938	2022-05-28T03:04:59.000Z	0xc4774f921e6c1a360b6b67ff0ccf8d22fc99b4596d716ad76a4baa34012ad89e
0xc0a11b1dc79b0efde895a9219660651df79d7649	0xc89958b03a55b5de2221acb25b58b89a000215e6	0xc0a11b1dc79b0efde895a9219660651df79d7649	300451372989580397157	false	301500000000000000000	2	13103185	2022-05-28T03:35:36.000Z	0x8a9580987cc6566b1ee0d52a46fbdf046c3840c7a4cc8eccd3a4f5c735248458

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_arbitrum.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.

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

in_to	address	in_from	in_part	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x21a8529a0180fb36037599c375bb37ac765359bd	0xc89958b03a55b5de2221acb25b58b89a000215e6	0x21a8529a0180fb36037599c375bb37ac765359bd	2258169773213299219839	false	2261084455999999999999	4	3944338	2021-12-18T20:43:08.000Z	0xab4cac11272b0fc366f05032b9912be07e889e2fd27b41eed959d05e0581cd32
0x21a8529a0180fb36037599c375bb37ac765359bd	0xc89958b03a55b5de2221acb25b58b89a000215e6	0x21a8529a0180fb36037599c375bb37ac765359bd	914362793498182555	false	915542999999999999	4	3944346	2021-12-18T20:44:37.000Z	0x07fecc329515a6d16792cbdd37e115e5a07c427ddc225da17726e4f1612f869b
0x21a8529a0180fb36037599c375bb37ac765359bd	0xc89958b03a55b5de2221acb25b58b89a000215e6	0x21a8529a0180fb36037599c375bb37ac765359bd	0	false	0	4	3944353	2021-12-18T20:44:41.000Z	0x06ce3d0d270546cdb8c5b6b34ec342d7d3d11da2c0d5012d19ed9ec70a003fdc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_arbitrum.Cauldron_LogRepay_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

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.

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

address	removed	in__from	log_index	in__amount	block_number	in__toAddress	in__dstChainId	block_timestamp	transaction_hash
0x957a8af7894e76e16db17c2a913496a4e60b7090	false	0x287176dfbec7e8cee0f876fc7b52960ee1784adc	6	1000000000000000000	276400367	0x000000000000000000000000408e5155ef433f3c47b0daab49e951eb6b6d8ec6	243	2024-11-20T09:34:26.000Z	0x35da41a26ac99ef8092bdff3cc13a523e8cec86406358aef11845a896b4dcdf4
0x957a8af7894e76e16db17c2a913496a4e60b7090	false	0xdab30be00992487a52ebf2d3ea33f16ce32482d8	17	2223078927750000000000	276407217	0x000000000000000000000000ecb456ea5365865ebab8a2661b0c503410e9b347	101	2024-11-20T10:03:02.000Z	0xb2b042fcac41007309c3c9994c17c4030b5d0ddc0f39288f7190ebe08d7ac96d
0x957a8af7894e76e16db17c2a913496a4e60b7090	false	0x287176dfbec7e8cee0f876fc7b52960ee1784adc	12	65892755193980000000000	228842779	0x000000000000000000000000a8a29bc8816e19d2b41cdaae48bd602180b0ff3e	101	2024-07-05T00:31:01.000Z	0x9ebf9b14a669a4846deefd4a9a0de4a2741bd5b9b6c9016ab8891ddbe3eb7702

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_arbitrum.LzIndirectOFTV2_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 Arbitrum, tracking user stakes into pool ID 0 with deposited token amounts. Useful for analyzing staking behavior and liquidity provision patterns in Abracadabra’s yield farming pools.

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

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x839de324a1ab773f76a53900d70ac1b913d2b387	0x14af6e9535473b2e25000c457b0d2381bddbd4cf	false	1276586252470763392	35	68318244	2023-03-09T20:35:31.000Z	0xb6491d2d8d4d8d2e26127b92f476d09d94a70786e61635f59eb2b109bee283ea
0x839de324a1ab773f76a53900d70ac1b913d2b387	0x8f2a0a07d2193e77dbad89821bc65d67e58c3859	false	429613610247255783	68	68318244	2023-03-09T20:35:31.000Z	0xb6491d2d8d4d8d2e26127b92f476d09d94a70786e61635f59eb2b109bee283ea
0x839de324a1ab773f76a53900d70ac1b913d2b387	0x8f2a0a07d2193e77dbad89821bc65d67e58c3859	false	12045789919514951005	92	68160825	2023-03-09T08:56:50.000Z	0xe252f9df9489ed8263ee43c69d4d3fda7ed3ad949f346ef9de5e4d7df545e335

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_arbitrum.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 Arbitrum, capturing user unstaking transactions with pool ID, withdrawn amounts, and user addresses. Used for tracking liquidity removals and analyzing staking behavior patterns.

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

address	in_user	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
0x839de324a1ab773f76a53900d70ac1b913d2b387	0x3bd5e344ac629c9f232f921bafdeeec312deac9b	false	0	20	16026348	2022-06-27T07:23:05.000Z	0xc149adc66774875cae36ef0addafaadd819855a0768e72f59f07b440045b784c
0x839de324a1ab773f76a53900d70ac1b913d2b387	0x8156e45ddd85ff1e6d013d0ae3424bbe20596ac3	false	10000000000000000001972	3	15978108	2022-06-27T00:03:18.000Z	0x8d9c5698534b9a39ca5232b281a7789577801914b3c629a27ace3d5340ea3ee7
0x839de324a1ab773f76a53900d70ac1b913d2b387	0x8156e45ddd85ff1e6d013d0ae3424bbe20596ac3	false	1206395546418510599446	3	15978319	2022-06-27T00:06:19.000Z	0x827f6b8d8513ddb4146b8e56d9485c45bf65f8c9feeaf9a65a14c142f4fffa25

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_arbitrum.Sorbettiere_Withdraw_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

Metrics

Primitives

Contracts

Blockchain

Tables

BentoBox_LogDeploy_event

Cauldron_LogAccrue_event

Cauldron_LogBorrow_event

Cauldron_LogRepay_event

LzIndirectOFTV2_SendToChain_event

Sorbettiere_Deposit_event

Sorbettiere_Withdraw_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BentoBox_LogDeploy_event

​Cauldron_LogAccrue_event

​Cauldron_LogBorrow_event

​Cauldron_LogRepay_event

​LzIndirectOFTV2_SendToChain_event

​Sorbettiere_Deposit_event

​Sorbettiere_Withdraw_event

Tables

BentoBox_LogDeploy_event

Cauldron_LogAccrue_event

Cauldron_LogBorrow_event

Cauldron_LogRepay_event

LzIndirectOFTV2_SendToChain_event

Sorbettiere_Deposit_event

Sorbettiere_Withdraw_event