Skip to main content

​
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__blockedUserSTRINGAddress of the account that was blocked and had funds destroyed. Hex-encoded, 0x-prefixed, 42-character string.
in__balanceSTRINGToken amount represented in smallest denomination. String-encoded integer value without decimal places.
addressremovedlog_indexin__balanceblock_numberblock_timestampin__blockedUsertransaction_hash
0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5efalse93000247767292024-03-27T15:42:53.000Z0x4830728ca2d613fb5bbe8956ffc07f476929ce550x49d454558c558a92c2af79e9ed5c2f06f11bccd0be9f264e8f5f3aee66816a41
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__destinationSTRINGConcatenated 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__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
addressremovedlog_indexin__amountblock_numberblock_timestampin__destinationtransaction_hash
0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5efalse2150000000000000266974582024-07-16T19:42:35.000Z0x5754284f345afc66a98fbb0a0afe71e0f007b9490x5c0ae43537678b762390ca40dc7d62569a295bb2068895455360c86f4cb125a6
0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5efalse2100000000000000259898272024-06-05T20:43:58.000Z0x5754284f345afc66a98fbb0a0afe71e0f007b9490xa4bfbc69ad39e3af3092e6ceb3e89e12ef1581d315bff7b23f2977bfd81f31fc
0x48065fbbe25f71c9282ddf5e1cd6d6a887483d5efalse31000000246927222024-03-22T19:02:02.000Z0x5754284f345afc66a98fbb0a0afe71e0f007b9490x9ab6f55011967e184a514262f8220e4ebe42cb2259bc47a5f379fbca8d045d18
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_numberINT64Sequential identifier for the block in which the event or transaction was recorded. Integer value indicating the block’s position in the blockchain.
transaction_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
log_indexINT64Position of the event within the block’s transaction logs. Zero-indexed integer representing the sequential order of log emission.
addressSTRINGContract address that emitted the event. Hex-encoded, 0x-prefixed, 42-character string.
removedBOOLBoolean flag indicating whether the event log was removed from the blockchain due to a chain reorganization.
in__amountSTRINGAmount of tokens involved in the transaction. String-encoded integer representing token quantity in smallest unit (wei for ETH, base units for ERC20 tokens).
No sample data available.
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