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

# tether_v1_celo

> Tables in tt-contracts.tether_v1_celo

## Tables

### USDT\_DestroyedBlockedFunds\_event

Events recording the destruction of USDT tokens from blocked addresses on Celo, capturing the blocked user address and token balance removed during compliance actions. Used for tracking Tether's blacklist enforcement and frozen fund seizures.

<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__blockedUser`  | `STRING`    | Address of the account that was blocked and had funds destroyed. Hex-encoded, 0x-prefixed, 42-character string.                                      |
  | `in__balance`      | `STRING`    | Token amount represented in smallest denomination. String-encoded integer value without decimal places.                                              |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_\_balance | block\_number | block\_timestamp         | in\_\_blockedUser                          | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | ------------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e | false   | 9          | 3000          | 24776729      | 2024-03-27T15:42:53.000Z | 0x4830728ca2d613fb5bbe8956ffc07f476929ce55 | 0x49d454558c558a92c2af79e9ed5c2f06f11bccd0be9f264e8f5f3aee66816a41 |
</Accordion>

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

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

***

### USDT\_Mint\_event

Tether USDT token mint events on Celo blockchain, capturing new token issuance with destination addresses and amounts. Used for tracking USDT supply changes and analyzing stablecoin monetary policy on Celo.

<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__destination`  | `STRING`    | Concatenated address pair used in LayerZero cross-chain messaging to specify source and destination contracts. 84-character hex string without 0x prefix, consisting of two 42-character addresses concatenated together. |
  | `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).                                                             |
</Accordion>

<Accordion title="Sample Data">
  | address                                    | removed | log\_index | in\_\_amount    | block\_number | block\_timestamp         | in\_\_destination                          | transaction\_hash                                                  |
  | ------------------------------------------ | ------- | ---------- | --------------- | ------------- | ------------------------ | ------------------------------------------ | ------------------------------------------------------------------ |
  | 0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e | false   | 2          | 150000000000000 | 26697458      | 2024-07-16T19:42:35.000Z | 0x5754284f345afc66a98fbb0a0afe71e0f007b949 | 0x5c0ae43537678b762390ca40dc7d62569a295bb2068895455360c86f4cb125a6 |
  | 0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e | false   | 2          | 100000000000000 | 25989827      | 2024-06-05T20:43:58.000Z | 0x5754284f345afc66a98fbb0a0afe71e0f007b949 | 0xa4bfbc69ad39e3af3092e6ceb3e89e12ef1581d315bff7b23f2977bfd81f31fc |
  | 0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5e | false   | 3          | 1000000         | 24692722      | 2024-03-22T19:02:02.000Z | 0x5754284f345afc66a98fbb0a0afe71e0f007b949 | 0x9ab6f55011967e184a514262f8220e4ebe42cb2259bc47a5f379fbca8d045d18 |
</Accordion>

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

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

***

### USDT\_Redeem\_event

USDT token redemption events emitted when tokens are burned or removed from circulation. Contains redemption amount and transaction metadata for tracking Tether (USDT) supply reduction operations.

<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__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). |
</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.tether_v1_celo.USDT_Redeem_event`
  WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
  LIMIT 100
  ```
</Accordion>

***