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

> Tables in tt-contracts.toucan_v1_celo

## Tables

### BCT\_Deposited\_event

BCT (Base Carbon Tonne) token deposit events from Toucan Protocol on Celo, recording carbon credit token deposits into the pool with deposit amounts and underlying ERC20 token addresses. Used for tracking carbon credit tokenization and pool liquidity flows.

<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">
  | address                                    | removed | in\_amount          | log\_index | block\_number | in\_erc20Addr                              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x02de4766c272abc10bc88c220d214a26960a7e92 | false   | 900000000000000000  | 1          | 18782810      | 0xb55f892d2d58a29d5f9143e9bc3f79d01ab28274 | 2023-04-15T18:10:30.000Z | 0x197e0aefaf1c4214beabba1ff1663541d3304e375e126cbb87d7ed7d1f04cf14 |
  | 0x02de4766c272abc10bc88c220d214a26960a7e92 | false   | 1000000000000000000 | 1          | 18782742      | 0x96e58418524c01edc7c72dadde5fd5c1c82ea89f | 2023-04-15T18:04:50.000Z | 0x61e556cea663cc907216cda84c018c1f628f867a20503c4593779e51e60e7ce0 |
  | 0x02de4766c272abc10bc88c220d214a26960a7e92 | false   | 20000000000000000   | 1          | 18815091      | 0x96e58418524c01edc7c72dadde5fd5c1c82ea89f | 2023-04-17T15:00:35.000Z | 0x7ee84c24818e2144ee63360fb209ac4058a17c7830a12747f3d43cf002c77661 |
</Accordion>

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

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

***

### BCT\_Redeemed\_event

Redemption events from Toucan Protocol's Base Carbon Tonne (BCT) pool on Celo, recording when users burn BCT tokens to receive underlying carbon credit ERC20 tokens. Captures account addresses, redeemed token contracts, and amounts for tracking carbon credit liquidity flows.

<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 | 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 |
  | 0x02de4766c272abc10bc88c220d214a26960a7e92 | false   | 0xd131ed94b36877c66016e3bcd374c306dbfdb3b9 | 118290683902978964940 | 21         | 0xce10d577295d34782815919843a3a4ef70dc33ce | 21167180      | 2023-08-31T17:53:04.000Z | 0x091e316e4ca66314c0c1aff6cc3f30da01556d3ea6a2aac4b17f97c38af364d5 |
</Accordion>

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

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

***

### NCT\_Deposited\_event

Nature Carbon Tonne (NCT) token deposit events on Toucan Protocol's Celo deployment, recording when carbon credit ERC20 tokens are deposited into the NCT pool with deposit amounts and token addresses. Useful for tracking carbon credit tokenization activity and pool composition analysis.

<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">
  | address                                    | removed | in\_amount          | log\_index | block\_number | in\_erc20Addr                              | block\_timestamp         | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ------------------- | ---------- | ------------- | ------------------------------------------ | ------------------------ | ------------------------------------------------------------------ |
  | 0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe | false   | 1170877538545432058 | 256        | 28208809      | 0x96e58418524c01edc7c72dadde5fd5c1c82ea89f | 2024-10-12T06:58:46.000Z | 0x9ade942e203e0c6f2aab034ea9d0617c7a227782853410d351a51016c8084f80 |
  | 0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe | false   | 20000000000000000   | 10         | 19987505      | 0x96e58418524c01edc7c72dadde5fd5c1c82ea89f | 2023-06-24T11:23:16.000Z | 0x2234be6392234761d347db536e93bdff762ffc776860efe3c108386ee8e62a54 |
  | 0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe | false   | 9117992484165893    | 36         | 28185242      | 0x96e58418524c01edc7c72dadde5fd5c1c82ea89f | 2024-10-10T22:14:48.000Z | 0x2ec3dea195231719d4e09afb992008f9217e836a6ffbf34a595f2f35fb7eba74 |
</Accordion>

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

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

***

### NCT\_Redeemed\_event

Redemption events for NCT (Nature Carbon Tonne) pool tokens on Toucan Protocol's Celo deployment, recording when users burn pool tokens to withdraw specific underlying carbon credit tokens. Used for tracking carbon credit withdrawals and analyzing which vintage tokens are redeemed from the NCT basket.

<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                                                  |
  | ------------------------------------------ | ------- | ------------------------------------------ | ------------------- | ---------- | ------------------------------------------ | ------------- | ------------------------ | ------------------------------------------------------------------ |
  | 0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe | false   | 0x3e7a610b66b621d48404e4408e16c80962a6c30b | 540857123005431893  | 4          | 0xdfc180272fc8e0b4fd6e5e1179808ad1049c4dc1 | 19604386      | 2023-06-02T07:16:15.000Z | 0xe44122f31d825d04b38aa6cbd1a6c206467660f3498b7685e57fe1ab788bb590 |
  | 0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe | false   | 0xf92cb18c27506b8b020560b4231358e9aaa77660 | 657790631415463019  | 7          | 0xdfc180272fc8e0b4fd6e5e1179808ad1049c4dc1 | 19604386      | 2023-06-02T07:16:15.000Z | 0xe44122f31d825d04b38aa6cbd1a6c206467660f3498b7685e57fe1ab788bb590 |
  | 0x0ccb0071e8b8b716a2a5998ab4d97b83790873fe | false   | 0xd337d13cea5691777bcee01b2f75be93d59c4459 | 1000000000000000000 | 26         | 0xeb947e9b0aeced803f7e4e83da8b096e14df2153 | 21526647      | 2023-09-21T13:09:52.000Z | 0xbcfca8648289d2f6f2dab933079f3e63ea2f0b432b166523aaf7ae0817e8173e |
</Accordion>

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

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

***