Skip to main content

​
Tables

​
WTRX_Deposit_event

Deposit events from the Wrapped TRX (WTRX) token contract on Tron, recording native TRX wrapping transactions with destination addresses and amounts. Used for tracking WTRX minting activity and cross-contract TRX flow analysis.
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_dstSTRINGAddress of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_sadSTRINGAmount of tokens involved in the deposit or withdrawal operation. String representation of an integer value, denominated in the token’s smallest unit.
in_dstin_sadaddressremovedlog_indexblock_numberblock_timestamptransaction_hash
TAUaWmPwpRrwkxqdMtBzZoSLq6n5AfnmB12500000000TNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFRfalse16262198252020-12-26T20:33:54.000Z0x952a32e21513bfa83fea97715e4aa70a7166f5921b0c4d3edc0d6886412801aa
TCBLTVx7dJWcFBBNE7e3QEPHXEtigsbpth200000000TNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFRfalse174262110592020-12-26T13:15:21.000Z0x0294a728bc95fc4b96fc715eb0221140242c55244a4e140442af7cf09c943101
TE2eWyy3Rix9HdkaVxgjbfBJEVhtaPGpSu135234505TNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFRfalse2261970522020-12-26T01:34:27.000Z0x105ab5c4d66d1ebca4e6220c587ff57d1c055b0aee764a8b8610dc0982702427
Query with partition filter
SELECT *
FROM `tt-contracts.wtrx_v1_tron.WTRX_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
WTRX_Withdrawal_event

Withdrawal events from the Wrapped TRX (WTRX) token contract on Tron, recording unwrapping transactions where users convert WTRX back to native TRX. Contains withdrawal amounts, source addresses, and timestamps for tracking WTRX liquidity flows.
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_srcSTRINGAddress of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string.
in_sadSTRINGAmount of tokens involved in the deposit or withdrawal operation. String representation of an integer value, denominated in the token’s smallest unit.
in_sadin_srcaddressremovedlog_indexblock_numberblock_timestamptransaction_hash
387000000TAqDoNQYxawUxJx4VJqyRNSavnGrWoK1pZTNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFRfalse19344390962021-10-10T02:22:39.000Z0xbee935dc5059551e1dd3d0f485aae4294f4b11fd348b1dc2fe465803dba050b4
802000000TCoSsdHLSzhBQAh88zDW1WCdQvZKUrRovETNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFRfalse34344504842021-10-10T11:52:33.000Z0x373d24cb0962dedcaf157019fe2f5e1e5fca11e9b5d1b69c9fb4f03fdaf535b3
7309835TDPjAV3VtYAmpCB6wkBs3HpsmnePdVe9h1TNUC9Qb1rRpS5CbWLmNMxXBjyFoydXjWFRfalse12344509992021-10-10T12:18:27.000Z0x5c12f9436c83b177065170437ec486e8b848f3bd48ff85062d9ecd66858acebc
Query with partition filter
SELECT *
FROM `tt-contracts.wtrx_v1_tron.WTRX_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100