abracadabra_v1_fantom

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
0x74a0bca2eeedf8883cb91e37e9ff49430f20a616	0x0000000000000000000000006f86e65b255c9111109d2d2325ca2dfc82456efc000000000000000000000000663ef4455a07243d9029ba0fc48297ae181aeb3800000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000012e337ee000000000000000000000000000000000000000000000000000000000001a5e00000000000000000000000000000000000000000000000000000000000014c0800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	7	31497878	2022-02-20T07:59:18.000Z	0x4fdffa59bf8dda3f4d5b38f260eab8bfac6d7bc1	0x73d140f76b630310cbf05bf1d1a817bb5f10faadb45c342e98d253933bfc8e83	0xb6ce2d48cc599a4162937538caebab1ba1c9579c
0x74a0bca2eeedf8883cb91e37e9ff49430f20a616	0x000000000000000000000000b32b31dfafbd53e310390f641c7119b5b9ea0488000000000000000000000000e02bf848395a538c7c624c2bfe377b039f067a6200000000000000000000000000000000000000000000000000000000000000e00000000000000000000000000000000000000000000000000000000012e337ee000000000000000000000000000000000000000000000000000000000001a5e00000000000000000000000000000000000000000000000000000000000014c0800000000000000000000000000000000000000000000000000000000000001f400000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	57	31494241	2022-02-20T07:02:52.000Z	0x7208d9f9398d7b02c5c22c334c2a7a3a98c0a45d	0x24919a148c4b1859816b5aa31514af6d83755f66927eadb54005ab912dae3db3	0xb6ce2d48cc599a4162937538caebab1ba1c9579c
0xf5bce5077908a1b7370b9ae04adc565ebd643966	0x00000000000000000000000069c744d3444202d35a2783929a0f930f2fbb05ad000000000000000000000000c09a7c3adecf7319e572d5c054da0963b5b8269400000000000000000000000000000000000000000000000000000000000000c000000000000000000000000000000000000000000000000000000000421b9cb7000000000000000000000000000000000000000000000000000000000001a9c80000000000000000000000000000000000000000000000000000000000014c0800000000000000000000000000000000000000000000000000000000000000140000000000000000000000000000000000000000000000000000000000000000	false	0	10580656	2021-06-25T06:20:31.000Z	0xff0c81489f91fa888b51c9173688677a22f2d562	0x6260749a66926c9b638ca4f55948cc3cbc3ca9c9d393ad3bc85b9575c9244ca5	0x991f3fa6d9370469356e887f00c119b3cfe7883d

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_fantom.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
0x8e45af6743422e488afacdad842ce75a09eaed34	false	18122617	2021-10-02T07:57:07.000Z	323054974975698702	0x8b96ecc3adc094a86426a17f51826e07dae75a7d78b6079e1a620f94b4528744
0x8e45af6743422e488afacdad842ce75a09eaed34	false	18105266	2021-10-02T01:38:18.000Z	1019374349137668886	0x0ee2cb096fe9ba006f00074b541a372180f1fe6d320c03614a228512b2d48253
0x8e45af6743422e488afacdad842ce75a09eaed34	false	18113061	2021-10-02T04:20:39.000Z	6449179792776048447	0x51f4182230a9259940d2e8c5f1f42e7bac8864f367f958ba17f3177b05413258

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_fantom.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
0x04feda00244db4234b0d68e5ccaf5d561ddb6049	0x8e45af6743422e488afacdad842ce75a09eaed34	0x04feda00244db4234b0d68e5ccaf5d561ddb6049	254995831874365099652	false	259184454463500000000	3	25937642	2021-12-24T22:11:01.000Z	0xc39feeee90bb92d4e04cfb2e24b95b5f1aa0441e8c25d8912bec4d3b55cdc661
0x04feda00244db4234b0d68e5ccaf5d561ddb6049	0x8e45af6743422e488afacdad842ce75a09eaed34	0x04feda00244db4234b0d68e5ccaf5d561ddb6049	492166848365907182519	false	500250000000000000000	42	25934960	2021-12-24T21:32:00.000Z	0xf9e744960272f0892f74953cb33c5a2ad74034600828e20c42240829fa2dedad
0x0be7fb81d433973dc1f233f35703423e7cd33ab9	0x8e45af6743422e488afacdad842ce75a09eaed34	0x0be7fb81d433973dc1f233f35703423e7cd33ab9	1476526373468273012366	false	1500750000000000000000	3	25916656	2021-12-24T17:09:08.000Z	0xaaf3348825b3218d24763bbc1ae13aee67f0c0fb41fe9ac88789281b7dbd8f7f

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_fantom.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
0x4e80baf6d4e635f5d3d4152f371b1cac39ddfda2	0x4fdffa59bf8dda3f4d5b38f260eab8bfac6d7bc1	0x4e80baf6d4e635f5d3d4152f371b1cac39ddfda2	2369729000358991342	false	2394462524527814382	9	60248541	2023-04-18T20:13:51.000Z	0x9399c9eefa034cbfee86a816c85b71bcddb6f5eecd96f0bdedf78cba83c86cec
0xd6a430b25b12e39dcc01edf5c84a860d27777777	0x8e45af6743422e488afacdad842ce75a09eaed34	0xd6a430b25b12e39dcc01edf5c84a860d27777777	377370636191615887385	false	401606675725228233703	41	60217624	2023-04-18T11:18:19.000Z	0x9fe9ed7dc5bb943fbec973c237276e8c66f56727f6042dfc01aa581c172a8e6b
0xa909be1ac709bc08bd8cd69604cee197360b3e33	0xed745b045f9495b8bfc7b58eea8e0d0597884e12	0xa909be1ac709bc08bd8cd69604cee197360b3e33	776359706209816188666	false	800946089609393513961	4	60183076	2023-04-18T00:36:21.000Z	0x5ea11bfce819883adaf246a75e217a110e4e18acc4ad9e15f1b409d11f71523b

Example Query

Query with partition filter

SELECT *
FROM `tt-contracts.abracadabra_v1_fantom.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
0xc5c01568a3b5d8c203964049615401aaf0783191	false	0x86355f02119bdbc28ed6a4d5e0ca327ca7730fff	35	513725371430000000000	65050433	0x000000000000000000000000a6861b61bb0c39cd13a57e9c4fe17a2e6b9a194c	101	2023-07-03T01:31:47.000Z	0x1a089860db5e89fa472bcec7dc761fbbc313b1eaa5a01e7f89a3cf3856269853
0xc5c01568a3b5d8c203964049615401aaf0783191	false	0x05706f4692457d100b4ad79bd448eafb13d67b54	13	99831002990000000000	65079492	0x00000000000000000000000005706f4692457d100b4ad79bd448eafb13d67b54	102	2023-07-03T16:25:43.000Z	0x40104a011cfd6e7bdde5fc05d715a46235c034c6e69f232fcc7d5070674488e3
0xc5c01568a3b5d8c203964049615401aaf0783191	false	0x0b4917b261793fc6c719893d2e30c962b05f2559	5	96128124590000000000	65073527	0x0000000000000000000000000b4917b261793fc6c719893d2e30c962b05f2559	102	2023-07-03T13:29:55.000Z	0x2f51322fea8a221b69495138c6d8f87adce0f661299ea236f5b21b91feb20e54

Example Query

Query with partition filter

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