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.

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.

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

Example Query

Query with partition filter

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

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.

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

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

Example Query

Query with partition filter

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

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.

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

Sample Data

No sample data available.

Example Query

Query with partition filter

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

USDT_DestroyedBlockedFunds_event

USDT_Mint_event

USDT_Redeem_event

​Tables

​USDT_DestroyedBlockedFunds_event

​USDT_Mint_event

​USDT_Redeem_event

Tables

USDT_DestroyedBlockedFunds_event

USDT_Mint_event

USDT_Redeem_event