tether_v1_tron

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.

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__blackListedUser`	`STRING`	Tron 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__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	transaction_hash	in__blackListedUser
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	18	2925951000000	42290074	2022-07-10T08:52:36.000Z	0x0e40a6976f6a7a4e09ab896f29170e8763b083c9ad5a57bef4dc19df85f33c10	TGisDdJ3TX1qkCgkeSfK1bit52wzc9tyH8
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	6	9280057166	25787684	2020-12-11T17:00:09.000Z	0x823d10644f44cd867259f5daf90d243e1bda77f1027663aa164ffa3be290ab79	TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	76	3753554900	25787687	2020-12-11T17:00:18.000Z	0x4b8063a2fe75021240b408b9a14414335b4be1b092f892276cee5798e08d1f7e	TM9797VRM66LyKXq2TbxP1sNmuQWBrsnYw

Example Query

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.

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`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	1000000000000000	14	58142990	2024-01-12T12:36:48.000Z	0xfbadd6ca945a045e2415cb43f6cfc65086644b4aec01a071aeafbd40b1cf9487
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	1000000000000000	34	71523078	2025-04-21T08:28:48.000Z	0x77ad8d16c90a41ecd84be167f3178923245c4fef79f73beff39073f0b0960cf3
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	6000000000000	56	8689426	2019-04-25T19:01:27.000Z	0xfddfc1f3f5de45996b35a332aa8132ce04c3c9360a7e3798f925075761efef4d

Example Query

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.

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`	Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.

Sample Data

address	removed	in_amount	log_index	block_number	block_timestamp	transaction_hash
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	500000	23	8480977	2019-04-18T12:33:45.000Z	0x476b47305d992e1f609cde968789fabf5106515dda124842a6b0095b82418e10
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	300000000000000	12	17316445	2020-02-20T14:17:33.000Z	0xf9d561cfddf4d8de1a63c397349b954b4d9785078ff5ae8d743ddfce6d954c94
TR7NHqjeKQxGTCi8q8ZY4pL8otSzgjLj6t	false	1000000000000000	42	30673973	2021-05-31T16:27:00.000Z	0x3cfbae3df8872c825b924ab40056515fe311b8b64abadef2e109af1964065687

Example Query

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

Overview

Metrics

Primitives

Contracts

Blockchain

Tables

USDT_DestroyedBlackFunds_event

USDT_Issue_event

USDT_Redeem_event

​Tables

​USDT_DestroyedBlackFunds_event

​USDT_Issue_event

​USDT_Redeem_event

Tables

USDT_DestroyedBlackFunds_event

USDT_Issue_event

USDT_Redeem_event