Skip to main content

Tables

USDC_Burn_event

USDC token burn events emitted when tokens are permanently destroyed from circulation. Records the burner address and amount removed from total supply for Circle’s USDC stablecoin across multiple blockchain networks.
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_burnerSTRINGAccount address that burned the tokens. Hex-encoded string with 0x prefix.
in_amountSTRINGInput amount for the swap, transaction, or operation. Numeric string representation of token quantity in smallest denomination.
addressremovedin_amountin_burnerlog_indexblock_numberblock_timestamptransaction_hash
0x79a02482a880bce3f13e09da970dc34db4cd24d1false1051111900xfd78ee919681417d192449715b2594ab58f5d0021153808412025-06-16T18:08:41.000Z0x952ad651b3e8361684be7b2c11fb307e5fd95787cc2ffa6f3f5be79eef59192b
0x79a02482a880bce3f13e09da970dc34db4cd24d1false4250000000xfd78ee919681417d192449715b2594ab58f5d0021153543672025-06-16T03:26:13.000Z0x22ae17a39a77aafd2df023d8edb676d7eda9d0ee013a9d2fb6cc38661a450a94
0x79a02482a880bce3f13e09da970dc34db4cd24d1false1355531672540xfd78ee919681417d192449715b2594ab58f5d0023153597162025-06-16T06:24:31.000Z0x16bfccc509380551511b628846a772f9d9dc4cca19cb5b618de8cc9497a6735a
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_worldchain.USDC_Burn_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100

USDC_Mint_event

USDC token minting events emitted by Circle’s smart contracts when new USDC tokens are created. Contains minter address, recipient address, and minted amount for tracking stablecoin supply expansion across supported blockchains.
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_minterSTRINGAddress authorized to mint tokens in the operation. Hex-encoded, 0x-prefixed, 42-character string for EVM chains; 66-character hex string for Aptos.
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.
in_toaddressremovedin_amountin_minterlog_indexblock_numberblock_timestamptransaction_hash
0xd0b625a0dc007c248f6cd9e7656ef7eb9bdfacdf0x79a02482a880bce3f13e09da970dc34db4cd24d1false9500000000xfd78ee919681417d192449715b2594ab58f5d0020155704522025-06-21T03:29:03.000Z0xf60a2126b635b3711904bd82117d9ed078a7c745020902a3330ef705411eda0e
0xaa61d909619c9b540daf9984fdb5db375e3a83b10x79a02482a880bce3f13e09da970dc34db4cd24d1false1200000000xfd78ee919681417d192449715b2594ab58f5d0020155973622025-06-21T18:26:03.000Z0x16f63969a63d706f1e51ff5e269f0612975fdcd8a06ae5b033dfd02085b3bc67
0xbc1ed9b1d612676ed952926f67cae544cf2fe3930x79a02482a880bce3f13e09da970dc34db4cd24d1false100000000xfd78ee919681417d192449715b2594ab58f5d0020155898612025-06-21T14:16:01.000Z0x6737b5c3576b7e7032ed4c4420170cc18ba93b516b79a2a787e05cb36e5946bc
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_worldchain.USDC_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100