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.Columns
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_dst | STRING | Address of the account receiving tokens or assets in the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_sad | STRING | Amount of tokens involved in the deposit or withdrawal operation. String representation of an integer value, denominated in the token’s smallest unit. |
Sample Data
Sample Data
| in_dst | in_sad | address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP | 428603800 | TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDn | false | 50 | 56418242 | 2023-11-13T14:49:36.000Z | 0x47c59c626bc792a626d66ee98e2b912be33c696cb808c9e9aefdd452cd47fa81 |
| TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP | 20000000000 | TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDn | false | 10 | 56408447 | 2023-11-13T06:39:42.000Z | 0x9c4911ccfe135619e8e891ff1c7d60c46876fb27085d378b988be21eb44d4bd3 |
| TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP | 78010933434 | TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDn | false | 7 | 43435882 | 2022-08-19T05:07:06.000Z | 0x4268a8dac0bb5330f066fffe49222cb6003ae50148974d8beb6568e07e0c0651 |
Example Query
Example Query
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.Columns
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_src | STRING | Address of the account from which tokens or assets are being withdrawn or transferred. Hex-encoded, 0x-prefixed, 42-character string. |
in_sad | STRING | Amount of tokens involved in the deposit or withdrawal operation. String representation of an integer value, denominated in the token’s smallest unit. |
Sample Data
Sample Data
| in_sad | in_src | address | removed | log_index | block_number | block_timestamp | transaction_hash |
|---|---|---|---|---|---|---|---|
| 219000000 | TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP | TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDn | false | 12 | 55420924 | 2023-10-09T23:26:57.000Z | 0x870704f031efd93f71375b126d5033259983ec8956d9f77ad71ced8b6d6dc571 |
| 219574871 | TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP | TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDn | false | 16 | 55394199 | 2023-10-09T01:10:24.000Z | 0x0e15f9da9dcef939446bc2ff70aae31d1fc053f4cb049c47b13c05eff4f6d28a |
| 60000000 | TMgSSHn8APyUVViqXxtveqFEB7mBBeGqNP | TPYmHEhy5n8TCEfYGqW2rPxsghSfzghPDn | false | 16 | 55394429 | 2023-10-09T01:21:54.000Z | 0x3c3b5207a3f18b90c6ec2148e2ff0d433d9dfca7c4c26871f6af5813735025c1 |
Example Query
Example Query
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