Tables
usdt_Burn_event
USDT token burn events on Aptos blockchain, recording token destruction transactions with burn amount, source address, and store identifier. Used for tracking USDT supply changes and analyzing deflationary token operations on Aptos.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_height | INT64 | Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block. |
sequence_number | STRING | Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination). |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
event_type | STRING | Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons. |
event_index | INT64 | Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction. |
event_guid_account_address | STRING | Account address component of the eventβs globally unique identifier. Hex-encoded string with 0x prefix. |
event_guid_creation_number | INT64 | Creation number component of the eventβs globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address. |
data | JSON | Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data. |
in_from | STRING | Address originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_store | STRING | Fungible asset store identifier where the asset is held. Hex-encoded, 0x-prefixed, 66-character string. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| data | in_from | in_store | in_amount | event_type | event_index | block_height | block_timestamp | sequence_number | transaction_hash | event_guid_account_address | event_guid_creation_number |
|---|---|---|---|---|---|---|---|---|---|---|---|
| {βamountβ:β20000β,βfromβ:β0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fdβ,βstoreβ:{βinnerβ:β0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a9β}} | 0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fd | 0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a9 | 20000 | 0xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Burn | 1 | 241982748 | 2024-10-21T18:12:17.754Z | 0 | 0xf2b26fb89104e1de5b7dff8b0faa554f7051894e1792c02bc1d0daeec2b3c44d | 0x0 | 0 |
| {βamountβ:β180000β,βfromβ:β0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fdβ,βstoreβ:{βinnerβ:β0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a9β}} | 0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fd | 0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a9 | 180000 | 0xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Burn | 1 | 241988350 | 2024-10-21T18:32:19.148Z | 0 | 0x7f102e2d3c1bb4200d2f3425de2f54a844cb457b75e08d458f4cfbe97e490b74 | 0x0 | 0 |
| {βamountβ:β200000β,βfromβ:β0x9b56469c10d50da2a0aa1b4347c232099c42a51c0d0b3174310ac7136b270422β,βstoreβ:{βinnerβ:β0xd71a91c51582840a294a0276a771fe6c371e75650142e28e97d21f2fbec935a6β}} | 0x9b56469c10d50da2a0aa1b4347c232099c42a51c0d0b3174310ac7136b270422 | 0xd71a91c51582840a294a0276a771fe6c371e75650142e28e97d21f2fbec935a6 | 200000 | 0xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Burn | 1 | 241971246 | 2024-10-21T17:32:30.939Z | 0 | 0x3d1b6c9b4f4e34cf3ed70fe0d3d5732f6a1e651ba02263b387a19fd77e34403f | 0x0 | 0 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.tether_v1_aptos.usdt_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100
usdt_Mint_event
Tether USDT token mint events on Aptos blockchain, capturing new token issuance with recipient addresses and mint amounts. Useful for tracking USDT supply expansion and authorized minter activity on Aptos.Columns
Columns
| Column | Type | Description |
|---|---|---|
block_timestamp | TIMESTAMP | Timestamp when the block was produced. UTC timezone, millisecond precision. |
block_height | INT64 | Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block. |
sequence_number | STRING | Sequential identifier for an event within its event stream. Non-negative integer string that uniquely orders events sharing the same GUID (account address and creation number combination). |
transaction_hash | STRING | Unique identifier for the transaction. 66-character hex string including 0x prefix. |
event_type | STRING | Fully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons. |
event_index | INT64 | Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction. |
event_guid_account_address | STRING | Account address component of the eventβs globally unique identifier. Hex-encoded string with 0x prefix. |
event_guid_creation_number | INT64 | Creation number component of the eventβs globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address. |
data | JSON | Raw event data payload containing structured parameters and values specific to each event type. JSON object with field names and values representing the complete event emission data. |
in_to | STRING | Destination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string. |
in_amount | STRING | Input amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination. |
Sample Data
Sample Data
| data | in_to | in_amount | event_type | event_index | block_height | block_timestamp | sequence_number | transaction_hash | event_guid_account_address | event_guid_creation_number |
|---|---|---|---|---|---|---|---|---|---|---|
| {βamountβ:β250000000000000β,βtoβ:β0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9β} | 0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9 | 250000000000000 | 0xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Mint | 1 | 266053627 | 2024-12-17T20:41:09.462Z | 0 | 0xdbc84a0bbb5ad6c16142abf107c796ae160145d0ae63188a92ca8b299ff5eb3a | 0x0 | 0 |
| {βamountβ:β100000000000000β,βtoβ:β0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9β} | 0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9 | 100000000000000 | 0xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Mint | 1 | 253953882 | 2024-11-18T18:09:06.069Z | 0 | 0x153566d00be7c276a42448d3d3930afff5319a9a4e70dc23dbcfbf7dd5231d17 | 0x0 | 0 |
| {βamountβ:β30000000000000β,βtoβ:β0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9β} | 0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9 | 30000000000000 | 0xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Mint | 1 | 244929649 | 2024-10-28T15:26:26.742Z | 0 | 0x1b4ee72a593520ddb7b5c57aa89139459b5c05756ea079334a8b9b03cc5e24b3 | 0x0 | 0 |
Example Query
Example Query
Query with partition filter
SELECT *
FROM `tt-contracts.tether_v1_aptos.usdt_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100