Skip to main content

​
Tables

​
USDD_Deposit_event

Deposit events for USDD (Decentralized USD) stablecoin on Tron blockchain, tracking amounts and recipient addresses for each deposit transaction. Used for analyzing USDD supply flows and user deposit patterns.
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
TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP428603800TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDnfalse50564182422023-11-13T14:49:36.000Z0x47c59c626bc792a626d66ee98e2b912be33c696cb808c9e9aefdd452cd47fa81
TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP20000000000TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDnfalse10564084472023-11-13T06:39:42.000Z0x9c4911ccfe135619e8e891ff1c7d60c46876fb27085d378b988be21eb44d4bd3
TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP78010933434TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDnfalse7434358822022-08-19T05:07:06.000Z0x4268a8dac0bb5330f066fffe49222cb6003ae50148974d8beb6568e07e0c0651
Query with partition filter
SELECT *
FROM `tt-contracts.tronusdd_v1_tron.USDD_Deposit_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

​
USDD_Withdrawal_event

Withdrawal events from the USDD stablecoin contract on Tron blockchain, recording amounts withdrawn and source addresses. Useful for tracking USDD redemption activity and protocol 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
219000000TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNPTPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDnfalse12554209242023-10-09T23:26:57.000Z0x870704f031efd93f71375b126d5033259983ec8956d9f77ad71ced8b6d6dc571
219574871TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNPTPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDnfalse16553941992023-10-09T01:10:24.000Z0x0e15f9da9dcef939446bc2ff70aae31d1fc053f4cb049c47b13c05eff4f6d28a
60000000TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNPTPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDnfalse16553944292023-10-09T01:21:54.000Z0x3c3b5207a3f18b90c6ec2148e2ff0d433d9dfca7c4c26871f6af5813735025c1
Query with partition filter
SELECT *
FROM `tt-contracts.tronusdd_v1_tron.USDD_Withdrawal_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100