> ## Documentation Index
> Fetch the complete documentation index at: https://tokenterminal.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# toucan_v1_celol2

> Tables in tt-contracts.toucan_v1_celol2

## Tables

### BCT\_Deposited\_event

*No description available.*

<Accordion title="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.                      |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.toucan_v1_celol2.BCT_Deposited_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### 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.

<Accordion title="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.                      |
</Accordion>

<Accordion title="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 |
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.toucan_v1_celol2.BCT_Redeemed_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### NCT\_Deposited\_event

*No description available.*

<Accordion title="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.                      |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.toucan_v1_celol2.NCT_Deposited_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***

### NCT\_Redeemed\_event

*No description available.*

<Accordion title="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.                      |
</Accordion>

<Accordion title="Sample Data">
  *No sample data available.*
</Accordion>

<Accordion title="Example Query">
  **Query with partition filter**

  ```sql theme={null}
  SELECT *
  FROM `tt-contracts.toucan_v1_celol2.NCT_Redeemed_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***