toucan_v1_celol2

Tables

BCT_Deposited_event

No description available.

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_erc20Addr`	`STRING`	Contract address of the ERC20 token being deposited. 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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

BCT_Redeemed_event

BCT (Base Carbon Tonne) token redemption events from Toucan Protocol on Celo L2, recording when users exchange pooled carbon credits for specific underlying tokenized carbon offset tokens. Tracks redemption amounts, redeemed ERC20 addresses, and account activity for analyzing carbon credit liquidity and retirement 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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_erc20`	`STRING`	Contract address of the ERC20 token being redeemed or registered. Hex-encoded, 0x-prefixed, 42-character string or zero address for native tokens.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_erc20	in_amount	log_index	in_account	block_number	block_timestamp	transaction_hash
0x02de4766c272abc10bc88c220d214a26960a7e92	false	0xb55f892d2d58a29d5f9143e9bc3f79d01ab28274	900000000000000	40	0xdd056266fccad19f44526462b09ef6199bd686b1	31193487	2025-03-27T16:50:45.000Z	0x93468417d875ef57ddf67e5b2883fad69a6f145b1fc1e99d075ead68019e1ede
0x02de4766c272abc10bc88c220d214a26960a7e92	false	0xb55f892d2d58a29d5f9143e9bc3f79d01ab28274	19573084516520464	28	0x7ebae2e3be88b4bb76e7952149a3b37121bc2473	31283917	2025-03-28T17:57:55.000Z	0xd49044872a4d314ecd70445868fd82d889e5505e4418169a8ccf464e552423f7
0x02de4766c272abc10bc88c220d214a26960a7e92	false	0xb55f892d2d58a29d5f9143e9bc3f79d01ab28274	900000000000000	4	0xdb45168bcc54a46960df8fbdad6d44433b13a6a5	31283158	2025-03-28T17:45:16.000Z	0x5430c49883437fa42b39a9a8a2bd97395b27e7c252c05d6afc576f0098940329

Example Query

Query with partition filter

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

NCT_Deposited_event

No description available.

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_erc20Addr`	`STRING`	Contract address of the ERC20 token being deposited. 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.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

NCT_Redeemed_event

No description available.

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_account`	`STRING`	Account address involved in the transaction or operation. Hex-encoded, 0x-prefixed, 42-character string.
`in_erc20`	`STRING`	Contract address of the ERC20 token being redeemed or registered. Hex-encoded, 0x-prefixed, 42-character string or zero address for native tokens.
`in_amount`	`STRING`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Metrics

Primitives

Contracts

Blockchain

Tables

BCT_Deposited_event

BCT_Redeemed_event

NCT_Deposited_event

NCT_Redeemed_event

Metrics

Primitives

Contracts

Blockchain

​Tables

​BCT_Deposited_event

​BCT_Redeemed_event

​NCT_Deposited_event

​NCT_Redeemed_event

Tables

BCT_Deposited_event

BCT_Redeemed_event

NCT_Deposited_event

NCT_Redeemed_event