Skip to main content

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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential 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_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw 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_fromSTRINGAddress originating the transfer or operation. Hex-encoded, 0x-prefixed, 42-character string.
in_storeSTRINGFungible asset store identifier where the asset is held. Hex-encoded, 0x-prefixed, 66-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
datain_fromin_storein_amountevent_typeevent_indexblock_heightblock_timestampsequence_numbertransaction_hashevent_guid_account_addressevent_guid_creation_number
{“amount”:“20000”,“from”:“0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fd”,“store”:{“inner”:“0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a9”}}0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fd0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a9200000xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Burn12419827482024-10-21T18:12:17.754Z00xf2b26fb89104e1de5b7dff8b0faa554f7051894e1792c02bc1d0daeec2b3c44d0x00
{“amount”:“180000”,“from”:“0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fd”,“store”:{“inner”:“0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a9”}}0x76ff3deac6723625606b11dfca7817fe1266fffcfc1fb26f5ccc9411f3def6fd0x658af96bf0c7104606f9994890a97fd1c84c3db1dfd7312100b9e1de8da863a91800000xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Burn12419883502024-10-21T18:32:19.148Z00x7f102e2d3c1bb4200d2f3425de2f54a844cb457b75e08d458f4cfbe97e490b740x00
{“amount”:“200000”,“from”:“0x9b56469c10d50da2a0aa1b4347c232099c42a51c0d0b3174310ac7136b270422”,“store”:{“inner”:“0xd71a91c51582840a294a0276a771fe6c371e75650142e28e97d21f2fbec935a6”}}0x9b56469c10d50da2a0aa1b4347c232099c42a51c0d0b3174310ac7136b2704220xd71a91c51582840a294a0276a771fe6c371e75650142e28e97d21f2fbec935a62000000xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Burn12419712462024-10-21T17:32:30.939Z00x3d1b6c9b4f4e34cf3ed70fe0d3d5732f6a1e651ba02263b387a19fd77e34403f0x00
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.
ColumnTypeDescription
block_timestampTIMESTAMPTimestamp when the block was produced. UTC timezone, millisecond precision.
block_heightINT64Sequential number identifying the position of the block in the blockchain. Positive integer incremented by one for each new block.
sequence_numberSTRINGSequential 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_hashSTRINGUnique identifier for the transaction. 66-character hex string including 0x prefix.
event_typeSTRINGFully qualified type identifier for the smart contract event. Module address, module name, and event name separated by double colons.
event_indexINT64Sequential position of the event within its containing transaction. Zero-indexed integer starting from 0 for the first event in each transaction.
event_guid_account_addressSTRINGAccount address component of the event’s globally unique identifier. Hex-encoded string with 0x prefix.
event_guid_creation_numberINT64Creation number component of the event’s globally unique identifier. Non-negative integer that distinguishes different event streams within the same account address.
dataJSONRaw 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_toSTRINGDestination address receiving tokens or assets in the operation. Hex-encoded, 0x-prefixed, 42-character string.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
datain_toin_amountevent_typeevent_indexblock_heightblock_timestampsequence_numbertransaction_hashevent_guid_account_addressevent_guid_creation_number
{“amount”:“250000000000000”,“to”:“0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9”}0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e92500000000000000xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Mint12660536272024-12-17T20:41:09.462Z00xdbc84a0bbb5ad6c16142abf107c796ae160145d0ae63188a92ca8b299ff5eb3a0x00
{“amount”:“100000000000000”,“to”:“0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9”}0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e91000000000000000xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Mint12539538822024-11-18T18:09:06.069Z00x153566d00be7c276a42448d3d3930afff5319a9a4e70dc23dbcfbf7dd5231d170x00
{“amount”:“30000000000000”,“to”:“0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9”}0xd5b71ee4d1bad5cb7f14c880ee55633c7befcb7384cf070919ea5c481019a4e9300000000000000xf73e887a8754f540ee6e1a93bdc6dde2af69fc7ca5de32013e89dd44244473cb::usdt::Mint12449296492024-10-28T15:26:26.742Z00x1b4ee72a593520ddb7b5c57aa89139459b5c05756ea079334a8b9b03cc5e24b30x00
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