abracadabra_v1_avalanche

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
0x1fc83f75499b7620d53757f0b01e2ae626aae530	0x00000000000000000000000057319d41f71e81f3c65f2a47ca4e001ebafd4f3300000000000000000000000059b3d5ddf93a3782f7b7a4be1214722fc6fecd4500000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000038a9a7ca0000000000000000000000000000000000000000000000000000000000019a2800000000000000000000000000000000000000000000000000000000000124f800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	21	6414426	2021-11-02T04:39:23.000Z	0x3b63f81ad1fc724e44330b4cf5b5b6e355ad964b	0xf4fe88e005e73aee8d30bd7c1b338f0a01117c8379e4680f90b12ed8c0ff128e	0x02e07b6f27e5ec37ca6e9f846b6d48704031625a
0x1fc83f75499b7620d53757f0b01e2ae626aae530	0x00000000000000000000000057319d41f71e81f3c65f2a47ca4e001ebafd4f3300000000000000000000000059b3d5ddf93a3782f7b7a4be1214722fc6fecd4500000000000000000000000000000000000000000000000000000000000000e0000000000000000000000000000000000000000000000000000000001c54d3e50000000000000000000000000000000000000000000000000000000000019a2800000000000000000000000000000000000000000000000000000000000124f800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	2	6414186	2021-11-02T04:31:23.000Z	0xaebe668df677feeab85adfc4a6109378a1c53438	0xfa7fa6b7c1da4f6e65991bba1f905548bb747d1a5b4f13c0232ec8c509589b06	0x02e07b6f27e5ec37ca6e9f846b6d48704031625a
0x1fc83f75499b7620d53757f0b01e2ae626aae530	0x000000000000000000000000a389f9430876455c36478deea9769b7ca4e3ddb10000000000000000000000000e1ea2269d6e22dfeebce7b0a4c6c3d415b5bc8500000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000038a9a7ca000000000000000000000000000000000000000000000000000000000001a5e00000000000000000000000000000000000000000000000000000000000014c0800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	49	6415427	2021-11-02T05:13:02.000Z	0x95cce62c3ecd9a33090bbf8a9eac50b699b54210	0x365ef4c8a97bfa251fc6e5d6984e14d114511efbcc971c663449f1c19b603cc0	0x02e07b6f27e5ec37ca6e9f846b6d48704031625a

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_avalanche.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
0x0a1e6a80e93e62bd0d3d3bfcf4c362c40fb1cf3d	false	75	11947506	2022-03-10T21:30:08.000Z	21050162348063203331	0x0228c71ca8097d91fb1b5576acb5d8c35d0176f14cf51fc9f28322cf13d7f278
0x2450bf8e625e98e14884355205af6f97e3e68d07	false	64	11944077	2022-03-10T19:33:30.000Z	3353388399495448066	0xd43e4fe51c31467ded0d52b984bd9b1f3b11fe2e5b2b454f687b80b696157901
0x2450bf8e625e98e14884355205af6f97e3e68d07	false	27	11950715	2022-03-10T23:25:16.000Z	7129949134057987778	0x3ae65a7858cb736eb56707f904df887e4bfc20867ee736b806a5aba415b4e8fe

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_avalanche.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
0x34f9321b04fa6f96d78f9fdf491dfbf1dfcb5800	0x2450bf8e625e98e14884355205af6f97e3e68d07	0x34f9321b04fa6f96d78f9fdf491dfbf1dfcb5800	200458757652122676025	false	201000000000000000000	28	11318572	2022-02-24T03:25:07.000Z	0xfd827a533964b99ab0b4fbcca27f26ec461b10d27284e4715cc702c355dc7815
0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd	0x2450bf8e625e98e14884355205af6f97e3e68d07	0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd	3006882673960926440080	false	3015000000000000000000	39	11317908	2022-02-24T03:02:13.000Z	0x626b1795e95d8c90abd8ff9303017dfaf875be66ae3df807d0decfd835b694b1
0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd	0x2450bf8e625e98e14884355205af6f97e3e68d07	0x6ecd2aa2aa2901cf045e47c116dcd99d63a2dbfd	10022943294642405411431	false	10050000000000000000000	54	11317753	2022-02-24T02:56:43.000Z	0x40dabfe1248d9027708a854295fbf50001b51e6dc14b419d7833651957374878

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_avalanche.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
0x9e7eb17ad6868322d6655a98906a58c11285cbe5	0x2450bf8e625e98e14884355205af6f97e3e68d07	0x9e7eb17ad6868322d6655a98906a58c11285cbe5	1003176853773492698919	false	1007739428570565399936	63	14172024	2022-05-02T09:37:41.000Z	0x91a8e5999480578519b343aeae1fe3344f11c2b6e4b81135f630f9fa583e8895
0x6fb737d1ebb73cda6cfa36fd16d9273065d1b084	0x3b63f81ad1fc724e44330b4cf5b5b6e355ad964b	0x6fb737d1ebb73cda6cfa36fd16d9273065d1b084	20627736651943315685	false	20933335795199999998	19	14187912	2022-05-02T18:41:48.000Z	0x0653382b6a9a60b2843fc83d876a5c9a63229dd675e2bf66006b68d0daf7f8c8
0x76b60dcf71da2294f8aa034432d925d1eed8cf68	0x3cfed0439ab822530b1ffbd19536d897ef30d2a2	0x76b60dcf71da2294f8aa034432d925d1eed8cf68	11010705271461266484241	false	11082668830209042538248	36	14175370	2022-05-02T11:31:42.000Z	0x13bf9b252a0b6b0f4288aa4934105ad975f9174ee36151faccfd7f2fd464fc7c

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_avalanche.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
0xb3a66127ccb143bfb01d3aecd3ce9d17381b130d	false	0x03351a3435af95e318aa7ba3eb17eb50a4c6c2df	23	7500000000000000000000	32754176	0x00000000000000000000000003351a3435af95e318aa7ba3eb17eb50a4c6c2df	102	2023-07-18T08:15:19.000Z	0xfa332f29f9bd78f9573d74df160c6685d7c64c55db2305ad0918bc4209ea87b5
0xb3a66127ccb143bfb01d3aecd3ce9d17381b130d	false	0x03351a3435af95e318aa7ba3eb17eb50a4c6c2df	18	8603548804150000000000	32750089	0x00000000000000000000000003351a3435af95e318aa7ba3eb17eb50a4c6c2df	102	2023-07-18T05:57:52.000Z	0xbc90c574eed5521e3b240c89a781c326879fe3ed004699473cdf2c7ce28a678f
0xb3a66127ccb143bfb01d3aecd3ce9d17381b130d	false	0x03351a3435af95e318aa7ba3eb17eb50a4c6c2df	38	7000000000000000000000	32754688	0x00000000000000000000000003351a3435af95e318aa7ba3eb17eb50a4c6c2df	102	2023-07-18T08:32:25.000Z	0x1c4aab171f4c20de90b8fd3907540bd8b9822c07201b3608d1f3a581d38e76e3

Example Query

Query with partition filter

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