Skip to main content

​
Tables

​
USDT_DestroyedBlackFunds_event

Tether USDT token burn events on Tron when blacklisted addresses have their funds destroyed by the issuer. Useful for tracking Tether’s compliance actions and the amounts removed from circulation due to sanctioned or flagged addresses.
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__blackListedUserSTRINGTron address of the blacklisted user whose USDT balance was destroyed by the contract issuer. Base58-encoded Tron address beginning with ‘T’ that had previously been added to the blacklist.
in__balanceSTRINGToken amount represented in smallest denomination. String-encoded integer value without decimal places.
addressremovedlog_indexin__balanceblock_numberblock_timestamptransaction_hashin__blackListedUser
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse182925951000000422900742022-07-10T08:52:36.000Z0x0e40a6976f6a7a4e09ab896f29170e8763b083c9ad5a57bef4dc19df85f33c10TGisDdJ3TX1qkCgkeSfK1bit52wzc9tyH8
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse69280057166257876842020-12-11T17:00:09.000Z0x823d10644f44cd867259f5daf90d243e1bda77f1027663aa164ffa3be290ab79TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse763753554900257876872020-12-11T17:00:18.000Z0x4b8063a2fe75021240b408b9a14414335b4be1b092f892276cee5798e08d1f7eTM9797VRM66LyKXq2TbxP1sNmuQWBrsnYw
Query with partition filter
SELECT *
FROM `tt-contracts.tether_v1_tron.USDT_DestroyedBlackFunds_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
USDT_Issue_event

USDT token issuance events on Tron blockchain, recording when new USDT (TRC20) tokens are minted by Tether at contract address TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t. Used for tracking USDT supply expansion and Tether’s minting activity on Tron.
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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse100000000000000014581429902024-01-12T12:36:48.000Z0xfbadd6ca945a045e2415cb43f6cfc65086644b4aec01a071aeafbd40b1cf9487
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse100000000000000034715230782025-04-21T08:28:48.000Z0x77ad8d16c90a41ecd84be167f3178923245c4fef79f73beff39073f0b0960cf3
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse60000000000005686894262019-04-25T19:01:27.000Z0xfddfc1f3f5de45996b35a332aa8132ce04c3c9360a7e3798f925075761efef4d
Query with partition filter
SELECT *
FROM `tt-contracts.tether_v1_tron.USDT_Issue_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_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountlog_indexblock_numberblock_timestamptransaction_hash
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse5000002384809772019-04-18T12:33:45.000Z0x476b47305d992e1f609cde968789fabf5106515dda124842a6b0095b82418e10
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse30000000000000012173164452020-02-20T14:17:33.000Z0xf9d561cfddf4d8de1a63c397349b954b4d9785078ff5ae8d743ddfce6d954c94
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6tfalse100000000000000042306739732021-05-31T16:27:00.000Z0x3cfbae3df8872c825b924ab40056515fe311b8b64abadef2e109af1964065687
Query with partition filter
SELECT *
FROM `tt-contracts.tether_v1_tron.USDT_Redeem_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100