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
0xfa2958cb79b0491cc627c1557f441ef849ca8eb1false100000000xfd78ee919681417d192449715b2594ab58f5d00214939954362025-09-24T08:04:29.000Z0x7f5a57c124c15b8c0857ba08e75c241dae3cfe96a239aea0b668fd27f1743626
0xfa2958cb79b0491cc627c1557f441ef849ca8eb1false100000000000xfd78ee919681417d192449715b2594ab58f5d0024939879872025-09-24T03:44:16.000Z0x14e4e666d9c2a23d9808040c0db3e4dd479d32e6c1ffcd84cf91ff3e453cb934
0xfa2958cb79b0491cc627c1557f441ef849ca8eb1false100000000000xfd78ee919681417d192449715b2594ab58f5d00213939981602025-09-24T09:40:44.000Z0x7b6bab76d21bcba9455e1b16ae68bdc10558159622d12f0d4c5799b74f2908b3
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_xdc.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
0x3b61abee91852714e4e99b09a1af3e9c13893ef10xfa2958cb79b0491cc627c1557f441ef849ca8eb1false1000000xfd78ee919681417d192449715b2594ab58f5d0020931675612025-09-03T19:34:53.000Z0x4f7c1561ad89cfa71d7eef7ebca58090402a14c104cf87e2a383828a08a6211f
0x3b61abee91852714e4e99b09a1af3e9c13893ef10xfa2958cb79b0491cc627c1557f441ef849ca8eb1false5000000xfd78ee919681417d192449715b2594ab58f5d0020931641452025-09-03T17:24:30.000Z0x6814071a038e81e614da0b92429e522bc99ccffac1137a76302c922edee140b7
0x3b61abee91852714e4e99b09a1af3e9c13893ef10xfa2958cb79b0491cc627c1557f441ef849ca8eb1false1000000xfd78ee919681417d192449715b2594ab58f5d0022931670222025-09-03T19:14:55.000Z0x46a078618a7e33bf754edd80635a87c4403e6dd1c8b56a671252040a8c294b2c
Query with partition filter
SELECT *
FROM `tt-contracts.circle_v1_xdc.USDC_Mint_event`
WHERE block_timestamp >= DATE_SUB(CURRENT_DATE(), INTERVAL 7 DAY)
LIMIT 100