abracadabra_v1_bsc

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
0x090185f2135308bad17527004364ebcc2d37e5f6	0x000000000000000000000000af16cb45b8149da403af41c63abfebfbcd16264b0000000000000000000000005fb9ff077256cf755798ef251e27f8f771b7ba9300000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000038a9a7ca000000000000000000000000000000000000000000000000000000000001adb000000000000000000000000000000000000000000000000000000000000124f800000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000000	false	780	16244926	2022-03-21T06:20:28.000Z	0xf0da5385afe8218502eb769164ac6cb38113aab1	0x52b741bf845ec84877193982f853b45b52af51417d93905557875d13c3c226aa	0x26fa3fffb6efe8c1e69103acb4044c26b9a106a9
0x090185f2135308bad17527004364ebcc2d37e5f6	0x000000000000000000000000af16cb45b8149da403af41c63abfebfbcd16264b0000000000000000000000003eba42e813c82857f412c7bce33be2fbdc18cdf000000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000038a9a7ca000000000000000000000000000000000000000000000000000000000001adb000000000000000000000000000000000000000000000000000000000000124f800000000000000000000000000000000000000000000000000000000000003e80000000000000000000000000000000000000000000000000000000000000000	false	475	16245194	2022-03-21T06:33:52.000Z	0x1f8fd4289423e273bc067af576bda66123de05b8	0x168a41f5d047fd9d5f4e9aba85c9f94c952ffb3e3fe95f38990014bc0b0d4afd	0x26fa3fffb6efe8c1e69103acb4044c26b9a106a9
0x090185f2135308bad17527004364ebcc2d37e5f6	0x0000000000000000000000000e09fabb73bd3ade0a17ecc321fd13a19e81ce8200000000000000000000000035f78ebb33b69d0006910913480f48327163805300000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000025c66fdc000000000000000000000000000000000000000000000000000000000001adb00000000000000000000000000000000000000000000000000000000000014c0800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	1451	12763953	2021-11-18T23:57:42.000Z	0x4048e5c2875069b97a1e9321427cb5cddf45b389	0x3d2ed4846e1860acf9e58a19dedf8a0b14de9a9da3584dcff47402e1cd8d0820	0x26fa3fffb6efe8c1e69103acb4044c26b9a106a9

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_bsc.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	log_index	block_number	block_timestamp	in_accruedAmount	transaction_hash
0x692cf15f80415d83e8c0e139cabcda67fcc12c90	false	244	20290492	2022-08-09T12:44:23.000Z	19935853621120493	0x1c54cb5313a3379b9e7cf58f19966dfa28c94d9acbf4b1232c20dda0de7e0e49
0x692cf15f80415d83e8c0e139cabcda67fcc12c90	false	890	20290414	2022-08-09T12:40:29.000Z	1547593067239020843	0xce706272150431ea292aa332d5c627ac690ace04558f935711c1e8910fbf2c57
0x692cf15f80415d83e8c0e139cabcda67fcc12c90	false	87	20290431	2022-08-09T12:41:20.000Z	5555893452538794	0x0966c5d6513c3153a4ce43f4516e103c55723517a7c504caa0cd2d679881b78e

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_bsc.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
0xe8967aae1136a0cd4122b1de9edec4344cd401d3	0x692cf15f80415d83e8c0e139cabcda67fcc12c90	0xe8967aae1136a0cd4122b1de9edec4344cd401d3	1979554726582553677	false	2010000000000000000	562	20749174	2022-08-25T11:22:53.000Z	0x66aebf1686ecff93394211dd43c39227df4d63d8fcc05603c38c89156bbd46d0
0x4918ecb510e82632643e190ddc7a81485ae89f87	0x692cf15f80415d83e8c0e139cabcda67fcc12c90	0x4918ecb510e82632643e190ddc7a81485ae89f87	75991018110227284516	false	78173921695471575218	88	27525830	2023-04-20T23:09:58.000Z	0xf5aded1536c9dbc40986d1ef16fc8cb115fc8435332b0a5d4f8b6d5012790f8c
0x646a1af841c10edce3a7b5960d69cbd0e1c4b134	0x692cf15f80415d83e8c0e139cabcda67fcc12c90	0x646a1af841c10edce3a7b5960d69cbd0e1c4b134	249170729706773142886	false	251250000000000000000	557	17109470	2022-04-20T11:58:20.000Z	0x0c8855e900117d171f89d6aa3864dcb025251efb650988c95124d7020f39cccc

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_bsc.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
0xc3f7411b2efcef0c52079f5eb9edb4e3eabb1be4	0x692cf15f80415d83e8c0e139cabcda67fcc12c90	0xc3f7411b2efcef0c52079f5eb9edb4e3eabb1be4	185182037213926444905	false	187488704571547590668	124	19235330	2022-07-03T19:30:03.000Z	0x077cd007d0637d5f79ce41ea1beb5ad129ccb5d829196c98b793914a0458c778
0x407bb437a026405f882af12072175eb8530d7a1f	0x692cf15f80415d83e8c0e139cabcda67fcc12c90	0xc368606afaba8331bd54afac3caf705a14bed216	185957411471436279	false	188273212644892326	9	19233865	2022-07-03T18:16:48.000Z	0x1855304b79b7dc982e58d4bd4e2713d5672f85bdbe63f951defa9e77b122b522
0xe8967aae1136a0cd4122b1de9edec4344cd401d3	0x692cf15f80415d83e8c0e139cabcda67fcc12c90	0xe8967aae1136a0cd4122b1de9edec4344cd401d3	4825993988561595403	false	4899999999999999998	279	20725911	2022-08-24T15:57:44.000Z	0xc9f5c88eb4cee988b500b665f5a17a358075e38ae83b7d62c9bdd1a33a52204b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_bsc.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
0x41d5a04b4e03dc27dc1f5c5a576ad2187bc601af	false	0x04217ff73b1f7c5b7b3fe1d24bdceed8e3bb0265	26	0	30125340	0x00000000000000000000000004217ff73b1f7c5b7b3fe1d24bdceed8e3bb0265	106	2023-07-20T10:19:57.000Z	0x9572a463adac7d69abe12cd53df85ccb4504ac5b3fb2988e27f8cd9ae4d07310
0x41d5a04b4e03dc27dc1f5c5a576ad2187bc601af	false	0x34de24418718269fc370fa673e262a921fb6f75f	135	0	30136955	0x00000000000000000000000034de24418718269fc370fa673e262a921fb6f75f	106	2023-07-20T20:02:54.000Z	0x98e8074408515d94101ad72d1505135079469cf69d129be10eafadd96eca20d7
0x41d5a04b4e03dc27dc1f5c5a576ad2187bc601af	false	0x94e823df8991259486ecb05dc9f4599e1c5f7861	742	10000000000000000	30128227	0x00000000000000000000000094e823df8991259486ecb05dc9f4599e1c5f7861	106	2023-07-20T12:44:53.000Z	0xf035f5d54f0f0d0e94782cc4f8ae7bf7cb733c7ac67c2367324b00578fdc207d

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

​Tables

​BentoBox_LogDeploy_event

​Cauldron_LogAccrue_event

​Cauldron_LogBorrow_event

​Cauldron_LogRepay_event

​LzIndirectOFTV2_SendToChain_event

Tables

BentoBox_LogDeploy_event

Cauldron_LogAccrue_event

Cauldron_LogBorrow_event

Cauldron_LogRepay_event

LzIndirectOFTV2_SendToChain_event